Package org.hibernate.dialect

Class PostgreSQLSqlAstTranslator<T extends JdbcOperation>

java.lang.Object

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

org.hibernate.dialect.SqlAstTranslatorWithMerge<T>

org.hibernate.dialect.PostgreSQLSqlAstTranslator<T>

All Implemented Interfaces:

Appendable, SqlAppender, SqlAstTranslator<T>, SqlAstWalker

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

A SQL AST translator for PostgreSQL.

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

Method Summary

Modifier and Type	Method	Description
protected String	getArrayContainsFunction()	Returns the name of the array_contains(array, element) function, which is used for emulating the cycle clause.
protected String	getForShare(int timeoutMillis)
protected String	getForUpdate()
protected void	renderComparison(Expression lhs, ComparisonOperator operator, Expression rhs)
protected void	renderDmlTargetTableExpression(NamedTableReference tableReference)
protected void	renderExpressionAsClauseItem(Expression expression)
protected void	renderFromClauseAfterUpdateSet(UpdateStatement statement)
protected void	renderInsertIntoNoColumns(TableInsertStandard tableInsert)	Handle rendering an insert with no columns
protected void	renderMaterializationHint(CteMaterialization materialization)
protected void	renderPartitionItem(Expression expression)
protected void	renderStandardCycleClause(CteStatement cte)
protected void	renderTableReferenceIdentificationVariable(TableReference tableReference)
protected boolean	shouldEmulateFetchClause(QueryPart queryPart)
protected boolean	supportsArrayConstructor()	Whether the SQL array constructor is supported.
boolean	supportsFilterClause()	Whether the FILTER clause for aggregate functions is supported.
protected boolean	supportsRecursiveCycleClause()	Whether the SQL cycle clause is supported, which can be used for recursive CTEs.
protected boolean	supportsRecursiveCycleUsingClause()	Whether the SQL cycle clause supports the using sub-clause.
protected boolean	supportsRecursiveSearchClause()	Whether the SQL search clause is supported, which can be used for recursive CTEs.
protected boolean	supportsRowConstructor()	Whether the SQL row constructor is supported.
protected JdbcOperationQueryInsert	translateInsert(InsertSelectStatement sqlAst)
void	visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)
void	visitBooleanExpressionPredicate(BooleanExpressionPredicate booleanExpressionPredicate)
protected void	visitConflictClause(ConflictClause conflictClause)
void	visitInArrayPredicate(InArrayPredicate inArrayPredicate)
void	visitLikePredicate(LikePredicate likePredicate)
void	visitNullnessPredicate(NullnessPredicate nullnessPredicate)
void	visitOffsetFetchClause(QueryPart queryPart)
void	visitQueryGroup(QueryGroup queryGroup)
void	visitQuerySpec(QuerySpec querySpec)

