Accepts comma ',' as key/value separator in JSON_OBJECT and JSON_OBJECTAGG functions.

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(). If disabled, the real column name (ID in this case) and table name is returned.

If true all numeric data types may have precision and 'UNSIGNED' clause.

Whether DB2 TIMESTAMP formats are allowed.

Whether IN predicate may have an empty value list.

If true constructs like 'CREATE TABLE CATALOG..TABLE_NAME' are allowed, the default schema is used.

Text can be concatenated using '+'.

If true unrelated ORDER BY expression are allowed in DISTINCT queries, if false they are disallowed.

If true, allow using from clause in update statement.

If true some additional non-standard ALTER TABLE commands are allowed.

If true non-standard ALTER TABLE MODIFY COLUMN is allowed.

If true non-standard ALTER TABLE MODIFY COLUMN preserves nullability when changing data type.

Whether MySQL-style AUTO_INCREMENT clause is supported.

If true 'CHAR' and 'BYTE' length units are allowed.

How to pad or trim CHAR values.

When 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.

If true, referential constraints will create a unique constraint on referenced columns if it doesn't exist instead of throwing an exception.

Whether DATE data type is parsed as TIMESTAMP(0).

If true, datetime value function return the same value within a transaction, if false datetime value functions return the same value within a command.

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.

If true DELETE identifier FROM is allowed

An 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.

Discard SQLServer table hints (e.g. "SELECT * FROM table WITH (NOLOCK)")

How column names are generated for expressions.

If true 'FOR BIT DATA' clauses are allowed for character string data types.

If true GREATEST and LEAST ignore nulls

Allow to use GROUP BY n, where n is column index in the SELECT list, similar to ORDER BY

Whether SQL Server-style IDENTITY clause is supported.

If true, identity columns have DEFAULT ON NULL clause.

Whether IDENTITY pseudo data type is supported.

Creating 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));

PostgreSQL style INSERT ... ON CONFLICT DO NOTHING.

can set the isolation level using WITH {RR|RS|CS|UR}

Whether LIMIT / OFFSET clauses are supported.

The single-argument function LOG() uses base 10 instead of E.

If true, merge when matched clause may have WHERE clause.

Whether MINUS can be used as EXCEPT.

If true MySQL table and column options are allowed

If true, sequence.NEXTVAL and sequence.CURRVAL pseudo columns are supported.

If true, the next value expression returns different values when invoked multiple times within a row. This setting does not affect NEXTVAL() function.

Determines how rows with NULL values in indexed columns are handled in unique indexes and constraints by default.

Whether NUMERIC and DECIMAL/DEC without parameters are parsed as DECFLOAT.

Allow to compare numeric with BOOLEAN.

MySQL style INSERT ... ON DUPLICATE KEY UPDATE ... and INSERT IGNORE.

The function REGEXP_REPLACE() uses \ for back-references.

MySQL style REPLACE INTO.

Whether SERIAL and BIGSERIAL pseudo data types are supported.

Identifiers may be quoted using square brackets as in [Test].

Pattern describing the keys the java.sql.Connection.setClientInfo() method accepts.

Support the # for column names

Swap the parameters of the CONVERT function.

Swap the parameters of LOG() function.

Support the pseudo-table SYSIBM.SYSDUMMY1.

The system columns 'ctid' and 'oid' are supported.

If true, last identity of the session is updated on generation of a new sequence value.

If true, last identity of the session is updated on insertion of a new value into identity column.

Whether TOP clause in DML commands is supported.

Whether TOP clause in SELECT queries is supported.

Empty strings are treated like NULL values. Useful for Oracle emulation.

If true TRUNCATE TABLE uses RESTART IDENTITY by default.

Custom mappings from type names to data types.

If true, sequences of generated by default identity columns are updated when value is provided by user.

How column names are generated for views.

If true 0x-prefixed numbers are parsed as binary string literals, if false they are parsed as hexadecimal numeric values.

Get the mode with the given name.

Parameters

name:String

the name of the mode

Returns:Mode

the mode object

Overrides java.lang.Object.toString.

Doc from java.lang.Object.toString.

Returns a string representation of the object. Satisfying this method's contract implies a non-null result must be returned.

Returns:String

a string representation of the object

Annotations

@Override