CloneSet73


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
51730.950statement_sequence[5]
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
1573
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/DaffodilDialectExt.java
2583
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/DB2DialectExt.java
3592
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/DerbyDialectExt.java
4585
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/FrontBaseDialectExt.java
5570
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/H2DialectExt.java
6565
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/HADBDialectExt.java
7563
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/HSQLDialectExt.java
8565
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/InformixDialectExt.java
9571
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/IngresDialectExt.java
101169
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/McKoiDialectExt.java
11572
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/MySQLDialectExt.java
12574
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/OracleDialectExt.java
13567
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/PointbaseDialectExt.java
14577
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/PostgreSQLDialectExt.java
15574
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java
16561
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/SQLServerDialectExt.java
17563
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/SybaseDialectExt.java
Next
Last
Clone Instance
1
Line Count
5
Source Line
73
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/DaffodilDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.TINYINT, "tinyint");


Next
Previous
Clone Instance
2
Line Count
5
Source Line
83
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/DB2DialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.TINYINT, "smallint");


Next
Previous
Clone Instance
3
Line Count
5
Source Line
92
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/DerbyDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.TINYINT, "smallint");


Next
Previous
Clone Instance
4
Line Count
5
Source Line
85
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/FrontBaseDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.TINYINT, "tinyint");


Next
Previous
Clone Instance
5
Line Count
5
Source Line
70
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/H2DialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.TINYINT, "tinyint");


Next
Previous
Clone Instance
6
Line Count
5
Source Line
65
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/HADBDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.TINYINT, "smallint");


Next
Previous
Clone Instance
7
Line Count
5
Source Line
63
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/HSQLDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.TINYINT, "tinyint");


Next
Previous
Clone Instance
8
Line Count
5
Source Line
65
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/InformixDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "datetime hour to second");
registerColumnType(Types.TIMESTAMP, "datetime year to fraction(5)");
registerColumnType(Types.TINYINT, "smallint");


Next
Previous
Clone Instance
9
Line Count
5
Source Line
71
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/IngresDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "date");
registerColumnType(Types.TIMESTAMP, "date");
registerColumnType(Types.TINYINT, "tinyint");


Next
Previous
Clone Instance
10
Line Count
11
Source Line
69
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/McKoiDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
// Don't use tinyint for now, even though Mckoi "supports" it. It's
// notion of tinyint is 7-bit (not 8-bit) so it is not compatible with
// other DBs and leads to overflow (resulting in negative values which
// are a corruption of the actual value inserted/updated). This is not
// a great work-around. I filed a bug report on the mailing list;
// hopefully it will get fixed soon.
registerColumnType(Types.TINYINT, "smallint");


Next
Previous
Clone Instance
11
Line Count
5
Source Line
72
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/MySQLDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.TINYINT, "tinyint");


Next
Previous
Clone Instance
12
Line Count
5
Source Line
74
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/OracleDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "date");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.TINYINT, "smallint");


Next
Previous
Clone Instance
13
Line Count
5
Source Line
67
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/PointbaseDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.TINYINT, "smallint");


Next
Previous
Clone Instance
14
Line Count
5
Source Line
77
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/PostgreSQLDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.TINYINT, "int");


Next
Previous
Clone Instance
15
Line Count
5
Source Line
74
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/ProgressDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "date");
registerColumnType(Types.TIMESTAMP, "timestamp");
registerColumnType(Types.TINYINT, "tinyint");


Next
Previous
Clone Instance
16
Line Count
5
Source Line
61
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/SQLServerDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "datetime");
registerColumnType(Types.TIMESTAMP, "datetime");
registerColumnType(Types.TINYINT, "tinyint");


First
Previous
Clone Instance
17
Line Count
5
Source Line
63
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/SybaseDialectExt.java

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME, "time");
registerColumnType(Types.TIMESTAMP, "datetime");
registerColumnType(Types.TINYINT, "tinyint");


Clone AbstractionParameter Count: 3Parameter Bindings

registerColumnType(Types.REAL, "real");
registerColumnType(Types.SMALLINT, "smallint");
registerColumnType(Types.TIME,  [[#variable1af23460]]);
registerColumnType(Types.TIMESTAMP,  [[#variable1af23380]]);
// Don't use tinyint for now, even though Mckoi "supports" it. It's
// notion of tinyint is 7-bit (not 8-bit) so it is not compatible with
// other DBs and leads to overflow (resulting in negative values which
// are a corruption of the actual value inserted/updated). This is not
// a great work-around. I filed a bug report on the mailing list;
// hopefully it will get fixed soon.
registerColumnType(Types.TINYINT,  [[#variable18cdc3c0]]);
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
11[[#1af23460]]
"time" 
12[[#1af23460]]
"time" 
13[[#1af23460]]
"time" 
14[[#1af23460]]
"time" 
15[[#1af23460]]
"time" 
16[[#1af23460]]
"time" 
17[[#1af23460]]
"time" 
18[[#1af23460]]
"datetime hour to second" 
19[[#1af23460]]
"date" 
110[[#1af23460]]
"time" 
111[[#1af23460]]
"time" 
112[[#1af23460]]
"date" 
113[[#1af23460]]
"time" 
114[[#1af23460]]
"time" 
115[[#1af23460]]
"date" 
116[[#1af23460]]
"datetime" 
117[[#1af23460]]
"time" 
21[[#1af23380]]
"timestamp" 
22[[#1af23380]]
"timestamp" 
23[[#1af23380]]
"timestamp" 
24[[#1af23380]]
"timestamp" 
25[[#1af23380]]
"timestamp" 
26[[#1af23380]]
"timestamp" 
27[[#1af23380]]
"timestamp" 
28[[#1af23380]]
"datetime year to fraction(5)" 
29[[#1af23380]]
"date" 
210[[#1af23380]]
"timestamp" 
211[[#1af23380]]
"timestamp" 
212[[#1af23380]]
"timestamp" 
213[[#1af23380]]
"timestamp" 
214[[#1af23380]]
"timestamp" 
215[[#1af23380]]
"timestamp" 
216[[#1af23380]]
"datetime" 
217[[#1af23380]]
"datetime" 
31[[#18cdc3c0]]
"tinyint" 
32[[#18cdc3c0]]
"smallint" 
33[[#18cdc3c0]]
"smallint" 
34[[#18cdc3c0]]
"tinyint" 
35[[#18cdc3c0]]
"tinyint" 
36[[#18cdc3c0]]
"smallint" 
37[[#18cdc3c0]]
"tinyint" 
38[[#18cdc3c0]]
"smallint" 
39[[#18cdc3c0]]
"tinyint" 
310[[#18cdc3c0]]
"smallint" 
311[[#18cdc3c0]]
"tinyint" 
312[[#18cdc3c0]]
"smallint" 
313[[#18cdc3c0]]
"smallint" 
314[[#18cdc3c0]]
"int" 
315[[#18cdc3c0]]
"tinyint" 
316[[#18cdc3c0]]
"tinyint" 
317[[#18cdc3c0]]
"tinyint"