if (iIndex != -1) { int iPrev = 0; StringBuffer sb = new StringBuffer(); sb.append(sResult.substring(iPrev, iIndex)); sb.append('\''); iPrev = iIndex; iIndex = sResult.indexOf("'", iPrev + 1); while (iIndex != -1) { sb.append(sResult.substring(iPrev, iIndex)); sb.append('\''); iPrev = iIndex; iIndex = sResult.indexOf("'", iPrev + 1); } sb.append(sResult.substring(iPrev)); sResult = sb.toString(); }
int iPrev = 0; StringBuffer sb = new StringBuffer(); sb.append(sResult.substring(iPrev, iIndex)); sb.append("\\n"); iPrev = iIndex + 1; iIndex = sResult.indexOf('\n', iPrev + 1); while (iIndex != -1) { sb.append(sResult.substring(iPrev, iIndex)); sb.append("\\n"); iPrev = iIndex + 1; iIndex = sResult.indexOf('\n', iPrev + 1); } sb.append(sResult.substring(iPrev)); sResult = sb.toString();
Clone fragments detected by clone detection tool
File path: /sql12/plugins/sqlscript/src/net/sourceforge/squirrel_sql/plugins/sqlscript/table_script/CreateDataScriptCommand.java File path: /sql12/plugins/sqlscript/src/net/sourceforge/squirrel_sql/plugins/sqlscript/table_script/CreateDataScriptCommand.java
Method name: void genInserts(ResultSet, String, StringBuffer, boolean) Method name: void genInserts(ResultSet, String, StringBuffer, boolean)
Number of AST nodes: 14 Number of AST nodes: 13
1
if (iIndex != -1)
2
                  {
3
                     int iPrev = 0;
1
int iPrev = 0;
4
                     StringBuffer sb = new StringBuffer();
2
                     StringBuffer sb = new StringBuffer();
5
                     sb.append(sResult.substring(iPrev, iIndex));
3
                     sb.append(sResult.substring(iPrev, iIndex));
6
                     sb.append('\'');
4
                     sb.append("\\n");
7
                     iPrev = iIndex;
5
                     iPrev = iIndex + 1;
8
                     iIndex = sResult.indexOf("'", iPrev + 1);
6
                     iIndex = sResult.indexOf('\n', iPrev + 1);
9
                     while (iIndex != -1)
7
                     while (iIndex != -1)
10
                     {
8
                     {
11
                        sb.append(sResult.substring(iPrev, iIndex));
9
                        sb.append(sResult.substring(iPrev, iIndex));
12
                        sb.append('\'');
10
                        sb.append("\\n");
13
                        iPrev = iIndex;
11
                        iPrev = iIndex + 1;
14
                        iIndex = sResult.indexOf("'", iPrev + 1);
12
                        iIndex = sResult.indexOf('\n', iPrev + 1);
15
                     }
13
                     }
16
                     sb.append(sResult.substring(iPrev));
14
                     sb.append(sResult.substring(iPrev));
17
                     sResult = sb.toString();
15
                     sResult = sb.toString();
18
                  }
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.2
Clones locationClones are in the same method
Number of node comparisons79
  1. {Refactorable}
    Mapping Summary
    Number of mapped statements9
    Number of unmapped statements in the first code fragment4
    Number of unmapped statements in the second code fragment4
    Time elapsed for statement mapping (ms)18.3
    Clone typeType 2
    Mapped Statements
    ID Statement ID Statement
    76
    int iPrev = 0;
    91
    int iPrev = 0;
    77
    StringBuffer sb = new StringBuffer();
    92
    StringBuffer sb = new StringBuffer();
    78
    sb.append(sResult.substring(iPrev, iIndex));
    93
    sb.append(sResult.substring(iPrev, iIndex));
    79
    sb.append('\'');
    79
    sb.append('\'');
    Preondition Violations
    Unmatched statement sb.append('\''); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
                                            
                                              
    94
    sb.append("\\n");
    Preondition Violations
    Unmatched statement sb.append("\\n"); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    94
    sb.append("\\n");
    80
    iPrev = iIndex;
    80
    iPrev = iIndex;
    95
    iPrev = iIndex + 1;
    Differences
    Expression1Expression2Difference
    iIndexiIndex + 1TYPE_COMPATIBLE_REPLACEMENT
    95
    iPrev = iIndex + 1;
    81
    iIndex = sResult.indexOf("'", iPrev + 1);
    81
    iIndex = sResult.indexOf("'", iPrev + 1);
    Preondition Violations
    Unmatched statement iIndex=sResult.indexOf("'",iPrev + 1); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
                                                                                        
                                                                                          
    96
    iIndex = sResult.indexOf('\n', iPrev + 1);
    Preondition Violations
    Unmatched statement iIndex=sResult.indexOf('\n',iPrev + 1); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    96
    iIndex = sResult.indexOf('\n', iPrev + 1);
    82
    while (iIndex != -1)
    97
    while (iIndex != -1)
    83
    sb.append(sResult.substring(iPrev, iIndex));
    98
    sb.append(sResult.substring(iPrev, iIndex));
    84
    sb.append('\'');
    84
    sb.append('\'');
    Preondition Violations
    Unmatched statement sb.append('\''); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
                                            
                                              
    99
    sb.append("\\n");
    Preondition Violations
    Unmatched statement sb.append("\\n"); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    99
    sb.append("\\n");
    85
    iPrev = iIndex;
    85
    iPrev = iIndex;
    100
    iPrev = iIndex + 1;
    Differences
    Expression1Expression2Difference
    iIndexiIndex + 1TYPE_COMPATIBLE_REPLACEMENT
    Preondition Violations
    Expression iIndex cannot be parameterized, because it has dependencies to/from statements that will be extracted
    Expression iIndex + 1 cannot be parameterized, because it has dependencies to/from statements that will be extracted
    100
    iPrev = iIndex + 1;
    86
    iIndex = sResult.indexOf("'", iPrev + 1);
    86
    iIndex = sResult.indexOf("'", iPrev + 1);
    Preondition Violations
    Unmatched statement iIndex=sResult.indexOf("'",iPrev + 1); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
                                                                                        
                                                                                            
    101
    iIndex = sResult.indexOf('\n', iPrev + 1);
    Preondition Violations
    Unmatched statement iIndex=sResult.indexOf('\n',iPrev + 1); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    101
    iIndex = sResult.indexOf('\n', iPrev + 1);
    87
    sb.append(sResult.substring(iPrev));
    102
    sb.append(sResult.substring(iPrev));
    88
    sResult = sb.toString();
    103
    sResult = sb.toString();
    Precondition Violations (10)
    Row Violation
    1Unmatched statement sb.append('\''); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    2Unmatched statement sb.append("\\n"); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    3Unmatched statement iIndex=sResult.indexOf("'",iPrev + 1); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    4Unmatched statement iIndex=sResult.indexOf('\n',iPrev + 1); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    5Unmatched statement sb.append('\''); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    6Unmatched statement sb.append("\\n"); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    7Expression iIndex cannot be parameterized, because it has dependencies to/from statements that will be extracted
    8Expression iIndex + 1 cannot be parameterized, because it has dependencies to/from statements that will be extracted
    9Unmatched statement iIndex=sResult.indexOf("'",iPrev + 1); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted
    10Unmatched statement iIndex=sResult.indexOf('\n',iPrev + 1); cannot be moved before or after the extracted code, because it has dependencies to/from statements that will be extracted