IXMLElement eExpression = (IXMLElement) vExpressions.elementAt(i); String expression = eExpression.getContent(); html.append(getHeader("expression", "#7FFFD4")); html.append(createHtmlFromText(expression));
IXMLElement eSubquery = (IXMLElement) vSubqueries.elementAt(i); String subquery = eSubquery.getContent(); html.append(getHeader("subquery", "#C0C0C0")); html.append(createHtmlFromText(subquery));
Clone fragments detected by clone detection tool
File path: /sql12/plugins/cache/src/de/ixdb/squirrel_sql/plugins/cache/ShowQueryPlanCommand.java File path: /sql12/plugins/cache/src/de/ixdb/squirrel_sql/plugins/cache/ShowQueryPlanCommand.java
Method name: String createExcutionPlanHTML(String, String) Method name: String createExcutionPlanHTML(String, String)
Number of AST nodes: 4 Number of AST nodes: 4
1
IXMLElement eExpression = (IXMLElement) vExpressions.elementAt(i);
1
IXMLElement eSubquery = (IXMLElement) vSubqueries.elementAt(i);
2
         String expression = eExpression.getContent();
2
         String subquery = eSubquery.getContent();
3
         html.append(getHeader("expression", "#7FFFD4"));
3
         html.append(getHeader("subquery", "#C0C0C0"));
4
         html.append(createHtmlFromText(expression));
4
         html.append(createHtmlFromText(subquery));
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.0
Clones locationClones are in the same method
Number of node comparisons17
  1. {Refactorable}
    Mapping Summary
    Number of mapped statements4
    Number of unmapped statements in the first code fragment0
    Number of unmapped statements in the second code fragment0
    Time elapsed for statement mapping (ms)0.0
    Clone typeType 2
    Mapped Statements
    ID Statement ID Statement
    28
    IXMLElement eExpression = (IXMLElement)vExpressions.elementAt(i);
    28
    IXMLElement eExpression = (IXMLElement)vExpressions.elementAt(i);
    22
    IXMLElement eSubquery = (IXMLElement)vSubqueries.elementAt(i);
    Differences
    Expression1Expression2Difference
    eExpressioneSubqueryVARIABLE_NAME_MISMATCH
    vExpressionsvSubqueriesVARIABLE_NAME_MISMATCH
    22
    IXMLElement eSubquery = (IXMLElement)vSubqueries.elementAt(i);
    29
    String expression = eExpression.getContent();
    29
    String expression = eExpression.getContent();
    23
    String subquery = eSubquery.getContent();
    Differences
    Expression1Expression2Difference
    expressionsubqueryVARIABLE_NAME_MISMATCH
    eExpressioneSubqueryVARIABLE_NAME_MISMATCH
    23
    String subquery = eSubquery.getContent();
    30
    html.append(getHeader("expression", "#7FFFD4"));
    30
    html.append(getHeader("expression", "#7FFFD4"));
    24
    html.append(getHeader("subquery", "#C0C0C0"));
    Differences
    Expression1Expression2Difference
    "expression""subquery"LITERAL_VALUE_MISMATCH
    "#7FFFD4""#C0C0C0"LITERAL_VALUE_MISMATCH
    24
    html.append(getHeader("subquery", "#C0C0C0"));
    31
    html.append(createHtmlFromText(expression));
    31
    html.append(createHtmlFromText(expression));
    25
    html.append(createHtmlFromText(subquery));
    Differences
    Expression1Expression2Difference
    expressionsubqueryVARIABLE_NAME_MISMATCH
    25
    html.append(createHtmlFromText(subquery));
    Precondition Violations (0)
    Row Violation