Package org.hibernate.dialect

Class SybaseASESqlAstTranslator<T extends JdbcOperation>

java.lang.Object

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

org.hibernate.dialect.SybaseASESqlAstTranslator<T>

All Implemented Interfaces:

Appendable, SqlAppender, SqlAstTranslator<T>, SqlAstWalker

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

A SQL AST translator for Sybase ASE.

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, COMMA_SEPARATOR, COMMA_SEPARATOR_CHAR, NO_SEPARATOR, NULL_KEYWORD, OPEN_PARENTHESIS, PARAM_MARKER, WHITESPACE

Constructor Summary

Constructors

Constructor	Description
SybaseASESqlAstTranslator(SessionFactoryImplementor sessionFactory, Statement statement)

Method Summary

Modifier and Type	Method	Description
protected String	determineColumnReferenceQualifier(ColumnReference columnReference)
protected AbstractSqlAstTranslator.LockStrategy	determineLockingStrategy(QuerySpec querySpec, AbstractSqlAstTranslator.ForUpdateClause forUpdateClause, Boolean followOnLocking)
protected String	getDual()	Returns a table expression that has one row.
protected boolean	needsRowsToSkip()
protected void	renderComparison(Expression lhs, ComparisonOperator operator, Expression rhs)
protected void	renderDeleteClause(DeleteStatement statement)
protected void	renderFetchExpression(Expression fetchExpression)
protected void	renderFetchPlusOffsetExpression(Expression fetchClauseExpression, Expression offsetClauseExpression, int offset)
protected void	renderForUpdateClause(QuerySpec querySpec, AbstractSqlAstTranslator.ForUpdateClause forUpdateClause)
protected void	renderFromClauseAfterUpdateSet(UpdateStatement statement)
protected boolean	renderNamedTableReference(NamedTableReference tableReference, LockMode lockMode)
protected void	renderOffsetExpression(Expression offsetExpression)
protected void	renderPartitionItem(Expression expression)
protected void	renderSelectTupleComparison(List<SqlSelection> lhsExpressions, SqlTuple tuple, ComparisonOperator operator)
protected void	renderTableGroupJoin(TableGroupJoin tableGroupJoin, List<TableGroupJoin> tableGroupJoinCollector)
protected boolean	supportsIntersect()
protected boolean	supportsJoinsInDelete()
protected boolean	supportsRowValueConstructorSyntax()	Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax.
protected 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.
protected boolean	supportsWithClause()	Whether the SQL with clause is supported.
protected void	visitAnsiCaseSearchedExpression(CaseSearchedExpression caseSearchedExpression, Consumer<Expression> resultRenderer)
protected void	visitAnsiCaseSimpleExpression(CaseSimpleExpression caseSimpleExpression, Consumer<Expression> resultRenderer)
void	visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)
protected void	visitConflictClause(ConflictClause conflictClause)
protected void	visitInsertStatementOnly(InsertSelectStatement statement)
void	visitOffsetFetchClause(QueryPart queryPart)
void	visitQueryGroup(QueryGroup queryGroup)
protected void	visitSqlSelections(SelectClause selectClause)
protected void	visitValuesList(List<Values> valuesList)
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, createRowMatchingPredicate, determineCyclePathColumnName, determineLateralEmulationPredicate, determineWhereClauseRestrictionWithJoinEmulation, determineWhereClauseRestrictionWithJoinEmulation, emulateCycleClauseWithRowAndArray, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctionsVisitQueryPart, emulateQuantifiedTupleSubQueryPredicate, emulateQueryPartTableReferenceColumnAliasing, emulateSearchClauseOrderWithRowAndArray, emulateSelectTupleComparison, emulateSortSpecificationNullPrecedence, emulateSubQueryRelationalRestrictionPredicate, emulateTupleComparison, emulateValuesTableReferenceColumnAliasing, getAffectedTableNames, getAppliedParameterBindings, getArrayContainsFunction, getBooleanType, getCastTypeName, getCastTypeName, getClauseStack, getCteStatement, getCurrentClauseStack, getCurrentCteStatement, getCurrentDmlStatement, getCurrentQueryPart, getDialect, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockTimeout, getFetchClauseTypeForRowNumbering, getForShare, getForUpdate, getForUpdateWithClause, getFromDual, getFromDualForSelectOnly, 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, getSqlTypeName, getStatement, getStatementStack, getStringType, getUniqueConstraintNameThatMayFail, getWrapperOptions, hasAggregateFunctions, hasLimit, hasLimit, hasNestedTableGroupsToRender, hasNonTrivialFromClause, hasOffset, inlineCteTableGroup, inOverOrWithinGroupClause, interpretExpression, isCorrelated, isInRecursiveQueryPart, isInSubquery, isIntegerDivisionEmulationRequired, isLiteral, isParameter, isRowNumberingCurrentQueryPart, isRowsOnlyFetchClauseType, isStruct, needsCteInlining, needsLocking, needsMaxRows, needsRecursiveKeywordInWithClause, prepareLimitOffsetParameters, processNestedTableGroupJoins, processTableGroupJoin, processTableGroupJoins, registerAffectedTable, registerAffectedTable, render, renderAsLiteral, renderBackslashEscapedLikePattern, renderCaseInsensitiveLikeEmulation, renderCasted, renderCombinedLimitClause, renderCombinedLimitClause, renderCommaSeparated, renderCommaSeparatedSelectExpression, renderCommaSeparatedSelectExpression, renderComparisonDistinctOperator, renderComparisonEmulateCase, renderComparisonEmulateDecode, renderComparisonEmulateDecode, renderComparisonEmulateIntersect, renderComparisonStandard, renderCteColumns, renderCycleClause, renderDerivedTableReference, renderDmlTargetTableExpression, renderDmlTargetTableGroup, renderExpressionAsClauseItem, renderExpressionAsLiteral, renderExpressionsAsSubquery, renderFetch, renderFetchPlusOffsetExpressionAsLiteral, renderFetchPlusOffsetExpressionAsSingleParameter, renderFirstClause, renderFirstClause, renderFirstSkipClause, renderFirstSkipClause, renderFromClauseExcludingDmlTargetReference, renderFromClauseJoiningDmlTargetReference, renderFromClauseSpaces, renderInsertIntoNoColumns, renderIntoIntoAndTable, renderLimitOffsetClause, renderLimitOffsetClause, renderLiteral, renderMaterializationHint, renderMergeUpdateClause, renderNull, renderOffset, renderOffsetFetchClause, renderOffsetFetchClause, renderOrderBy, renderParameterAsParameter, renderParameterAsParameter, renderPrimaryTableReference, renderQueryGroup, renderRecursiveCteVirtualSelections, renderRootTableGroup, renderRowNumber, renderRowNumberingSelectItems, renderRowsToClause, renderRowsToClause, renderSearchClause, renderSelectExpression, renderSelectExpressionWithCastedOrInlinedPlainParameters, renderSelectSimpleComparison, renderSetClause, renderSkipFirstClause, renderSkipFirstClause, renderStandardCycleClause, renderStandardSearchClause, renderStringContainsExactlyPredicate, renderTableGroup, renderTableReferenceIdentificationVariable, renderTableReferenceJoins, renderTopClause, renderTopClause, renderTopStartAtClause, renderTopStartAtClause, renderTupleComparisonStandard, renderUpdateClause, renderVirtualSelections, resolveAliasedExpression, resolveAliasedExpression, resolveExpressionToAlias, setLimitParameter, setOffsetParameter, shouldEmulateLateralWithIntersect, shouldInlineCte, simpleColumnWriteFragmentRendering, supportsArrayConstructor, supportsDistinctFromPredicate, supportsDuplicateSelectItemsInQueryGroup, supportsFilterClause, supportsJoinInMutationStatementSubquery, supportsNestedSubqueryCorrelation, supportsNestedWithClause, supportsNullPrecedence, supportsQuantifiedPredicates, supportsRecursiveClauseArrayAndRowEmulation, supportsRecursiveCycleClause, supportsRecursiveCycleUsingClause, supportsRecursiveSearchClause, supportsRowConstructor, supportsRowValueConstructorDistinctFromSyntax, supportsRowValueConstructorGtLtSyntax, supportsRowValueConstructorSyntaxInInSubQuery, supportsRowValueConstructorSyntaxInSet, supportsSimpleQueryGrouping, supportsWithClauseInSubquery, translate, translateDelete, translateInsert, translateSelect, translateUpdate, useOffsetFetchClause, visitAggregateColumnWriteExpression, 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, 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, visitNullnessPredicate, visitOnDuplicateKeyConflictClause, visitOptionalTableUpdate, visitOrderBy, visitOver, visitOverClause, visitOverClause, visitOverflow, visitParameter, visitParameterAsParameter, visitPartitionByClause, visitPartitionExpressions, visitPartitionExpressions, visitQueryLiteral, visitQueryPartTableReference, visitQuerySpec, visitRecursivePath, visitRelationalPredicate, visitReturningColumns, visitReturningColumns, visitSelectClause, 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, visitValuesListEmulateSelectUnion, visitValuesListStandard, visitWhereClause, withParameterRenderingMode, withRowNumbering

