File path: /sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/FirebirdDialectExt.java | File path: /sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/OracleDialectExt.java | |||
Method name: String[] getAddPrimaryKeySQL(String, TableColumnInfo[], ITableInfo, DatabaseObjectQualifier, SqlGenerationPreferences)
|
Method name: String[] getAddPrimaryKeySQL(String, TableColumnInfo[], ITableInfo, DatabaseObjectQualifier, SqlGenerationPreferences)
|
|||
Number of AST nodes: 13 | Number of AST nodes: 12 | |||
1 | StringBuilder result = new StringBuilder();↵ | 1 | StringBuffer result = new StringBuffer();↵ | |
2 | result.append("ALTER TABLE ");↵ | 2 | result.append("ALTER TABLE ");↵ | |
3 | result.append(DialectUtils.shapeQualifiableIdentifier(ti.getSimpleName(), qualifier, prefs, this));↵ | 3 | result.append(DialectUtils.shapeQualifiableIdentifier(ti.getSimpleName(), qualifier, prefs, this));↵ | |
4 | result.append(" ADD CONSTRAINT ");↵ | 4 | result.append(" ADD CONSTRAINT ");↵ | |
5 | result.append(pkName);↵ | 5 | result.append(pkName);↵ | |
6 | result.append(" PRIMARY KEY (");↵ | 6 | result.append(" PRIMARY KEY (");↵ | |
7 | for (int i = 0; i < columns.length; i++)↵ | 7 | for (int i = 0; i < columns.length; i++)↵ | |
8 | {↵ | 8 | {↵ | |
9 | String shapedColumn = DialectUtils.shapeIdentifier(columns[i].getColumnName(), prefs, this);↵ | 9 | ↵ | |
10 | result.append(shapedColumn);↵ | 10 | result.append(columns[i].getColumnName());↵ | |
11 | if (i + 1 < columns.length)↵ | 11 | if (i + 1 < columns.length)↵ | |
12 | {↵ | 12 | {↵ | |
13 | result.append(", ");↵ | 13 | result.append(", ");↵ | |
14 | }↵ | 14 | }↵ | |
15 | }↵ | 15 | }↵ | |
16 | result.append(")");↵ | 16 | result.append(")");↵ | |
17 | return new String[] { result.toString() }; | 17 |
| |
See real code fragment | See real code fragment |
Number of common nesting structure subtrees | 1 |
Number of refactorable cases | 0 |
Number of non-refactorable cases | 1 |
Time elapsed for finding largest common nesting structure subtrees (ms) | 0.5 |
Clones location | Clones are in different classes having the same super class |
Number of node comparisons | 60 |
Number of mapped statements | 12 |
Number of unmapped statements in the first code fragment | 1 |
Number of unmapped statements in the second code fragment | 0 |
Time elapsed for statement mapping (ms) | 16.0 |
Clone type | Type 3 |
ID | Statement | ID | Statement | |||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | StringBuilder result = new StringBuilder(); |
| 1 | StringBuffer result = new StringBuffer(); | ||||||||||||||||
2 | result.append("ALTER TABLE "); |
| 2 | result.append("ALTER TABLE "); | ||||||||||||||||
3 | result.append(DialectUtils.shapeQualifiableIdentifier(ti.getSimpleName(), qualifier, prefs, this)); |
| 3 | result.append(DialectUtils.shapeQualifiableIdentifier(ti.getSimpleName(), qualifier, prefs, this)); | ||||||||||||||||
4 | result.append(" ADD CONSTRAINT "); |
| 4 | result.append(" ADD CONSTRAINT "); | ||||||||||||||||
5 | result.append(pkName); |
| 5 | result.append(pkName); | ||||||||||||||||
6 | result.append(" PRIMARY KEY ("); |
| 6 | result.append(" PRIMARY KEY ("); | ||||||||||||||||
7 | for (int i = 0; i < columns.length; i++) | 7 | for (int i = 0; i < columns.length; i++) | |||||||||||||||||
8 | String shapedColumn = DialectUtils.shapeIdentifier(columns[i].getColumnName(), prefs, this); |
| | |||||||||||||||||
9 | result.append(shapedColumn); |
| 8 | result.append(columns[i].getColumnName()); | ||||||||||||||||
10 | if (i + 1 < columns.length) | 9 | if (i + 1 < columns.length) | |||||||||||||||||
11 | result.append(", "); |
| 10 | result.append(", "); | ||||||||||||||||
12 | result.append(")"); |
| 11 | result.append(")"); | ||||||||||||||||
13 | return new String[] {result.toString()}; |
| 12 | return new String[] {result.toString()}; |
Row | Violation |
---|---|
1 | Unmatched statement String shapedColumn=DialectUtils.shapeIdentifier(columns[i].getColumnName(),prefs,this); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
2 | Expression shapedColumn cannot be parameterized, because it has dependencies to/from statements that will be extracted |
3 | Expression columns[i].getColumnName() cannot be parameterized, because it has dependencies to/from statements that will be extracted |
4 | Clone fragment #1 returns variables i , while Clone fragment #2 returns variables |