Package org.hibernate.dialect

Class HSQLSqlAstTranslator<T extends JdbcOperation>

java.lang.Object

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

org.hibernate.dialect.HSQLSqlAstTranslator<T>

All Implemented Interfaces:

Appendable, SqlAppender, SqlAstTranslator<T>, SqlAstWalker

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

A SQL AST translator for HSQL.

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
HSQLSqlAstTranslator(SessionFactoryImplementor sessionFactory, Statement statement)

Method Summary

Modifier and Type	Method	Description
protected boolean	areAllResultsPlainParametersOrLiterals(CaseSearchedExpression caseSearchedExpression)
protected boolean	areAllResultsPlainParametersOrLiterals(CaseSimpleExpression caseSimpleExpression)
protected String	getFromDual()	Some databases require a bit of syntactic noise when there are no tables in the from clause.
protected String	getFromDualForSelectOnly()
protected void	renderComparison(Expression lhs, ComparisonOperator operator, Expression rhs)
protected void	renderExpressionAsClauseItem(Expression expression)
protected void	renderPartitionItem(Expression expression)
protected void	renderSelectExpression(Expression expression)
protected void	renderSelectTupleComparison(List<SqlSelection> lhsExpressions, SqlTuple tuple, ComparisonOperator operator)
protected boolean	supportsArrayConstructor()	Whether the SQL array constructor is supported.
boolean	supportsFilterClause()	Whether the FILTER clause for aggregate functions is supported.
protected boolean	supportsRecursiveClauseArrayAndRowEmulation()	Whether the recursive search and cycle clause emulations based on the array and row constructor is supported.
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	supportsWithClauseInSubquery()	Whether the SQL with clause is supported within a subquery.
protected void	visitAnsiCaseSearchedExpression(CaseSearchedExpression expression, Consumer<Expression> resultRenderer)
protected void	visitAnsiCaseSimpleExpression(CaseSimpleExpression expression, Consumer<Expression> resultRenderer)
void	visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)
void	visitBooleanExpressionPredicate(BooleanExpressionPredicate booleanExpressionPredicate)
void	visitInArrayPredicate(InArrayPredicate inArrayPredicate)
void	visitOffsetFetchClause(QueryPart queryPart)
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.

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, getDialect, getDmlTargetTableAlias, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockTimeout, getFetchClauseTypeForRowNumbering, getForShare, 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, renderSelectExpressionWithCastedOrInlinedPlainParameters, renderSelectSimpleComparison, renderSetClause, renderSkipFirstClause, renderSkipFirstClause, rendersTableReferenceAlias, renderStandardCycleClause, renderStandardSearchClause, renderTableGroup, renderTableGroupJoin, renderTableReferenceIdentificationVariable, renderTableReferenceJoins, renderTopClause, renderTopClause, renderTopStartAtClause, renderTopStartAtClause, renderTupleComparisonStandard, renderVirtualSelections, resolveAliasedExpression, resolveAliasedExpression, resolveExpressionToAlias, setLimitParameter, setOffsetParameter, shouldEmulateLateralWithIntersect, shouldInlineCte, simpleColumnWriteFragmentRendering, supportsDistinctFromPredicate, supportsDuplicateSelectItemsInQueryGroup, supportsIntersect, supportsJoinInMutationStatementSubquery, supportsNestedSubqueryCorrelation, supportsNestedWithClause, supportsNullPrecedence, supportsQuantifiedPredicates, supportsRecursiveCycleClause, supportsRecursiveCycleUsingClause, supportsRecursiveSearchClause, supportsRowConstructor, supportsRowValueConstructorDistinctFromSyntax, supportsRowValueConstructorGtLtSyntax, supportsRowValueConstructorSyntaxInInSubQuery, supportsRowValueConstructorSyntaxInSet, supportsSimpleQueryGrouping, supportsWithClause, translate, translateDelete, translateInsert, translateSelect, translateUpdate, useOffsetFetchClause, visitAggregateColumnWriteExpression, visitAny, visitAssignment, visitBetweenPredicate, visitCaseSearchedExpression, visitCaseSearchedExpression, visitCaseSimpleExpression, visitCaseSimpleExpression, visitCastTarget, 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, visitInListPredicate, visitInsertStatement, visitInsertStatementOnly, visitInSubQueryPredicate, visitJdbcLiteral, visitJunction, visitLikePredicate, visitModifiedSubQueryExpression, visitNamedTableReference, visitNegatedPredicate, visitNullnessPredicate, visitOrderBy, visitOver, visitOverClause, visitOverClause, visitOverflow, visitParameter, visitParameterAsParameter, visitPartitionByClause, visitPartitionExpressions, visitPartitionExpressions, visitQueryGroup, visitQueryLiteral, visitQueryPartTableReference, visitQuerySpec, 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, visitValuesTableReference, visitWhereClause, withParameterRenderingMode, withRowNumbering

Methods inherited from class java.lang.Object

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

Constructor Detail

HSQLSqlAstTranslator

public HSQLSqlAstTranslator(SessionFactoryImplementor sessionFactory,
                            Statement statement)

Method Detail

renderExpressionAsClauseItem

protected void renderExpressionAsClauseItem(Expression expression)

Overrides:

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

visitInArrayPredicate

public void visitInArrayPredicate(InArrayPredicate inArrayPredicate)

Specified by:

visitInArrayPredicate in interface SqlAstWalker

Overrides:

visitInArrayPredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsArrayConstructor

protected boolean supportsArrayConstructor()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL array constructor is supported.

Overrides:

supportsArrayConstructor in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsWithClauseInSubquery

protected boolean supportsWithClauseInSubquery()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL with clause is supported within a subquery.

Overrides:

supportsWithClauseInSubquery in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsRecursiveClauseArrayAndRowEmulation

protected boolean supportsRecursiveClauseArrayAndRowEmulation()

Description copied from class: AbstractSqlAstTranslator

Whether the recursive search and cycle clause emulations based on the array and row constructor is supported.

Overrides:

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

visitAnsiCaseSearchedExpression

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

Overrides:

visitAnsiCaseSearchedExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

visitAnsiCaseSimpleExpression

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

Overrides:

visitAnsiCaseSimpleExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>

areAllResultsPlainParametersOrLiterals

protected boolean areAllResultsPlainParametersOrLiterals(CaseSearchedExpression caseSearchedExpression)

areAllResultsPlainParametersOrLiterals

protected boolean areAllResultsPlainParametersOrLiterals(CaseSimpleExpression caseSimpleExpression)

supportsFilterClause

public boolean supportsFilterClause()

Description copied from interface: SqlAstTranslator

Whether the FILTER clause for aggregate functions is supported.

Specified by:

supportsFilterClause in interface SqlAstTranslator<T extends JdbcOperation>

Overrides:

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

renderSelectExpression

protected void renderSelectExpression(Expression expression)

Overrides:

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

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>

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.

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>

visitBinaryArithmeticExpression

public void visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)

Specified by:

visitBinaryArithmeticExpression in interface SqlAstWalker

Overrides:

visitBinaryArithmeticExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>