Package org.hibernate.dialect

Class MySQLSqlAstTranslator<T extends JdbcOperation>

java.lang.Object

org.hibernate.sql.ast.spi.AbstractSqlAstTranslator<T>

org.hibernate.dialect.MySQLSqlAstTranslator<T>

All Implemented Interfaces:

Appendable, SqlAppender, SqlAstTranslator<T>, SqlAstWalker

public class MySQLSqlAstTranslator<T extends JdbcOperation>
extends AbstractSqlAstTranslator<T>

A SQL AST translator for MySQL.

Nested Class Summary

Nested classes/interfaces inherited from class org.hibernate.sql.ast.spi.AbstractSqlAstTranslator

AbstractSqlAstTranslator.ForUpdateClause, AbstractSqlAstTranslator.LockStrategy, AbstractSqlAstTranslator.SubQueryRelationalRestrictionEmulationRenderer<X extends Expression>

Field Summary

Fields inherited from interface org.hibernate.sql.ast.spi.SqlAppender

CLOSE_PARENTHESIS, COMA_SEPARATOR, COMA_SEPARATOR_CHAR, NO_SEPARATOR, NULL_KEYWORD, OPEN_PARENTHESIS, PARAM_MARKER, WHITESPACE

Constructor Summary

Constructors

Constructor	Description
MySQLSqlAstTranslator(SessionFactoryImplementor sessionFactory, Statement statement)

Method Summary

Modifier and Type	Method	Description
MySQLDialect	getDialect()
protected String	getForShare(int timeoutMillis)
protected String	getFromDual()	Some databases require a bit of syntactic noise when there are no tables in the from clause.
protected String	getFromDualForSelectOnly()
static String	getSqlType(CastTarget castTarget, Dialect dialect)	Deprecated, for removal: This API element is subject to removal in a future version. Use getSqlType(CastTarget, SessionFactoryImplementor) instead
static String	getSqlType(CastTarget castTarget, SessionFactoryImplementor factory)
protected void	renderComparison(Expression lhs, ComparisonOperator operator, Expression rhs)
protected void	renderExpressionAsClauseItem(Expression expression)
protected void	renderPartitionItem(Expression expression)
protected boolean	shouldEmulateFetchClause(QueryPart queryPart)
protected boolean	supportsDistinctFromPredicate()	Is this SQL dialect known to support some kind of distinct from predicate.
protected boolean	supportsIntersect()
protected boolean	supportsNestedSubqueryCorrelation()
boolean	supportsRowValueConstructorSyntaxInInList()	If the dialect supports row values, does it offer such support in IN lists as well?
protected boolean	supportsRowValueConstructorSyntaxInQuantifiedPredicates()	Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax with quantified predicates.
boolean	supportsRowValueConstructorSyntaxInSet()	Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax, sometimes called tuple syntax, in the SET clause;
protected boolean	supportsSimpleQueryGrouping()
protected boolean	supportsWithClause()	Whether the SQL with clause is supported.
void	visitBooleanExpressionPredicate(BooleanExpressionPredicate booleanExpressionPredicate)
void	visitCastTarget(CastTarget castTarget)
void	visitLikePredicate(LikePredicate likePredicate)
void	visitOffsetFetchClause(QueryPart queryPart)
void	visitQueryGroup(QueryGroup queryGroup)
void	visitQueryPartTableReference(QueryPartTableReference tableReference)
void	visitQuerySpec(QuerySpec querySpec)
protected void	visitRecursivePath(Expression recursivePath, int sizeEstimate)	Renders the recursive path, possibly wrapping a cast expression around it, to make sure a type with proper size is chosen.
void	visitValuesTableReference(ValuesTableReference tableReference)

Methods inherited from class org.hibernate.sql.ast.spi.AbstractSqlAstTranslator

