MySQLDialect (hibernate-core JavaDocs)

java.lang.Object
- org.hibernate.dialect.Dialect
- - org.hibernate.dialect.MySQLDialect

All Implemented Interfaces:

ConversionContext

Direct Known Subclasses:

MariaDBDialect, MySQL55Dialect, MySQL57Dialect, MySQL5Dialect, MySQL8Dialect
```
public class MySQLDialect
extends Dialect
```
An SQL dialect for MySQL (prior to 5.x).

Nested Class Summary
- Nested classes/interfaces inherited from class org.hibernate.dialect.Dialect
  Dialect.SizeStrategy, Dialect.SizeStrategyImpl

Field Summary
- Fields inherited from class org.hibernate.dialect.Dialect
  CLOSED_QUOTE, DEFAULT_BATCH_SIZE, LEGACY_LOB_MERGE_STRATEGY, NEW_LOCATOR_LOB_MERGE_STRATEGY, NO_BATCH, QUOTE, STANDARD_DEFAULT_BATCH_LOAD_SIZING_STRATEGY, STREAM_XFER_LOB_MERGE_STRATEGY, TWO_SINGLE_QUOTES_REPLACEMENT

Constructor Summary

Constructors
Constructor and Description
`MySQLDialect()`
`MySQLDialect(DialectResolutionInfo info)`
`MySQLDialect(int version)`
`MySQLDialect(int version, int characterSetBytesPerCharacter)`

Method Summary

All Methods Static Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`boolean`	`areStringComparisonsCaseInsensitive()` Are string comparisons implicitly case insensitive.
`IdentifierHelper`	`buildIdentifierHelper(IdentifierHelperBuilder builder, DatabaseMetaData dbMetaData)` Build the IdentifierHelper indicated by this Dialect for handling identifier conversions.
`SQLExceptionConversionDelegate`	`buildSQLExceptionConversionDelegate()` Build an instance of a `SQLExceptionConversionDelegate` for interpreting dialect-specific error or SQLState codes.
`boolean`	`canCreateCatalog()` Does this dialect support catalog creation?
`boolean`	`canCreateSchema()` Does this dialect support schema creation?
`char`	`closeQuote()` The character specific to this dialect used to close a quoted identifier.
`String`	`currentTimestamp()` MySQL 5.7 precision defaults to seconds, but microseconds is better
`static Replacer`	`datetimeFormat(String format)`
`boolean`	`dropConstraints()` Do we need to drop constraints before dropping tables in this dialect?
`protected String`	`escapeLiteral(String literal)` Escape String literal.
`String`	`extractPattern(TemporalUnit unit)` MySQL supports a limited list of temporal fields in the extract() function, but we can emulate some of them by using the appropriate named functions instead of extract().
`String`	`getAddForeignKeyConstraintString(String constraintName, String[] foreignKey, String referencedTable, String[] primaryKey, boolean referencesPrimaryKey)` The syntax used to add a foreign key constraint to a table.
`String`	`getCastTypeName(SqlExpressable type, Long length, Integer precision, Integer scale)` Get the name of the database type appropriate for casting operations (via the CAST() SQL function) for the given `SqlExpressable` SQL type.
`protected static int`	`getCharacterSetBytesPerCharacter(DatabaseMetaData databaseMetaData)`
`String`	`getColumnComment(String comment)` Get the comment into a form supported for column definition.
`String[]`	`getCreateCatalogCommand(String catalogName)` Get the SQL command used to create the named catalog
`String[]`	`getCreateSchemaCommand(String schemaName)` Get the SQL command used to create the named schema
`String`	`getCurrentTimestampSelectString()` Retrieve the command used to retrieve the current timestamp from the database.
`long`	`getDefaultLobLength()`
`protected MySQLStorageEngine`	`getDefaultMySQLStorageEngine()`
`String[]`	`getDropCatalogCommand(String catalogName)` Get the SQL command used to drop the named catalog
`String`	`getDropForeignKeyString()`
`String[]`	`getDropSchemaCommand(String schemaName)` Get the SQL command used to drop the named schema
`SqmMultiTableMutationStrategy`	`getFallbackSqmMutationStrategy(EntityMappingType rootEntityDescriptor, RuntimeModelCreationContext runtimeModelCreationContext)`
`int`	`getFloatPrecision()` This is the default precision for a generated column mapped to a Java `Float` or `float`.
`String`	`getForUpdateNowaitString()` Retrieves the `FOR UPDATE NOWAIT` syntax specific to this dialect.
`String`	`getForUpdateNowaitString(String aliases)` Get the `FOR UPDATE OF column_list NOWAIT` fragment appropriate for this dialect given the aliases of the columns to be write locked.
`String`	`getForUpdateSkipLockedString()` Retrieves the `FOR UPDATE SKIP LOCKED` syntax specific to this dialect.
`String`	`getForUpdateSkipLockedString(String aliases)` Get the `FOR UPDATE OF column_list SKIP LOCKED` fragment appropriate for this dialect given the aliases of the columns to be write locked.
`String`	`getForUpdateString(String aliases)` Get the `FOR UPDATE OF column_list` fragment appropriate for this dialect given the aliases of the columns to be write locked.
`long`	`getFractionalSecondPrecisionInNanos()` `microsecond` is the smallest unit for `timestampadd()` and `timestampdiff()`, and the highest precision for a `timestamp`.
`String`	`getFromDual()` Some databases require a bit of syntactic noise when there are no tables in the from clause.
`GroupBySummarizationRenderingStrategy`	`getGroupBySummarizationRenderingStrategy()` The strategy to use for rendering summarizations in the GROUP BY clause.
`IdentityColumnSupport`	`getIdentityColumnSupport()` Get the appropriate `IdentityColumnSupport`
`LimitHandler`	`getLimitHandler()` Returns a `LimitHandler` that implements support for `Query.setMaxResults(int)` and `Query.setFirstResult(int)` for this dialect.
`protected int`	`getMaxVarcharLen()`
`int`	`getMySQLVersion()`
`String`	`getNotExpression(String expression)` Negate an expression
`String`	`getNullColumnString(String columnType)` The keyword used to specify a nullable column.
`NullOrdering`	`getNullOrdering()` Returns the ordering of null.
`int`	`getPreferredSqlTypeCodeForBoolean()` The JDBC `type code` to use for mapping properties of Java type `boolean`.
`String`	`getQueryHintString(String query, String hints)` Apply a hint to the query.
`String`	`getReadLockString(int timeout)` Get the string to append to SELECT statements to acquire READ locks for this dialect.
`String`	`getReadLockString(String aliases, int timeout)` Get the string to append to SELECT statements to acquire READ locks for this dialect given the aliases of the columns to be read locked.
`ResultSet`	`getResultSet(CallableStatement ps)` Given a callable statement previously processed by `Dialect.registerResultSetOutParameter(java.sql.CallableStatement, int)`, extract the `ResultSet` from the OUT parameter.
`String`	`getSelectGUIDString()` Get the command used to select a GUID from the underlying database.
`SequenceSupport`	`getSequenceSupport()` No support for sequences.
`Dialect.SizeStrategy`	`getSizeStrategy()`
`SqlAstTranslatorFactory`	`getSqlAstTranslatorFactory()` Return an SqlAstTranslatorFactory specific for the Dialect.
`String`	`getTableComment(String comment)` Get the comment into a form supported for table definition.
`String`	`getTableTypeString()`
`UniqueDelegate`	`getUniqueDelegate()` Get the UniqueDelegate supported by this dialect
`int`	`getVersion()`
`ViolatedConstraintNameExtractor`	`getViolatedConstraintNameExtractor()`
`String`	`getWriteLockString(int timeout)` Get the string to append to SELECT statements to acquire WRITE locks for this dialect.
`String`	`getWriteLockString(String aliases, int timeout)` Get the string to append to SELECT statements to acquire WRITE locks for this dialect given the aliases of the columns to be write locked.
`RowLockStrategy`	`getWriteRowLockStrategy()` The row lock strategy to use for write locks.
`boolean`	`hasSelfReferentialForeignKeyBug()` Does the database/driver have bug in deleting rows that refer to other rows being deleted in the same query?
`void`	`initializeFunctionRegistry(QueryEngine queryEngine)` Initialize the given registry with any dialect-specific functions.
`boolean`	`isCurrentTimestampSelectStringCallable()` Should the value returned by `Dialect.getCurrentTimestampSelectString()` be treated as callable.
`boolean`	`isJdbcLogWarningsEnabledByDefault()` Does the fetching JDBC statement warning for logging is enabled by default
`char`	`openQuote()` The character specific to this dialect used to begin a quoted identifier.
`boolean`	`qualifyIndexName()` Do we need to qualify index names with the schema name?
`int`	`registerResultSetOutParameter(CallableStatement statement, int col)` Registers a parameter (either OUT, or the new REF_CURSOR param type available in Java 8) capable of returning `ResultSet` by position.
`String`	`renderOrderByElement(String expression, String collation, String order, NullPrecedence nulls)` Renders an ordering fragment
`JdbcTypeDescriptor`	`resolveSqlTypeDescriptor(int jdbcTypeCode, int precision, int scale, JdbcTypeDescriptorRegistry jdbcTypeDescriptorRegistry)`
`boolean`	`supportsCascadeDelete()` Does this dialect support cascaded delete on foreign key definitions?
`boolean`	`supportsColumnCheck()` Does this dialect support column-level check constraints?
`boolean`	`supportsCurrentTimestampSelection()` Does this dialect support a way to retrieve the database's current timestamp value?
`boolean`	`supportsEmptyInList()` Does this dialect support empty IN lists? For example, is [where XYZ in ()] a supported construct?
`boolean`	`supportsIfExistsBeforeTableName()` For dropping a table, can the phrase "if exists" be applied before the table name? NOTE : Only one or the other (or neither) of this and `Dialect.supportsIfExistsAfterTableName()` should return true
`boolean`	`supportsLobValueChangePropagation()` Does the dialect support propagating changes to LOB values back to the database? Talking about mutating the internal value of the locator as opposed to supplying a new locator instance...
`boolean`	`supportsLockTimeouts()` Informational metadata about whether this dialect is known to support specifying timeouts for requested lock acquisitions.
`boolean`	`supportsNoWait()` Does this dialect/database support NO_WAIT timeout.
`boolean`	`supportsNullPrecedence()`
`boolean`	`supportsOffsetInSubquery()` Does this dialect support offset in subqueries? Ex: select * from Table1 where col1 in (select col1 from Table2 order by col2 limit 1 offset 1)
`boolean`	`supportsRowValueConstructorSyntax()` Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax.
`boolean`	`supportsRowValueConstructorSyntaxInInList()` If the dialect supports `row values`, does it offer such support in IN lists as well? For example, "...
`boolean`	`supportsRowValueConstructorSyntaxInSet()` Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax, sometimes called tuple syntax, in the SET clause; Basically, does it support syntax like "...
`boolean`	`supportsSelectAliasInGroupByClause()`
`boolean`	`supportsSkipLocked()` Does this dialect/database support SKIP_LOCKED timeout.
`boolean`	`supportsSubqueryOnMutatingTable()` Does this dialect support referencing the table being mutated in a subquery.
`boolean`	`supportsUnionAll()` Does this dialect support UNION ALL.
`boolean`	`supportsWait()` Does this dialect/database support WAIT timeout.
`boolean`	`supportsWindowFunctions()` Does this dialect support window functions like `row_number() over (..)`
`String`	`timestampaddPattern(TemporalUnit unit, TemporalType temporalType)` Obtain a pattern for the SQL equivalent to a `timestampadd()` function call.
`String`	`timestampdiffPattern(TemporalUnit unit, TemporalType fromTemporalType, TemporalType toTemporalType)` Obtain a pattern for the SQL equivalent to a `timestampdiff()` function call.
`String`	`translateDatetimeFormat(String format)` Translate the given datetime format string from the pattern language defined by Java's `DateTimeFormatter` to whatever pattern language is understood by the native datetime formatting function for this database (often the `to_char()` function).