Methods inherited from class java.lang.Object

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

Constructor Detail

SybaseASESqlAstTranslator

public SybaseASESqlAstTranslator(SessionFactoryImplementor sessionFactory,
                                 Statement statement)

Method Detail

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>

supportsJoinsInDelete

protected boolean supportsJoinsInDelete()

Overrides:

supportsJoinsInDelete 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>

supportsWithClause

protected boolean supportsWithClause()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL with clause is supported.

Overrides:

supportsWithClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitAnsiCaseSearchedExpression

protected void visitAnsiCaseSearchedExpression(CaseSearchedExpression caseSearchedExpression,
                                               Consumer<Expression> resultRenderer)

Overrides:

visitAnsiCaseSearchedExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitAnsiCaseSimpleExpression

protected void visitAnsiCaseSimpleExpression(CaseSimpleExpression caseSimpleExpression,
                                             Consumer<Expression> resultRenderer)

Overrides:

visitAnsiCaseSimpleExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderNamedTableReference

protected boolean renderNamedTableReference(NamedTableReference tableReference,
                                            LockMode lockMode)

Overrides:

renderNamedTableReference in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderTableGroupJoin

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

Overrides:

renderTableGroupJoin in class AbstractSqlAstTranslator<T extends JdbcOperation>