addAdditionalWherePredicate, addAppliedParameterBinding, append, append, append, appendBackslashEscapedLikeLiteral, appendSql, appendSql, appendSql, appendSql, appendSql, applyParameter, areAllResultsParameters, areAllResultsParameters, assertRowsOnlyFetchClauseType, castFunction, castNumberToString, cleanup, determineCyclePathColumnName, determineLateralEmulationPredicate, determineLockingStrategy, determineWhereClauseRestrictionWithJoinEmulation, emulateCycleClauseWithRowAndArray, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctionsVisitQueryPart, emulateQuantifiedTupleSubQueryPredicate, emulateQueryPartTableReferenceColumnAliasing, emulateSearchClauseOrderWithRowAndArray, emulateSelectTupleComparison, emulateSortSpecificationNullPrecedence, emulateSubQueryRelationalRestrictionPredicate, emulateTupleComparison, emulateValuesTableReferenceColumnAliasing, getAffectedTableNames, getAppliedParameterBindings, getArrayContainsFunction, getBooleanType, getClauseStack, getCteStatement, getCurrentClauseStack, getCurrentCteStatement, getCurrentDmlStatement, getCurrentQueryPart, getDmlTargetTableAlias, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockTimeout, getFetchClauseTypeForRowNumbering, getForUpdate, getForUpdateWithClause, getIntegerType, getJdbcLockStrategy, getJdbcParameterBindings, getJdbcServices, getLeftHandExpression, getLimit, getLimitParameter, getLockOptions, getMaxRows, getNoWait, getOffsetParameter, getParameterBinders, getParameterBindValue, getParameterRenderingMode, getQueryPartForRowNumbering, getQueryPartStack, getRowsToSkip, getSelectItemReference, getSessionFactory, getSkipLocked, getSortSpecificationsRowNumbering, getSql, getSqlAppender, getSqlBuffer, getSqlTypeName, getStatement, getStringType, getWrapperOptions, hasAggregateFunctions, hasLimit, hasLimit, hasNestedTableGroupsToRender, hasOffset, inlineCteTableGroup, inOverOrWithinGroupClause, interpretExpression, isCorrelated, isInRecursiveQueryPart, isLiteral, isParameter, isRowNumberingCurrentQueryPart, isRowsOnlyFetchClauseType, isStruct, needsCteInlining, needsLocking, needsMaxRows, needsRecursiveKeywordInWithClause, needsRowsToSkip, prepareLimitOffsetParameters, processNestedTableGroupJoins, processTableGroupJoin, processTableGroupJoins, registerAffectedTable, registerAffectedTable, render, renderAsLiteral, renderBackslashEscapedLikePattern, renderCaseInsensitiveLikeEmulation, renderCasted, renderCombinedLimitClause, renderCombinedLimitClause, renderCommaSeparated, renderCommaSeparatedSelectExpression, renderCommaSeparatedSelectExpression, renderComparisonDistinctOperator, renderComparisonEmulateCase, renderComparisonEmulateDecode, renderComparisonEmulateIntersect, renderComparisonStandard, renderCteColumns, renderCycleClause, renderDerivedTableReference, renderExpressionAsLiteral, renderExpressionsAsSubquery, renderFetch, renderFetchExpression, renderFetchPlusOffsetExpression, renderFetchPlusOffsetExpressionAsLiteral, renderFetchPlusOffsetExpressionAsSingleParameter, renderFirstClause, renderFirstClause, renderFirstSkipClause, renderFirstSkipClause, renderForUpdateClause, renderInsertIntoNoColumns, renderIntoIntoAndTable, renderLimitOffsetClause, renderLimitOffsetClause, renderLiteral, renderMaterializationHint, renderNamedTableReference, renderOffset, renderOffsetExpression, renderOffsetFetchClause, renderOffsetFetchClause, renderOrderBy, renderParameterAsParameter, renderParameterAsParameter, renderPrimaryTableReference, renderQueryGroup, renderRecursiveCteVirtualSelections, renderRootTableGroup, renderRowNumber, renderRowNumberingSelectItems, renderRowsToClause, renderRowsToClause, renderSearchClause, renderSelectExpression, renderSelectExpressionWithCastedOrInlinedPlainParameters, renderSelectSimpleComparison, renderSelectTupleComparison, renderSetClause, renderSkipFirstClause, renderSkipFirstClause, rendersTableReferenceAlias, renderStandardCycleClause, renderStandardSearchClause, renderTableGroup, renderTableGroupJoin, renderTableReferenceIdentificationVariable, renderTableReferenceJoins, renderTopClause, renderTopClause, renderTopStartAtClause, renderTopStartAtClause, renderTupleComparisonStandard, renderVirtualSelections, resolveAliasedExpression, resolveAliasedExpression, resolveExpressionToAlias, setLimitParameter, setOffsetParameter, shouldEmulateLateralWithIntersect, shouldInlineCte, simpleColumnWriteFragmentRendering, supportsArrayConstructor, supportsDuplicateSelectItemsInQueryGroup, supportsFilterClause, supportsJoinInMutationStatementSubquery, supportsNestedWithClause, supportsNullPrecedence, supportsQuantifiedPredicates, supportsRecursiveClauseArrayAndRowEmulation, supportsRecursiveCycleClause, supportsRecursiveCycleUsingClause, supportsRecursiveSearchClause, supportsRowConstructor, supportsRowValueConstructorDistinctFromSyntax, supportsRowValueConstructorGtLtSyntax, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInSubQuery, supportsWithClauseInSubquery, translate, translateDelete, translateInsert, translateSelect, translateUpdate, useOffsetFetchClause, visitAggregateColumnWriteExpression, visitAnsiCaseSearchedExpression, visitAnsiCaseSimpleExpression, visitAny, visitAssignment, visitBetweenPredicate, visitBinaryArithmeticExpression, visitCaseSearchedExpression, visitCaseSearchedExpression, visitCaseSimpleExpression, visitCaseSimpleExpression, visitCollation, visitColumnReference, visitColumnWriteFragment, visitConversion, visitCteContainer, visitCteDefinition, visitCustomTableDelete, visitCustomTableInsert, visitCustomTableUpdate, visitDecodeCaseSearchedExpression, visitDeleteStatement, visitDeleteStatementOnly, visitDistinct, visitDuration, visitDurationUnit, visitEntityTypeLiteral, visitEvery, visitExistsPredicate, visitExtractUnit, visitFilterFragmentPredicate, visitFilterPredicate, visitFormat, visitForUpdateClause, visitFromClause, visitFunctionTableReference, visitGroupByClause, visitGroupedPredicate, visitHavingClause, visitInArrayPredicate, visitInListPredicate, visitInsertStatement, visitInsertStatementOnly, visitInSubQueryPredicate, visitJdbcLiteral, visitJunction, visitModifiedSubQueryExpression, visitNamedTableReference, visitNegatedPredicate, visitNullnessPredicate, visitOrderBy, visitOver, visitOverClause, visitOverClause, visitOverflow, visitParameter, visitParameterAsParameter, visitPartitionByClause, visitPartitionExpressions, visitPartitionExpressions, visitQueryLiteral, visitRelationalPredicate, visitReturningColumns, visitReturningColumns, visitSelectClause, visitSelectStatement, visitSelfRenderingExpression, visitSelfRenderingPredicate, visitSetAssignment, visitSortSpecification, visitSortSpecification, visitSqlFragmentPredicate, visitSqlSelectExpression, visitSqlSelection, visitSqlSelectionExpression, visitSqlSelections, visitStandardTableDelete, visitStandardTableInsert, visitStandardTableUpdate, visitStar, visitSummarization, visitTableGroup, visitTableGroupJoin, visitTableReferenceJoin, visitTrimSpecification, visitTuple, visitUnaryOperationExpression, visitUpdateStatement, visitUpdateStatementOnly, visitValuesList, visitWhereClause, withParameterRenderingMode, withRowNumbering

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

