CloneSet60


Previous CloneSetNext CloneSetBack to Main Report
Clone
Mass
Clones in
CloneSet
Parameter
Count
Clone
Similarity
Syntax Category
[Sequence Length]
236230.976class_body_declarations[27]
Clone AbstractionParameter Bindings
Clone Instance
(Click to see clone)
Line CountSource Line
Source File
1236910
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/InformixDialectExt.java
2227873
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/MySQLDialectExt.java
Next
Last
Clone Instance
1
Line Count
236
Source Line
910
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/InformixDialectExt.java

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#getUpdateSQL(java.lang.String,
 *      java.lang.String[], java.lang.String[], java.lang.String[], java.lang.String[], java.lang.String[],
 *      net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier,
 *      net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences)
 */
public String[] getUpdateSQL(String tableName, String[] setColumns, String[] setValues, String[] fromTables, String[] whereColumns, String[] whereValues, DatabaseObjectQualifier qualifier, SqlGenerationPreferences prefs) {
  // UPDATE t SET a = (SELECT a FROM t2 WHERE t.b = t2.b);
  //              String templateStr = 
  //                      "UPDATE $destTableName$ SET $columnName$ = " +
  //                      "(SELECT $columnName$ FROM $sourceTableName$ " +
  //                      "WHERE $sourceTableName$.$whereColumnName$ = $destTableName$.$whereColumnValue$";
  //              StringTemplate st = new StringTemplate(templateStr);
  String templateStr = "";
  if (fromTables != null) {
    templateStr = ST_UPDATE_CORRELATED_QUERY_STYLE_TWO;
  }
  else {
    templateStr = ST_UPDATE_STYLE_ONE;
  }
  StringTemplate st = new StringTemplate(templateStr);
  return DialectUtils.getUpdateSQL(st, tableName, setColumns, setValues, fromTables, whereColumns, whereValues, qualifier, prefs, this );
}

