File path: /sql12/test/adhoc/test/ProgressGetTablesTest.java | File path: /sql12/test/adhoc/test/SybaseNonDboTableTest.java | |||
Method name: void test(Connection)
|
Method name: void test(Connection)
|
|||
Number of AST nodes: 16 | Number of AST nodes: 16 | |||
1 | DatabaseMetaData md = con.getMetaData();↵ | 1 | DatabaseMetaData md = con.getMetaData();↵ | |
2 | ↵ | 2 | ↵ | |
3 | String cat = "DBCOPYDEST";↵ | 3 | String cat = "dbcopydest";↵ | |
4 | String schemaPattern = "MANNINGR";↵ | 4 | String schemaPattern = null;↵ | |
5 | String tableNamePattern = "TEST";↵ | 5 | String tableNamePattern = null;↵ | |
6 | ResultSet rs = md.getTables(cat,↵ | 6 | ResultSet rs = md.getTables(cat,↵ | |
7 | schemaPattern,↵ | 7 | schemaPattern,↵ | |
8 | tableNamePattern,↵ | 8 | tableNamePattern,↵ | |
9 | new String[] { "TABLE" });↵ | 9 | new String[] { "TABLE" });↵ | |
10 | while (rs.next()) {↵ | 10 | while (rs.next()) {↵ | |
11 | /*↵ | 11 | /*↵ | |
12 | * String catalog, String schema, String simpleName,↵ | 12 | * String catalog, String schema, String simpleName,↵ | |
13 | String tableType, String remarks,↵ | 13 | String tableType, String remarks,↵ | |
14 | */↵ | 14 | */↵ | |
15 | String catalog = rs.getString(1);↵ | 15 | String catalog = rs.getString(1);↵ | |
16 | String schema = rs.getString(2);↵ | 16 | String schema = rs.getString(2);↵ | |
17 | String simpleName = rs.getString(3);↵ | 17 | String simpleName = rs.getString(3);↵ | |
18 | String tableType = rs.getString(4);↵ | 18 | String tableType = rs.getString(4);↵ | |
19 | String remarks = rs.getString(5);↵ | 19 | String remarks = rs.getString(5);↵ | |
20 | System.out.println("catalog: "+catalog);↵ | 20 | System.out.println("catalog: "+catalog);↵ | |
21 | System.out.println("schema: "+schema);↵ | 21 | System.out.println("schema: "+schema);↵ | |
22 | System.out.println("simpleName: "+simpleName);↵ | 22 | System.out.println("simpleName: "+simpleName);↵ | |
23 | System.out.println("tableType: "+tableType);↵ | 23 | System.out.println("tableType: "+tableType);↵ | |
24 | System.out.println("remarks: "+remarks);↵ | 24 | System.out.println("remarks: "+remarks);↵ | |
25 | } | 25 |
| |
See real code fragment | See real code fragment |
Number of common nesting structure subtrees | 1 |
Number of refactorable cases | 1 |
Number of non-refactorable cases | 0 |
Time elapsed for finding largest common nesting structure subtrees (ms) | 0.1 |
Clones location | Clones are in different classes |
Number of node comparisons | 146 |
Number of mapped statements | 16 |
Number of unmapped statements in the first code fragment | 0 |
Number of unmapped statements in the second code fragment | 0 |
Time elapsed for statement mapping (ms) | 14.1 |
Clone type | Type 2 |
ID | Statement | ID | Statement | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | DatabaseMetaData md = con.getMetaData(); | 1 | DatabaseMetaData md = con.getMetaData(); | |||||||||||
2 | String cat = "DBCOPYDEST"; |
| 2 | String cat = "dbcopydest"; | ||||||||||
3 | String schemaPattern = "MANNINGR"; |
| 3 | String schemaPattern = null; | ||||||||||
4 | String tableNamePattern = "TEST"; |
| 4 | String tableNamePattern = null; | ||||||||||
5 | ResultSet rs = md.getTables(cat, schemaPattern, tableNamePattern, new String[] {"TABLE"}); | 5 | ResultSet rs = md.getTables(cat, schemaPattern, tableNamePattern, new String[] {"TABLE"}); | |||||||||||
6 | while (rs.next()) | 6 | while (rs.next()) | |||||||||||
7 | String catalog = rs.getString(1); | 7 | String catalog = rs.getString(1); | |||||||||||
8 | String schema = rs.getString(2); | 8 | String schema = rs.getString(2); | |||||||||||
9 | String simpleName = rs.getString(3); | 9 | String simpleName = rs.getString(3); | |||||||||||
10 | String tableType = rs.getString(4); | 10 | String tableType = rs.getString(4); | |||||||||||
11 | String remarks = rs.getString(5); | 11 | String remarks = rs.getString(5); | |||||||||||
12 | System.out.println("catalog: " + catalog); | 12 | System.out.println("catalog: " + catalog); | |||||||||||
13 | System.out.println("schema: " + schema); | 13 | System.out.println("schema: " + schema); | |||||||||||
14 | System.out.println("simpleName: " + simpleName); | 14 | System.out.println("simpleName: " + simpleName); | |||||||||||
15 | System.out.println("tableType: " + tableType); | 15 | System.out.println("tableType: " + tableType); | |||||||||||
16 | System.out.println("remarks: " + remarks); | 16 | System.out.println("remarks: " + remarks); |
Row | Violation |
---|