MySQLSqlAstTranslator

public MySQLSqlAstTranslator(SessionFactoryImplementor sessionFactory,
                             Statement statement)

Method Detail

getSqlType

@Deprecated(forRemoval=true)
public static String getSqlType(CastTarget castTarget,
                                Dialect dialect)

Deprecated, for removal: This API element is subject to removal in a future version.

Use getSqlType(CastTarget, SessionFactoryImplementor) instead

getSqlType

public static String getSqlType(CastTarget castTarget,
                                SessionFactoryImplementor factory)

renderExpressionAsClauseItem

protected void renderExpressionAsClauseItem(Expression expression)

Overrides:

renderExpressionAsClauseItem in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitRecursivePath

protected void visitRecursivePath(Expression recursivePath,
                                  int sizeEstimate)

Description copied from class: AbstractSqlAstTranslator

Renders the recursive path, possibly wrapping a cast expression around it, to make sure a type with proper size is chosen.

Overrides:

visitRecursivePath in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitBooleanExpressionPredicate

public void visitBooleanExpressionPredicate(BooleanExpressionPredicate booleanExpressionPredicate)

Specified by:

visitBooleanExpressionPredicate in interface SqlAstWalker

Overrides:

visitBooleanExpressionPredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

getForShare

protected String getForShare(int timeoutMillis)

Overrides:

getForShare in class AbstractSqlAstTranslator<T extends JdbcOperation>

shouldEmulateFetchClause

protected boolean shouldEmulateFetchClause(QueryPart queryPart)

visitQueryGroup

