File path: /sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/H2DialectExt.java | File path: /sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/SybaseDialectExt.java | |||
Method name: String getViewDefinitionSQL(String, DatabaseObjectQualifier, SqlGenerationPreferences)
|
Method name: String getViewDefinitionSQL(String, DatabaseObjectQualifier, SqlGenerationPreferences)
|
|||
Number of AST nodes: 5 | Number of AST nodes: 5 | |||
1 | String templateStr =↵ | 1 | String sql =↵ | |
2 | "select view_definition from information_schema.views "↵ | 2 | "select text from sysobjects inner join syscomments on syscomments.id = sysobjects.id "↵ | |
3 | + "where table_schema = '$schemaName$' and UPPER(table_↵ | 3 | + "where (loginame = '$catalogName$' or loginame is null) " +↵ | |
4 | name) = UPPER('$viewName$') ";↵ | 4 | "and name = '$viewName$' and text not like '%--%'"; ↵ | |
5 | StringTemplate st = new StringTemplate(templateStr);↵ | 5 | StringTemplate st = new StringTemplate(sql);↵ | |
6 | st.setAttribute(ST_SCHEMA_NAME_KEY, qualifier.getSchema());↵ | 6 | st.setAttribute(ST_CATALOG_NAME_KEY, qualifier.getCatalog());↵ | |
7 | st.setAttribute(ST_VIEW_NAME_KEY, viewName);↵ | 7 | st.setAttribute(ST_VIEW_NAME_KEY, viewName);↵ | |
8 | return st.toString(); | 8 |
| |
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.0 |
Clones location | Clones are in different classes having the same super class |
Number of node comparisons | 17 |
Number of mapped statements | 5 |
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) | 0.0 |
Clone type | Type 2 |
ID | Statement | ID | Statement | ||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | String templateStr = "select view_definition from information_schema.views " + "where table_schema = '$schemaName$' and UPPER(table_name) = UPPER('$viewName$') "; |
| 1 | String sql = "select text from sysobjects inner join syscomments on syscomments.id = sysobjects.id " + "where (loginame = '$catalogName$' or loginame is null) " + "and name = '$viewName$' and text not like '%--%'"; | |||||||||||||||||||
2 | StringTemplate st = new StringTemplate(templateStr); |
| 2 | StringTemplate st = new StringTemplate(sql); | |||||||||||||||||||
3 | st.setAttribute(ST_SCHEMA_NAME_KEY, qualifier.getSchema()); |
| 4 | st.setAttribute(ST_VIEW_NAME_KEY, viewName); | |||||||||||||||||||
4 | st.setAttribute(ST_VIEW_NAME_KEY, viewName); |
| 3 | st.setAttribute(ST_CATALOG_NAME_KEY, qualifier.getCatalog()); | |||||||||||||||||||
5 | return st.toString(); | 5 | return st.toString(); |
Row | Violation |
---|