Package org.hibernate.dialect.sql.ast

Class SQLServerSqlAstTranslator<T extends JdbcOperation>

java.lang.Object

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

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

org.hibernate.dialect.sql.ast.SQLServerSqlAstTranslator<T>

All Implemented Interfaces:

Appendable, SqlAppender, SqlAstTranslator<T>, SqlAstWalker

public class SQLServerSqlAstTranslator<T extends JdbcOperation>
extends SqlAstTranslatorWithMerge<T>

A SQL AST translator for SQL Server.

Nested Class Summary

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

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

Field Summary

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

CLOSE_PARENTHESIS, COMMA_SEPARATOR, COMMA_SEPARATOR_CHAR, NO_SEPARATOR, NULL_KEYWORD, OPEN_PARENTHESIS, PARAM_MARKER, WHITESPACE

Constructor Summary

Constructors

Constructor	Description
SQLServerSqlAstTranslator(SessionFactoryImplementor sessionFactory, Statement statement)

Method Summary

Modifier and Type	Method	Description
static String	determineLockHint(LockMode lockMode, int effectiveLockTimeout)
protected AbstractSqlAstTranslator.LockStrategy	determineLockingStrategy(QuerySpec querySpec, Locking.FollowOn followOnLocking)
protected org.hibernate.dialect.sql.ast.SQLServerSqlAstTranslator.OffsetFetchClauseMode	getOffsetFetchClauseMode(QueryPart queryPart)
protected boolean	needsRecursiveKeywordInWithClause()	Whether the SQL with clause requires the "recursive" keyword for recursive CTEs.
protected void	renderComparison(Expression lhs, ComparisonOperator operator, Expression rhs)
protected void	renderDeleteClause(DeleteStatement statement)
protected void	renderDerivedTableReference(DerivedTableReference tableReference)
protected void	renderDmlTargetTableExpression(NamedTableReference tableReference)
protected void	renderEmptyOrderBy()
protected void	renderFromClauseAfterUpdateSet(UpdateStatement statement)
protected void	renderMergeStatement(OptionalTableUpdate optionalTableUpdate)	Renders the OptionalTableUpdate as a MERGE query.
void	renderNamedSetReturningFunction(String functionName, List<? extends SqlAstNode> sqlAstArguments, AnonymousTupleTableGroupProducer tupleType, String tableIdentifierVariable, SqlAstNodeRenderingMode argumentRenderingMode)	Renders a named set returning function.
protected boolean	renderNamedTableReference(NamedTableReference tableReference, LockMode lockMode)
protected void	renderOrderBy(boolean addWhitespace, List<SortSpecification> sortSpecifications)
protected void	renderPartitionItem(Expression expression)
protected void	renderSelectTupleComparison(List<SqlSelection> lhsExpressions, SqlTuple tuple, ComparisonOperator operator)
protected void	renderStringContainsExactlyPredicate(Expression haystack, Expression needle)
protected void	renderTableGroupJoin(TableGroupJoin tableGroupJoin, List<TableGroupJoin> tableGroupJoinCollector)
protected void	renderUpdateClause(UpdateStatement updateStatement)
protected boolean	shouldEmulateFetchClause(QueryPart queryPart)
void	visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)
protected void	visitConflictClause(ConflictClause conflictClause)
protected void	visitInsertStatementOnly(InsertSelectStatement statement)
void	visitOffsetFetchClause(QueryPart queryPart)
void	visitQueryGroup(QueryGroup queryGroup)
void	visitQuerySpec(QuerySpec querySpec)
void	visitSelectClause(SelectClause selectClause)
protected void	visitSqlSelections(SelectClause selectClause)

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

createMergeOperation, renderMergeDelete, renderMergeInsert, renderMergeInto, renderMergeOn, renderMergeSourceAlias, renderMergeTargetAlias, renderMergeUpdate, renderMergeUsing, renderMergeUsingQuerySelection

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

