File path: /sql12/test/src/net/sourceforge/squirrel_sql/fw/util/Support_Exec.java | File path: /sql12/plugins/refactoring/src/net/sourceforge/squirrel_sql/plugins/refactoring/commands/DropViewCommand.java | |||
Method name: Object[] execJavaCommon(String[], String[], String[], boolean, boolean)
|
Method name: String[] generateSQLStatements()
|
|||
Number of AST nodes: 4 | Number of AST nodes: 2 | |||
1 | if (classpath != null) {↵ | |||
2 | for (String element : classpath) {↵ | |||
3 | classPathString.append(File.pathSeparator);↵ | |||
4 | classPathString.append(element);↵ | |||
5 | }↵ | |||
6 | ↵ | 1 | for (IDatabaseObjectInfo dbo : _info)↵ | |
2 | {↵ | |||
3 | result.add(_dialect.getDropViewSQL(dbo.getSimpleName(),↵ | |||
4 | customDialog.isCascadeSelected(),↵ | |||
5 | new DatabaseObjectQualifier(dbo.getCatalogName(), dbo.getSchemaName()),↵ | |||
6 | _sqlPrefs)↵ | |||
7 | + "\n");↵ | |||
7 | } | 8 | } | |
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.2 |
Clones location | Clones are in different classes |
Number of node comparisons | 7 |
Number of mapped statements | 1 |
Number of unmapped statements in the first code fragment | 2 |
Number of unmapped statements in the second code fragment | 1 |
Time elapsed for statement mapping (ms) | 23.3 |
Clone type | Type 3 |
ID | Statement | ID | Statement | |||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
14 | for (String element : classpath) |
| 3 | for (IDatabaseObjectInfo dbo : _info) | ||||||||||||||||||
|
| 4 | result.add(_dialect.getDropViewSQL(dbo.getSimpleName(), customDialog.isCascadeSelected(), new DatabaseObjectQualifier(dbo.getCatalogName(), dbo.getSchemaName()), _sqlPrefs) + "\n"); | |||||||||||||||||||
15 | classPathString.append(File.pathSeparator); | | ||||||||||||||||||||
16 | classPathString.append(element); |
| |
Row | Violation |
---|---|
1 | Type java.lang.String does not match with type net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo |
2 | Type java.lang.String[] of variable classpath does not match with type net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo[] of variable _info |
3 | Unmatched statement result.add(_dialect.getDropViewSQL(dbo.getSimpleName(),customDialog.isCascadeSelected(),new DatabaseObjectQualifier(dbo.getCatalogName(),dbo.getSchemaName()),_sqlPrefs) + "\n"); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
4 | Unmatched statement result.add(_dialect.getDropViewSQL(dbo.getSimpleName(),customDialog.isCascadeSelected(),new DatabaseObjectQualifier(dbo.getCatalogName(),dbo.getSchemaName()),_sqlPrefs) + "\n"); cannot be moved before or after the extracted code, because it throws exception(s) that should be caught by a try block that will be extracted |
5 | Unmatched statement classPathString.append(element); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted |
6 | Clone fragment #1 returns variable element with type java.lang.String , while Clone fragment #2 returns variable dbo with type net.sourceforge.squirrel_sql.fw.sql.IDatabaseObjectInfo |
7 | The refactoring of the clones is infeasible, because the number of macthed statements is equal to zero |