public class Mode extends Object
Modifier and Type | Field and Description |
---|---|
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 |
allowPlusForStringConcat
Text can be concatenated using '+'.
|
boolean |
convertInsertNullToZero
When 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.
|
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 |
indexDefinitionInCreateTable
Creating indexes in the CREATE TABLE statement is allowed using
INDEX(..) or KEY(..) . |
boolean |
isolationLevelInSelectOrInsertStatement
can set the isolation level using WITH {RR|RS|CS|UR}
|
boolean |
logIsLogBase10
The function LOG() uses base 10 instead of E.
|
boolean |
lowerCaseIdentifiers
Meta data calls return identifiers in lower case.
|
boolean |
nullConcatIsNull
Concatenation with NULL results in NULL.
|
boolean |
onDuplicateKeyUpdate
MySQL style INSERT ...
|
boolean |
prohibitEmptyInPredicate
Whether an empty list as in "NAME IN()" results in a syntax error.
|
boolean |
serialColumnIsNotPK
SERIAL and BIGSERIAL columns are not automatically primary keys.
|
boolean |
squareBracketQuotedNames
Identifiers may be quoted using square brackets as in [Test].
|
Pattern |
supportedClientInfoPropertiesRegEx
Pattern describing the keys the java.sql.Connection.setClientInfo()
method accepts.
|
boolean |
supportOffsetFetch
Support for the syntax
[OFFSET ..
|
boolean |
supportPoundSymbolForColumnNames
Support the # for column names
|
boolean |
swapConvertFunctionParameters
Swap the parameters of the CONVERT function.
|
boolean |
sysDummy1
Support the pseudo-table SYSIBM.SYSDUMMY1.
|
boolean |
systemColumns
The system columns 'CTID' and 'OID' are supported.
|
boolean |
treatEmptyStringsAsNull
Empty strings are treated like NULL values.
|
boolean |
uniqueIndexSingleNull
For unique indexes, NULL is distinct.
|
boolean |
uniqueIndexSingleNullExceptAllColumnsAreNull
When using unique indexes, multiple rows with NULL in all columns
are allowed, however it is not allowed to have multiple rows with the
same values otherwise.
|
Modifier and Type | Method and Description |
---|---|
static Mode |
getInstance(String name)
Get the mode with the given name.
|
String |
getName() |
public boolean aliasColumnName
public boolean convertInsertNullToZero
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 lowerCaseIdentifiers
public boolean nullConcatIsNull
public boolean squareBracketQuotedNames
public boolean supportOffsetFetch
public boolean systemColumns
public boolean uniqueIndexSingleNull
public boolean uniqueIndexSingleNullExceptAllColumnsAreNull
public boolean treatEmptyStringsAsNull
public boolean sysDummy1
public boolean allowPlusForStringConcat
public boolean logIsLogBase10
public boolean serialColumnIsNotPK
public boolean swapConvertFunctionParameters
public boolean isolationLevelInSelectOrInsertStatement
public boolean onDuplicateKeyUpdate
public Pattern supportedClientInfoPropertiesRegEx
public boolean supportPoundSymbolForColumnNames
public boolean prohibitEmptyInPredicate
Copyright © 2017 JBoss by Red Hat. All rights reserved.