public boolean supportsAccessMethods() {
  // TODO Auto-generated method stub
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAddForeignKeyConstraint()
 */
public boolean supportsAddForeignKeyConstraint() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAddUniqueConstraint()
 */
public boolean supportsAddUniqueConstraint() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAlterSequence()
 */
public boolean supportsAlterSequence() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAutoIncrement()
 */
public boolean supportsAutoIncrement() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCheckOptionsForViews()
 */
public boolean supportsCheckOptionsForViews() {
  // TODO Auto-generated method stub
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCreateIndex()
 */
public boolean supportsCreateIndex() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCreateSequence()
 */
public boolean supportsCreateSequence() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCreateTable()
 */
public boolean supportsCreateTable() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCreateView()
 */
public boolean supportsCreateView() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsDropConstraint()
 */
public boolean supportsDropConstraint() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsDropIndex()
 */
public boolean supportsDropIndex() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsDropSequence()
 */
public boolean supportsDropSequence() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsDropView()
 */
public boolean supportsDropView() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsEmptyTables()
 */
public boolean supportsEmptyTables() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsIndexes()
 */
public boolean supportsIndexes() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsInsertInto()
 */
public boolean supportsInsertInto() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsMultipleRowInserts()
 */
public boolean supportsMultipleRowInserts() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsRenameTable()
 */
public boolean supportsRenameTable() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsRenameView()
 */
public boolean supportsRenameView() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsSequence()
 */
public boolean supportsSequence() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsSequenceInformation()
 */
public boolean supportsSequenceInformation() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsTablespace()
 */
public boolean supportsTablespace() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsUpdate()
 */
public boolean supportsUpdate() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAddColumn()
 */
public boolean supportsAddColumn() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsViewDefinition()
 */
public boolean supportsViewDefinition() {
  return true;
}


First
Previous
Clone Instance
2
Line Count
227
Source Line
873
Source File
E:/TSE/Projects-CloneDR/sql12/fw/src/net/sourceforge/squirrel_sql/fw/dialects/MySQLDialectExt.java

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#getUpdateSQL(java.lang.String,
 *      java.lang.String[], java.lang.String[], java.lang.String[], java.lang.String[], java.lang.String[],
 *      net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier,
 *      net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences)
 */
public String[] getUpdateSQL(String tableName, String[] setColumns, String[] setValues, String[] fromTables, String[] whereColumns, String[] whereValues, DatabaseObjectQualifier qualifier, SqlGenerationPreferences prefs) {
  String templateStr = "";
  if (fromTables != null) {
    templateStr = ST_UPDATE_CORRELATED_QUERY_STYLE_TWO;
  }
  else {
    templateStr = ST_UPDATE_STYLE_ONE;
  }
  final StringTemplate st = new StringTemplate(templateStr);
  return DialectUtils.getUpdateSQL(st, tableName, setColumns, setValues, fromTables, whereColumns, whereValues, qualifier, prefs, this );
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAccessMethods()
 */
public boolean supportsAccessMethods() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAddForeignKeyConstraint()
 */
public boolean supportsAddForeignKeyConstraint() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAddUniqueConstraint()
 */
public boolean supportsAddUniqueConstraint() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAlterSequence()
 */
public boolean supportsAlterSequence() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAutoIncrement()
 */
public boolean supportsAutoIncrement() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCheckOptionsForViews()
 */
public boolean supportsCheckOptionsForViews() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCreateIndex()
 */
public boolean supportsCreateIndex() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCreateSequence()
 */
public boolean supportsCreateSequence() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCreateTable()
 */
public boolean supportsCreateTable() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCreateView()
 */
public boolean supportsCreateView() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsDropConstraint()
 */
public boolean supportsDropConstraint() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsDropIndex()
 */
public boolean supportsDropIndex() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsDropSequence()
 */
public boolean supportsDropSequence() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsDropView()
 */
public boolean supportsDropView() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsEmptyTables()
 */
public boolean supportsEmptyTables() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsIndexes()
 */
public boolean supportsIndexes() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsInsertInto()
 */
public boolean supportsInsertInto() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsMultipleRowInserts()
 */
public boolean supportsMultipleRowInserts() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsRenameTable()
 */
public boolean supportsRenameTable() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsRenameView()
 */
public boolean supportsRenameView() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsSequence()
 */
public boolean supportsSequence() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsSequenceInformation()
 */
public boolean supportsSequenceInformation() {
  return false;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsTablespace()
 */
public boolean supportsTablespace() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsUpdate()
 */
public boolean supportsUpdate() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAddColumn()
 */
public boolean supportsAddColumn() {
  return true;
}

/**
 * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsViewDefinition()
 */
public boolean supportsViewDefinition() {
  return false;
}


Clone AbstractionParameter Count: 3Parameter Bindings

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#getUpdateSQL(java.lang.String,
         *      java.lang.String[], java.lang.String[], java.lang.String[], java.lang.String[], java.lang.String[],
         *      net.sourceforge.squirrel_sql.fw.dialects.DatabaseObjectQualifier,
         *      net.sourceforge.squirrel_sql.fw.dialects.SqlGenerationPreferences)
         */
public String[] getUpdateSQL(String tableName, String[] setColumns, String[] setValues, String[] fromTables, String[] whereColumns, String[] whereValues, DatabaseObjectQualifier qualifier, SqlGenerationPreferences prefs) {
  // UPDATE t SET a = (SELECT a FROM t2 WHERE t.b = t2.b);
  //              String templateStr = 
  //                      "UPDATE $destTableName$ SET $columnName$ = " +
  //                      "(SELECT $columnName$ FROM $sourceTableName$ " +
  //                      "WHERE $sourceTableName$.$whereColumnName$ = $destTableName$.$whereColumnValue$";
  //              StringTemplate st = new StringTemplate(templateStr);
  String templateStr = "";
  if (fromTables != null) {
    templateStr = ST_UPDATE_CORRELATED_QUERY_STYLE_TWO;
  }
  else {
    templateStr = ST_UPDATE_STYLE_ONE;
  }
   [[#variable1903d5a0]]StringTemplate st = new StringTemplate(templateStr);
  return DialectUtils.getUpdateSQL(st, tableName, setColumns, setValues, fromTables, whereColumns, whereValues, qualifier, prefs, this );
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAccessMethods()
         */
public boolean supportsAccessMethods() {
  // TODO Auto-generated method stub
  return [[#variable18c52980]];
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAddForeignKeyConstraint()
         */
public boolean supportsAddForeignKeyConstraint() {
  return true;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAddUniqueConstraint()
         */
public boolean supportsAddUniqueConstraint() {
  return true;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAlterSequence()
         */
public boolean supportsAlterSequence() {
  return [[#variable13ccd3a0]];
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAutoIncrement()
         */
public boolean supportsAutoIncrement() {
  return true;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCheckOptionsForViews()
         */
public boolean supportsCheckOptionsForViews() {
  // TODO Auto-generated method stub
  return false;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCreateIndex()
         */
public boolean supportsCreateIndex() {
  return true;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCreateSequence()
         */
public boolean supportsCreateSequence() {
  return [[#variable13ccd3a0]];
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCreateTable()
         */
public boolean supportsCreateTable() {
  return true;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsCreateView()
         */
public boolean supportsCreateView() {
  return [[#variable13ccd3a0]];
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsDropConstraint()
         */
public boolean supportsDropConstraint() {
  return [[#variable13ccd3a0]];
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsDropIndex()
         */
public boolean supportsDropIndex() {
  return true;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsDropSequence()
         */
public boolean supportsDropSequence() {
  return [[#variable13ccd3a0]];
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsDropView()
         */
public boolean supportsDropView() {
  return [[#variable13ccd3a0]];
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsEmptyTables()
         */
public boolean supportsEmptyTables() {
  return false;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsIndexes()
         */
public boolean supportsIndexes() {
  return true;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsInsertInto()
         */
public boolean supportsInsertInto() {
  return true;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsMultipleRowInserts()
         */
public boolean supportsMultipleRowInserts() {
  return [[#variable18c52980]];
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsRenameTable()
         */
public boolean supportsRenameTable() {
  return true;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsRenameView()
         */
public boolean supportsRenameView() {
  return false;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsSequence()
         */
public boolean supportsSequence() {
  return [[#variable13ccd3a0]];
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsSequenceInformation()
         */
public boolean supportsSequenceInformation() {
  return [[#variable13ccd3a0]];
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsTablespace()
         */
public boolean supportsTablespace() {
  return [[#variable18c52980]];
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsUpdate()
         */
public boolean supportsUpdate() {
  return true;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsAddColumn()
         */
public boolean supportsAddColumn() {
  return true;
}

/**
         * @see net.sourceforge.squirrel_sql.fw.dialects.HibernateDialect#supportsViewDefinition()
         */
public boolean supportsViewDefinition() {
  return [[#variable13ccd3a0]];
}
 

CloneAbstraction
Parameter Bindings
Parameter
Index
Clone
Instance
Parameter
Name
Value
11[[#1903d5a0]]
12[[#1903d5a0]]
final 
21[[#18c52980]]
false 
22[[#18c52980]]
true 
31[[#13ccd3a0]]
true 
32[[#13ccd3a0]]
false