Methods inherited from class org.hibernate.dialect.Dialect
addSqlHintOrComment, appendLockHint, appendLockHint, applyLocksToSql, augmentRecognizedTableTypes, binaryToDecimalPrecision, bindLimitParametersFirst, bindLimitParametersInReverseOrder, buildSQLExceptionConverter, castPattern, contributeTypes, convertToFirstRowValue, createCaseFragment, createOuterJoinFragment, currentDate, currentLocalTime, currentLocalTimestamp, currentTime, currentTimestampWithTimeZone, defaultScrollMode, doesReadCommittedCauseWritersToBlockReaders, doesRepeatableReadCauseReadersToBlockWriters, equivalentTypes, escapeComment, forceLimitUsage, forceLobAsLastValue, formatAsTimestamp, formatAsTimestamp, formatAsTimestamp, formatBinaryLiteral, formatDateTimeLiteral, formatDateTimeLiteral, formatDateTimeLiteral, forUpdateOfColumns, getAddColumnString, getAddColumnSuffixString, getAddForeignKeyConstraintString, getAddPrimaryKeyConstraintString, getAddUniqueConstraintString, getAlterTableString, getAuxiliaryDatabaseObjectExporter, getBooleanCheckCondition, getCallableStatementSupport, getCascadeConstraintsString, getCaseInsensitiveLike, getColumnAliasExtractor, getCreateMultisetTableString, getCreateSequenceString, getCreateSequenceString, getCreateSequenceStrings, getCreateTableString, getCreateTemporaryTableColumnAnnotation, getCrossJoinSeparator, getCurrentSchemaCommand, getCurrentTimestampSQLFunctionName, getDefaultBatchLoadSizingStrategy, getDefaultDecimalPrecision, getDefaultProperties, getDefaultTimestampPrecision, getDialect, getDialect, getDoublePrecision, getDropSequenceString, getDropSequenceStrings, getDropTableString, getEnumCheckCondition, getForeignKeyExporter, getForUpdateString, getForUpdateString, getForUpdateString, getForUpdateString, getGroupByConstantRenderingStrategy, getHibernateTypeName, getHibernateTypeName, getHqlTranslator, getIndexExporter, getInExpressionCountLimit, getKeywords, getLimitString, getLimitString, getLobMergeStrategy, getLockingStrategy, getLockRowIdentifier, getLowercaseFunction, getMaxAliasLength, getNameQualifierSupport, getNationalizationSupport, getNativeIdentifierGeneratorClass, getNativeIdentifierGeneratorStrategy, getNoColumnsInsertString, getNullColumnString, getQueryHintString, getQuerySequencesString, getRawTypeName, getRawTypeName, getReadRowLockStrategy, getResultSet, getResultSet, getSchemaNameResolver, getSelectClauseNullString, getSelectSequenceNextValString, getSequenceExporter, getSequenceInformationExtractor, getSequenceNextValString, getSequenceNextValString, getSqlTypeDescriptorOverride, getSqmTranslatorFactory, getTableAliasSeparator, getTableExporter, getTypeName, getTypeName, getTypeName, getTypeName, getUniqueKeyExporter, hasAlterTable, inlineLiteral, isEmptyStringTreatedAsNull, isLockTimeoutParameterized, isTypeNameRegistered, prependComment, quote, registerColumnType, registerColumnType, registerHibernateType, registerHibernateType, registerKeyword, registerResultSetOutParameter, remapSqlTypeDescriptor, replaceResultVariableInOrderByClauseWithPosition, requiresCastingOfParametersInSelectClause, requiresFloatCastingOfIntegerDivision, requiresParensForTupleDistinctCounts, supportsBindAsCallableArgument, supportsBitType, supportsCaseInsensitiveLike, supportsCircularCascadeDeleteConstraints, supportsCommentOn, supportsExistsInSelect, supportsExpectedLobUsagePattern, supportsFetchClause, supportsFractionalTimestampArithmetic, supportsIfExistsAfterAlterTable, supportsIfExistsAfterConstraintName, supportsIfExistsAfterTableName, supportsIfExistsBeforeConstraintName, supportsJdbcConnectionLobCreation, supportsLimit, supportsLimitOffset, supportsNamedParameters, supportsNationalizedTypes, supportsNoColumnsInsert, supportsNonQueryWithCTE, supportsNotNullUnique, supportsOrderByInSubquery, supportsOrdinalSelectItemReference, supportsOuterJoinForUpdate, supportsParametersInInsertSelect, supportsPartitionBy, supportsPooledSequences, supportsResultSetPositionQueryMethodsOnForwardOnlyCursor, supportsRowValueConstructorSyntaxInInSubquery, supportsRowValueConstructorSyntaxInQuantifiedPredicates, supportsSelectQueryWithoutFromClause, supportsSequences, supportsSubqueryInSelect, supportsSubselectAsInPredicateLHS, supportsTableCheck, supportsTemporalLiteralOffset, supportsTemporaryTables, supportsTimezoneTypes, supportsTruncateWithCast, supportsTupleCounts, supportsTupleDistinctCounts, supportsTuplesInSubqueries, supportsUnboundedLobLocatorMaterialization, supportsUnionInSubquery, supportsUnique, supportsUniqueConstraintInCreateAlterTable, supportsValuesList, supportsValuesListForInsert, supportsVariableLimit, toBooleanValueString, toString, transformSelectString, translateDurationField, translateExtractField, trimPattern, useFollowOnLocking, useInputStreamToInsertBlob, useMaxForLimit, wrapDateLiteral, wrapTimeLiteral, wrapTimestampLiteral

Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, wait, wait, wait

