com.github.drinkjava2.jdialects.DDLFeatures Maven / Gradle / Ivy
/*
* License: GNU Lesser General Public License (LGPL), version 2.1 or later. See
* the lgpl.txt file in the root directory or
* .
*/
package com.github.drinkjava2.jdialects;
/**
* DDL about features, this file is generated by source code generator (see
* jDiagen project) from Hibernate5.2.9 final
*
* @author Yong Zhu
* @since 1.0.2
*/
public class DDLFeatures {
public static final String NOT_SUPPORT = "NOT_SUPPORT";
protected String addColumnString;
protected String addColumnSuffixString;
protected String addForeignKeyConstraintString;
protected String addFKeyRefPkeyString;// If ref pkey, can ignore ref columns
protected String addPrimaryKeyConstraintString;
protected String columnComment;
protected String createCatalogCommand;
protected String createMultisetTableString;// for create table without PKEY
protected String createPooledSequenceStrings;
protected String createSchemaCommand;
protected String createSequenceStrings;
protected String createTableString; // for create table with PKEY
protected String currentSchemaCommand;
protected String dropCatalogCommand;
protected String dropForeignKeyString;
protected String dropSchemaCommand;
protected String dropSequenceStrings;
protected String dropTableString;
protected Boolean hasAlterTable;
protected Boolean hasDataTypeInIdentityColumn;
protected String identityColumnString;
protected String identityColumnStringBigINT;
protected String identitySelectString;
protected String identitySelectStringBigINT;
protected Boolean needDropConstraintsBeforeDropTable;
protected String nullColumnString;// for allowed null column definition
protected Boolean requiresParensForTupleDistinctCounts;
protected String selectSequenceNextValString;
protected String sequenceNextValString;
protected Boolean supportsColumnCheck;
protected Boolean supportsCommentOn;
protected Boolean supportsIdentityColumns;
protected Boolean supportsIfExistsAfterConstraintName;
public String getAddColumnString() {
return addColumnString;
}
public String getAddColumnSuffixString() {
return addColumnSuffixString;
}
public String getAddForeignKeyConstraintString() {
return addForeignKeyConstraintString;
}
public String getAddFKeyRefPkeyString() {
return addFKeyRefPkeyString;
}
public String getAddPrimaryKeyConstraintString() {
return addPrimaryKeyConstraintString;
}
public String getColumnComment() {
return columnComment;
}
public String getCreateCatalogCommand() {
return createCatalogCommand;
}
public String getCreateMultisetTableString() {
return createMultisetTableString;
}
public String getCreatePooledSequenceStrings() {
return createPooledSequenceStrings;
}
public String getCreateSchemaCommand() {
return createSchemaCommand;
}
public String getCreateSequenceStrings() {
return createSequenceStrings;
}
public String getCreateTableString() {
return createTableString;
}
public String getCurrentSchemaCommand() {
return currentSchemaCommand;
}
public String getDropCatalogCommand() {
return dropCatalogCommand;
}
public String getDropForeignKeyString() {
return dropForeignKeyString;
}
public String getDropSchemaCommand() {
return dropSchemaCommand;
}
public String getDropSequenceStrings() {
return dropSequenceStrings;
}
public String getDropTableString() {
return dropTableString;
}
public Boolean getHasAlterTable() {
return hasAlterTable;
}
public Boolean getHasDataTypeInIdentityColumn() {
return hasDataTypeInIdentityColumn;
}
public String getIdentityColumnString() {
return identityColumnString;
}
public String getIdentitySelectString() {
return identitySelectString;
}
public Boolean getNeedDropConstraintsBeforeDropTable() {
return needDropConstraintsBeforeDropTable;
}
public String getNullColumnString() {
return nullColumnString;
}
public Boolean getRequiresParensForTupleDistinctCounts() {
return requiresParensForTupleDistinctCounts;
}
public String getSelectSequenceNextValString() {
return selectSequenceNextValString;
}
public String getSequenceNextValString() {
return sequenceNextValString;
}
public Boolean getSupportsColumnCheck() {
return supportsColumnCheck;
}
public Boolean getSupportsCommentOn() {
return supportsCommentOn;
}
public Boolean getSupportsIdentityColumns() {
return supportsIdentityColumns;
}
public Boolean getSupportsIfExistsAfterConstraintName() {
return supportsIfExistsAfterConstraintName;
}
public Boolean getSupportsIfExistsAfterTableName() {
return supportsIfExistsAfterTableName;
}
public Boolean getSupportsIfExistsBeforeConstraintName() {
return supportsIfExistsBeforeConstraintName;
}
public Boolean getSupportsIfExistsBeforeTableName() {
return supportsIfExistsBeforeTableName;
}
public Boolean getSupportsInsertSelectIdentity() {
return supportsInsertSelectIdentity;
}
public Boolean getSupportsPooledSequences() {
return supportsPooledSequences;
}
public Boolean getSupportsSequences() {
return supportsSequences;
}
public Boolean getSupportsTableCheck() {
return supportsTableCheck;
}
public String getTableTypeString() {
return tableTypeString;
}
public String getIdentityColumnStringBigINT() {
return identityColumnStringBigINT;
}
public String getIdentitySelectStringBigINT() {
return identitySelectStringBigINT;
}
/**
* For dropping a table, can the phrase "if exists" be applied beforeQuery the
* table name
*/
protected Boolean supportsIfExistsAfterTableName;
protected Boolean supportsIfExistsBeforeConstraintName;
/**
* For dropping a table, can the phrase "if exists" be applied afterQuery the
* table name?
*/
protected Boolean supportsIfExistsBeforeTableName;
protected Boolean supportsInsertSelectIdentity;
protected Boolean supportsPooledSequences; // support initial & increment
protected Boolean supportsSequences; // basic sequence
protected Boolean supportsTableCheck;
protected String tableTypeString;
protected static boolean isValidDDLTemplate(String featureValue) {
return !(StrUtils.isEmpty(featureValue) || NOT_SUPPORT.equals(featureValue));
}
public boolean supportBasicOrPooledSequence() {
return supportsSequences || supportsPooledSequences;
}
@SuppressWarnings("all")
protected static void initDDLFeatures(Dialect dia, DDLFeatures ddl) {
ddl.addColumnString = "add";
ddl.addColumnSuffixString = "";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE";
ddl.addForeignKeyConstraintString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2)";
ddl.addPrimaryKeyConstraintString = " add constraint _PKEYNAME primary key ";
ddl.columnComment = "";
ddl.createCatalogCommand = NOT_SUPPORT;
ddl.createMultisetTableString = "create table";
ddl.createPooledSequenceStrings = "create sequence _SEQ start with 11 increment by 33";
ddl.createSchemaCommand = "create schema _SCHEMANAME";
ddl.createSequenceStrings = "create sequence _SEQ";
ddl.createTableString = "create table";
ddl.currentSchemaCommand = NOT_SUPPORT;
ddl.dropCatalogCommand = NOT_SUPPORT;
ddl.dropForeignKeyString = " drop constraint ";
ddl.dropSchemaCommand = "drop schema _SCHEMANAME";
ddl.dropSequenceStrings = "drop sequence _SEQNAME";
ddl.dropTableString = "drop table _TABLENAME cascade constraints";
ddl.hasAlterTable = true;
ddl.hasDataTypeInIdentityColumn = true;
ddl.identityColumnString = NOT_SUPPORT;
ddl.identityColumnStringBigINT = NOT_SUPPORT;
ddl.identitySelectString = NOT_SUPPORT;
ddl.identitySelectStringBigINT = NOT_SUPPORT;
ddl.needDropConstraintsBeforeDropTable = false;
ddl.nullColumnString = "";
ddl.requiresParensForTupleDistinctCounts = false;
ddl.selectSequenceNextValString = "_SEQNAME.nextval";
ddl.sequenceNextValString = "select _SEQNAME.nextval from dual";
ddl.supportsColumnCheck = true;
ddl.supportsCommentOn = true;
ddl.supportsIdentityColumns = false;
ddl.supportsIfExistsAfterConstraintName = false;
ddl.supportsIfExistsBeforeConstraintName = false;
ddl.supportsPooledSequences = true;
ddl.supportsSequences = true;
ddl.supportsTableCheck = true;
ddl.tableTypeString = "";
switch (dia) {
case SQLiteDialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = NOT_SUPPORT;
ddl.addForeignKeyConstraintString = NOT_SUPPORT;
ddl.addPrimaryKeyConstraintString = NOT_SUPPORT;
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropForeignKeyString = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.hasAlterTable = false;
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "integer";
ddl.identityColumnStringBigINT = "integer";
ddl.identitySelectString = "select last_insert_rowid()";
ddl.identitySelectStringBigINT = "select last_insert_rowid()";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case AccessDialect: {
ddl.addColumnString = "add column";
ddl.addPrimaryKeyConstraintString = " primary key ";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.dropForeignKeyString = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = "nextval('_SEQNAME')";
ddl.sequenceNextValString = "select nextval('_SEQNAME')";
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.supportsTableCheck = false;
}
break;
case ExcelDialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = NOT_SUPPORT;
ddl.addForeignKeyConstraintString = NOT_SUPPORT;
ddl.addPrimaryKeyConstraintString = " primary key ";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.dropForeignKeyString = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = "nextval('_SEQNAME')";
ddl.sequenceNextValString = "select nextval('_SEQNAME')";
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.supportsTableCheck = false;
}
break;
case TextDialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = NOT_SUPPORT;
ddl.addForeignKeyConstraintString = NOT_SUPPORT;
ddl.addPrimaryKeyConstraintString = " primary key ";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.dropForeignKeyString = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.hasAlterTable = false;
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = "nextval('_SEQNAME')";
ddl.sequenceNextValString = "select nextval('_SEQNAME')";
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.supportsTableCheck = false;
}
break;
case ParadoxDialect: {
ddl.addColumnString = "add column";
ddl.addPrimaryKeyConstraintString = " primary key ";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.dropForeignKeyString = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = "nextval('_SEQNAME')";
ddl.sequenceNextValString = "select nextval('_SEQNAME')";
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.supportsTableCheck = false;
}
break;
case CobolDialect: {
ddl.addColumnString = "add column";
ddl.addPrimaryKeyConstraintString = " primary key ";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.dropForeignKeyString = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.hasAlterTable = false;
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = "nextval('_SEQNAME')";
ddl.sequenceNextValString = "select nextval('_SEQNAME')";
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.supportsTableCheck = false;
}
break;
case XMLDialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = NOT_SUPPORT;
ddl.addForeignKeyConstraintString = NOT_SUPPORT;
ddl.addPrimaryKeyConstraintString = " primary key ";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.dropForeignKeyString = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = "nextval('_SEQNAME')";
ddl.sequenceNextValString = "select nextval('_SEQNAME')";
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.supportsTableCheck = false;
}
break;
case DbfDialect: {
ddl.addColumnString = "add column";
ddl.addPrimaryKeyConstraintString = " primary key ";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.dropForeignKeyString = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = "nextval('_SEQNAME')";
ddl.sequenceNextValString = "select nextval('_SEQNAME')";
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.supportsTableCheck = false;
}
break;
case Cache71Dialect: {
ddl.addColumnString = " add column";
ddl.addFKeyRefPkeyString = " ADD CONSTRAINT _FKEYNAME FOREIGN KEY _FKEYNAME (_FK1, _FK2) REFERENCES _REFTABLE (_REF1, _REF2) ";
ddl.addForeignKeyConstraintString = " ADD CONSTRAINT _FKEYNAME FOREIGN KEY _FKEYNAME (_FK1, _FK2) REFERENCES _REFTABLE (_REF1, _REF2) ";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "identity";
ddl.identityColumnStringBigINT = "identity";
ddl.identitySelectString = "SELECT LAST_IDENTITY() FROM %TSQL_sys.snf";
ddl.identitySelectStringBigINT = "SELECT LAST_IDENTITY() FROM %TSQL_sys.snf";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case CUBRIDDialect: {
ddl.createPooledSequenceStrings = "create serial _SEQ start with 11 increment by 33";
ddl.createSequenceStrings = "create serial _SEQ";
ddl.dropForeignKeyString = " drop foreign key ";
ddl.dropSequenceStrings = "drop serial _SEQNAME";
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.identityColumnString = "not null auto_increment";
ddl.identityColumnStringBigINT = "not null auto_increment";
ddl.identitySelectString = "select last_insert_id()";
ddl.identitySelectStringBigINT = "select last_insert_id()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = "select _SEQNAME.next_value from table({1}) as T(X)";
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
}
break;
case DataDirectOracle9Dialect: {
}
break;
case DB2Dialect: {
ddl.addColumnString = "add column";
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "generated by default as identity";
ddl.identityColumnStringBigINT = "generated by default as identity";
ddl.identitySelectString = "values identity_val_local()";
ddl.identitySelectStringBigINT = "values identity_val_local()";
ddl.selectSequenceNextValString = "next value for _SEQNAME";
ddl.sequenceNextValString = "values nextval for _SEQNAME";
ddl.supportsIdentityColumns = true;
}
break;
case DB2390Dialect: {
ddl.addColumnString = "add column";
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "generated by default as identity";
ddl.identityColumnStringBigINT = "generated by default as identity";
ddl.identitySelectString = "select identity_val_local() from sysibm.sysdummy1";
ddl.identitySelectStringBigINT = "select identity_val_local() from sysibm.sysdummy1";
ddl.selectSequenceNextValString = "next value for _SEQNAME";
ddl.sequenceNextValString = "values nextval for _SEQNAME";
ddl.supportsIdentityColumns = true;
ddl.supportsSequences = false;
}
break;
case DB2400Dialect: {
ddl.addColumnString = "add column";
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "generated by default as identity";
ddl.identityColumnStringBigINT = "generated by default as identity";
ddl.identitySelectString = "select identity_val_local() from sysibm.sysdummy1";
ddl.identitySelectStringBigINT = "select identity_val_local() from sysibm.sysdummy1";
ddl.selectSequenceNextValString = "next value for _SEQNAME";
ddl.sequenceNextValString = "values nextval for _SEQNAME";
ddl.supportsIdentityColumns = true;
ddl.supportsSequences = false;
}
break;
case DerbyDialect: {
ddl.addColumnString = "add column";
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "generated by default as identity";
ddl.identityColumnStringBigINT = "generated by default as identity";
ddl.identitySelectString = "values identity_val_local()";
ddl.identitySelectStringBigINT = "values identity_val_local()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = "next value for _SEQNAME";
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsSequences = false;
}
break;
case DerbyTenFiveDialect: {
ddl.addColumnString = "add column";
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "generated by default as identity";
ddl.identityColumnStringBigINT = "generated by default as identity";
ddl.identitySelectString = "values identity_val_local()";
ddl.identitySelectStringBigINT = "values identity_val_local()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = "next value for _SEQNAME";
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsSequences = false;
}
break;
case DerbyTenSevenDialect: {
ddl.addColumnString = "add column";
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "generated by default as identity";
ddl.identityColumnStringBigINT = "generated by default as identity";
ddl.identitySelectString = "values identity_val_local()";
ddl.identitySelectStringBigINT = "values identity_val_local()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = "next value for _SEQNAME";
ddl.sequenceNextValString = "values next value for _SEQNAME";
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
}
break;
case DerbyTenSixDialect: {
ddl.addColumnString = "add column";
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "generated by default as identity";
ddl.identityColumnStringBigINT = "generated by default as identity";
ddl.identitySelectString = "values identity_val_local()";
ddl.identitySelectStringBigINT = "values identity_val_local()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = "next value for _SEQNAME";
ddl.sequenceNextValString = "values next value for _SEQNAME";
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
}
break;
case FirebirdDialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = "create generator _SEQ";
ddl.dropSequenceStrings = "drop generator _SEQNAME";
ddl.dropTableString = "drop table _TABLENAME";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = "gen_id( _SEQNAME, 1 )";
ddl.sequenceNextValString = "select gen_id( _SEQNAME, 1 ) from RDB$DATABASE";
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
}
break;
case FrontBaseDialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME cascade";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case H2Dialect: {
ddl.addColumnString = "add column";
ddl.dropSequenceStrings = "drop sequence if exists _SEQNAME";
ddl.dropTableString = "drop table _TABLENAME if exists";
ddl.identityColumnString = "generated by default as identity";
ddl.identityColumnStringBigINT = "generated by default as identity";
ddl.identitySelectString = "call identity()";
ddl.identitySelectStringBigINT = "call identity()";
ddl.requiresParensForTupleDistinctCounts = true;
ddl.selectSequenceNextValString = "next value for _SEQNAME";
ddl.sequenceNextValString = "call next value for _SEQNAME";
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsIfExistsBeforeConstraintName = true;
}
break;
case HANAColumnStoreDialect: {
ddl.addColumnString = "add (";
ddl.addColumnSuffixString = ")";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE on update cascade";
ddl.addForeignKeyConstraintString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2) on update cascade";
ddl.createMultisetTableString = "create column table";
ddl.createTableString = "create column table";
ddl.dropTableString = "drop table _TABLENAME cascade";
ddl.sequenceNextValString = "select _SEQNAME.nextval from dummy";
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsTableCheck = false;
}
break;
case HANARowStoreDialect: {
ddl.addColumnString = "add (";
ddl.addColumnSuffixString = ")";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE on update cascade";
ddl.addForeignKeyConstraintString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2) on update cascade";
ddl.dropTableString = "drop table _TABLENAME cascade";
ddl.sequenceNextValString = "select _SEQNAME.nextval from dummy";
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsTableCheck = false;
}
break;
case HSQLDialect: {
ddl.addColumnString = "add column";
ddl.createSequenceStrings = "create sequence _SEQ start with 1";
ddl.dropSequenceStrings = "drop sequence _SEQNAME if exists";
ddl.dropTableString = "drop table _TABLENAME if exists";
ddl.identityColumnString = "generated by default as identity (start with 1)";
ddl.identityColumnStringBigINT = "generated by default as identity (start with 1)";
ddl.identitySelectString = "call identity()";
ddl.identitySelectStringBigINT = "call identity()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = "next value for _SEQNAME";
ddl.sequenceNextValString = "call next value for _SEQNAME";
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
}
break;
case InformixDialect: {
ddl.addFKeyRefPkeyString = " add constraint foreign key (_FK1, _FK2) references _REFTABLE constraint _FKEYNAME";
ddl.addForeignKeyConstraintString = " add constraint foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2) constraint _FKEYNAME";
ddl.addPrimaryKeyConstraintString = " add constraint primary key constraint _PKEYNAME ";
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME";
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "serial not null";
ddl.identityColumnStringBigINT = "serial8 not null";
ddl.identitySelectString = "select dbinfo('sqlca.sqlerrd1') from informix.systables where tabid=1";
ddl.identitySelectStringBigINT = "select dbinfo('serial8') from informix.systables where tabid=1";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.sequenceNextValString = "select _SEQNAME.nextval from informix.systables where tabid=1";
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
}
break;
case Informix10Dialect: {
ddl.addFKeyRefPkeyString = " add constraint foreign key (_FK1, _FK2) references _REFTABLE constraint _FKEYNAME";
ddl.addForeignKeyConstraintString = " add constraint foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2) constraint _FKEYNAME";
ddl.addPrimaryKeyConstraintString = " add constraint primary key constraint _PKEYNAME ";
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME";
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "serial not null";
ddl.identityColumnStringBigINT = "serial8 not null";
ddl.identitySelectString = "select dbinfo('sqlca.sqlerrd1') from informix.systables where tabid=1";
ddl.identitySelectStringBigINT = "select dbinfo('serial8') from informix.systables where tabid=1";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.sequenceNextValString = "select _SEQNAME.nextval from informix.systables where tabid=1";
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
}
break;
case IngresDialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME";
ddl.nullColumnString = " with null";
ddl.sequenceNextValString = "select nextval for _SEQNAME";
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
}
break;
case Ingres10Dialect: {
ddl.addColumnString = "add column";
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "not null generated by default as identity";
ddl.identityColumnStringBigINT = "not null generated by default as identity";
ddl.identitySelectString = "select last_identity()";
ddl.identitySelectStringBigINT = "select last_identity()";
ddl.nullColumnString = " with null";
ddl.sequenceNextValString = "select nextval for _SEQNAME";
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
}
break;
case Ingres9Dialect: {
ddl.addColumnString = "add column";
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME";
ddl.identitySelectString = "select last_identity()";
ddl.identitySelectStringBigINT = "select last_identity()";
ddl.nullColumnString = " with null";
ddl.sequenceNextValString = "select nextval for _SEQNAME";
ddl.supportsCommentOn = false;
}
break;
case InterbaseDialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = "create generator _SEQ";
ddl.dropSequenceStrings = "delete from RDB$GENERATORS where RDB$GENERATOR_NAME = '_SEQNAME'";
ddl.dropTableString = "drop table _TABLENAME";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = "gen_id( _SEQNAME, 1 )";
ddl.sequenceNextValString = "select gen_id( _SEQNAME, 1 ) from RDB$DATABASE";
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
}
break;
case JDataStoreDialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME cascade";
ddl.identityColumnString = "autoincrement";
ddl.identityColumnStringBigINT = "autoincrement";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.supportsTableCheck = false;
}
break;
case MariaDBDialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2)";
ddl.columnComment = " comment '_COMMENT'";
ddl.createCatalogCommand = "create database _CATALOGNAME";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSchemaCommand = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropCatalogCommand = "drop database _CATALOGNAME";
ddl.dropForeignKeyString = " drop foreign key ";
ddl.dropSchemaCommand = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.identityColumnString = "not null auto_increment";
ddl.identityColumnStringBigINT = "not null auto_increment";
ddl.identitySelectString = "select last_insert_id()";
ddl.identitySelectStringBigINT = "select last_insert_id()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.tableTypeString = " engine=InnoDB";
}
break;
case MariaDB53Dialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2)";
ddl.columnComment = " comment '_COMMENT'";
ddl.createCatalogCommand = "create database _CATALOGNAME";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSchemaCommand = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropCatalogCommand = "drop database _CATALOGNAME";
ddl.dropForeignKeyString = " drop foreign key ";
ddl.dropSchemaCommand = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.identityColumnString = "not null auto_increment";
ddl.identityColumnStringBigINT = "not null auto_increment";
ddl.identitySelectString = "select last_insert_id()";
ddl.identitySelectStringBigINT = "select last_insert_id()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.tableTypeString = " engine=InnoDB";
}
break;
case MckoiDialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = "nextval('_SEQNAME')";
ddl.sequenceNextValString = "select nextval('_SEQNAME')";
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
}
break;
case MimerSQLDialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = "create unique sequence _SEQ";
ddl.dropSequenceStrings = "drop sequence _SEQNAME restrict";
ddl.dropTableString = "drop table _TABLENAME cascade";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = "select next_value of _SEQNAME from system.onerow";
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
}
break;
case MySQLDialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2)";
ddl.columnComment = " comment '_COMMENT'";
ddl.createCatalogCommand = "create database _CATALOGNAME";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSchemaCommand = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropCatalogCommand = "drop database _CATALOGNAME";
ddl.dropForeignKeyString = " drop foreign key ";
ddl.dropSchemaCommand = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.identityColumnString = "not null auto_increment";
ddl.identityColumnStringBigINT = "not null auto_increment";
ddl.identitySelectString = "select last_insert_id()";
ddl.identitySelectStringBigINT = "select last_insert_id()";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.tableTypeString = " type=MyISAM";
}
break;
case MySQL5Dialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2)";
ddl.columnComment = " comment '_COMMENT'";
ddl.createCatalogCommand = "create database _CATALOGNAME";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSchemaCommand = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropCatalogCommand = "drop database _CATALOGNAME";
ddl.dropForeignKeyString = " drop foreign key ";
ddl.dropSchemaCommand = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.identityColumnString = "not null auto_increment";
ddl.identityColumnStringBigINT = "not null auto_increment";
ddl.identitySelectString = "select last_insert_id()";
ddl.identitySelectStringBigINT = "select last_insert_id()";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.tableTypeString = " engine=MyISAM";
}
break;
case MySQL55Dialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2)";
ddl.columnComment = " comment '_COMMENT'";
ddl.createCatalogCommand = "create database _CATALOGNAME";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSchemaCommand = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropCatalogCommand = "drop database _CATALOGNAME";
ddl.dropForeignKeyString = " drop foreign key ";
ddl.dropSchemaCommand = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.identityColumnString = "not null auto_increment";
ddl.identityColumnStringBigINT = "not null auto_increment";
ddl.identitySelectString = "select last_insert_id()";
ddl.identitySelectStringBigINT = "select last_insert_id()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.tableTypeString = " engine=InnoDB";
}
break;
case MySQL57Dialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2)";
ddl.columnComment = " comment '_COMMENT'";
ddl.createCatalogCommand = "create database _CATALOGNAME";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSchemaCommand = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropCatalogCommand = "drop database _CATALOGNAME";
ddl.dropForeignKeyString = " drop foreign key ";
ddl.dropSchemaCommand = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.identityColumnString = "not null auto_increment";
ddl.identityColumnStringBigINT = "not null auto_increment";
ddl.identitySelectString = "select last_insert_id()";
ddl.identitySelectStringBigINT = "select last_insert_id()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.tableTypeString = " engine=InnoDB";
}
break;
case MySQL57InnoDBDialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2)";
ddl.columnComment = " comment '_COMMENT'";
ddl.createCatalogCommand = "create database _CATALOGNAME";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSchemaCommand = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropCatalogCommand = "drop database _CATALOGNAME";
ddl.dropForeignKeyString = " drop foreign key ";
ddl.dropSchemaCommand = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.identityColumnString = "not null auto_increment";
ddl.identityColumnStringBigINT = "not null auto_increment";
ddl.identitySelectString = "select last_insert_id()";
ddl.identitySelectStringBigINT = "select last_insert_id()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.tableTypeString = " engine=InnoDB";
}
break;
case MySQL5InnoDBDialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2)";
ddl.columnComment = " comment '_COMMENT'";
ddl.createCatalogCommand = "create database _CATALOGNAME";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSchemaCommand = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropCatalogCommand = "drop database _CATALOGNAME";
ddl.dropForeignKeyString = " drop foreign key ";
ddl.dropSchemaCommand = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.identityColumnString = "not null auto_increment";
ddl.identityColumnStringBigINT = "not null auto_increment";
ddl.identitySelectString = "select last_insert_id()";
ddl.identitySelectStringBigINT = "select last_insert_id()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.tableTypeString = " engine=InnoDB";
}
break;
case MySQLInnoDBDialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2)";
ddl.columnComment = " comment '_COMMENT'";
ddl.createCatalogCommand = "create database _CATALOGNAME";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSchemaCommand = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropCatalogCommand = "drop database _CATALOGNAME";
ddl.dropForeignKeyString = " drop foreign key ";
ddl.dropSchemaCommand = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.identityColumnString = "not null auto_increment";
ddl.identityColumnStringBigINT = "not null auto_increment";
ddl.identitySelectString = "select last_insert_id()";
ddl.identitySelectStringBigINT = "select last_insert_id()";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.tableTypeString = " type=InnoDB";
}
break;
case MySQLMyISAMDialect: {
ddl.addColumnString = "add column";
ddl.addFKeyRefPkeyString = " add constraint _FKEYNAME foreign key (_FK1, _FK2) references _REFTABLE (_REF1, _REF2)";
ddl.columnComment = " comment '_COMMENT'";
ddl.createCatalogCommand = "create database _CATALOGNAME";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSchemaCommand = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropCatalogCommand = "drop database _CATALOGNAME";
ddl.dropForeignKeyString = " drop foreign key ";
ddl.dropSchemaCommand = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table if exists _TABLENAME";
ddl.identityColumnString = "not null auto_increment";
ddl.identityColumnStringBigINT = "not null auto_increment";
ddl.identitySelectString = "select last_insert_id()";
ddl.identitySelectStringBigINT = "select last_insert_id()";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.tableTypeString = " type=MyISAM";
}
break;
case OracleDialect: {
}
break;
case Oracle10gDialect: {
}
break;
case Oracle12cDialect: {
ddl.identityColumnString = "generated as identity";
ddl.identityColumnStringBigINT = "generated as identity";
ddl.supportsIdentityColumns = true;
}
break;
case Oracle8iDialect: {
}
break;
case Oracle9Dialect: {
}
break;
case Oracle9iDialect: {
}
break;
case PointbaseDialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME cascade";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case PostgresPlusDialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = "create sequence _SEQ start 11 increment 33";
ddl.dropSequenceStrings = "drop sequence if exists _SEQNAME";
ddl.dropTableString = "drop table if exists _TABLENAME cascade";
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "serial not null";
ddl.identityColumnStringBigINT = "bigserial not null";
ddl.identitySelectString = "select currval('_table__col_seq')";
ddl.identitySelectStringBigINT = "select currval('_table__col_seq')";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.requiresParensForTupleDistinctCounts = true;
ddl.selectSequenceNextValString = "nextval ('_SEQNAME')";
ddl.sequenceNextValString = "select nextval ('_SEQNAME')";
ddl.supportsIdentityColumns = true;
}
break;
case PostgreSQLDialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = "create sequence _SEQ start 11 increment 33";
ddl.dropSequenceStrings = "drop sequence if exists _SEQNAME";
ddl.dropTableString = "drop table if exists _TABLENAME cascade";
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "serial not null";
ddl.identityColumnStringBigINT = "bigserial not null";
ddl.identitySelectString = "select currval('_table__col_seq')";
ddl.identitySelectStringBigINT = "select currval('_table__col_seq')";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.requiresParensForTupleDistinctCounts = true;
ddl.selectSequenceNextValString = "nextval ('_SEQNAME')";
ddl.sequenceNextValString = "select nextval ('_SEQNAME')";
ddl.supportsIdentityColumns = true;
}
break;
case PostgreSQL81Dialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = "create sequence _SEQ start 11 increment 33";
ddl.dropTableString = "drop table _TABLENAME cascade";
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "serial not null";
ddl.identityColumnStringBigINT = "bigserial not null";
ddl.identitySelectString = "select currval('_table__col_seq')";
ddl.identitySelectStringBigINT = "select currval('_table__col_seq')";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.requiresParensForTupleDistinctCounts = true;
ddl.selectSequenceNextValString = "nextval ('_SEQNAME')";
ddl.sequenceNextValString = "select nextval ('_SEQNAME')";
ddl.supportsIdentityColumns = true;
}
break;
case PostgreSQL82Dialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = "create sequence _SEQ start 11 increment 33";
ddl.dropSequenceStrings = "drop sequence if exists _SEQNAME";
ddl.dropTableString = "drop table if exists _TABLENAME cascade";
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "serial not null";
ddl.identityColumnStringBigINT = "bigserial not null";
ddl.identitySelectString = "select currval('_table__col_seq')";
ddl.identitySelectStringBigINT = "select currval('_table__col_seq')";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.requiresParensForTupleDistinctCounts = true;
ddl.selectSequenceNextValString = "nextval ('_SEQNAME')";
ddl.sequenceNextValString = "select nextval ('_SEQNAME')";
ddl.supportsIdentityColumns = true;
}
break;
case PostgreSQL9Dialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = "create sequence _SEQ start 11 increment 33";
ddl.dropSequenceStrings = "drop sequence if exists _SEQNAME";
ddl.dropTableString = "drop table if exists _TABLENAME cascade";
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "serial not null";
ddl.identityColumnStringBigINT = "bigserial not null";
ddl.identitySelectString = "select currval('_table__col_seq')";
ddl.identitySelectStringBigINT = "select currval('_table__col_seq')";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.requiresParensForTupleDistinctCounts = true;
ddl.selectSequenceNextValString = "nextval ('_SEQNAME')";
ddl.sequenceNextValString = "select nextval ('_SEQNAME')";
ddl.supportsIdentityColumns = true;
ddl.supportsIfExistsBeforeConstraintName = true;
}
break;
case PostgreSQL91Dialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = "create sequence _SEQ start 11 increment 33";
ddl.dropSequenceStrings = "drop sequence if exists _SEQNAME";
ddl.dropTableString = "drop table if exists _TABLENAME cascade";
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "serial not null";
ddl.identityColumnStringBigINT = "bigserial not null";
ddl.identitySelectString = "select currval('_table__col_seq')";
ddl.identitySelectStringBigINT = "select currval('_table__col_seq')";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.requiresParensForTupleDistinctCounts = true;
ddl.selectSequenceNextValString = "nextval ('_SEQNAME')";
ddl.sequenceNextValString = "select nextval ('_SEQNAME')";
ddl.supportsIdentityColumns = true;
ddl.supportsIfExistsBeforeConstraintName = true;
}
break;
case PostgreSQL92Dialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = "create sequence _SEQ start 11 increment 33";
ddl.dropSequenceStrings = "drop sequence if exists _SEQNAME";
ddl.dropTableString = "drop table if exists _TABLENAME cascade";
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "serial not null";
ddl.identityColumnStringBigINT = "bigserial not null";
ddl.identitySelectString = "select currval('_table__col_seq')";
ddl.identitySelectStringBigINT = "select currval('_table__col_seq')";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.requiresParensForTupleDistinctCounts = true;
ddl.selectSequenceNextValString = "nextval ('_SEQNAME')";
ddl.sequenceNextValString = "select nextval ('_SEQNAME')";
ddl.supportsIdentityColumns = true;
ddl.supportsIfExistsBeforeConstraintName = true;
}
break;
case PostgreSQL93Dialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = "create sequence _SEQ start 11 increment 33";
ddl.dropSequenceStrings = "drop sequence if exists _SEQNAME";
ddl.dropTableString = "drop table if exists _TABLENAME cascade";
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "serial not null";
ddl.identityColumnStringBigINT = "bigserial not null";
ddl.identitySelectString = "select currval('_table__col_seq')";
ddl.identitySelectStringBigINT = "select currval('_table__col_seq')";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.requiresParensForTupleDistinctCounts = true;
ddl.selectSequenceNextValString = "nextval ('_SEQNAME')";
ddl.sequenceNextValString = "select nextval ('_SEQNAME')";
ddl.supportsIdentityColumns = true;
ddl.supportsIfExistsBeforeConstraintName = true;
}
break;
case PostgreSQL94Dialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = "create sequence _SEQ start 11 increment 33";
ddl.dropSequenceStrings = "drop sequence if exists _SEQNAME";
ddl.dropTableString = "drop table if exists _TABLENAME cascade";
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "serial not null";
ddl.identityColumnStringBigINT = "bigserial not null";
ddl.identitySelectString = "select currval('_table__col_seq')";
ddl.identitySelectStringBigINT = "select currval('_table__col_seq')";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.requiresParensForTupleDistinctCounts = true;
ddl.selectSequenceNextValString = "nextval ('_SEQNAME')";
ddl.sequenceNextValString = "select nextval ('_SEQNAME')";
ddl.supportsIdentityColumns = true;
ddl.supportsIfExistsBeforeConstraintName = true;
}
break;
case PostgreSQL95Dialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = "create sequence _SEQ start 11 increment 33";
ddl.dropSequenceStrings = "drop sequence if exists _SEQNAME";
ddl.dropTableString = "drop table if exists _TABLENAME cascade";
ddl.hasDataTypeInIdentityColumn = false;
ddl.identityColumnString = "serial not null";
ddl.identityColumnStringBigINT = "bigserial not null";
ddl.identitySelectString = "select currval('_table__col_seq')";
ddl.identitySelectStringBigINT = "select currval('_table__col_seq')";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.requiresParensForTupleDistinctCounts = true;
ddl.selectSequenceNextValString = "nextval ('_SEQNAME')";
ddl.sequenceNextValString = "select nextval ('_SEQNAME')";
ddl.supportsIdentityColumns = true;
ddl.supportsIfExistsBeforeConstraintName = true;
}
break;
case ProgressDialect: {
ddl.addColumnString = "add column";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.hasAlterTable = false;
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case RDMSOS2200Dialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = "";
ddl.dropTableString = "drop table _TABLENAME including contents";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = "select permuted_id('NEXT',31) from rdms.rdms_dummy where key_col = 1 ";
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case SAPDBDialect: {
ddl.addFKeyRefPkeyString = " foreign key _FKEYNAME (_FK1, _FK2) references _REFTABLE";
ddl.addForeignKeyConstraintString = " foreign key _FKEYNAME (_FK1, _FK2) references _REFTABLE (_REF1, _REF2)";
ddl.addPrimaryKeyConstraintString = " primary key ";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.nullColumnString = " null";
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
}
break;
case SQLServerDialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "identity not null";
ddl.identityColumnStringBigINT = "identity not null";
ddl.identitySelectString = "select @@identity";
ddl.identitySelectStringBigINT = "select @@identity";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case SQLServer2005Dialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "identity not null";
ddl.identityColumnStringBigINT = "identity not null";
ddl.identitySelectString = "select @@identity";
ddl.identitySelectStringBigINT = "select @@identity";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case SQLServer2008Dialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "identity not null";
ddl.identityColumnStringBigINT = "identity not null";
ddl.identitySelectString = "select @@identity";
ddl.identitySelectStringBigINT = "select @@identity";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case SQLServer2012Dialect: {
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "identity not null";
ddl.identityColumnStringBigINT = "identity not null";
ddl.identitySelectString = "select @@identity";
ddl.identitySelectStringBigINT = "select @@identity";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = "next value for _SEQNAME";
ddl.sequenceNextValString = "select next value for _SEQNAME";
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
}
break;
case SybaseDialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "identity not null";
ddl.identityColumnStringBigINT = "identity not null";
ddl.identitySelectString = "select @@identity";
ddl.identitySelectStringBigINT = "select @@identity";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case Sybase11Dialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "identity not null";
ddl.identityColumnStringBigINT = "identity not null";
ddl.identitySelectString = "select @@identity";
ddl.identitySelectStringBigINT = "select @@identity";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case SybaseAnywhereDialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "identity not null";
ddl.identityColumnStringBigINT = "identity not null";
ddl.identitySelectString = "select @@identity";
ddl.identitySelectStringBigINT = "select @@identity";
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case SybaseASE15Dialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "identity not null";
ddl.identityColumnStringBigINT = "identity not null";
ddl.identitySelectString = "select @@identity";
ddl.identitySelectStringBigINT = "select @@identity";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case SybaseASE157Dialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "identity not null";
ddl.identityColumnStringBigINT = "identity not null";
ddl.identitySelectString = "select @@identity";
ddl.identitySelectStringBigINT = "select @@identity";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.nullColumnString = " null";
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
ddl.tableTypeString = " lock datarows";
}
break;
case TeradataDialect: {
ddl.addColumnString = "Add Column";
ddl.createMultisetTableString = "create multiset table ";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case Teradata14Dialect: {
ddl.addColumnString = "Add";
ddl.createMultisetTableString = "create multiset table ";
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.createSequenceStrings = NOT_SUPPORT;
ddl.dropSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.identityColumnString = "generated by default as identity not null";
ddl.identityColumnStringBigINT = "generated by default as identity not null";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.selectSequenceNextValString = NOT_SUPPORT;
ddl.sequenceNextValString = NOT_SUPPORT;
ddl.supportsCommentOn = false;
ddl.supportsIdentityColumns = true;
ddl.supportsPooledSequences = false;
ddl.supportsSequences = false;
}
break;
case TimesTenDialect: {
ddl.createPooledSequenceStrings = NOT_SUPPORT;
ddl.dropTableString = "drop table _TABLENAME";
ddl.needDropConstraintsBeforeDropTable = true;
ddl.sequenceNextValString = "select first 1 _SEQNAME.nextval from sys.tables";
ddl.supportsColumnCheck = false;
ddl.supportsCommentOn = false;
ddl.supportsPooledSequences = false;
ddl.supportsTableCheck = false;
}
break;
default:
}
}
}
© 2015 - 2025 Weber Informatics LLC | Privacy Policy