IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName, null, schemas[i], DatabaseObjectType.SCHEMA, md); if(filterMatcher.matches(dbo.getSimpleName())) { childNodes.add(new ObjectTreeNode(session, dbo)); }
IDatabaseObjectInfo dbinfo = new DatabaseObjectInfo(catalogName, schemaName, rs.getString(1), _objectType._childDboType, md); if(filterMatcher.matches(dbinfo.getSimpleName())) { childNodes.add(new ObjectTreeNode(session, dbinfo)); }
Clone fragments detected by clone detection tool
File path: /sql12/app/src/net/sourceforge/squirrel_sql/client/session/mainpanel/objecttree/expanders/DatabaseExpander.java File path: /sql12/plugins/oracle/src/net/sourceforge/squirrel_sql/plugins/oracle/expander/ObjectTypeExpander.java
Method name: List createSchemaNodes(ISession, SQLDatabaseMetaData, String) Method name: List createNodes(ISession, String, String)
Number of AST nodes: 3 Number of AST nodes: 3
1
IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName, null,
1
IDatabaseObjectInfo dbinfo = new DatabaseObjectInfo(catalogName,
2
                                    schemas[i],
3
                                    DatabaseObjectType.SCHEMA
2
											schemaName, rs.getString(1),
4
, md);
3
											_objectType._childDboType, md);
5
            if(filterMatcher.matches(dbo.getSimpleName()))
4
               if(filterMatcher.matches(dbinfo.getSimpleName()))
6
            {
5
            
6
   {
7
               childNodes.add(new ObjectTreeNode(session, dbo));
7
                  childNodes.add(new ObjectTreeNode(session, dbinfo));
8
				}
8
               }
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
Number of node comparisons6
  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
    7
    IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName, null, schemas[i], DatabaseObjectType.SCHEMA, md);
    7
    IDatabaseObjectInfo dbo = new DatabaseObjectInfo(catalogName, null, schemas[i], DatabaseObjectType.SCHEMA, md);
    13
    IDatabaseObjectInfo dbinfo = new DatabaseObjectInfo(catalogName, schemaName, rs.getString(1), _objectType._childDboType, md);
    Differences
    Expression1Expression2Difference
    dbodbinfoVARIABLE_NAME_MISMATCH
    nullschemaNameTYPE_COMPATIBLE_REPLACEMENT
    schemas[i]rs.getString(1)TYPE_COMPATIBLE_REPLACEMENT
    net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectTypenet.sourceforge.squirrel_sql.plugins.oracle.expander.ObjectTypeVARIABLE_TYPE_MISMATCH
    SCHEMA_childDboTypeVARIABLE_NAME_MISMATCH
    Preondition Violations
    Type net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectType of variable DatabaseObjectType does not match with type net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectType of variable _objectType._childDboType
    • Make classes net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectType and net.sourceforge.squirrel_sql.plugins.oracle.expander.ObjectType extend a common superclass
    13
    IDatabaseObjectInfo dbinfo = new DatabaseObjectInfo(catalogName, schemaName, rs.getString(1), _objectType._childDboType, md);
    8
    if (filterMatcher.matches(dbo.getSimpleName()))
    8
    if (filterMatcher.matches(dbo.getSimpleName()))
    14
    if (filterMatcher.matches(dbinfo.getSimpleName()))
    Differences
    Expression1Expression2Difference
    dbodbinfoVARIABLE_NAME_MISMATCH
    net.sourceforge.squirrel_sql.client.session.schemainfo.SchemaFilterMatchernet.sourceforge.squirrel_sql.client.session.schemainfo.ObjFilterMatcherSUBCLASS_TYPE_MISMATCH
    14
    if (filterMatcher.matches(dbinfo.getSimpleName()))
    9
    childNodes.add(new ObjectTreeNode(session, dbo));
    9
    childNodes.add(new ObjectTreeNode(session, dbo));
    15
    childNodes.add(new ObjectTreeNode(session, dbinfo));
    Differences
    Expression1Expression2Difference
    dbodbinfoVARIABLE_NAME_MISMATCH
    15
    childNodes.add(new ObjectTreeNode(session, dbinfo));
    Precondition Violations (1)
    Row Violation
    1Type net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectType of variable DatabaseObjectType does not match with type net.sourceforge.squirrel_sql.fw.sql.DatabaseObjectType of variable _objectType._childDboType