String templateStr = "select view_definition from information_schema.views " + "where table_schema = '$schemaName$' and UPPER(table_name) = UPPER('$viewName$') "; StringTemplate st = new StringTemplate(templateStr); st.setAttribute(ST_SCHEMA_NAME_KEY, qualifier.getSchema()); st.setAttribute(ST_VIEW_NAME_KEY, viewName); return st.toString();
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 '%--%'"; StringTemplate st = new StringTemplate(sql); st.setAttribute(ST_CATALOG_NAME_KEY, qualifier.getCatalog()); st.setAttribute(ST_VIEW_NAME_KEY, viewName); return st.toString();
Clone fragments detected by clone detection tool
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
		return st.toString();
Summary
Number of common nesting structure subtrees1
Number of refactorable cases1
Number of non-refactorable cases0
Time elapsed for finding largest common nesting structure subtrees (ms)0.0
Clones locationClones are in different classes having the same super class
Number of node comparisons17
  1. {Refactorable}
    Mapping Summary
    Number of mapped statements5
    Number of unmapped statements in the first code fragment0
    Number of unmapped statements in the second code fragment0
    Time elapsed for statement mapping (ms)0.0
    Clone typeType 2
    Mapped Statements
    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 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 '%--%'";
    Differences
    Expression1Expression2Difference
    templateStrsqlVARIABLE_NAME_MISMATCH
    "select view_definition from information_schema.views ""select text from sysobjects inner join syscomments on syscomments.id = sysobjects.id "LITERAL_VALUE_MISMATCH
    "where table_schema = '$schemaName$' and UPPER(table_name) = UPPER('$viewName$') ""where (loginame = '$catalogName$' or loginame is null) "LITERAL_VALUE_MISMATCH
    "select view_definition from information_schema.views " + "where table_schema = '$schemaName$' and UPPER(table_name) = UPPER('$viewName$') ""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 '%--%'"INFIX_EXTENDED_OPERAND_NUMBER_MISMATCH
    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(templateStr);
    2
    StringTemplate st = new StringTemplate(sql);
    Differences
    Expression1Expression2Difference
    templateStrsqlVARIABLE_NAME_MISMATCH
    2
    StringTemplate st = new StringTemplate(sql);
    3
    st.setAttribute(ST_SCHEMA_NAME_KEY, qualifier.getSchema());
    3
    st.setAttribute(ST_SCHEMA_NAME_KEY, qualifier.getSchema());
    4
    st.setAttribute(ST_VIEW_NAME_KEY, viewName);
    Differences
    Expression1Expression2Difference
    ST_SCHEMA_NAME_KEYST_VIEW_NAME_KEYVARIABLE_NAME_MISMATCH
    qualifier.getSchema()viewNameTYPE_COMPATIBLE_REPLACEMENT
    4
    st.setAttribute(ST_VIEW_NAME_KEY, viewName);
    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());
    Differences
    Expression1Expression2Difference
    ST_VIEW_NAME_KEYST_CATALOG_NAME_KEYVARIABLE_NAME_MISMATCH
    viewNamequalifier.getCatalog()TYPE_COMPATIBLE_REPLACEMENT
    3
    st.setAttribute(ST_CATALOG_NAME_KEY, qualifier.getCatalog());
    5
    return st.toString();
    5
    return st.toString();
    Precondition Violations (0)
    Row Violation