- Constructor Detail
  - MySQLDialect
```
public MySQLDialect(DialectResolutionInfo info)
```
  - MySQLDialect
```
public MySQLDialect()
```
  - MySQLDialect
```
public MySQLDialect(int version)
```
  - MySQLDialect
```
public MySQLDialect(int version,
                    int characterSetBytesPerCharacter)
```
- Method Detail
  - getCharacterSetBytesPerCharacter
```
protected static int getCharacterSetBytesPerCharacter(DatabaseMetaData databaseMetaData)
```
  - getMaxVarcharLen
```
protected int getMaxVarcharLen()
```
  - getNullColumnString
```
public String getNullColumnString(String columnType)
```
    Description copied from class: Dialect
    
    The keyword used to specify a nullable column.
    
    Overrides:
    
    getNullColumnString in class Dialect
    
    Returns:
    
    String
  - getVersion
```
public int getVersion()
```
    Specified by:
    
    getVersion in class Dialect
  - getMySQLVersion
```
public int getMySQLVersion()
```
  - getSizeStrategy
```
public Dialect.SizeStrategy getSizeStrategy()
```
    Overrides:
    
    getSizeStrategy in class Dialect
  - getDefaultLobLength
```
public long getDefaultLobLength()
```
    Overrides:
    
    getDefaultLobLength in class Dialect
  - resolveSqlTypeDescriptor
```
public JdbcTypeDescriptor resolveSqlTypeDescriptor(int jdbcTypeCode,
                                                   int precision,
                                                   int scale,
                                                   JdbcTypeDescriptorRegistry jdbcTypeDescriptorRegistry)
```
    Overrides:
    
    resolveSqlTypeDescriptor in class Dialect
  - getPreferredSqlTypeCodeForBoolean
```
public int getPreferredSqlTypeCodeForBoolean()
```
    Description copied from class: Dialect
    
    The JDBC type code to use for mapping properties of Java type boolean.
    Usually Types.BOOLEAN or Types.BIT.
    
    Overrides:
    
    getPreferredSqlTypeCodeForBoolean in class Dialect
    
    Returns:
    
    one of the type codes defined by Types.
  - initializeFunctionRegistry
```
public void initializeFunctionRegistry(QueryEngine queryEngine)
```
    Description copied from class: Dialect
    Initialize the given registry with any dialect-specific functions. Support for certain SQL functions is required, and if the database does not support a required function, then the dialect must define a way to emulate it. These required functions include the functions defined by the JPA query language specification:
    - avg(arg) - aggregate function
    - count([distinct ]arg) - aggregate function
    - max(arg) - aggregate function
    - min(arg) - aggregate function
    - sum(arg) - aggregate function
    - coalesce(arg0, arg1, ...)
    - nullif(arg0, arg1)
    - lower(arg)
    - upper(arg)
    - length(arg)
    - concat(arg0, arg1, ...)
    - locate(pattern, string[, start])
    - substring(string, start[, length])
    - trim([[spec ][character ]from] string)
    - abs(arg)
    - mod(arg0, arg1)
    - sqrt(arg)
    - current date
    - current time
    - current timestamp
    Along with an additional set of functions defined by ANSI SQL:
    - any(arg) - aggregate function
    - every(arg) - aggregate function
    - cast(arg as Type)
    - extract(field from arg)
    - ln(arg)
    - exp(arg)
    - power(arg0, arg1)
    - floor(arg)
    - ceiling(arg)
    - position(pattern in string)
    - substring(string from start[ for length])
    - overlay(string placing replacement from start[ for length])
    And the following functions for working with java.time types:
    - local date
    - local time
    - local datetime
    - offset datetime
    - instant
    And a number of additional "standard" functions:
    - left(string, length)
    - right(string, length)
    - replace(string, pattern, replacement)
    - pad(string with length spec[ character])
    - sign(arg)
    - sin(arg)
    - cos(arg)
    - tan(arg)
    - asin(arg)
    - acos(arg)
    - atan(arg)
    - atan2(arg0, arg1)
    - round(arg0, arg1)
    - least(arg0, arg1, ...)
    - greatest(arg0, arg1, ...)
    - format(datetime as pattern)
    - str(arg) - synonym of cast(a as String)
    - ifnull(arg0, arg1) - synonym of coalesce(a, b)
    Finally, the following functions are defined as abbreviations for extract(), and desugared by the parser:
    - second(arg) - synonym of extract(second from a)
    - minute(arg) - synonym of extract(minute from a)
    - hour(arg) - synonym of extract(hour from a)
    - day(arg) - synonym of extract(day from a)
    - month(arg) - synonym of extract(month from a)
    - year(arg) - synonym of extract(year from a)
    Overrides:
    
    initializeFunctionRegistry in class Dialect
  - getSqlAstTranslatorFactory
