for (int colIdx = 0; colIdx < nbrSelCols; ++colIdx) { TableColumn col = _table.getColumnModel().getColumn(selCols[colIdx]); ColumnDisplayDefinition colDef = null; if(col instanceof ExtTableColumn) { colDef = ((ExtTableColumn) col).getColumnDisplayDefinition(); } else { continue; } if (firstCol) { firstCol = false; } else { buf.append(","); } final Object cellObj = _table.getValueAt(selRows[rowIdx], selCols[colIdx]); buf.append(colDef.getColumnName()).append(getData(colDef, cellObj, StatType.UPDATE)); }
for (int colIdx = 0; colIdx < nbrSelCols; ++colIdx) { TableColumn col = _table.getColumnModel().getColumn(selCols[colIdx]); ColumnDisplayDefinition colDef = null; if(col instanceof ExtTableColumn) { colDef = ((ExtTableColumn) col).getColumnDisplayDefinition(); } else { continue; } if(firstCol) { firstCol = false; } else { buf.append(" AND "); } final Object cellObj = _table.getValueAt(selRows[rowIdx], selCols[colIdx]); buf.append(colDef.getColumnName()).append(getData(colDef, cellObj, StatType.WHERE)); }
Clone fragments detected by clone detection tool
File path: /sql12/fw/src/net/sourceforge/squirrel_sql/fw/gui/action/TableCopyUpdateStatementCommand.java File path: /sql12/fw/src/net/sourceforge/squirrel_sql/fw/gui/action/TableCopyWhereStatementCommand.java
Method name: void execute() Method name: void execute()
Number of AST nodes: 11 Number of AST nodes: 11
1
for (int colIdx = 0; colIdx < nbrSelCols; ++colIdx)
1
for (int colIdx = 0; colIdx < nbrSelCols; ++colIdx)
2
            {
2
            {
3
               TableColumn col = _table.getColumnModel().getColumn(selCols[colIdx]);
3
               TableColumn col = _table.getColumnModel().getColumn(selCols[colIdx]);
4
               ColumnDisplayDefinition colDef = null;
4
               ColumnDisplayDefinition colDef = null;
5
               if(col instanceof ExtTableColumn)
5
               if(col instanceof ExtTableColumn)
6
               {
6
               {
7
                  colDef = ((ExtTableColumn) col).getColumnDisplayDefinition();
7
                  colDef = ((ExtTableColumn) col).getColumnDisplayDefinition();
8
               }
8
               }
9
               else
9
               else
10
               {
10
               {
11
                  continue;
11
                  continue;
12
               }
12
               }
13
               if (firstCol)
13
               if(firstCol)
14
               {
14
               {
15
                  firstCol = false;
15
                  firstCol = false;
16
               }
16
               }
17
               else
17
               else
18
               {
18
               {
19
                  buf.append(",");
19
                  buf.append(" AND ");
20
               }
20
               }
21
               final Object cellObj = _table.getValueAt(selRows[rowIdx], selCols[colIdx]);
21
               final Object cellObj = _table.getValueAt(selRows[rowIdx], selCols[colIdx]);
22
               buf.append(colDef.getColumnName()).append(getData(colDef, cellObj, StatType.UPDATE));
22
               buf.append(colDef.getColumnName()).append(getData(colDef, cellObj, StatType.WHERE));
23
            }
23
            }
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.7
Clones locationClones are in different classes having the same super class
Number of node comparisons56
  1. {Refactorable}
    Mapping Summary
    Number of mapped statements11
    Number of unmapped statements in the first code fragment0
    Number of unmapped statements in the second code fragment0
    Time elapsed for statement mapping (ms)20.1
    Clone typeType 2
    Mapped Statements
    ID Statement ID Statement
    10
    for (int colIdx = 0; colIdx < nbrSelCols; ++colIdx)
    15
    for (int colIdx = 0; colIdx < nbrSelCols; ++colIdx)
    11
    TableColumn col = _table.getColumnModel().getColumn(selCols[colIdx]);
    16
    TableColumn col = _table.getColumnModel().getColumn(selCols[colIdx]);
    12
    ColumnDisplayDefinition colDef = null;
    17
    ColumnDisplayDefinition colDef = null;
    13
    if (col instanceof ExtTableColumn)
    18
    if (col instanceof ExtTableColumn)
    14
    colDef = ((ExtTableColumn)col).getColumnDisplayDefinition();
    19
    colDef = ((ExtTableColumn)col).getColumnDisplayDefinition();
    else
    else
    15
    continue;
    20
    continue;
    16
    if (firstCol)
    21
    if (firstCol)
    17
    firstCol = false;
    22
    firstCol = false;
    else
    else
    18
    buf.append(",");
    18
    buf.append(",");
    23
    buf.append(" AND ");
    Differences
    Expression1Expression2Difference
    ","" AND "LITERAL_VALUE_MISMATCH
    23
    buf.append(" AND ");
    19
    final Object cellObj = _table.getValueAt(selRows[rowIdx], selCols[colIdx]);
    24
    final Object cellObj = _table.getValueAt(selRows[rowIdx], selCols[colIdx]);
    20
    buf.append(colDef.getColumnName()).append(getData(colDef, cellObj, StatType.UPDATE));
    20
    buf.append(colDef.getColumnName()).append(getData(colDef, cellObj, StatType.UPDATE));
    25
    buf.append(colDef.getColumnName()).append(getData(colDef, cellObj, StatType.WHERE));
    Differences
    Expression1Expression2Difference
    UPDATEWHEREVARIABLE_NAME_MISMATCH
    25
    buf.append(colDef.getColumnName()).append(getData(colDef, cellObj, StatType.WHERE));
    Precondition Violations (0)
    Row Violation