Methods inherited from class org.hibernate.dialect.SqlAstTranslatorWithMerge

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

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, determineColumnReferenceQualifier, determineCyclePathColumnName, determineLateralEmulationPredicate, determineLockingStrategy, determineWhereClauseRestrictionWithJoinEmulation, determineWhereClauseRestrictionWithJoinEmulation, emulateCycleClauseWithRowAndArray, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctions, emulateFetchOffsetWithWindowFunctionsVisitQueryPart, emulateQuantifiedTupleSubQueryPredicate, emulateQueryPartTableReferenceColumnAliasing, emulateSearchClauseOrderWithRowAndArray, emulateSelectTupleComparison, emulateSortSpecificationNullPrecedence, emulateSubQueryRelationalRestrictionPredicate, emulateTupleComparison, emulateValuesTableReferenceColumnAliasing, getAffectedTableNames, getAppliedParameterBindings, getBooleanType, getCastTypeName, getCastTypeName, getClauseStack, getCteStatement, getCurrentClauseStack, getCurrentCteStatement, getCurrentDmlStatement, getCurrentQueryPart, getDialect, getDual, getEffectiveLockMode, getEffectiveLockMode, getEffectiveLockTimeout, getFetchClauseTypeForRowNumbering, 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, needsRowsToSkip, prepareLimitOffsetParameters, processNestedTableGroupJoins, processTableGroupJoin, processTableGroupJoins, registerAffectedTable, registerAffectedTable, render, renderAsLiteral, renderBackslashEscapedLikePattern, renderCaseInsensitiveLikeEmulation, renderCasted, renderCombinedLimitClause, renderCombinedLimitClause, renderCommaSeparated, renderCommaSeparatedSelectExpression, renderCommaSeparatedSelectExpression, renderComparisonDistinctOperator, renderComparisonEmulateCase, renderComparisonEmulateDecode, renderComparisonEmulateDecode, renderComparisonEmulateIntersect, renderComparisonStandard, renderCteColumns, renderCycleClause, renderDeleteClause, renderDerivedTableReference, renderDmlTargetTableGroup, renderExpressionAsLiteral, renderExpressionsAsSubquery, renderFetch, renderFetchExpression, renderFetchPlusOffsetExpression, renderFetchPlusOffsetExpressionAsLiteral, renderFetchPlusOffsetExpressionAsSingleParameter, renderFirstClause, renderFirstClause, renderFirstSkipClause, renderFirstSkipClause, renderForUpdateClause, renderFromClauseExcludingDmlTargetReference, renderFromClauseJoiningDmlTargetReference, renderFromClauseSpaces, renderIntoIntoAndTable, renderLimitOffsetClause, renderLimitOffsetClause, renderLiteral, renderMergeUpdateClause, renderNamedTableReference, renderNull, renderOffset, renderOffsetExpression, renderOffsetFetchClause, renderOffsetFetchClause, renderOrderBy, renderParameterAsParameter, renderParameterAsParameter, renderPrimaryTableReference, renderQueryGroup, renderRecursiveCteVirtualSelections, renderRootTableGroup, renderRowNumber, renderRowNumberingSelectItems, renderRowsToClause, renderRowsToClause, renderSearchClause, renderSelectExpression, renderSelectExpressionWithCastedOrInlinedPlainParameters, renderSelectSimpleComparison, renderSelectTupleComparison, renderSetClause, renderSkipFirstClause, renderSkipFirstClause, renderSortExpression, renderStandardSearchClause, renderStringContainsExactlyPredicate, renderTableGroup, renderTableGroupJoin, renderTableReferenceJoins, renderTableReferenceJoins, renderTopClause, renderTopClause, renderTopStartAtClause, renderTopStartAtClause, renderTupleComparisonStandard, renderUpdateClause, renderVirtualSelections, renderWrappedParameter, resolveAliasedExpression, resolveAliasedExpression, resolveExpressionToAlias, setLimitParameter, setOffsetParameter, shouldEmulateLateralWithIntersect, shouldInlineCte, simpleColumnWriteFragmentRendering, supportsDistinctFromPredicate, supportsDuplicateSelectItemsInQueryGroup, supportsIntersect, supportsJoinInMutationStatementSubquery, supportsJoinsInDelete, supportsNestedSubqueryCorrelation, supportsNestedWithClause, supportsNullPrecedence, supportsQuantifiedPredicates, supportsRecursiveClauseArrayAndRowEmulation, supportsRowValueConstructorDistinctFromSyntax, supportsRowValueConstructorGtLtSyntax, supportsRowValueConstructorSyntax, supportsRowValueConstructorSyntaxInInList, supportsRowValueConstructorSyntaxInInSubQuery, supportsRowValueConstructorSyntaxInQuantifiedPredicates, supportsRowValueConstructorSyntaxInSet, supportsSimpleQueryGrouping, supportsWithClause, supportsWithClauseInSubquery, translate, translateDelete, translateSelect, translateUpdate, useOffsetFetchClause, visitAggregateColumnWriteExpression, visitAnsiCaseSearchedExpression, visitAnsiCaseSimpleExpression, visitAny, visitArithmeticOperand, visitAssignment, visitBetweenPredicate, 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, visitInListPredicate, visitInsertSource, visitInsertStatement, visitInsertStatementEmulateMerge, visitInsertStatementOnly, visitInSubQueryPredicate, visitJdbcLiteral, visitJunction, visitModifiedSubQueryExpression, visitNamedTableReference, visitNegatedPredicate, visitNestedColumnReference, visitOnDuplicateKeyConflictClause, visitOptionalTableUpdate, visitOrderBy, visitOver, visitOverClause, visitOverClause, visitOverflow, visitParameter, visitParameterAsParameter, visitPartitionByClause, visitPartitionExpressions, visitPartitionExpressions, visitQueryLiteral, visitQueryPartTableReference, visitRecursivePath, visitRelationalPredicate, visitReturningColumns, visitReturningColumns, visitSelectClause, visitSelectStatement, visitSelfRenderingExpression, visitSelfRenderingPredicate, visitSetAssignment, visitSetAssignmentEmulateJoin, visitSortSpecification, visitSortSpecification, visitSqlFragmentPredicate, visitSqlSelectExpression, visitSqlSelection, visitSqlSelectionExpression, visitSqlSelections, 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 Detail

