public class Mode
extends java.lang.Object
Modifier and Type | Class and Description |
---|---|
static class |
Mode.CharPadding
When CHAR values are right-padded with spaces.
|
static class |
Mode.ExpressionNames
Generation of column names for expressions.
|
static class |
Mode.ModeEnum |
static class |
Mode.ViewExpressionNames
Generation of column names for expressions to be used in a view.
|
Modifier and Type | Field and Description |
---|---|
boolean |
acceptsCommaAsJsonKeyValueSeparator
Accepts comma ',' as key/value separator in JSON_OBJECT and JSON_OBJECTAGG functions.
|
boolean |
aliasColumnName
When enabled, aliased columns (as in SELECT ID AS I FROM TEST) return the
alias (I in this case) in ResultSetMetaData.getColumnName() and 'null' in
getTableName().
|
boolean |
allNumericTypesHavePrecision
If
true all numeric data types may have precision and 'UNSIGNED'
clause. |
boolean |
allowDB2TimestampFormat
Whether DB2 TIMESTAMP formats are allowed.
|
boolean |
allowEmptyInPredicate
Whether IN predicate may have an empty value list.
|
boolean |
allowEmptySchemaValuesAsDefaultSchema
If
true constructs like 'CREATE TABLE CATALOG..TABLE_NAME' are allowed,
the default schema is used. |
boolean |
allowPlusForStringConcat
Text can be concatenated using '+'.
|
boolean |
allowUnrelatedOrderByExpressionsInDistinctQueries
If
true unrelated ORDER BY expression are allowed in DISTINCT
queries, if false they are disallowed. |
boolean |
allowUsingFromClauseInUpdateStatement
If
true , allow using from clause in update statement. |
boolean |
alterTableExtensionsMySQL
If
true some additional non-standard ALTER TABLE commands are allowed. |
boolean |
alterTableModifyColumn
If
true non-standard ALTER TABLE MODIFY COLUMN is allowed. |
boolean |
alterTableModifyColumnPreserveNullability
If
true non-standard ALTER TABLE MODIFY COLUMN preserves nullability when changing data type. |
boolean |
autoIncrementClause
Whether MySQL-style AUTO_INCREMENT clause is supported.
|
boolean |
charAndByteLengthUnits
If
true 'CHAR' and 'BYTE' length units are allowed. |
Mode.CharPadding |
charPadding
How to pad or trim CHAR values.
|
boolean |
convertOnlyToSmallerScale
When converting the scale of decimal data, the number is only converted
if the new scale is smaller than the current scale.
|
boolean |
createUniqueConstraintForReferencedColumns
If
true , referential constraints will create a unique constraint
on referenced columns if it doesn't exist instead of throwing an
exception. |
boolean |
dateIsTimestamp0
Whether DATE data type is parsed as TIMESTAMP(0).
|
boolean |
dateTimeValueWithinTransaction
If
true , datetime value function return the same value within a
transaction, if false datetime value functions return the same
value within a command. |
boolean |
decimalSequences
If
true NEXT VALUE FOR SEQUENCE, CURRENT VALUE FOR SEQUENCE,
SEQUENCE.NEXTVAL, and SEQUENCE.CURRVAL return values with DECIMAL/NUMERIC
data type instead of BIGINT. |
boolean |
deleteIdentifierFrom
If
true DELETE identifier FROM is allowed |
java.util.Set<java.lang.String> |
disallowedTypes
An optional Set of hidden/disallowed column types.
|
boolean |
discardWithTableHints
Discard SQLServer table hints (e.g.
|
Mode.ExpressionNames |
expressionNames
How column names are generated for expressions.
|
boolean |
forBitData
If
true 'FOR BIT DATA' clauses are allowed for character string
data types. |
boolean |
greatestLeastIgnoreNulls
If
true GREATEST and LEAST ignore nulls |
boolean |
groupByColumnIndex
Allow to use GROUP BY n, where n is column index in the SELECT list, similar to ORDER BY
|
boolean |
identityClause
Whether SQL Server-style IDENTITY clause is supported.
|
boolean |
identityColumnsHaveDefaultOnNull
If
true , identity columns have DEFAULT ON NULL clause. |
boolean |
identityDataType
Whether IDENTITY pseudo data type is supported.
|
boolean |
indexDefinitionInCreateTable
Creating indexes in the CREATE TABLE statement is allowed using
INDEX(..) or KEY(..) . |
boolean |
insertOnConflict
PostgreSQL style INSERT ...
|
boolean |
isolationLevelInSelectOrInsertStatement
can set the isolation level using WITH {RR|RS|CS|UR}
|
boolean |
limit
Whether LIMIT / OFFSET clauses are supported.
|
boolean |
logIsLogBase10
The single-argument function LOG() uses base 10 instead of E.
|
boolean |
mergeWhere
If
true , merge when matched clause may have WHERE clause. |
boolean |
minusIsExcept
Whether MINUS can be used as EXCEPT.
|
boolean |
mySqlTableOptions
If
true MySQL table and column options are allowed |
boolean |
nextvalAndCurrvalPseudoColumns
If
true , sequence.NEXTVAL and sequence.CURRVAL pseudo columns are
supported. |
boolean |
nextValueReturnsDifferentValues
If
true , the next value expression returns different values when
invoked multiple times within a row. |
NullsDistinct |
nullsDistinct
Determines how rows with
NULL values in indexed columns are handled
in unique indexes and constraints by default. |
boolean |
numericIsDecfloat
Whether NUMERIC and DECIMAL/DEC without parameters are parsed as DECFLOAT.
|
boolean |
numericWithBooleanComparison
Allow to compare numeric with BOOLEAN.
|
boolean |
onDuplicateKeyUpdate
MySQL style INSERT ...
|
boolean |
regexpReplaceBackslashReferences
The function REGEXP_REPLACE() uses \ for back-references.
|
boolean |
replaceInto
MySQL style REPLACE INTO.
|
boolean |
serialDataTypes
Whether SERIAL and BIGSERIAL pseudo data types are supported.
|
boolean |
squareBracketQuotedNames
Identifiers may be quoted using square brackets as in [Test].
|
java.util.regex.Pattern |
supportedClientInfoPropertiesRegEx
Pattern describing the keys the java.sql.Connection.setClientInfo()
method accepts.
|
boolean |
supportPoundSymbolForColumnNames
Support the # for column names
|
boolean |
swapConvertFunctionParameters
Swap the parameters of the CONVERT function.
|
boolean |
swapLogFunctionParameters
Swap the parameters of LOG() function.
|
boolean |
sysDummy1
Support the pseudo-table SYSIBM.SYSDUMMY1.
|
boolean |
systemColumns
The system columns 'ctid' and 'oid' are supported.
|
boolean |
takeGeneratedSequenceValue
If
true , last identity of the session is updated on generation of
a new sequence value. |
boolean |
takeInsertedIdentity
If
true , last identity of the session is updated on insertion of
a new value into identity column. |
boolean |
topInDML
Whether TOP clause in DML commands is supported.
|
boolean |
topInSelect
Whether TOP clause in SELECT queries is supported.
|
boolean |
treatEmptyStringsAsNull
Empty strings are treated like NULL values.
|
boolean |
truncateTableRestartIdentity
If
true TRUNCATE TABLE uses RESTART IDENTITY by default. |
java.util.HashMap<java.lang.String,org.h2.value.DataType> |
typeByNameMap
Custom mappings from type names to data types.
|
boolean |
updateSequenceOnManualIdentityInsertion
If
true , sequences of generated by default identity columns are
updated when value is provided by user. |
Mode.ViewExpressionNames |
viewExpressionNames
How column names are generated for views.
|
boolean |
zeroExLiteralsAreBinaryStrings
If
true 0x -prefixed numbers are parsed as binary string
literals, if false they are parsed as hexadecimal numeric values. |
Modifier and Type | Method and Description |
---|---|
Mode.ModeEnum |
getEnum() |
static Mode |
getInstance(java.lang.String name)
Get the mode with the given name.
|
java.lang.String |
getName() |
static Mode |
getRegular() |
java.lang.String |
toString() |
public boolean aliasColumnName
public boolean convertOnlyToSmallerScale
public boolean indexDefinitionInCreateTable
INDEX(..)
or KEY(..)
.
Example: create table test(id int primary key, name varchar(255),
key idx_name(name));
public boolean squareBracketQuotedNames
public boolean systemColumns
public NullsDistinct nullsDistinct
NULL
values in indexed columns are handled
in unique indexes and constraints by default.public boolean treatEmptyStringsAsNull
public boolean greatestLeastIgnoreNulls
true
GREATEST and LEAST ignore nullspublic boolean sysDummy1
public boolean allowPlusForStringConcat
public boolean logIsLogBase10
public boolean swapLogFunctionParameters
public boolean regexpReplaceBackslashReferences
public boolean swapConvertFunctionParameters
public boolean isolationLevelInSelectOrInsertStatement
public boolean onDuplicateKeyUpdate
public boolean replaceInto
public boolean insertOnConflict
public java.util.regex.Pattern supportedClientInfoPropertiesRegEx
public boolean supportPoundSymbolForColumnNames
public boolean allowEmptyInPredicate
public Mode.CharPadding charPadding
public boolean allowDB2TimestampFormat
public boolean discardWithTableHints
public boolean dateTimeValueWithinTransaction
true
, datetime value function return the same value within a
transaction, if false
datetime value functions return the same
value within a command.public boolean zeroExLiteralsAreBinaryStrings
true
0x
-prefixed numbers are parsed as binary string
literals, if false
they are parsed as hexadecimal numeric values.public boolean allowUnrelatedOrderByExpressionsInDistinctQueries
true
unrelated ORDER BY expression are allowed in DISTINCT
queries, if false
they are disallowed.public boolean alterTableExtensionsMySQL
true
some additional non-standard ALTER TABLE commands are allowed.public boolean alterTableModifyColumn
true
non-standard ALTER TABLE MODIFY COLUMN is allowed.public boolean alterTableModifyColumnPreserveNullability
true
non-standard ALTER TABLE MODIFY COLUMN preserves nullability when changing data type.public boolean mySqlTableOptions
true
MySQL table and column options are allowedpublic boolean deleteIdentifierFrom
true
DELETE identifier FROM is allowedpublic boolean truncateTableRestartIdentity
true
TRUNCATE TABLE uses RESTART IDENTITY by default.public boolean decimalSequences
true
NEXT VALUE FOR SEQUENCE, CURRENT VALUE FOR SEQUENCE,
SEQUENCE.NEXTVAL, and SEQUENCE.CURRVAL return values with DECIMAL/NUMERIC
data type instead of BIGINT.public boolean allowEmptySchemaValuesAsDefaultSchema
true
constructs like 'CREATE TABLE CATALOG..TABLE_NAME' are allowed,
the default schema is used.public boolean allNumericTypesHavePrecision
true
all numeric data types may have precision and 'UNSIGNED'
clause.public boolean forBitData
true
'FOR BIT DATA' clauses are allowed for character string
data types.public boolean charAndByteLengthUnits
true
'CHAR' and 'BYTE' length units are allowed.public boolean nextvalAndCurrvalPseudoColumns
true
, sequence.NEXTVAL and sequence.CURRVAL pseudo columns are
supported.public boolean nextValueReturnsDifferentValues
true
, the next value expression returns different values when
invoked multiple times within a row. This setting does not affect
NEXTVAL() function.public boolean updateSequenceOnManualIdentityInsertion
true
, sequences of generated by default identity columns are
updated when value is provided by user.public boolean takeInsertedIdentity
true
, last identity of the session is updated on insertion of
a new value into identity column.public boolean takeGeneratedSequenceValue
true
, last identity of the session is updated on generation of
a new sequence value.public boolean identityColumnsHaveDefaultOnNull
true
, identity columns have DEFAULT ON NULL clause.public boolean mergeWhere
true
, merge when matched clause may have WHERE clause.public boolean allowUsingFromClauseInUpdateStatement
true
, allow using from clause in update statement.public boolean createUniqueConstraintForReferencedColumns
true
, referential constraints will create a unique constraint
on referenced columns if it doesn't exist instead of throwing an
exception.public Mode.ExpressionNames expressionNames
public Mode.ViewExpressionNames viewExpressionNames
public boolean topInSelect
public boolean topInDML
public boolean limit
public boolean minusIsExcept
public boolean identityDataType
public boolean serialDataTypes
public boolean identityClause
public boolean autoIncrementClause
public boolean dateIsTimestamp0
public boolean numericIsDecfloat
public java.util.Set<java.lang.String> disallowedTypes
public java.util.HashMap<java.lang.String,org.h2.value.DataType> typeByNameMap
public boolean groupByColumnIndex
public boolean numericWithBooleanComparison
public boolean acceptsCommaAsJsonKeyValueSeparator
public static Mode getInstance(java.lang.String name)
name
- the name of the modepublic static Mode getRegular()
public java.lang.String getName()
public Mode.ModeEnum getEnum()
public java.lang.String toString()
toString
in class java.lang.Object