addAdditionalWherePredicate, addAffectedTableName, addAppliedParameterBinding, addParameterBinder, addParameterBinder, afterQueryGroup, append, append, append, appendAssignmentColumn, appendBackslashEscapedLikeLiteral, appendDoubleQuoteEscapedString, appendSingleQuoteEscapedString, appendSql, appendSql, appendSql, appendSql, appendSql, areAllResultsParameters, areAllResultsParameters, assertRowsOnlyFetchClauseType, beforeQueryGroup, castFunction, castNumberToString, cleanup, createRowMatchingPredicate, determineColumnReferenceQualifier, determineCyclePathColumnName, determineLateralEmulationPredicate, determineWhereClauseRestrictionWithJoinEmulation, determineWhereClauseRestrictionWithJoinEmulation, emulateCycleClauseWithRowAndArray, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctionsVisitQueryPart, emulateQuantifiedTupleSubQueryPredicate, emulateQueryPartTableReferenceColumnAliasing, emulateSearchClauseOrderWithRowAndArray, emulateSelectTupleComparison, emulateSortSpecificationNullPrecedence, emulateSubQueryRelationalRestrictionPredicate, emulateTupleComparison, emulateValuesTableReferenceColumnAliasing, getAffectedTableNames, getAppliedParameterBindings, getArrayContainsFunction, getBooleanType, getCastTypeName, getClauseStack, getCteStatement, getCurrentClauseStack, getCurrentCteStatement, getCurrentDmlStatement, getCurrentQueryPart, getDialect, getDual, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockTimeout, getFetchClauseTypeForRowNumbering, getFromDualForSelectOnly, getIntegerType, getJdbcLockStrategy, getJdbcParameterBindings, getJdbcServices, getLeftHandExpression, getLimit, getLimitParameter, getLiteralValue, getLockingClauseStrategy, getLockOptions, getMaxRows, getOffsetParameter, getParameterBinders, getParameterBindValue, getParameterRenderingMode, getQueryPartForRowNumbering, getQueryPartStack, getRowsToSkip, getSelectItemReference, getSessionFactory, getSortSpecificationsRowNumbering, getSql, getSqlAppender, getSqlAst, getSqlBuffer, getSqlTypeName, getStatement, getStatementStack, getStringType, getUniqueConstraintNameThatMayFail, getWrapperOptions, hasAggregateFunctions, hasFrom, hasLimit, hasLimit, hasNestedTableGroupsToRender, hasNonTrivialFromClause, hasOffset, hasWhere, inlineCteTableGroup, inOverOrWithinGroupClause, interpretExpression, isCorrelated, isInRecursiveQueryPart, isInSubquery, isIntegerDivisionEmulationRequired, isLiteral, isParameter, isRowNumberingCurrentQueryPart, isRowsOnlyFetchClauseType, isStruct, needsCteInlining, needsLocking, needsMaxRows, needsParenthesesAroundQueryGroup, needsRowsToSkip, prepareLimitOffsetParameters, prependSql, processNestedTableGroupJoins, processTableGroupJoin, processTableGroupJoins, registerAffectedTable, registerAffectedTable, render, renderAsLiteral, renderBackslashEscapedLikePattern, renderCaseInsensitiveLikeEmulation, renderCasted, renderCombinedLimitClause, renderCombinedLimitClause, renderCommaSeparated, renderCommaSeparatedSelectExpression, renderCommaSeparatedSelectExpression, renderComparisonDistinctOperator, renderComparisonEmulateCase, renderComparisonEmulateDecode, renderComparisonEmulateDecode, renderComparisonEmulateIntersect, renderComparisonStandard, renderCteColumns, renderCycleClause, renderDerivedTableReferenceIdentificationVariable, renderDmlTargetTableGroup, renderExpressionAsClauseItem, renderExpressionAsLiteral, renderExpressionsAsSubquery, renderFetch, renderFetchExpression, renderFetchPlusOffsetExpression, renderFetchPlusOffsetExpressionAsLiteral, renderFetchPlusOffsetExpressionAsSingleParameter, renderFirstClause, renderFirstClause, renderFirstSkipClause, renderFirstSkipClause, renderFromClauseExcludingDmlTargetReference, renderFromClauseJoiningDmlTargetReference, renderFromClauseSpaces, renderInsertIntoNoColumns, renderInterval, renderIntervalLiteral, renderIntoIntoAndTable, renderJoinedTableGroup, renderLikePredicate, renderLimitOffsetClause, renderLimitOffsetClause, renderLiteral, renderMaterializationHint, renderMergeUpdateClause, renderNull, renderOffset, renderOffsetExpression, renderOffsetFetchClause, renderOffsetFetchClause, renderParameterAsParameter, renderPrimaryTableReference, renderQueryGroup, renderRecursiveCteVirtualSelections, renderRootTableGroup, renderRowNumber, renderRowNumberingSelectItems, renderRowsToClause, renderRowsToClause, renderSearchClause, renderSelectExpression, renderSelectExpressionWithCastedOrInlinedPlainParameters, renderSelectSimpleComparison, renderSetClause, renderSimpleNamedFunction, renderSkipFirstClause, renderSkipFirstClause, renderSortExpression, renderStandardCycleClause, renderStandardSearchClause, renderTableReferenceIdentificationVariable, renderTableReferenceJoins, renderTableReferenceJoins, renderTopClause, renderTopClause, renderTopStartAtClause, renderTopStartAtClause, renderTupleComparisonStandard, renderVirtualSelections, renderWrappedParameter, resolveAliasedExpression, resolveAliasedExpression, resolveExpressionToAlias, setLimitParameter, setLockingTarget, setOffsetParameter, shouldEmulateLateralWithIntersect, shouldInlineCte, simpleColumnWriteFragmentRendering, supportsRecursiveClauseArrayAndRowEmulation, translate, translateDelete, translateInsert, translateSelect, translateUpdate, useOffsetFetchClause, visitAggregateColumnWriteExpression, visitAnsiCaseSearchedExpression, visitAnsiCaseSimpleExpression, visitAny, visitArithmeticOperand, visitAssignment, visitBetweenPredicate, visitBooleanExpressionPredicate, visitCaseSearchedExpression, visitCaseSearchedExpression, visitCaseSimpleExpression, visitCaseSimpleExpression, visitCastTarget, visitCollation, visitColumnReference, visitColumnWriteFragment, visitConversion, visitCteContainer, visitCteDefinition, visitCteObject, visitCustomTableDelete, visitCustomTableInsert, visitCustomTableUpdate, visitDecodeCaseSearchedExpression, visitDeleteStatement, visitDeleteStatementOnly, visitDistinct, visitDuration, visitDurationUnit, visitEmbeddableTypeLiteral, visitEntityTypeLiteral, visitEvery, visitExistsPredicate, visitExtractUnit, visitFilterFragmentPredicate, visitFilterPredicate, visitFormat, visitForUpdateClause, visitFromClause, visitFunctionTableReference, visitGroupByClause, visitGroupedPredicate, visitHavingClause, visitInArrayPredicate, visitInListPredicate, visitInsertSource, visitInsertStatement, visitInsertStatementEmulateMerge, visitInSubQueryPredicate, visitJdbcLiteral, visitJunction, visitLikePredicate, visitModifiedSubQueryExpression, visitNamedTableReference, visitNegatedPredicate, visitNestedColumnReference, visitNullnessPredicate, visitOnDuplicateKeyConflictClause, visitOnDuplicateKeyConflictClauseWithDoNothing, visitOptionalTableUpdate, visitOrderBy, visitOver, visitOverClause, visitOverClause, visitOverflow, visitParameter, visitParameterAsParameter, visitPartitionByClause, visitPartitionExpressions, visitPartitionExpressions, visitQueryClauses, visitQueryLiteral, visitQueryPartTableReference, visitRecursivePath, visitRelationalPredicate, visitReturningColumns, visitReturningColumns, visitSelectStatement, visitSelfRenderingExpression, visitSelfRenderingPredicate, visitSetAssignment, visitSetAssignmentEmulateJoin, visitSortSpecification, visitSortSpecification, visitSqlFragmentPredicate, visitSqlSelectExpression, visitSqlSelection, visitSqlSelectionExpression, visitStandardConflictClause, visitStandardTableDelete, visitStandardTableInsert, visitStandardTableUpdate, visitStar, visitSummarization, visitTableGroup, visitTableGroupJoin, visitTableReferenceJoin, visitThruthnessPredicate, visitTrimSpecification, visitTuple, visitUnaryOperationExpression, visitUnparsedNumericLiteral, visitUpdateStatement, visitUpdateStatementEmulateInlineView, visitUpdateStatementEmulateMerge, visitUpdateStatementEmulateTupleSet, visitUpdateStatementOnly, visitValuesList, visitValuesListEmulateSelectUnion, visitValuesListStandard, visitValuesTableReference, visitWhereClause, withParameterRenderingMode, withRowNumbering