PostgreSQLSqlAstTranslator

public PostgreSQLSqlAstTranslator(SessionFactoryImplementor sessionFactory,
                                  Statement statement)

Method Detail

visitInArrayPredicate

public void visitInArrayPredicate(InArrayPredicate inArrayPredicate)

Specified by:

visitInArrayPredicate in interface SqlAstWalker

Overrides:

visitInArrayPredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

getArrayContainsFunction

protected String getArrayContainsFunction()

Description copied from class: AbstractSqlAstTranslator

Returns the name of the array_contains(array, element) function, which is used for emulating the cycle clause.

Overrides:

getArrayContainsFunction in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderInsertIntoNoColumns

protected void renderInsertIntoNoColumns(TableInsertStandard tableInsert)

Description copied from class: AbstractSqlAstTranslator

Handle rendering an insert with no columns

Overrides:

renderInsertIntoNoColumns in class AbstractSqlAstTranslator<T extends JdbcOperation>

translateInsert

protected JdbcOperationQueryInsert translateInsert(InsertSelectStatement sqlAst)

Overrides:

translateInsert in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderTableReferenceIdentificationVariable

protected void renderTableReferenceIdentificationVariable(TableReference tableReference)

Overrides:

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

renderExpressionAsClauseItem

protected void renderExpressionAsClauseItem(Expression expression)

Overrides:

renderExpressionAsClauseItem in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderComparison

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

Overrides:

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

visitNullnessPredicate

public void visitNullnessPredicate(NullnessPredicate nullnessPredicate)

Specified by:

visitNullnessPredicate in interface SqlAstWalker

Overrides:

visitNullnessPredicate in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderMaterializationHint

protected void renderMaterializationHint(CteMaterialization materialization)

Overrides:

renderMaterializationHint in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsRowConstructor

protected boolean supportsRowConstructor()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL row constructor is supported.

Overrides:

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

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>

getForUpdate

protected String getForUpdate()

Overrides:

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

visitOffsetFetchClause

public void visitOffsetFetchClause(QueryPart queryPart)

Specified by:

visitOffsetFetchClause in interface SqlAstWalker

Overrides:

visitOffsetFetchClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsRecursiveSearchClause

protected boolean supportsRecursiveSearchClause()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL search clause is supported, which can be used for recursive CTEs.

Overrides:

supportsRecursiveSearchClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsRecursiveCycleClause

protected boolean supportsRecursiveCycleClause()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL cycle clause is supported, which can be used for recursive CTEs.

Overrides:

supportsRecursiveCycleClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

supportsRecursiveCycleUsingClause

protected boolean supportsRecursiveCycleUsingClause()

Description copied from class: AbstractSqlAstTranslator

Whether the SQL cycle clause supports the using sub-clause.

Overrides:

supportsRecursiveCycleUsingClause in class AbstractSqlAstTranslator<T extends JdbcOperation>

renderStandardCycleClause

protected void renderStandardCycleClause(CteStatement cte)

Overrides:

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

visitBinaryArithmeticExpression

public void visitBinaryArithmeticExpression(BinaryArithmeticExpression arithmeticExpression)

Specified by:

visitBinaryArithmeticExpression in interface SqlAstWalker

Overrides:

visitBinaryArithmeticExpression in class AbstractSqlAstTranslator<T extends JdbcOperation>