```
public SqlAstTranslatorFactory getSqlAstTranslatorFactory()
```
    Description copied from class: Dialect
    
    Return an SqlAstTranslatorFactory specific for the Dialect. Return null to use Hibernate's standard translator.
    
    Overrides:
    
    getSqlAstTranslatorFactory in class Dialect
    
    See Also:
    
    StandardSqlAstTranslatorFactory, JdbcEnvironment.getSqlAstTranslatorFactory()
  - getFloatPrecision
```
public int getFloatPrecision()
```
    Description copied from class: Dialect
    
    This is the default precision for a generated column mapped to a Java Float or float. That is, a value representing "single precision".
    Usually 24 binary digits, at least for databases with a conventional interpretation of the ANSI SQL specification.
    
    Overrides:
    
    getFloatPrecision in class Dialect
    
    Returns:
    
    a value representing "single precision", usually in binary digits, but sometimes in decimal digits
  - currentTimestamp
```
public String currentTimestamp()
```
    MySQL 5.7 precision defaults to seconds, but microseconds is better
    
    Overrides:
    
    currentTimestamp in class Dialect
  - getFractionalSecondPrecisionInNanos
```
public long getFractionalSecondPrecisionInNanos()
```
    microsecond is the smallest unit for timestampadd() and timestampdiff(), and the highest precision for a timestamp.
    
    Overrides:
    
    getFractionalSecondPrecisionInNanos in class Dialect
    
    Returns:
    
    the precision, specified as a quantity of nanoseconds
    
    See Also:
    
    TemporalUnit.NATIVE
  - extractPattern
```
public String extractPattern(TemporalUnit unit)
```
    MySQL supports a limited list of temporal fields in the extract() function, but we can emulate some of them by using the appropriate named functions instead of extract(). Thus, the additional supported fields are TemporalUnit.DAY_OF_YEAR, TemporalUnit.DAY_OF_MONTH, TemporalUnit.DAY_OF_YEAR. In addition, the field TemporalUnit.SECOND is redefined to include microseconds.
    
    Overrides:
    
    extractPattern in class Dialect
    
    Parameters:
    
    unit - the first argument
  - timestampaddPattern
```
public String timestampaddPattern(TemporalUnit unit,
                                  TemporalType temporalType)
```
    Description copied from class: Dialect
    
    Obtain a pattern for the SQL equivalent to a timestampadd() function call. The resulting pattern must contain ?1, ?2, and ?3 placeholders for the arguments.
    
    Overrides:
    
    timestampaddPattern in class Dialect
    
    Parameters:
    
    unit - the first argument
    
    temporalType - true if the third argument is a
  - timestampdiffPattern
```
public String timestampdiffPattern(TemporalUnit unit,
                                   TemporalType fromTemporalType,
                                   TemporalType toTemporalType)
```
    Description copied from class: Dialect
    
    Obtain a pattern for the SQL equivalent to a timestampdiff() function call. The resulting pattern must contain ?1, ?2, and ?3 placeholders for the arguments.
    
    Overrides:
    
    timestampdiffPattern in class Dialect
    
    Parameters:
    
    unit - the first argument
    
    fromTemporalType - true if the first argument is a timestamp, false if a date
    
    toTemporalType - true if the second argument is
  - supportsRowValueConstructorSyntaxInInList
```
public boolean supportsRowValueConstructorSyntaxInInList()
```
    Description copied from class: Dialect
    
    If the dialect supports row values, does it offer such support in IN lists as well?
    For example, "... where (FIRST_NAME, LAST_NAME) IN ( (?, ?), (?, ?) ) ..."
    
    Overrides:
    
    supportsRowValueConstructorSyntaxInInList in class Dialect
    
    Returns:
    
    true for MySQL 5.7 and above
    
    See Also:
    
    MySQL 5.7 work log
  - supportsUnionAll
```
public boolean supportsUnionAll()
```
    Description copied from class: Dialect
    
    Does this dialect support UNION ALL.
    
    Overrides:
    
    supportsUnionAll in class Dialect
    
    Returns:
    
    True if UNION ALL is supported; false otherwise.
  - supportsSelectAliasInGroupByClause
```
public boolean supportsSelectAliasInGroupByClause()
```
    Overrides:
    
    supportsSelectAliasInGroupByClause in class Dialect
  - supportsColumnCheck
```
public boolean supportsColumnCheck()
```
    Description copied from class: Dialect
    
    Does this dialect support column-level check constraints?
    
    Overrides:
    
    supportsColumnCheck in class Dialect
    
    Returns:
    
    True if column-level CHECK constraints are supported; false otherwise.
  - getQueryHintString
```
public String getQueryHintString(String query,
                                 String hints)
```
    Description copied from class: Dialect
    
    Apply a hint to the query. The entire query is provided, allowing the Dialect full control over the placement and syntax of the hint. By default, ignore the hint and simply return the query.
    
    Overrides:
    
    getQueryHintString in class Dialect
    
    Parameters:
    
    query - The query to which to apply the hint.
    
    hints - The hints to apply
    
    Returns:
    
    The modified SQL
  - getSequenceSupport
```
public SequenceSupport getSequenceSupport()
```
    No support for sequences.
    
    Overrides:
    
    getSequenceSupport in class Dialect
  - getViolatedConstraintNameExtractor
```
public ViolatedConstraintNameExtractor getViolatedConstraintNameExtractor()
```
    Specified by:
    
    getViolatedConstraintNameExtractor in interface ConversionContext
    
    Overrides:
    
    getViolatedConstraintNameExtractor in class Dialect
  - qualifyIndexName
```
public boolean qualifyIndexName()
```
    Description copied from class: Dialect
    
    Do we need to qualify index names with the schema name?
    
    Overrides:
    
    qualifyIndexName in class Dialect
    
    Returns:
    
    boolean
  - getAddForeignKeyConstraintString
```
public String getAddForeignKeyConstraintString(String constraintName,
                                               String[] foreignKey,
                                               String referencedTable,
                                               String[] primaryKey,
                                               boolean referencesPrimaryKey)
```
    Description copied from class: Dialect
    
    The syntax used to add a foreign key constraint to a table.
    
    Overrides:
    
    getAddForeignKeyConstraintString in class Dialect
    
    Parameters:
    
    constraintName - The FK constraint name.
    
    foreignKey - The names of the columns comprising the FK
    
    referencedTable - The table referenced by the FK
    
    primaryKey - The explicit columns in the referencedTable referenced by this FK.
    
    referencesPrimaryKey - if false, constraint should be explicit about which column names the constraint refers to
    
    Returns:
    
    the "add FK" fragment
  - getDropForeignKeyString
