[hibernate-commits] [hibernate/hibernate-orm] 90a752: HHH-15328 Add support for CTE WITH clause

Branch: refs/heads/main Home: https://github.com/hibernate/hibernate-orm Commit: 90a752a0ee0d553098db415f7008622f10680339 https://github.com/hibernate/hibernate-orm/commit/90a752a0ee0d553098db415... Author: Christian Beikov <christian.beikov(a)gmail.com&gt; Date: 2022-11-10 (Thu, 10 Nov 2022) Changed paths: M documentation/src/main/asciidoc/userguide/chapters/query/hql/QueryLanguage.adoc M documentation/src/main/asciidoc/userguide/chapters/query/hql/extras/statement_select_bnf.txt M documentation/src/test/java/org/hibernate/userguide/hql/HQLTest.java M gradle/databases.gradle M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/CUBRIDSqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/CacheSqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/CockroachLegacyDialect.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/CockroachLegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/DB2LegacyDialect.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/DB2LegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/DB2iLegacyDialect.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/DB2zLegacyDialect.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/DB2zLegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/DerbyLegacyDialect.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/DerbyLegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/FirebirdSqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/H2LegacyDialect.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/H2LegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/HSQLLegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/InformixSqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/IngresSqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/MariaDBLegacyDialect.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/MariaDBLegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/MaxDBSqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/MimerSQLSqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/MySQLLegacyDialect.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/MySQLLegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/OracleLegacyDialect.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/OracleLegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/PostgreSQLLegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/RDMSOS2200SqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/SQLServerLegacyDialect.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/SQLServerLegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/SQLiteSqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/SybaseASELegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/SybaseAnywhereSqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/SybaseLegacySqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/TeradataSqlAstTranslator.java M hibernate-community-dialects/src/main/java/org/hibernate/community/dialect/TimesTenSqlAstTranslator.java M hibernate-core/src/main/antlr/org/hibernate/grammars/hql/HqlLexer.g4 M hibernate-core/src/main/antlr/org/hibernate/grammars/hql/HqlParser.g4 M hibernate-core/src/main/java/org/hibernate/action/internal/BulkOperationCleanupAction.java M hibernate-core/src/main/java/org/hibernate/dialect/AbstractTransactSQLDialect.java M hibernate-core/src/main/java/org/hibernate/dialect/CockroachDialect.java M hibernate-core/src/main/java/org/hibernate/dialect/CockroachSqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/DB2Dialect.java M hibernate-core/src/main/java/org/hibernate/dialect/DB2SqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/DB2iDialect.java M hibernate-core/src/main/java/org/hibernate/dialect/DB2zDialect.java M hibernate-core/src/main/java/org/hibernate/dialect/DB2zSqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/DerbyDialect.java M hibernate-core/src/main/java/org/hibernate/dialect/DerbySqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/Dialect.java M hibernate-core/src/main/java/org/hibernate/dialect/H2Dialect.java M hibernate-core/src/main/java/org/hibernate/dialect/H2SqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/HANASqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/HSQLDialect.java M hibernate-core/src/main/java/org/hibernate/dialect/HSQLSqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/MariaDBDialect.java M hibernate-core/src/main/java/org/hibernate/dialect/MariaDBSqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/MySQLDialect.java M hibernate-core/src/main/java/org/hibernate/dialect/MySQLSqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/OracleDialect.java M hibernate-core/src/main/java/org/hibernate/dialect/OracleSqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/PostgreSQLDialect.java M hibernate-core/src/main/java/org/hibernate/dialect/PostgreSQLSqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/SQLServerDialect.java M hibernate-core/src/main/java/org/hibernate/dialect/SQLServerSqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/SpannerSqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/SybaseASESqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/SybaseSqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/TiDBDialect.java M hibernate-core/src/main/java/org/hibernate/dialect/TiDBSqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/dialect/function/AggregateWindowEmulationQueryTransformer.java A hibernate-core/src/main/java/org/hibernate/dialect/function/ChrLiteralEmulation.java M hibernate-core/src/main/java/org/hibernate/dialect/function/CountFunction.java M hibernate-core/src/main/java/org/hibernate/internal/util/collections/Stack.java M hibernate-core/src/main/java/org/hibernate/internal/util/collections/StandardStack.java M hibernate-core/src/main/java/org/hibernate/query/criteria/HibernateCriteriaBuilder.java A hibernate-core/src/main/java/org/hibernate/query/criteria/JpaCteContainer.java A hibernate-core/src/main/java/org/hibernate/query/criteria/JpaCteCriteria.java A hibernate-core/src/main/java/org/hibernate/query/criteria/JpaCteCriteriaAttribute.java A hibernate-core/src/main/java/org/hibernate/query/criteria/JpaCteCriteriaType.java M hibernate-core/src/main/java/org/hibernate/query/criteria/JpaDerivedJoin.java M hibernate-core/src/main/java/org/hibernate/query/criteria/JpaEntityJoin.java M hibernate-core/src/main/java/org/hibernate/query/criteria/JpaFrom.java M hibernate-core/src/main/java/org/hibernate/query/criteria/JpaJoinedFrom.java M hibernate-core/src/main/java/org/hibernate/query/criteria/JpaQueryableCriteria.java A hibernate-core/src/main/java/org/hibernate/query/criteria/JpaSearchOrder.java M hibernate-core/src/main/java/org/hibernate/query/criteria/JpaSelectCriteria.java M hibernate-core/src/main/java/org/hibernate/query/criteria/JpaSubQuery.java M hibernate-core/src/main/java/org/hibernate/query/derived/AnonymousTupleEntityValuedModelPart.java M hibernate-core/src/main/java/org/hibernate/query/derived/AnonymousTupleSqmPathSource.java M hibernate-core/src/main/java/org/hibernate/query/derived/AnonymousTupleTableGroupProducer.java M hibernate-core/src/main/java/org/hibernate/query/derived/AnonymousTupleType.java A hibernate-core/src/main/java/org/hibernate/query/derived/CteTupleTableGroupProducer.java M hibernate-core/src/main/java/org/hibernate/query/hql/internal/QualifiedJoinPathConsumer.java M hibernate-core/src/main/java/org/hibernate/query/hql/internal/QuerySplitter.java M hibernate-core/src/main/java/org/hibernate/query/hql/internal/SemanticQueryBuilder.java M hibernate-core/src/main/java/org/hibernate/query/hql/spi/SqmCreationState.java M hibernate-core/src/main/java/org/hibernate/query/sqm/SemanticQueryWalker.java M hibernate-core/src/main/java/org/hibernate/query/sqm/StrictJpaComplianceViolation.java M hibernate-core/src/main/java/org/hibernate/query/sqm/internal/SqmCriteriaNodeBuilder.java M hibernate-core/src/main/java/org/hibernate/query/sqm/internal/SqmTreePrinter.java M hibernate-core/src/main/java/org/hibernate/query/sqm/mutation/internal/cte/AbstractCteMutationHandler.java M hibernate-core/src/main/java/org/hibernate/query/sqm/mutation/internal/cte/CteDeleteHandler.java M hibernate-core/src/main/java/org/hibernate/query/sqm/mutation/internal/cte/CteInsertHandler.java M hibernate-core/src/main/java/org/hibernate/query/sqm/mutation/internal/cte/CteInsertStrategy.java M hibernate-core/src/main/java/org/hibernate/query/sqm/mutation/internal/cte/CteMutationStrategy.java M hibernate-core/src/main/java/org/hibernate/query/sqm/mutation/internal/cte/CteUpdateHandler.java M hibernate-core/src/main/java/org/hibernate/query/sqm/spi/BaseSemanticQueryWalker.java M hibernate-core/src/main/java/org/hibernate/query/sqm/sql/BaseSqmToSqlAstConverter.java M hibernate-core/src/main/java/org/hibernate/query/sqm/sql/internal/EntityValuedPathInterpretation.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/AbstractSqmDmlStatement.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/AbstractSqmRestrictedDmlStatement.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/cte/SqmCteContainer.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/cte/SqmCteStatement.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/cte/SqmCteTable.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/cte/SqmCteTableColumn.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/cte/SqmSearchClauseSpecification.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/delete/SqmDeleteStatement.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/domain/AbstractSqmAttributeJoin.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/domain/AbstractSqmFrom.java A hibernate-core/src/main/java/org/hibernate/query/sqm/tree/domain/AbstractSqmQualifiedJoin.java A hibernate-core/src/main/java/org/hibernate/query/sqm/tree/domain/SqmCteRoot.java A hibernate-core/src/main/java/org/hibernate/query/sqm/tree/from/SqmCteJoin.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/from/SqmDerivedJoin.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/from/SqmEntityJoin.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/from/SqmFrom.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/insert/AbstractSqmInsertStatement.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/insert/SqmInsertSelectStatement.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/insert/SqmInsertValuesStatement.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/select/AbstractSqmSelectQuery.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/select/SqmSelectQuery.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/select/SqmSelectStatement.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/select/SqmSubQuery.java M hibernate-core/src/main/java/org/hibernate/query/sqm/tree/update/SqmUpdateStatement.java M hibernate-core/src/main/java/org/hibernate/sql/ast/Clause.java M hibernate-core/src/main/java/org/hibernate/sql/ast/SqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/sql/ast/SqlTreePrinter.java M hibernate-core/src/main/java/org/hibernate/sql/ast/spi/AbstractSqlAstTranslator.java M hibernate-core/src/main/java/org/hibernate/sql/ast/spi/AbstractSqlAstWalker.java M hibernate-core/src/main/java/org/hibernate/sql/ast/spi/ExpressionReplacementWalker.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/AbstractStatement.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/cte/CteContainer.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/cte/CteStatement.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/cte/CteTable.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/cte/CteTableGroup.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/delete/DeleteStatement.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/expression/Any.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/expression/Every.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/expression/ModifiedSubQueryExpression.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/from/QueryPartTableGroup.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/from/QueryPartTableReference.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/insert/InsertStatement.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/predicate/ExistsPredicate.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/predicate/InSubQueryPredicate.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/select/QueryGroup.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/select/QueryPart.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/select/QuerySpec.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/select/SelectStatement.java M hibernate-core/src/main/java/org/hibernate/sql/ast/tree/update/UpdateStatement.java A hibernate-core/src/test/java/org/hibernate/orm/test/query/CteTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/SubQueryInFromEmbeddedIdTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/SubQueryInFromIdClassTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/SubQueryInFromInverseOneEmbeddedIdTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/SubQueryInFromInverseOneIdClassTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/SubQueryInFromInverseOneTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/SubQueryInFromManyToManyEmbeddedIdTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/SubQueryInFromManyToManyIdClassTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/SubQueryInFromManyToManyTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/SubQueryInFromOneToManyEmbeddedIdTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/SubQueryInFromOneToManyIdClassTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/SubQueryInFromOneToManyTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/SubQueryInFromTests.java M hibernate-core/src/test/java/org/hibernate/orm/test/query/hql/CountExpressionTest.java M hibernate-testing/src/main/java/org/hibernate/testing/DialectChecks.java M hibernate-testing/src/main/java/org/hibernate/testing/orm/junit/DialectFeatureChecks.java Log Message: ----------- HHH-15328 Add support for CTE WITH clause