determineLockingStrategy

protected AbstractSqlAstTranslator.LockStrategy determineLockingStrategy(QuerySpec querySpec,
                                                                         AbstractSqlAstTranslator.ForUpdateClause forUpdateClause,
                                                                         Boolean followOnLocking)

Overrides:

determineLockingStrategy in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderForUpdateClause

protected void renderForUpdateClause(QuerySpec querySpec,
                                     AbstractSqlAstTranslator.ForUpdateClause forUpdateClause)

Overrides:

renderForUpdateClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitSqlSelections

protected void visitSqlSelections(SelectClause selectClause)

Overrides:

visitSqlSelections in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderFetchPlusOffsetExpression

protected void renderFetchPlusOffsetExpression(Expression fetchClauseExpression,
                                               Expression offsetClauseExpression,
                                               int offset)

Overrides:

renderFetchPlusOffsetExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitQueryGroup

public void visitQueryGroup(QueryGroup queryGroup)

Specified by:

visitQueryGroup in interface SqlAstWalker

Overrides:

visitQueryGroup in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitValuesList

protected void visitValuesList(List<Values> valuesList)

Overrides:

visitValuesList 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>

visitOffsetFetchClause

public void visitOffsetFetchClause(QueryPart queryPart)

Specified by:

visitOffsetFetchClause in interface SqlAstWalker

Overrides:

visitOffsetFetchClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderFetchExpression

protected void renderFetchExpression(Expression fetchExpression)

Overrides:

renderFetchExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderOffsetExpression

protected void renderOffsetExpression(Expression offsetExpression)

Overrides:

renderOffsetExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderComparison

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

Overrides:

renderComparison in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsIntersect

protected boolean supportsIntersect()

Overrides:

supportsIntersect 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>

determineColumnReferenceQualifier

protected String determineColumnReferenceQualifier(ColumnReference columnReference)

Overrides:

determineColumnReferenceQualifier in class AbstractSqlAstTranslator<T extends JdbcOperation>

needsRowsToSkip

protected boolean needsRowsToSkip()

Overrides:

needsRowsToSkip in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsRowValueConstructorSyntax

protected boolean supportsRowValueConstructorSyntax()

Description copied from class: AbstractSqlAstTranslator

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

Returns:

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

supportsRowValueConstructorSyntaxInInList

protected 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.

getDual

protected String getDual()

Description copied from class: AbstractSqlAstTranslator

Returns a table expression that has one row.

Overrides:

getDual in class AbstractSqlAstTranslator<T extends JdbcOperation>

Returns:

the SQL equivalent to Oracle's dual.