```
public String getDropForeignKeyString()
```
    Overrides:
    
    getDropForeignKeyString in class Dialect
  - getLimitHandler
```
public LimitHandler getLimitHandler()
```
    Description copied from class: Dialect
    
    Returns a LimitHandler that implements support for Query.setMaxResults(int) and Query.setFirstResult(int) for this dialect.
    
    Overrides:
    
    getLimitHandler in class Dialect
  - getFromDual
```
public String getFromDual()
```
    Description copied from class: Dialect
    
    Some databases require a bit of syntactic noise when there are no tables in the from clause.
    
    Overrides:
    
    getFromDual in class Dialect
    
    Returns:
    
    the SQL equivalent to Oracle's from dual.
  - closeQuote
```
public char closeQuote()
```
    Description copied from class: Dialect
    
    The character specific to this dialect used to close a quoted identifier.
    
    Overrides:
    
    closeQuote in class Dialect
    
    Returns:
    
    The dialect's specific close quote character.
  - openQuote
```
public char openQuote()
```
    Description copied from class: Dialect
    
    The character specific to this dialect used to begin a quoted identifier.
    
    Overrides:
    
    openQuote in class Dialect
    
    Returns:
    
    The dialect's specific open quote character.
  - canCreateCatalog
```
public boolean canCreateCatalog()
```
    Description copied from class: Dialect
    
    Does this dialect support catalog creation?
    
    Overrides:
    
    canCreateCatalog in class Dialect
    
    Returns:
    
    True if the dialect supports catalog creation; false otherwise.
  - getCreateCatalogCommand
```
public String[] getCreateCatalogCommand(String catalogName)
```
    Description copied from class: Dialect
    
    Get the SQL command used to create the named catalog
    
    Overrides:
    
    getCreateCatalogCommand in class Dialect
    
    Parameters:
    
    catalogName - The name of the catalog to be created.
    
    Returns:
    
    The creation commands
  - getDropCatalogCommand
```
public String[] getDropCatalogCommand(String catalogName)
```
    Description copied from class: Dialect
    
    Get the SQL command used to drop the named catalog
    
    Overrides:
    
    getDropCatalogCommand in class Dialect
    
    Parameters:
    
    catalogName - The name of the catalog to be dropped.
    
    Returns:
    
    The drop commands
  - canCreateSchema
```
public boolean canCreateSchema()
```
    Description copied from class: Dialect
    
    Does this dialect support schema creation?
    
    Overrides:
    
    canCreateSchema in class Dialect
    
    Returns:
    
    True if the dialect supports schema creation; false otherwise.
  - getCreateSchemaCommand
```
public String[] getCreateSchemaCommand(String schemaName)
```
    Description copied from class: Dialect
    
    Get the SQL command used to create the named schema
    
    Overrides:
    
    getCreateSchemaCommand in class Dialect
    
    Parameters:
    
    schemaName - The name of the schema to be created.
    
    Returns:
    
    The creation commands
  - getDropSchemaCommand
```
public String[] getDropSchemaCommand(String schemaName)
```
    Description copied from class: Dialect
    
    Get the SQL command used to drop the named schema
    
    Overrides:
    
    getDropSchemaCommand in class Dialect
    
    Parameters:
    
    schemaName - The name of the schema to be dropped.
    
    Returns:
    
    The drop commands
  - supportsIfExistsBeforeTableName
```
public boolean supportsIfExistsBeforeTableName()
```
    Description copied from class: Dialect
    
    For dropping a table, can the phrase "if exists" be applied before the table name?
    NOTE : Only one or the other (or neither) of this and Dialect.supportsIfExistsAfterTableName() should return true
    
    Overrides:
    
    supportsIfExistsBeforeTableName in class Dialect
    
    Returns:
    
    true if the "if exists" can be applied before the table name
  - getSelectGUIDString
```
public String getSelectGUIDString()
```
    Description copied from class: Dialect
    
    Get the command used to select a GUID from the underlying database.
    Optional operation.
    
    Overrides:
    
    getSelectGUIDString in class Dialect
    
    Returns:
    
    The appropriate command.
  - getTableComment
```
public String getTableComment(String comment)
```
    Description copied from class: Dialect
    
    Get the comment into a form supported for table definition.
    
    Overrides:
    
    getTableComment in class Dialect
    
    Parameters:
    
    comment - The comment to apply
    
    Returns:
    
    The comment fragment
  - getColumnComment
```
public String getColumnComment(String comment)
```
    Description copied from class: Dialect
    
    Get the comment into a form supported for column definition.
    
    Overrides:
    
    getColumnComment in class Dialect
    
    Parameters:
    
    comment - The comment to apply
    
    Returns:
    
    The comment fragment
  - getNullOrdering
```
public NullOrdering getNullOrdering()
```
    Description copied from class: Dialect
    
    Returns the ordering of null.
    
    Overrides:
    
    getNullOrdering in class Dialect
  - getFallbackSqmMutationStrategy
```
public SqmMultiTableMutationStrategy getFallbackSqmMutationStrategy(EntityMappingType rootEntityDescriptor,
                                                                    RuntimeModelCreationContext runtimeModelCreationContext)
```
    Overrides:
    
    getFallbackSqmMutationStrategy in class Dialect
  - getCastTypeName
```
public String getCastTypeName(SqlExpressable type,
                              Long length,
                              Integer precision,
                              Integer scale)
```
    Description copied from class: Dialect
    
    Get the name of the database type appropriate for casting operations (via the CAST() SQL function) for the given SqlExpressable SQL type.
    
    Overrides:
    
    getCastTypeName in class Dialect
    
    Returns:
    
    The database type name
  - supportsCurrentTimestampSelection
```
public boolean supportsCurrentTimestampSelection()
```
    Description copied from class: Dialect
    
    Does this dialect support a way to retrieve the database's current timestamp value?
    
    Overrides:
    
    supportsCurrentTimestampSelection in class Dialect
    
    Returns:
    
    True if the current timestamp can be retrieved; false otherwise.
  - isCurrentTimestampSelectStringCallable
```
public boolean isCurrentTimestampSelectStringCallable()
```
    Description copied from class: Dialect
    
    Should the value returned by Dialect.getCurrentTimestampSelectString() be treated as callable. Typically this indicates that JDBC escape syntax is being used...
    
    Overrides:
    
    isCurrentTimestampSelectStringCallable in class Dialect
    
    Returns:
    
    True if the Dialect.getCurrentTimestampSelectString() return is callable; false otherwise.
  - getCurrentTimestampSelectString
```
public String getCurrentTimestampSelectString()
```
    Description copied from class: Dialect
    
    Retrieve the command used to retrieve the current timestamp from the database.
    
    Overrides:
    
    getCurrentTimestampSelectString in class Dialect
    
    Returns:
    
    The command.
  - registerResultSetOutParameter
