ModeThe compatibility modes. There is a fixed set of modes (for example PostgreSQL, MySQL). Each mode has different settings.
aliasColumnNameWhen 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(). If disabled, the real column name (ID in this case) and
table name is returned.
allowAffinityKeyWhether AFFINITY KEY keywords are supported.
allowDB2TimestampFormatWhether DB2 TIMESTAMP formats are allowed.
allowPlusForStringConcatText can be concatenated using '+'.
convertInsertNullToZeroWhen inserting data, if a column is defined to be NOT NULL and NULL is
inserted, then a 0 (or empty string, or the current timestamp for
timestamp columns) value is used. Usually, this operation is not allowed
and an exception is thrown.
convertOnlyToSmallerScaleWhen converting the scale of decimal data, the number is only converted
if the new scale is smaller than the current scale. Usually, the scale is
converted and 0s are added if required.
disallowedTypesAn optional Set of hidden/disallowed column types.
Certain DBMSs don't support all column types provided by H2, such as
"NUMBER" when using PostgreSQL mode.
indexDefinitionInCreateTableCreating indexes in the CREATE TABLE statement is allowed using
INDEX(..) or KEY(..) .
Example: create table test(id int primary key, name varchar(255),
key idx_name(name)); isolationLevelInSelectOrInsertStatementcan set the isolation level using WITH {RR|RS|CS|UR}
logIsLogBase10The function LOG() uses base 10 instead of E.
lowerCaseIdentifiersMeta data calls return identifiers in lower case.
nullConcatIsNullConcatenation with NULL results in NULL. Usually, NULL is treated as an
empty string if only one of the operands is NULL, and NULL is only
returned if both operands are NULL.
onDuplicateKeyUpdateMySQL style INSERT ... ON DUPLICATE KEY UPDATE ... and INSERT IGNORE
padFixedLengthStringsWhether to right-pad fixed strings with spaces.
prohibitEmptyInPredicateWhether an empty list as in "NAME IN()" results in a syntax error.
regexpReplaceBackslashReferencesThe function REGEXP_REPLACE() uses \ for back-references.
serialColumnIsNotPKSERIAL and BIGSERIAL columns are not automatically primary keys.
squareBracketQuotedNamesIdentifiers may be quoted using square brackets as in [Test].
supportPoundSymbolForColumnNamesSupport the # for column names
supportedClientInfoPropertiesRegExPattern describing the keys the java.sql.Connection.setClientInfo()
method accepts.
swapConvertFunctionParametersSwap the parameters of the CONVERT function.
sysDummy1Support the pseudo-table SYSIBM.SYSDUMMY1.
systemColumnsThe system columns 'CTID' and 'OID' are supported.
treatEmptyStringsAsNullEmpty strings are treated like NULL values. Useful for Oracle emulation.
typeByNameMapCustom mappings from type names to data types.
uniqueIndexNullsHandlingDetermines how rows with {@code NULL} values in indexed columns are handled
in unique indexes.
|