int endIx = matcher.end(1); int len = matcher.group(1).length(); String proc = sql.substring(endIx - len, endIx); String[] splits = proc.split("\\."); String simpleName = splits[splits.length - 1]; simpleName = removeQuotes(simpleName); if(isAlterOrDrop) { String buf = _session.getSchemaInfo().getCaseSensitiveProcedureName(simpleName); if(null != buf) { simpleName = buf; } return new ProcedureInfo[]{new ProcedureInfo(null, null, simpleName, null, DatabaseMetaData.procedureResultUnknown, _dmd)}; } else { // DB2 stores all names in upper case. // PostgreSQL stores all names in lower case. // That's why we may not find proc as it was written in the create statement. // So we try out the upper and lower case names too. return new ProcedureInfo[] { new ProcedureInfo(null, null, simpleName, null, DatabaseMetaData.procedureResultUnknown, _dmd), new ProcedureInfo(null, null, simpleName.toUpperCase(), null, DatabaseMetaData.procedureResultUnknown, _dmd), new ProcedureInfo(null, null, simpleName.toLowerCase(), null, DatabaseMetaData.procedureResultUnknown, _dmd) }; }
int endIx = matcher.end(1); int len = matcher.group(1).length(); String table = sql.substring(endIx - len, endIx); String[] splits = table.split("\\."); String simpleName = splits[splits.length - 1]; simpleName = removeQuotes(simpleName); if(isAlterOrDrop) { String buf = _session.getSchemaInfo().getCaseSensitiveTableName(simpleName); if(null != buf) { simpleName = buf; } return new TableInfo[]{new TableInfo(null, null, simpleName, type, null, _dmd)}; } else { // DB2 stores all names in upper case. // PostgreSQL stores table names in lower case. // That's why we may not find table as it was written in the create statement. // So we try out the upper and lower case names too. return new TableInfo[] { new TableInfo(null, null, simpleName, type, null, _dmd), new TableInfo(null, null, simpleName.toUpperCase(), type, null, _dmd), new TableInfo(null, null, simpleName.toLowerCase(), type, null, _dmd) }; }
Clone fragments detected by clone detection tool
File path: /sql12/app/src/net/sourceforge/squirrel_sql/client/session/schemainfo/SchemaInfoUpdateCheck.java File path: /sql12/app/src/net/sourceforge/squirrel_sql/client/session/schemainfo/SchemaInfoUpdateCheck.java
Method name: ProcedureInfo[] createProcdureInfos(Matcher, String, boolean) Method name: TableInfo[] createTableInfos(Matcher, String, String, boolean)
Number of AST nodes: 12 Number of AST nodes: 12
1
int endIx = matcher.end(1);
1
int endIx = matcher.end(1);
2
      int len = matcher.group(1).length();
2
      int len = matcher.group(1).length();
3
      String proc = sql.substring(endIx - len, endIx);
3
      String table = sql.substring(endIx - len, endIx);
4
      String[] splits = proc.split("\\.");
4
      String[] splits = table.split("\\.");
5
      String simpleName = splits[splits.length - 1];
5
      String simpleName = splits[splits.length - 1];
6
      simpleName = removeQuotes(simpleName);
6
      simpleName = removeQuotes(simpleName);
7
      if(isAlterOrDrop)
7
      if(isAlterOrDrop)
8
      {
8
      {
9
         String buf = _session.getSchemaInfo().getCaseSensitiveProcedureName(simpleName);
9
         String buf = _session.getSchemaInfo().getCaseSensitiveTableName(simpleName);
10
         if(null != buf)
10
         if(null != buf)
11
         {
11
         {
12
            simpleName = buf;
12
            simpleName = buf;
13
         }
13
         }
14
         return new ProcedureInfo[]{new ProcedureInfo(null, null, simpleName, null, DatabaseMetaData.procedureResultUnknown, _dmd)};
14
         return new TableInfo[]{new TableInfo(null, null, simpleName, type, null, _dmd)};
15
      }
15
      }
16
      else
16
      else
17
      {
17
      {
18
         // DB2 stores all names in upper case.
18
         // DB2 stores all names in upper case.
19
         // PostgreSQL stores all names in lower case.
19
         // PostgreSQL stores table names in lower case.
20
         // That's why we may not find proc as it was written in the create statement.
20
         // That's why we may not find table as it was written in the create statement.
21
         // So we try out the upper and lower case names too.
21
         // So we try out the upper and lower case names too.
22
         return new ProcedureInfo[]
22
         return new TableInfo[]
23
            {
23
            {
24
               new ProcedureInfo(null, null, simpleName, null, DatabaseMetaData.procedureResultUnknown, _dmd),
24
               new TableInfo(null, null, simpleName, type, null, _dmd),
25
               new ProcedureInfo(null, null, simpleName.toUpperCase(), null, DatabaseMetaData.procedureResultUnknown, _dmd),
25
               new TableInfo(null, null, simpleName.toUpperCase(), type, null, _dmd),
26
               new ProcedureInfo(null, null, simpleName.toLowerCase(), null, DatabaseMetaData.procedureResultUnknown, _dmd)
26
               new TableInfo(null, null, simpleName.toLowerCase(), type, null, _dmd)
27
            };
27
            };
28
      }
28
      }
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.2
Clones locationClones are declared in the same class
Number of node comparisons56
  1. {Non-refactorable}
    Mapping Summary
    Number of mapped statements10
    Number of unmapped statements in the first code fragment2
    Number of unmapped statements in the second code fragment2
    Time elapsed for statement mapping (ms)21.1
    Clone typeType 2
    Mapped Statements
    ID Statement ID Statement
    1
    int endIx = matcher.end(1);
    1
    int endIx = matcher.end(1);
    2
    int len = matcher.group(1).length();
    2
    int len = matcher.group(1).length();
    3
    String proc = sql.substring(endIx - len, endIx);
    3
    String proc = sql.substring(endIx - len, endIx);
    3
    String table = sql.substring(endIx - len, endIx);
    Differences
    Expression1Expression2Difference
    proctableVARIABLE_NAME_MISMATCH
    3
    String table = sql.substring(endIx - len, endIx);
    4
    String[] splits = proc.split("\\.");
    4
    String[] splits = proc.split("\\.");
    4
    String[] splits = table.split("\\.");
    Differences
    Expression1Expression2Difference
    proctableVARIABLE_NAME_MISMATCH
    4
    String[] splits = table.split("\\.");
    5
    String simpleName = splits[splits.length - 1];
    5
    String simpleName = splits[splits.length - 1];
    6
    simpleName = removeQuotes(simpleName);
    6
    simpleName = removeQuotes(simpleName);
    7
    if (isAlterOrDrop)
    7
    if (isAlterOrDrop)
    8
    String buf = _session.getSchemaInfo().getCaseSensitiveProcedureName(simpleName);
    8
    String buf = _session.getSchemaInfo().getCaseSensitiveProcedureName(simpleName);
    8
    String buf = _session.getSchemaInfo().getCaseSensitiveTableName(simpleName);
    Differences
    Expression1Expression2Difference
    getCaseSensitiveProcedureNamegetCaseSensitiveTableNameMETHOD_INVOCATION_NAME_MISMATCH
    Preondition Violations
    Expression _session.getSchemaInfo().getCaseSensitiveProcedureName(simpleName) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    Expression _session.getSchemaInfo().getCaseSensitiveTableName(simpleName) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    8
    String buf = _session.getSchemaInfo().getCaseSensitiveTableName(simpleName);
    9
    if (null != buf)
    9
    if (null != buf)
    10
    simpleName = buf;
    10
    simpleName = buf;
                                                                                                                                                                  
    11
    return new TableInfo[] {new TableInfo(null, null, simpleName, type, null, _dmd)};
    Preondition Violations
    Unmatched statement return new TableInfo[]{new TableInfo(null,null,simpleName,type,null,_dmd)}; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    Unmatched return new TableInfo[]{new TableInfo(null,null,simpleName,type,null,_dmd)};
    11
    return new TableInfo[] {new TableInfo(null, null, simpleName, type, null, _dmd)};
    11
    return new ProcedureInfo[] {new ProcedureInfo(null, null, simpleName, null, DatabaseMetaData.procedureResultUnknown, _dmd)};
    11
    return new ProcedureInfo[] {new ProcedureInfo(null, null, simpleName, null, DatabaseMetaData.procedureResultUnknown, _dmd)};
    Preondition Violations
    Unmatched statement return new ProcedureInfo[]{new ProcedureInfo(null,null,simpleName,null,DatabaseMetaData.procedureResultUnknown,_dmd)}; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    Unmatched return new ProcedureInfo[]{new ProcedureInfo(null,null,simpleName,null,DatabaseMetaData.procedureResultUnknown,_dmd)};
                                                                                                                                                                                                                                                        
    else
            
                                                                                                                                                                                                                                                                                                                                                                                                                                      
    12
    return new TableInfo[] {new TableInfo(null, null, simpleName, type, null, _dmd), new TableInfo(null, null, simpleName.toUpperCase(), type, null, _dmd), new TableInfo(null, null, simpleName.toLowerCase(), type, null, _dmd)};
    Preondition Violations
    Unmatched statement return new TableInfo[]{new TableInfo(null,null,simpleName,type,null,_dmd),new TableInfo(null,null,simpleName.toUpperCase(),type,null,_dmd),new TableInfo(null,null,simpleName.toLowerCase(),type,null,_dmd)}; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    Unmatched return new TableInfo[]{new TableInfo(null,null,simpleName,type,null,_dmd),new TableInfo(null,null,simpleName.toUpperCase(),type,null,_dmd),new TableInfo(null,null,simpleName.toLowerCase(),type,null,_dmd)};
    12
    return new TableInfo[] {new TableInfo(null, null, simpleName, type, null, _dmd), new TableInfo(null, null, simpleName.toUpperCase(), type, null, _dmd), new TableInfo(null, null, simpleName.toLowerCase(), type, null, _dmd)};
    12
    return new ProcedureInfo[] {new ProcedureInfo(null, null, simpleName, null, DatabaseMetaData.procedureResultUnknown, _dmd), new ProcedureInfo(null, null, simpleName.toUpperCase(), null, DatabaseMetaData.procedureResultUnknown, _dmd), new ProcedureInfo(null, null, simpleName.toLowerCase(), null, DatabaseMetaData.procedureResultUnknown, _dmd)};
    12
    return new ProcedureInfo[] {new ProcedureInfo(null, null, simpleName, null, DatabaseMetaData.procedureResultUnknown, _dmd), new ProcedureInfo(null, null, simpleName.toUpperCase(), null, DatabaseMetaData.procedureResultUnknown, _dmd), new ProcedureInfo(null, null, simpleName.toLowerCase(), null, DatabaseMetaData.procedureResultUnknown, _dmd)};
    Preondition Violations
    Unmatched statement return new ProcedureInfo[]{new ProcedureInfo(null,null,simpleName,null,DatabaseMetaData.procedureResultUnknown,_dmd),new ProcedureInfo(null,null,simpleName.toUpperCase(),null,DatabaseMetaData.procedureResultUnknown,_dmd),new ProcedureInfo(null,null,simpleName.toLowerCase(),null,DatabaseMetaData.procedureResultUnknown,_dmd)}; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    Unmatched return new ProcedureInfo[]{new ProcedureInfo(null,null,simpleName,null,DatabaseMetaData.procedureResultUnknown,_dmd),new ProcedureInfo(null,null,simpleName.toUpperCase(),null,DatabaseMetaData.procedureResultUnknown,_dmd),new ProcedureInfo(null,null,simpleName.toLowerCase(),null,DatabaseMetaData.procedureResultUnknown,_dmd)};
                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                        
    Precondition Violations (10)
    Row Violation
    1Expression _session.getSchemaInfo().getCaseSensitiveProcedureName(simpleName) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    2Expression _session.getSchemaInfo().getCaseSensitiveTableName(simpleName) cannot be parameterized, because it has dependencies to/from statements that will be extracted
    3Unmatched statement return new TableInfo[]{new TableInfo(null,null,simpleName,type,null,_dmd)}; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    4Unmatched return new TableInfo[]{new TableInfo(null,null,simpleName,type,null,_dmd)};
    5Unmatched statement return new ProcedureInfo[]{new ProcedureInfo(null,null,simpleName,null,DatabaseMetaData.procedureResultUnknown,_dmd)}; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    6Unmatched return new ProcedureInfo[]{new ProcedureInfo(null,null,simpleName,null,DatabaseMetaData.procedureResultUnknown,_dmd)};
    7Unmatched statement return new TableInfo[]{new TableInfo(null,null,simpleName,type,null,_dmd),new TableInfo(null,null,simpleName.toUpperCase(),type,null,_dmd),new TableInfo(null,null,simpleName.toLowerCase(),type,null,_dmd)}; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    8Unmatched return new TableInfo[]{new TableInfo(null,null,simpleName,type,null,_dmd),new TableInfo(null,null,simpleName.toUpperCase(),type,null,_dmd),new TableInfo(null,null,simpleName.toLowerCase(),type,null,_dmd)};
    9Unmatched statement return new ProcedureInfo[]{new ProcedureInfo(null,null,simpleName,null,DatabaseMetaData.procedureResultUnknown,_dmd),new ProcedureInfo(null,null,simpleName.toUpperCase(),null,DatabaseMetaData.procedureResultUnknown,_dmd),new ProcedureInfo(null,null,simpleName.toLowerCase(),null,DatabaseMetaData.procedureResultUnknown,_dmd)}; cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    10Unmatched return new ProcedureInfo[]{new ProcedureInfo(null,null,simpleName,null,DatabaseMetaData.procedureResultUnknown,_dmd),new ProcedureInfo(null,null,simpleName.toUpperCase(),null,DatabaseMetaData.procedureResultUnknown,_dmd),new ProcedureInfo(null,null,simpleName.toLowerCase(),null,DatabaseMetaData.procedureResultUnknown,_dmd)};