```
public int registerResultSetOutParameter(CallableStatement statement,
                                         int col)
                                  throws SQLException
```
    Description copied from class: Dialect
    
    Registers a parameter (either OUT, or the new REF_CURSOR param type available in Java 8) capable of returning ResultSet *by position*. Pre-Java 8, registering such ResultSet-returning parameters varied greatly across database and drivers; hence its inclusion as part of the Dialect contract.
    
    Overrides:
    
    registerResultSetOutParameter in class Dialect
    
    Parameters:
    
    statement - The callable statement.
    
    col - The bind position at which to register the output param.
    
    Returns:
    
    The number of (contiguous) bind positions used.
    
    Throws:
    
    SQLException - Indicates problems registering the param.
  - getResultSet
```
public ResultSet getResultSet(CallableStatement ps)
                       throws SQLException
```
    Description copied from class: Dialect
    
    Given a callable statement previously processed by Dialect.registerResultSetOutParameter(java.sql.CallableStatement, int), extract the ResultSet from the OUT parameter.
    
    Overrides:
    
    getResultSet in class Dialect
    
    Parameters:
    
    ps - The callable statement.
    
    Returns:
    
    The extracted result set.
    
    Throws:
    
    SQLException - Indicates problems extracting the result set.
  - getUniqueDelegate
```
public UniqueDelegate getUniqueDelegate()
```
    Description copied from class: Dialect
    
    Get the UniqueDelegate supported by this dialect
    
    Overrides:
    
    getUniqueDelegate in class Dialect
    
    Returns:
    
    The UniqueDelegate
  - supportsRowValueConstructorSyntax
```
public boolean supportsRowValueConstructorSyntax()
```
    Description copied from class: Dialect
    
    Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax.
    Basically, does it support syntax like "... where (FIRST_NAME, LAST_NAME) = ('Steve', 'Ebersole') ...".
    
    Overrides:
    
    supportsRowValueConstructorSyntax in class Dialect
    
    Returns:
    
    True if this SQL dialect is known to support "row value constructor" syntax; false otherwise.
  - supportsNullPrecedence
```
public boolean supportsNullPrecedence()
```
    Overrides:
    
    supportsNullPrecedence in class Dialect
  - supportsRowValueConstructorSyntaxInSet
```
public boolean supportsRowValueConstructorSyntaxInSet()
```
    Description copied from class: Dialect
    
    Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax, sometimes called tuple syntax, in the SET clause;
    Basically, does it support syntax like "... SET (FIRST_NAME, LAST_NAME) = ('Steve', 'Ebersole') ...".
    
    Overrides:
    
    supportsRowValueConstructorSyntaxInSet in class Dialect
    
    Returns:
    
    True if this SQL dialect is known to support "row value constructor" syntax in the SET clause; false otherwise.
  - renderOrderByElement
```
public String renderOrderByElement(String expression,
                                   String collation,
                                   String order,
                                   NullPrecedence nulls)
```
    Description copied from class: Dialect
    
    Renders an ordering fragment
    
    Overrides:
    
    renderOrderByElement in class Dialect
    
    Parameters:
    
    expression - The SQL order expression. In case of @OrderBy annotation user receives property placeholder (e.g. attribute name enclosed in '{' and '}' signs).
    
    collation - Collation string in format collate IDENTIFIER, or null if expression has not been explicitly specified.
    
    order - Order direction. Possible values: asc, desc, or null if expression has not been explicitly specified.
    
    nulls - Nulls precedence. Default value: NullPrecedence.NONE.
    
    Returns:
    
    Renders single element of ORDER BY clause.
  - supportsEmptyInList
```
public boolean supportsEmptyInList()
```
    Description copied from class: Dialect
    
    Does this dialect support empty IN lists?
    For example, is [where XYZ in ()] a supported construct?
    
    Overrides:
    
    supportsEmptyInList in class Dialect
    
    Returns:
    
    True if empty in lists are supported; false otherwise.
  - areStringComparisonsCaseInsensitive
```
public boolean areStringComparisonsCaseInsensitive()
```
    Description copied from class: Dialect
    
    Are string comparisons implicitly case insensitive.
    In other words, does [where 'XYZ' = 'xyz'] resolve to true?
    
    Overrides:
    
    areStringComparisonsCaseInsensitive in class Dialect
    
    Returns:
    
    True if comparisons are case insensitive.
  - supportsLobValueChangePropagation
```
public boolean supportsLobValueChangePropagation()
```
    Description copied from class: Dialect
    
    Does the dialect support propagating changes to LOB values back to the database? Talking about mutating the internal value of the locator as opposed to supplying a new locator instance...
    For BLOBs, the internal value might be changed by: Blob.setBinaryStream(long), Blob.setBytes(long, byte[]), Blob.setBytes(long, byte[], int, int), or Blob.truncate(long).
    For CLOBs, the internal value might be changed by: Clob.setAsciiStream(long), Clob.setCharacterStream(long), Clob.setString(long, String), Clob.setString(long, String, int, int), or Clob.truncate(long).
    NOTE : I do not know the correct answer currently for databases which (1) are not part of the cruise control process or (2) do not Dialect.supportsExpectedLobUsagePattern().
    
    Overrides:
    
    supportsLobValueChangePropagation in class Dialect
    
    Returns:
    
    True if the changes are propagated back to the database; false otherwise.
  - supportsSubqueryOnMutatingTable
```
public boolean supportsSubqueryOnMutatingTable()
```
    Description copied from class: Dialect
    Does this dialect support referencing the table being mutated in a subquery. The "table being mutated" is the table referenced in an UPDATE or a DELETE query. And so can that table then be referenced in a subquery of said UPDATE/DELETE query.
    For example, would the following two syntaxes be supported:
    - delete from TABLE_A where ID not in ( select ID from TABLE_A )
    - update TABLE_A set NON_ID = 'something' where ID in ( select ID from TABLE_A)
    Overrides:
    
    supportsSubqueryOnMutatingTable in class Dialect
    
    Returns:
    
    True if this dialect allows references the mutating table from a subquery.
  - supportsLockTimeouts
```
public boolean supportsLockTimeouts()
```
    Description copied from class: Dialect
    
    Informational metadata about whether this dialect is known to support specifying timeouts for requested lock acquisitions.
    
    Overrides:
    
    supportsLockTimeouts in class Dialect
    
    Returns:
    
    True is this dialect supports specifying lock timeouts.
  - buildSQLExceptionConversionDelegate
```
public SQLExceptionConversionDelegate buildSQLExceptionConversionDelegate()
```
    Description copied from class: Dialect
    Build an instance of a SQLExceptionConversionDelegate for interpreting dialect-specific error or SQLState codes.
    When Dialect.buildSQLExceptionConverter() returns null, the default SQLExceptionConverter is used to interpret SQLState and error codes. If this method is overridden to return a non-null value, the default SQLExceptionConverter will use the returned SQLExceptionConversionDelegate in addition to the following standard delegates:
    1. a "static" delegate based on the JDBC 4 defined SQLException hierarchy;
    2. a delegate that interprets SQLState codes for either X/Open or SQL-2003 codes, depending on java.sql.DatabaseMetaData#getSQLStateType
    It is strongly recommended that specific Dialect implementations override this method, since interpretation of a SQL error is much more accurate when based on the vendor-specific ErrorCode rather than the SQLState.
    Specific Dialects may override to return whatever is most appropriate for that vendor.
    Overrides:
    
    buildSQLExceptionConversionDelegate in class Dialect
    
    Returns:
    
    The SQLExceptionConversionDelegate for this dialect
  - buildIdentifierHelper