Methods inherited from class java.lang.Object

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

Constructor Details

SQLServerSqlAstTranslator

public SQLServerSqlAstTranslator(SessionFactoryImplementor sessionFactory,
 Statement statement)

Method Details

visitInsertStatementOnly

protected void visitInsertStatementOnly(InsertSelectStatement statement)

Overrides:

visitInsertStatementOnly in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderDeleteClause

protected void renderDeleteClause(DeleteStatement statement)

Overrides:

renderDeleteClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderUpdateClause

protected void renderUpdateClause(UpdateStatement updateStatement)

Overrides:

renderUpdateClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderDmlTargetTableExpression

protected void renderDmlTargetTableExpression(NamedTableReference tableReference)

Overrides:

renderDmlTargetTableExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderFromClauseAfterUpdateSet

protected void renderFromClauseAfterUpdateSet(UpdateStatement statement)

Overrides:

renderFromClauseAfterUpdateSet in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitConflictClause

protected void visitConflictClause(ConflictClause conflictClause)

Overrides:

visitConflictClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

needsRecursiveKeywordInWithClause

protected boolean needsRecursiveKeywordInWithClause()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL with clause requires the "recursive" keyword for recursive CTEs.

Overrides:

needsRecursiveKeywordInWithClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderTableGroupJoin

protected void renderTableGroupJoin(TableGroupJoin tableGroupJoin,
 List<TableGroupJoin> tableGroupJoinCollector)

Overrides:

renderTableGroupJoin in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderDerivedTableReference

protected void renderDerivedTableReference(DerivedTableReference tableReference)

Overrides:

renderDerivedTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderNamedSetReturningFunction

public void renderNamedSetReturningFunction(String functionName,
 List<? extends SqlAstNode> sqlAstArguments,
 AnonymousTupleTableGroupProducer tupleType,
 String tableIdentifierVariable,
 SqlAstNodeRenderingMode argumentRenderingMode)

Description copied from interface: SqlAstTranslator

Renders a named set returning function.

Specified by:

renderNamedSetReturningFunction in interface SqlAstTranslator<T extends JdbcOperation>

Overrides:

renderNamedSetReturningFunction in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderNamedTableReference

protected boolean renderNamedTableReference(NamedTableReference tableReference,
 LockMode lockMode)

Overrides:

renderNamedTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

determineLockHint

@Internal
public static String determineLockHint(LockMode lockMode,
 int effectiveLockTimeout)

determineLockingStrategy

protected AbstractSqlAstTranslator.LockStrategy determineLockingStrategy(QuerySpec querySpec,
 Locking.FollowOn followOnLocking)

Overrides:

determineLockingStrategy in class AbstractSqlAstTranslator<T extends JdbcOperation>

getOffsetFetchClauseMode

protected org.hibernate.dialect.sql.ast.SQLServerSqlAstTranslator.OffsetFetchClauseMode getOffsetFetchClauseMode(QueryPart queryPart)

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>

visitSelectClause

public void visitSelectClause(SelectClause selectClause)

Specified by:

visitSelectClause in interface SqlAstWalker

Overrides:

visitSelectClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitSqlSelections

protected void visitSqlSelections(SelectClause selectClause)

Overrides:

visitSqlSelections in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderOrderBy

protected void renderOrderBy(boolean addWhitespace,
 List<SortSpecification> sortSpecifications)

Overrides:

renderOrderBy in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderEmptyOrderBy

protected void renderEmptyOrderBy()

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>

renderSelectTupleComparison

protected void renderSelectTupleComparison(List<SqlSelection> lhsExpressions,
 SqlTuple tuple,
 ComparisonOperator operator)

Overrides:

renderSelectTupleComparison in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderPartitionItem

protected void renderPartitionItem(Expression expression)

Overrides:

renderPartitionItem in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitBinaryArithmeticExpression

public void visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)

Specified by:

visitBinaryArithmeticExpression in interface SqlAstWalker

Overrides:

visitBinaryArithmeticExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderMergeStatement

protected void renderMergeStatement(OptionalTableUpdate optionalTableUpdate)

Description copied from class: SqlAstTranslatorWithMerge

Renders the OptionalTableUpdate as a MERGE query.

Overrides:

renderMergeStatement in class SqlAstTranslatorWithMerge<T extends JdbcOperation>

renderStringContainsExactlyPredicate

protected void renderStringContainsExactlyPredicate(Expression haystack,
 Expression needle)

Overrides:

renderStringContainsExactlyPredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>