ArrayList<DefaultConstraint> results = new ArrayList<DefaultConstraint>(); for (int i = 0; i < _constraints.size(); i++) { MssqlConstraint constraint = _constraints.get(i); if (constraint instanceof DefaultConstraint) { DefaultConstraint def = (DefaultConstraint) constraint; if (def.constrainsColumn(columnName)) results.add(def); } } return results;
ArrayList<ForeignKeyConstraint> results = new ArrayList<ForeignKeyConstraint>(); for (int i = 0; i < _constraints.size(); i++) { MssqlConstraint constraint = _constraints.get(i); if (constraint instanceof ForeignKeyConstraint) { results.add((ForeignKeyConstraint)constraint); } } return results;
Clone fragments detected by clone detection tool
File path: /sql12/plugins/mssql/src/net/sourceforge/squirrel_sql/plugins/mssql/sql/constraint/TableConstraints.java File path: /sql12/plugins/mssql/src/net/sourceforge/squirrel_sql/plugins/mssql/sql/constraint/TableConstraints.java
Method name: List getDefaultsForColumn(String) Method name: List getForeignKeyConstraints()
Number of AST nodes: 8 Number of AST nodes: 6
1
ArrayList<DefaultConstraint> results = 
1
ArrayList<ForeignKeyConstraint> results = 
2
new ArrayList<DefaultConstraint>();
2
            new ArrayList<ForeignKeyConstraint>();
3
        for (int i = 0; i < _constraints.size(); i++) {
3
        for (int i = 0; i < _constraints.size(); i++) {
4
            MssqlConstraint constraint = _constraints.get(i);
4
            MssqlConstraint constraint = _constraints.get(i);
5
            if (constraint instanceof DefaultConstraint) {
5
            if (constraint instanceof ForeignKeyConstraint) {
6
                DefaultConstraint def = (DefaultConstraint) constraint;
6
                
7
                if (def.constrainsColumn(columnName))
8
                    results.add(def);
7
results.add((ForeignKeyConstraint)constraint);
9
            }
8
            }
10
        }
9
        }
11
        return results;
10
        return results;
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.1
Clones locationClones are declared in the same class
Number of node comparisons7
  1. {Non-refactorable}
    Mapping Summary
    Number of mapped statements3
    Number of unmapped statements in the first code fragment0
    Number of unmapped statements in the second code fragment0
    Time elapsed for statement mapping (ms)3.3
    Clone typeType 2
    Mapped Statements
    ID Statement ID Statement
    5
    DefaultConstraint def = (DefaultConstraint)constraint;
    5
    DefaultConstraint def = (DefaultConstraint)constraint;
    3
    MssqlConstraint constraint = _constraints.get(i);
    Differences
    Expression1Expression2Difference
    net.sourceforge.squirrel_sql.plugins.mssql.sql.constraint.DefaultConstraintnet.sourceforge.squirrel_sql.plugins.mssql.sql.constraint.MssqlConstraintSUBCLASS_TYPE_MISMATCH
    defconstraintVARIABLE_NAME_MISMATCH
    net.sourceforge.squirrel_sql.plugins.mssql.sql.constraint.DefaultConstraintnet.sourceforge.squirrel_sql.plugins.mssql.sql.constraint.MssqlConstraintSUBCLASS_TYPE_MISMATCH
    net.sourceforge.squirrel_sql.plugins.mssql.sql.constraint.DefaultConstraintnet.sourceforge.squirrel_sql.plugins.mssql.sql.constraint.MssqlConstraintSUBCLASS_TYPE_MISMATCH
    (DefaultConstraint)constraint_constraints.get(i)TYPE_COMPATIBLE_REPLACEMENT
    3
    MssqlConstraint constraint = _constraints.get(i);
    6
    if (def.constrainsColumn(columnName))
    6
    if (def.constrainsColumn(columnName))
    4
    if (constraint instanceof ForeignKeyConstraint)
    Differences
    Expression1Expression2Difference
    def.constrainsColumn(columnName)constraint instanceof ForeignKeyConstraintTYPE_COMPATIBLE_REPLACEMENT
    Preondition Violations
    Expression def.constrainsColumn(columnName) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    Expression constraint instanceof ForeignKeyConstraint cannot be parameterized, because it has dependencies to/from statements that will be extracted
    4
    if (constraint instanceof ForeignKeyConstraint)
    7
    results.add(def);
    7
    results.add(def);
    5
    results.add((ForeignKeyConstraint)constraint);
    Differences
    Expression1Expression2Difference
    net.sourceforge.squirrel_sql.plugins.mssql.sql.constraint.DefaultConstraintnet.sourceforge.squirrel_sql.plugins.mssql.sql.constraint.ForeignKeyConstraintSUBCLASS_TYPE_MISMATCH
    def(ForeignKeyConstraint)constraintTYPE_COMPATIBLE_REPLACEMENT
    Preondition Violations
    Expression def cannot be parameterized, because it has dependencies to/from statements that will be extracted
    Expression (ForeignKeyConstraint)constraint cannot be parameterized, because it has dependencies to/from statements that will be extracted
    Expression def cannot be unified with expression (ForeignKeyConstraint)constraint , because common superclass type net.sourceforge.squirrel_sql.plugins.mssql.sql.constraint.MssqlConstraint cannot be passed as an argument to public boolean add(net.sourceforge.squirrel_sql.plugins.mssql.sql.constraint.DefaultConstraint)
    5
    results.add((ForeignKeyConstraint)constraint);
    Precondition Violations (5)
    Row Violation
    1Expression def.constrainsColumn(columnName) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    2Expression constraint instanceof ForeignKeyConstraint cannot be parameterized, because it has dependencies to/from statements that will be extracted
    3Expression def cannot be parameterized, because it has dependencies to/from statements that will be extracted
    4Expression (ForeignKeyConstraint)constraint cannot be parameterized, because it has dependencies to/from statements that will be extracted
    5Expression def cannot be unified with expression (ForeignKeyConstraint)constraint , because common superclass type net.sourceforge.squirrel_sql.plugins.mssql.sql.constraint.MssqlConstraint cannot be passed as an argument to public boolean add(net.sourceforge.squirrel_sql.plugins.mssql.sql.constraint.DefaultConstraint)