public Class MariaDBDialect

Overrides org.hibernate.dialect.MySQLDialect.buildIdentifierHelper.

Doc from org.hibernate.dialect.Dialect.buildIdentifierHelper.

The IdentifierHelper indicated by this dialect for handling identifier conversions. Returning null is allowed and indicates that Hibernate should fall back 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

Parameters

builder:IdentifierHelperBuilder

A partially-configured IdentifierHelperBuilder.

dbMetaData:DatabaseMetaData

Access to the metadata returned from the driver if needed and if available

Warning

it may be null.

Returns:IdentifierHelper

The IdentifierHelper instance to use, or null to indicate Hibernate should use its fallback path

Annotations

@Override

Exceptions

SQLException:

Accessing the DatabaseMetaData can throw it. Just rethrow and Hibernate will handle it.

Overrides org.hibernate.dialect.MySQLDialect.contributeTypes.

Doc from org.hibernate.dialect.Dialect.contributeTypes.

A callback which allows the Dialect to contribute types.

Parameters

typeContributions:TypeContributions

Callback to contribute the types

serviceRegistry:ServiceRegistry

The service registry

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.getFunctionalDependencyAnalysisSupport.

Doc from org.hibernate.dialect.Dialect.getFunctionalDependencyAnalysisSupport.

Get this dialect's level of support for primary key functional dependency analysis within GROUP BY and ORDER BY clauses.

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.getMySQLVersion.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getNationalizationSupport.

Doc from org.hibernate.dialect.Dialect.getNationalizationSupport.

Determines whether this database requires the use of explicitly nationalized character (Unicode) data types.

That is, whether the use of Types#NCHAR, Types#NVARCHAR, and Types#NCLOB is required for nationalized character data.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getQuerySequencesString.

Doc from org.hibernate.dialect.Dialect.getQuerySequencesString.

Get the select command used retrieve the names of all sequences.

Returns:String

The select command; or null if sequences are not supported.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.getSequenceInformationExtractor.

Doc from org.hibernate.dialect.Dialect.getSequenceInformationExtractor.

A SequenceInformationExtractor which is able to extract org.hibernate.tool.schema.extract.spi.SequenceInformation from the JDBC result set returned when getQuerySequencesString() is executed.

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.getSequenceSupport.

Doc from org.hibernate.dialect.MySQLDialect.getSequenceSupport.

No support for sequences.

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.getSqlAstTranslatorFactory.

Doc from org.hibernate.dialect.Dialect.getSqlAstTranslatorFactory.

Return a SqlAstTranslatorFactory specific to this dialect, or null to use the standard translator.

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.initializeFunctionRegistry.

Doc from org.hibernate.dialect.Dialect.initializeFunctionRegistry.

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

• any(arg) - aggregate function
• every(arg) - aggregate function

• var_samp(arg) - aggregate function
• var_pop(arg) - aggregate function
• stddev_samp(arg) - aggregate function
• stddev_pop(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])

• local date
• local time
• local datetime
• offset datetime
• instant

• left(string, length)
• right(string, length)
• replace(string, pattern, replacement)
• pad(string with length spec[ character])
• repeat(string, times)

• pi
• log10(arg)
• log(base, arg)
• sign(arg)
• sin(arg)
• cos(arg)
• tan(arg)
• asin(arg)
• acos(arg)
• atan(arg)
• atan2(arg0, arg1)
• round(arg0[, arg1])
• truncate(arg0[, arg1])
• sinh(arg)
• tanh(arg)
• cosh(arg)
• least(arg0, arg1, ...)
• greatest(arg0, arg1, ...)
• degrees(arg)
• radians(arg)

• format(datetime as pattern)
• collate(string as collation)
• str(arg) - synonym of cast(a as String)
• ifnull(arg0, arg1) - synonym of coalesce(a, b)

• 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)

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.resolveSqlTypeDescriptor.

Doc from org.hibernate.dialect.Dialect.resolveSqlTypeDescriptor.

Assigns an appropriate JdbcType to a column of a JDBC result set based on the column type name, JDBC type code, precision, and scale.

Parameters

columnTypeName:String

the column type name

jdbcTypeCode:int

the type code

precision:int

the precision or 0

scale:int

the scale or 0

Returns:JdbcType

an appropriate instance of JdbcType

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.supportsColumnCheck.

Doc from org.hibernate.dialect.Dialect.supportsColumnCheck.

Does this dialect support column-level check constraints?

Returns:boolean

True if column-level check constraints are supported; false otherwise.

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsIfExistsAfterAlterTable.

Doc from org.hibernate.dialect.Dialect.supportsIfExistsAfterAlterTable.

For an alter table, can the phrase if exists be applied?

Returns:boolean

true if if exists can be applied after alter table

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsIfExistsBeforeConstraintName.

Doc from org.hibernate.dialect.Dialect.supportsIfExistsBeforeConstraintName.

For dropping a constraint with an alter table statement, can the phrase if exists be applied before the constraint name?

Returns:boolean

true if if exists can be applied before the constraint name

Annotations

@Override

Overrides org.hibernate.dialect.Dialect.supportsInsertReturning.

Doc from org.hibernate.dialect.Dialect.supportsInsertReturning.

Does this dialect fully support returning arbitrary generated column values after execution of an insert statement, using native SQL syntax?

Support for identity columns is insufficient here, we require something like:

1. insert ... returning ...
2. select from final table (insert ... )

Returns:boolean

true for 10.5 and above because Maria supports insert ... returning even though MySQL does not

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.supportsLateral.

Doc from org.hibernate.dialect.Dialect.supportsLateral.

Does this dialect support the SQL lateral keyword or a proprietary alternative?

Returns:boolean

true if the underlying database supports lateral, false otherwise. The default is false.

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.supportsNoWait.

Doc from org.hibernate.dialect.Dialect.supportsNoWait.

Does this dialect support NO_WAIT timeout.

Returns:boolean

true if NO_WAIT is supported

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.supportsRecursiveCTE.

Doc from org.hibernate.dialect.Dialect.supportsRecursiveCTE.

Does this dialect/database support recursive CTEs?

Returns:boolean

true if recursive CTEs are supported

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.supportsSkipLocked.

Doc from org.hibernate.dialect.Dialect.supportsSkipLocked.

Does this dialect support SKIP_LOCKED timeout.

Returns:boolean

true if SKIP_LOCKED is supported

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.supportsWait.

Doc from org.hibernate.dialect.Dialect.supportsWait.

Does this dialect support WAIT timeout.

Returns:boolean

true if WAIT is supported

Annotations

@Override

Overrides org.hibernate.dialect.MySQLDialect.supportsWindowFunctions.

Doc from org.hibernate.dialect.Dialect.supportsWindowFunctions.

Does this dialect support window functions like row_number() over (..)?

Returns:boolean

true if the underlying database supports window functions, false otherwise. The default is false.

Annotations

@Override