```
public IdentifierHelper buildIdentifierHelper(IdentifierHelperBuilder builder,
                                              DatabaseMetaData dbMetaData)
                                       throws SQLException
```
    Description copied from class: Dialect
    Build the IdentifierHelper indicated by this Dialect for handling identifier conversions. Returning null is allowed and indicates that Hibernate should fallback to building a "standard" helper. In the fallback path, any changes made to the IdentifierHelperBuilder during this call will still be incorporated into the built IdentifierHelper.
    The incoming builder will have the following set:
    - IdentifierHelperBuilder.isGloballyQuoteIdentifiers()
    - IdentifierHelperBuilder.getUnquotedCaseStrategy() - initialized to UPPER
    - IdentifierHelperBuilder.getQuotedCaseStrategy() - initialized to MIXED
    By default Hibernate will do the following:
    - Call IdentifierHelperBuilder.applyIdentifierCasing(DatabaseMetaData)
    - Call IdentifierHelperBuilder.applyReservedWords(DatabaseMetaData)
    - Applies AnsiSqlKeywords.sql2003() as reserved words
    - Applies the {#link #sqlKeywords} collected here as reserved words
    - Applies the Dialect's NameQualifierSupport, if it defines one
    Overrides:
    
    buildIdentifierHelper in class Dialect
    
    Parameters:
    
    builder - A semi-configured IdentifierHelper builder.
    
    dbMetaData - Access to the metadata returned from the driver if needed and if available. WARNING: may be null
    
    Returns:
    
    The IdentifierHelper instance to use, or null to indicate Hibernate should use its fallback path
    
    Throws:
    
    SQLException - Accessing the DatabaseMetaData can throw it. Just re-throw and Hibernate will handle.
    
    See Also:
    
    Dialect.getNameQualifierSupport()
  - getNotExpression
```
public String getNotExpression(String expression)
```
    Description copied from class: Dialect
    
    Negate an expression
    
    Overrides:
    
    getNotExpression in class Dialect
    
    Parameters:
    
    expression - The expression to negate
    
    Returns:
    
    The negated expression
  - getIdentityColumnSupport
```
public IdentityColumnSupport getIdentityColumnSupport()
```
    Description copied from class: Dialect
    
    Get the appropriate IdentityColumnSupport
    
    Overrides:
    
    getIdentityColumnSupport in class Dialect
    
    Returns:
    
    the IdentityColumnSupport
  - isJdbcLogWarningsEnabledByDefault
```
public boolean isJdbcLogWarningsEnabledByDefault()
```
    Description copied from class: Dialect
    
    Does the fetching JDBC statement warning for logging is enabled by default
    
    Overrides:
    
    isJdbcLogWarningsEnabledByDefault in class Dialect
    
    Returns:
    
    boolean
  - supportsCascadeDelete
```
public boolean supportsCascadeDelete()
```
    Description copied from class: Dialect
    
    Does this dialect support cascaded delete on foreign key definitions?
    
    Overrides:
    
    supportsCascadeDelete in class Dialect
    
    Returns:
    
    true indicates that the dialect does support cascaded delete on foreign keys.
  - getTableTypeString
```
public String getTableTypeString()
```
    Overrides:
    
    getTableTypeString in class Dialect
  - hasSelfReferentialForeignKeyBug
```
public boolean hasSelfReferentialForeignKeyBug()
```
    Description copied from class: Dialect
    
    Does the database/driver have bug in deleting rows that refer to other rows being deleted in the same query?
    
    Overrides:
    
    hasSelfReferentialForeignKeyBug in class Dialect
    
    Returns:
    
    true if the database/driver has this bug
  - dropConstraints
```
public boolean dropConstraints()
```
    Description copied from class: Dialect
    
    Do we need to drop constraints before dropping tables in this dialect?
    
    Overrides:
    
    dropConstraints in class Dialect
    
    Returns:
    
    True if constraints must be dropped prior to dropping the table; false otherwise.
  - getDefaultMySQLStorageEngine
```
protected MySQLStorageEngine getDefaultMySQLStorageEngine()
```
  - escapeLiteral
```
protected String escapeLiteral(String literal)
```
    Description copied from class: Dialect
    
    Escape String literal.
    
    Overrides:
    
    escapeLiteral in class Dialect
    
    Returns:
    
    escaped String
  - translateDatetimeFormat
```
public String translateDatetimeFormat(String format)
```
    Description copied from class: Dialect
    Translate the given datetime format string from the pattern language defined by Java's DateTimeFormatter to whatever pattern language is understood by the native datetime formatting function for this database (often the to_char() function).
    Since it's never possible to translate all of the pattern letter sequences understood by DateTimeFormatter, only the following subset of pattern letters is accepted by Hibernate:
    - G: era
    - y: year of era
    - Y: year of week-based year
    - M: month of year
    - w: week of week-based year (ISO week number)
    - W: week of month
    - E: day of week (name)
    - e: day of week (number)
    - d: day of month
    - D: day of year
    - a: AM/PM
    - H: hour of day (24 hour time)
    - h: hour of AM/PM (12 hour time)
    - m: minutes
    - s: seconds
    - z,Z,x: timezone offset
    In addition, punctuation characters and single-quoted literal strings are accepted.
    Overrides:
    
    translateDatetimeFormat in class Dialect
    
    Returns:
    
    a pattern accepted by the function that formats dates and times in this dialect
  - datetimeFormat
```
public static Replacer datetimeFormat(String format)
```
  - getWriteLockString
```
public String getWriteLockString(int timeout)
```
    Description copied from class: Dialect
    
    Get the string to append to SELECT statements to acquire WRITE locks for this dialect. Location of the returned string is treated the same as getForUpdateString.
    
    Overrides:
    
    getWriteLockString in class Dialect
    
    Parameters:
    
    timeout - in milliseconds, -1 for indefinite wait and 0 for no wait.
    
    Returns:
    
    The appropriate LOCK clause string.
  - getWriteLockString
```
public String getWriteLockString(String aliases,
                                 int timeout)
```
    Description copied from class: Dialect
    
    Get the string to append to SELECT statements to acquire WRITE locks for this dialect given the aliases of the columns to be write locked. Location of the of the returned string is treated the same as getForUpdateString.
    
    Overrides:
    
    getWriteLockString in class Dialect
    
    Parameters:
    
    aliases - The columns to be read locked.
    
    timeout - in milliseconds, -1 for indefinite wait and 0 for no wait.
    
    Returns:
    
    The appropriate LOCK clause string.
  - getReadLockString
```
public String getReadLockString(int timeout)
```
    Description copied from class: Dialect
    
    Get the string to append to SELECT statements to acquire READ locks for this dialect. Location of the returned string is treated the same as getForUpdateString.
    
    Overrides:
    
    getReadLockString in class Dialect
    
    Parameters:
    
    timeout - in milliseconds, -1 for indefinite wait and 0 for no wait.
    
    Returns:
    
    The appropriate LOCK clause string.
  - getReadLockString
```
public String getReadLockString(String aliases,
                                int timeout)
```
    Description copied from class: Dialect
    
    Get the string to append to SELECT statements to acquire READ locks for this dialect given the aliases of the columns to be read locked. Location of the returned string is treated the same as getForUpdateString.
    
    Overrides:
    
    getReadLockString in class Dialect
    
    Parameters:
    
    aliases - The columns to be read locked.
    
    timeout - in milliseconds, -1 for indefinite wait and 0 for no wait.
    
    Returns:
    
    The appropriate LOCK clause string.
  - getForUpdateSkipLockedString
```
public String getForUpdateSkipLockedString()
```
    Description copied from class: Dialect
    
    Retrieves the FOR UPDATE SKIP LOCKED syntax specific to this dialect.
    
    Overrides:
    
    getForUpdateSkipLockedString in class Dialect
    
    Returns:
    
    The appropriate FOR UPDATE SKIP LOCKED clause string.
  - getForUpdateSkipLockedString
```
public String getForUpdateSkipLockedString(String aliases)
```
    Description copied from class: Dialect
    
    Get the FOR UPDATE OF column_list SKIP LOCKED fragment appropriate for this dialect given the aliases of the columns to be write locked.
    
    Overrides:
    
    getForUpdateSkipLockedString in class Dialect
    
    Parameters:
    
    aliases - The columns to be write locked.
    
    Returns:
    
    The appropriate FOR UPDATE colunm_list SKIP LOCKED clause string.
  - getForUpdateNowaitString
```
public String getForUpdateNowaitString()
```
    Description copied from class: Dialect
    
    Retrieves the FOR UPDATE NOWAIT syntax specific to this dialect.
    
    Overrides:
    
    getForUpdateNowaitString in class Dialect
    
    Returns:
    
    The appropriate FOR UPDATE NOWAIT clause string.
  - getForUpdateNowaitString
```
public String getForUpdateNowaitString(String aliases)
```
    Description copied from class: Dialect
    
    Get the FOR UPDATE OF column_list NOWAIT fragment appropriate for this dialect given the aliases of the columns to be write locked.
    
    Overrides:
    
    getForUpdateNowaitString in class Dialect
    
    Parameters:
    
    aliases - The columns to be write locked.
    
    Returns:
    
    The appropriate FOR UPDATE OF colunm_list NOWAIT clause string.
  - getForUpdateString
```
public String getForUpdateString(String aliases)
```
    Description copied from class: Dialect
    
    Get the FOR UPDATE OF column_list fragment appropriate for this dialect given the aliases of the columns to be write locked.
    
    Overrides:
    
    getForUpdateString in class Dialect
    
    Parameters:
    
    aliases - The columns to be write locked.
    
    Returns:
    
    The appropriate FOR UPDATE OF column_list clause string.
  - supportsOffsetInSubquery
```
public boolean supportsOffsetInSubquery()
```
    Description copied from class: Dialect
    
    Does this dialect support offset in subqueries? Ex: select * from Table1 where col1 in (select col1 from Table2 order by col2 limit 1 offset 1)
    
    Overrides:
    
    supportsOffsetInSubquery in class Dialect
    
    Returns:
    
    boolean
  - supportsWindowFunctions
```
public boolean supportsWindowFunctions()
```
    Description copied from class: Dialect
    
    Does this dialect support window functions like `row_number() over (..)`
    
    Overrides:
    
    supportsWindowFunctions in class Dialect
    
    Returns:
    
    true if the underlying database supports window functions, false otherwise. The default is false.
  - supportsSkipLocked
```
public boolean supportsSkipLocked()
```
    Description copied from class: Dialect
    
    Does this dialect/database support SKIP_LOCKED timeout.
    
    Overrides:
    
    supportsSkipLocked in class Dialect
    
    Returns:
    
    true if SKIP_LOCKED is supported
  - supportsNoWait
```
public boolean supportsNoWait()
```
    Description copied from class: Dialect
    
    Does this dialect/database support NO_WAIT timeout.
    
    Overrides:
    
    supportsNoWait in class Dialect
    
    Returns:
    
    true if NO_WAIT is supported
  - supportsWait
```
public boolean supportsWait()
```
    Description copied from class: Dialect
    
    Does this dialect/database support WAIT timeout.
    
    Overrides:
    
    supportsWait in class Dialect
    
    Returns:
    
    true if WAIT is supported
  - getWriteRowLockStrategy
```
public RowLockStrategy getWriteRowLockStrategy()
```
    Description copied from class: Dialect
    
    The row lock strategy to use for write locks.
    
    Overrides:
    
    getWriteRowLockStrategy in class Dialect
  - getGroupBySummarizationRenderingStrategy
```
public GroupBySummarizationRenderingStrategy getGroupBySummarizationRenderingStrategy()
```
    Description copied from class: Dialect
    
    The strategy to use for rendering summarizations in the GROUP BY clause.
    
    Overrides:
    
    getGroupBySummarizationRenderingStrategy in class Dialect

Class MySQLDialect

Nested Class Summary

Nested classes/interfaces inherited from class org.hibernate.dialect.Dialect

Field Summary

Fields inherited from class org.hibernate.dialect.Dialect

Constructor Summary

Method Summary

Methods inherited from class org.hibernate.dialect.Dialect

Methods inherited from class java.lang.Object

Constructor Detail

MySQLDialect

MySQLDialect

MySQLDialect

MySQLDialect

Method Detail

getCharacterSetBytesPerCharacter

getMaxVarcharLen

getNullColumnString

getVersion

getMySQLVersion

getSizeStrategy

getDefaultLobLength

resolveSqlTypeDescriptor

getPreferredSqlTypeCodeForBoolean

initializeFunctionRegistry

getSqlAstTranslatorFactory

getFloatPrecision

currentTimestamp

getFractionalSecondPrecisionInNanos

extractPattern

timestampaddPattern

timestampdiffPattern

supportsRowValueConstructorSyntaxInInList

supportsUnionAll

supportsSelectAliasInGroupByClause

supportsColumnCheck

getQueryHintString

getSequenceSupport

getViolatedConstraintNameExtractor

qualifyIndexName

getAddForeignKeyConstraintString

getDropForeignKeyString

getLimitHandler

getFromDual

closeQuote

openQuote

canCreateCatalog

getCreateCatalogCommand

getDropCatalogCommand

canCreateSchema

getCreateSchemaCommand

getDropSchemaCommand

supportsIfExistsBeforeTableName

getSelectGUIDString

getTableComment

getColumnComment

getNullOrdering

getFallbackSqmMutationStrategy

getCastTypeName

supportsCurrentTimestampSelection

isCurrentTimestampSelectStringCallable

getCurrentTimestampSelectString

registerResultSetOutParameter

getResultSet

getUniqueDelegate

supportsRowValueConstructorSyntax

supportsNullPrecedence

supportsRowValueConstructorSyntaxInSet

renderOrderByElement

supportsEmptyInList

areStringComparisonsCaseInsensitive

supportsLobValueChangePropagation

supportsSubqueryOnMutatingTable

supportsLockTimeouts

buildSQLExceptionConversionDelegate

buildIdentifierHelper

getNotExpression

getIdentityColumnSupport

isJdbcLogWarningsEnabledByDefault

supportsCascadeDelete