public void visitQueryGroup(QueryGroup queryGroup)

Specified by:

visitQueryGroup in interface SqlAstWalker

Overrides:

visitQueryGroup in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitQuerySpec

public void visitQuerySpec(QuerySpec querySpec)

Specified by:

visitQuerySpec in interface SqlAstWalker

Overrides:

visitQuerySpec in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitValuesTableReference

public void visitValuesTableReference(ValuesTableReference tableReference)

Specified by:

visitValuesTableReference in interface SqlAstWalker

Overrides:

visitValuesTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitQueryPartTableReference

public void visitQueryPartTableReference(QueryPartTableReference tableReference)

Specified by:

visitQueryPartTableReference in interface SqlAstWalker

Overrides:

visitQueryPartTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitOffsetFetchClause

public void visitOffsetFetchClause(QueryPart queryPart)

Specified by:

visitOffsetFetchClause in interface SqlAstWalker

Overrides:

visitOffsetFetchClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderComparison

protected void renderComparison(Expression lhs,
                                ComparisonOperator operator,
                                Expression rhs)

Overrides:

renderComparison in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderPartitionItem

protected void renderPartitionItem(Expression expression)

Overrides:

renderPartitionItem in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitLikePredicate

public void visitLikePredicate(LikePredicate likePredicate)

Specified by:

visitLikePredicate in interface SqlAstWalker

Overrides:

visitLikePredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsRowValueConstructorSyntaxInSet

public boolean supportsRowValueConstructorSyntaxInSet()

Description copied from class: AbstractSqlAstTranslator

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 AbstractSqlAstTranslator<T extends JdbcOperation>

Returns:

True if this SQL dialect is known to support "row value constructor" syntax in the SET clause; false otherwise.

supportsRowValueConstructorSyntaxInInList

public boolean supportsRowValueConstructorSyntaxInInList()

Description copied from class: AbstractSqlAstTranslator

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 AbstractSqlAstTranslator<T extends JdbcOperation>

Returns:

True if this SQL dialect is known to support "row value constructor" syntax in the IN list; false otherwise.

supportsRowValueConstructorSyntaxInQuantifiedPredicates

protected boolean supportsRowValueConstructorSyntaxInQuantifiedPredicates()

Description copied from class: AbstractSqlAstTranslator

Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax with quantified predicates.

Basically, does it support syntax like ... where (FIRST_NAME, LAST_NAME) = ALL (select ...) ...

Overrides:

supportsRowValueConstructorSyntaxInQuantifiedPredicates in class AbstractSqlAstTranslator<T extends JdbcOperation>

Returns:

True if this SQL dialect is known to support "row value constructor" syntax with quantified predicates; false otherwise.

supportsIntersect

protected boolean supportsIntersect()

Overrides:

supportsIntersect in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsDistinctFromPredicate

protected boolean supportsDistinctFromPredicate()

Description copied from class: AbstractSqlAstTranslator

Is this SQL dialect known to support some kind of distinct from predicate.

Basically, does it support syntax like ... where FIRST_NAME IS DISTINCT FROM LAST_NAME

Overrides:

supportsDistinctFromPredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

Returns:

True if this SQL dialect is known to support some kind of distinct from predicate; false otherwise

supportsSimpleQueryGrouping

protected boolean supportsSimpleQueryGrouping()

Overrides:

supportsSimpleQueryGrouping in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsNestedSubqueryCorrelation

protected boolean supportsNestedSubqueryCorrelation()

Overrides:

supportsNestedSubqueryCorrelation in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsWithClause

protected boolean supportsWithClause()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL with clause is supported.

Overrides:

supportsWithClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

getFromDual

protected String getFromDual()

Description copied from class: AbstractSqlAstTranslator

Some databases require a bit of syntactic noise when there are no tables in the from clause.

Overrides:

getFromDual in class AbstractSqlAstTranslator<T extends JdbcOperation>

Returns:

the SQL equivalent to Oracle's from dual.

getFromDualForSelectOnly

protected String getFromDualForSelectOnly()

Overrides:

getFromDualForSelectOnly in class AbstractSqlAstTranslator<T extends JdbcOperation>

getDialect

public MySQLDialect getDialect()

Overrides:

getDialect in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitCastTarget

public void visitCastTarget(CastTarget castTarget)

Specified by:

visitCastTarget in interface SqlAstWalker

Overrides:

visitCastTarget in class AbstractSqlAstTranslator<T extends JdbcOperation>