StringBuilder result = new StringBuilder(); result.append("ALTER TABLE "); result.append(DialectUtils.shapeQualifiableIdentifier(ti.getSimpleName(), qualifier, prefs, this)); result.append(" ADD CONSTRAINT "); result.append(pkName); result.append(" PRIMARY KEY ("); for (int i = 0; i < columns.length; i++) { String shapedColumn = DialectUtils.shapeIdentifier(columns[i].getColumnName(), prefs, this); result.append(shapedColumn); if (i + 1 < columns.length) { result.append(", "); } } result.append(")"); return new String[] { result.toString() };
StringBuffer result = new StringBuffer(); result.append("ALTER TABLE "); result.append(DialectUtils.shapeQualifiableIdentifier(ti.getSimpleName(), qualifier, prefs, this)); result.append(" ADD CONSTRAINT "); result.append(pkName); result.append(" PRIMARY KEY ("); for (int i = 0; i < columns.length; i++) { result.append(columns[i].getColumnName()); if (i + 1 < columns.length) { result.append(", "); } } result.append(")"); return new String[] { result.toString() };
Clone fragments detected by clone detection tool
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
		return new String[] { result.toString() };
Summary
Number of common nesting structure subtrees1
Number of refactorable cases0
Number of non-refactorable cases1
Time elapsed for finding largest common nesting structure subtrees (ms)0.5
Clones locationClones are in different classes having the same super class
Number of node comparisons60
  1. {Non-refactorable}
    Mapping Summary
    Number of mapped statements12
    Number of unmapped statements in the first code fragment1
    Number of unmapped statements in the second code fragment0
    Time elapsed for statement mapping (ms)16.0
    Clone typeType 3
    Mapped Statements
    ID Statement ID Statement
    1
    StringBuilder result = new StringBuilder();
    1
    StringBuilder result = new StringBuilder();
    1
    StringBuffer result = new StringBuffer();
    Differences
    Expression1Expression2Difference
    java.lang.StringBuilderjava.lang.StringBufferSUBCLASS_TYPE_MISMATCH
    java.lang.StringBuilderjava.lang.StringBufferSUBCLASS_TYPE_MISMATCH
    java.lang.StringBuilderjava.lang.StringBufferSUBCLASS_TYPE_MISMATCH
    1
    StringBuffer result = new StringBuffer();
    2
    result.append("ALTER TABLE ");
    2
    result.append("ALTER TABLE ");
    2
    result.append("ALTER TABLE ");
    Differences
    Expression1Expression2Difference
    java.lang.StringBuilderjava.lang.StringBufferSUBCLASS_TYPE_MISMATCH
    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));
    3
    result.append(DialectUtils.shapeQualifiableIdentifier(ti.getSimpleName(), qualifier, prefs, this));
    Differences
    Expression1Expression2Difference
    java.lang.StringBuilderjava.lang.StringBufferSUBCLASS_TYPE_MISMATCH
    3
    result.append(DialectUtils.shapeQualifiableIdentifier(ti.getSimpleName(), qualifier, prefs, this));
    4
    result.append(" ADD CONSTRAINT ");
    4
    result.append(" ADD CONSTRAINT ");
    4
    result.append(" ADD CONSTRAINT ");
    Differences
    Expression1Expression2Difference
    java.lang.StringBuilderjava.lang.StringBufferSUBCLASS_TYPE_MISMATCH
    4
    result.append(" ADD CONSTRAINT ");
    5
    result.append(pkName);
    5
    result.append(pkName);
    5
    result.append(pkName);
    Differences
    Expression1Expression2Difference
    java.lang.StringBuilderjava.lang.StringBufferSUBCLASS_TYPE_MISMATCH
    5
    result.append(pkName);
    6
    result.append(" PRIMARY KEY (");
    6
    result.append(" PRIMARY KEY (");
    6
    result.append(" PRIMARY KEY (");
    Differences
    Expression1Expression2Difference
    java.lang.StringBuilderjava.lang.StringBufferSUBCLASS_TYPE_MISMATCH
    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);
    8
    String shapedColumn = DialectUtils.shapeIdentifier(columns[i].getColumnName(), prefs, this);
    Preondition Violations
    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
                                                                                                                                                                                          
    9
    result.append(shapedColumn);
    9
    result.append(shapedColumn);
    8
    result.append(columns[i].getColumnName());
    Differences
    Expression1Expression2Difference
    shapedColumncolumns[i].getColumnName()TYPE_COMPATIBLE_REPLACEMENT
    java.lang.StringBuilderjava.lang.StringBufferSUBCLASS_TYPE_MISMATCH
    Preondition Violations
    Expression shapedColumn cannot be parameterized, because it has dependencies to/from statements that will be extracted
    Expression columns[i].getColumnName() cannot be parameterized, because it has dependencies to/from statements that will be extracted
    8
    result.append(columns[i].getColumnName());
    10
    if (i + 1 < columns.length)
    9
    if (i + 1 < columns.length)
    11
    result.append(", ");
    11
    result.append(", ");
    10
    result.append(", ");
    Differences
    Expression1Expression2Difference
    java.lang.StringBuilderjava.lang.StringBufferSUBCLASS_TYPE_MISMATCH
    10
    result.append(", ");
    12
    result.append(")");
    12
    result.append(")");
    11
    result.append(")");
    Differences
    Expression1Expression2Difference
    java.lang.StringBuilderjava.lang.StringBufferSUBCLASS_TYPE_MISMATCH
    11
    result.append(")");
    13
    return new String[] {result.toString()};
    13
    return new String[] {result.toString()};
    12
    return new String[] {result.toString()};
    Differences
    Expression1Expression2Difference
    java.lang.StringBuilderjava.lang.StringBufferSUBCLASS_TYPE_MISMATCH
    12
    return new String[] {result.toString()};
    Precondition Violations (4)
    Row Violation
    1Unmatched 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
    2Expression shapedColumn cannot be parameterized, because it has dependencies to/from statements that will be extracted
    3Expression columns[i].getColumnName() cannot be parameterized, because it has dependencies to/from statements that will be extracted
    4Clone fragment #1 returns variables i , while Clone fragment #2 returns variables