[CALCITE-5529] Improve dialect tests, part 1: check each query against a reference dialect #14854

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testBoolLiteralOracle() java.lang.RuntimeException: while preparing [SELECT "e1"."department_id" FROM "foodmart"."employee" "e1" LEFT JOIN "employee" "e2" ON TRUE] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testBoolLiteralOracle(RelToSqlConverterTest.java:8706) Caused by: java.sql.SQLException: Error while preparing statement [SELECT "e1"."department_id" FROM "foodmart"."employee" "e1" LEFT JOIN "employee" "e2" ON TRUE] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 3, column 11 to line 3, column 20: Object 'employee' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateJoin(SqlValidatorImpl.java:3734) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3616) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calc

Linux (JDK 11, Pacific/Chatham Timezone): RelToSqlConverterTest.java#L9672

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testUsingClauseWithStarInProjection() java.lang.RuntimeException: while preparing [select "employee_id", * from "employee" e0 join "employee" e1 using ("employee_id")] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testUsingClauseWithStarInProjection(RelToSqlConverterTest.java:9672) Caused by: java.sql.SQLException: Error while preparing statement [select "employee_id", * from "employee" e0 join "employee" e1 using ("employee_id")] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 30 to line 1, column 39: Object 'employee' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateJoin(SqlValidatorImpl.java:3733) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3616) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calc

Linux (JDK 11, Pacific/Chatham Timezone): RelToSqlConverterTest.java#L5377

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testConvertNestWindowToSql() java.lang.RuntimeException: while preparing [ SELECT RANK() OVER (ORDER BY "daily_sales" DESC) AS "rank1" FROM ( SELECT "product_name", SUM("product_id") OVER (PARTITION BY "product_name") AS "daily_sales" FROM "product" ) subquery] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testConvertNestWindowToSql(RelToSqlConverterTest.java:5377) Caused by: java.sql.SQLException: Error while preparing statement [ SELECT RANK() OVER (ORDER BY "daily_sales" DESC) AS "rank1" FROM ( SELECT "product_name", SUM("product_id") OVER (PARTITION BY "product_name") AS "daily_sales" FROM "product" ) subquery] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 167 to line 1, column 175: Object 'product' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.

Linux (JDK 11, Pacific/Chatham Timezone): RelToSqlConverterTest.java#L9102

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testInsertValuesWithDynamicParams() java.lang.RuntimeException: while preparing [insert into dept values (?,?,?), (?,?,?)] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testInsertValuesWithDynamicParams(RelToSqlConverterTest.java:9102) Caused by: java.sql.SQLException: Error while preparing statement [insert into dept values (?,?,?), (?,?,?)] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 13 to line 1, column 16: Object 'DEPT' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateInsert(SqlValidatorImpl.java:5314) at app//org.apache.calcite.sql.SqlInsert.validate(SqlInsert.java:168) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at app//org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at app//org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:524) at app//org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:492) at app//org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:257) at app//org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:237) ... 7 more Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Object 'DEPT' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:605) ... 26 more Next exception 3: [CIRCULAR REFERENCE PlaceholderE

Linux (JDK 11, Pacific/Chatham Timezone): RelToSqlConverterTest.java#L4058

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testCastToCharWithPrecision() java.lang.RuntimeException: while preparing [select cast("product_id" as char(5)) from "product"] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testCastToCharWithPrecision(RelToSqlConverterTest.java:4058) Caused by: java.sql.SQLException: Error while preparing statement [select cast("product_id" as char(5)) from "product"] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 43 to line 1, column 51: Object 'product' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at app//org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at app//org.apache.calcite.prepare.CalcitePrepareIm

Linux (JDK 11, Pacific/Chatham Timezone): RelToSqlConverterTest.java#L642

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSelectQueryWithHiveCube() java.lang.RuntimeException: while preparing [select "product_class_id", "product_id", count(*) from "product" group by cube("product_class_id", "product_id")] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSelectQueryWithHiveCube(RelToSqlConverterTest.java:642) Caused by: java.sql.SQLException: Error while preparing statement [select "product_class_id", "product_id", count(*) from "product" group by cube("product_class_id", "product_id")] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at app//org.apache.calcite.p

Linux (JDK 11, Pacific/Chatham Timezone): RelToSqlConverterTest.java#L7882

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testBitOrAgg() java.lang.RuntimeException: while preparing [select bit_or("product_id") from "product"] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testBitOrAgg(RelToSqlConverterTest.java:7882) Caused by: java.sql.SQLException: Error while preparing statement [select bit_or("product_id") from "product"] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at app//org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at app//org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:524)

Linux (JDK 11, Pacific/Chatham Timezone): RelToSqlConverterTest.java#L5907

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSubQueryWithSingleValue() java.lang.RuntimeException: while preparing [select "product_class_id" as c from "product" where "net_weight" > (select "product_class_id" from "product")] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSubQueryWithSingleValue(RelToSqlConverterTest.java:5907) Caused by: java.sql.SQLException: Error while preparing statement [select "product_class_id" as c from "product" where "net_weight" > (select "product_class_id" from "product")] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at app//org.apache.calcite.prepare.

Linux (JDK 11, Pacific/Chatham Timezone): RelToSqlConverterTest.java#L621

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSelectQueryWithWhereClauseOfBasicOperators() java.lang.RuntimeException: while preparing [select * from "product" where ("product_id" = 10 OR "product_id" <= 5) AND (80 >= "shelf_width" OR "shelf_width" > 30)] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSelectQueryWithWhereClauseOfBasicOperators(RelToSqlConverterTest.java:621) Caused by: java.sql.SQLException: Error while preparing statement [select * from "product" where ("product_id" = 10 OR "product_id" <= 5) AND (80 >= "shelf_width" OR "shelf_width" > 30)] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prep

Linux (JDK 11, Pacific/Chatham Timezone): RelToSqlConverterTest.java#L9796

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testPrestoFloatingPointTypesCast() java.lang.RuntimeException: while preparing [SELECT CAST("department_id" AS float), CAST("department_id" AS double), CAST("department_id" AS real) FROM "employee"] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testPrestoFloatingPointTypesCast(RelToSqlConverterTest.java:9796) Caused by: java.sql.SQLException: Error while preparing statement [SELECT CAST("department_id" AS float), CAST("department_id" AS double), CAST("department_id" AS real) FROM "employee"] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 108 to line 1, column 117: Object 'employee' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at app//org

Linux (JDK 8, oldest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L8706

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testBoolLiteralOracle() java.lang.RuntimeException: while preparing [SELECT "e1"."department_id" FROM "foodmart"."employee" "e1" LEFT JOIN "employee" "e2" ON TRUE] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testBoolLiteralOracle(RelToSqlConverterTest.java:8706) Caused by: java.sql.SQLException: Error while preparing statement [SELECT "e1"."department_id" FROM "foodmart"."employee" "e1" LEFT JOIN "employee" "e2" ON TRUE] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 3, column 11 to line 3, column 20: Object 'employee' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateJoin(SqlValidatorImpl.java:3734) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3616) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepa

Linux (JDK 8, oldest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L9672

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testUsingClauseWithStarInProjection() java.lang.RuntimeException: while preparing [select "employee_id", * from "employee" e0 join "employee" e1 using ("employee_id")] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testUsingClauseWithStarInProjection(RelToSqlConverterTest.java:9672) Caused by: java.sql.SQLException: Error while preparing statement [select "employee_id", * from "employee" e0 join "employee" e1 using ("employee_id")] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 30 to line 1, column 39: Object 'employee' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateJoin(SqlValidatorImpl.java:3733) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3616) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepa

Linux (JDK 8, oldest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L5377

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testConvertNestWindowToSql() java.lang.RuntimeException: while preparing [ SELECT RANK() OVER (ORDER BY "daily_sales" DESC) AS "rank1" FROM ( SELECT "product_name", SUM("product_id") OVER (PARTITION BY "product_name") AS "daily_sales" FROM "product" ) subquery] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testConvertNestWindowToSql(RelToSqlConverterTest.java:5377) Caused by: java.sql.SQLException: Error while preparing statement [ SELECT RANK() OVER (ORDER BY "daily_sales" DESC) AS "rank1" FROM ( SELECT "product_name", SUM("product_id") OVER (PARTITION BY "product_name") AS "daily_sales" FROM "product" ) subquery] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 167 to line 1, column 175: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.vali

Linux (JDK 8, oldest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L3155

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testPositionFunctionForMySql() java.lang.RuntimeException: while preparing [select position('A' IN 'ABC') from "product"] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testPositionFunctionForMySql(RelToSqlConverterTest.java:3155) Caused by: java.sql.SQLException: Error while preparing statement [select position('A' IN 'ABC') from "product"] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 36 to line 1, column 44: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:524) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.

Linux (JDK 8, oldest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L9102

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testInsertValuesWithDynamicParams() java.lang.RuntimeException: while preparing [insert into dept values (?,?,?), (?,?,?)] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testInsertValuesWithDynamicParams(RelToSqlConverterTest.java:9102) Caused by: java.sql.SQLException: Error while preparing statement [insert into dept values (?,?,?), (?,?,?)] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 13 to line 1, column 16: Object 'DEPT' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateInsert(SqlValidatorImpl.java:5314) at org.apache.calcite.sql.SqlInsert.validate(SqlInsert.java:168) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:524) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:492) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:257) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:237) ... 7 more Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Object 'DEPT' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:605) ... 26 more Next exception 3: [CIRCULAR REFERENCE PlaceholderException] Caused by: [CIRCULAR REFERENCE PlaceholderException]

Linux (JDK 8, oldest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L4058

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testCastToCharWithPrecision() java.lang.RuntimeException: while preparing [select cast("product_id" as char(5)) from "product"] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testCastToCharWithPrecision(RelToSqlConverterTest.java:4058) Caused by: java.sql.SQLException: Error while preparing statement [select cast("product_id" as char(5)) from "product"] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 43 to line 1, column 51: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:524) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(Calcite

Linux (JDK 8, oldest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L642

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSelectQueryWithHiveCube() java.lang.RuntimeException: while preparing [select "product_class_id", "product_id", count(*) from "product" group by cube("product_class_id", "product_id")] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSelectQueryWithHiveCube(RelToSqlConverterTest.java:642) Caused by: java.sql.SQLException: Error while preparing statement [select "product_class_id", "product_id", count(*) from "product" group by cube("product_class_id", "product_id")] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at org.apache.calcite.prepare.CalciteP

Linux (JDK 8, oldest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L7882

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testBitOrAgg() java.lang.RuntimeException: while preparing [select bit_or("product_id") from "product"] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testBitOrAgg(RelToSqlConverterTest.java:7882) Caused by: java.sql.SQLException: Error while preparing statement [select bit_or("product_id") from "product"] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:524) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:492) at org.apac

Linux (JDK 8, oldest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L5907

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSubQueryWithSingleValue() java.lang.RuntimeException: while preparing [select "product_class_id" as c from "product" where "net_weight" > (select "product_class_id" from "product")] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSubQueryWithSingleValue(RelToSqlConverterTest.java:5907) Caused by: java.sql.SQLException: Error while preparing statement [select "product_class_id" as c from "product" where "net_weight" > (select "product_class_id" from "product")] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at org.apache.calcite.prepare.CalcitePrepareI

Linux (JDK 8, oldest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L621

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSelectQueryWithWhereClauseOfBasicOperators() java.lang.RuntimeException: while preparing [select * from "product" where ("product_id" = 10 OR "product_id" <= 5) AND (80 >= "shelf_width" OR "shelf_width" > 30)] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSelectQueryWithWhereClauseOfBasicOperators(RelToSqlConverterTest.java:621) Caused by: java.sql.SQLException: Error while preparing statement [select * from "product" where ("product_id" = 10 OR "product_id" <= 5) AND (80 >= "shelf_width" OR "shelf_width" > 30)] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:6

Linux (JDK 17): RelToSqlConverterTest.java#L8706

Linux (JDK 17): RelToSqlConverterTest.java#L9672

Linux (JDK 17): RelToSqlConverterTest.java#L5377

Linux (JDK 17): RelToSqlConverterTest.java#L9102

Linux (JDK 17): RelToSqlConverterTest.java#L4058

Linux (JDK 17): RelToSqlConverterTest.java#L642

Linux (JDK 17): RelToSqlConverterTest.java#L7882

Linux (JDK 17): RelToSqlConverterTest.java#L5907

Linux (JDK 17): RelToSqlConverterTest.java#L621

Linux (JDK 17): RelToSqlConverterTest.java#L9796

Linux (JDK 8, latest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L8706

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testBoolLiteralOracle() java.lang.RuntimeException: while preparing [SELECT "e1"."department_id" FROM "foodmart"."employee" "e1" LEFT JOIN "employee" "e2" ON TRUE] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testBoolLiteralOracle(RelToSqlConverterTest.java:8706) Caused by: java.sql.SQLException: Error while preparing statement [SELECT "e1"."department_id" FROM "foodmart"."employee" "e1" LEFT JOIN "employee" "e2" ON TRUE] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 3, column 11 to line 3, column 20: Object 'employee' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateJoin(SqlValidatorImpl.java:3734) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3616) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepa

Linux (JDK 8, latest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L9672

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testUsingClauseWithStarInProjection() java.lang.RuntimeException: while preparing [select "employee_id", * from "employee" e0 join "employee" e1 using ("employee_id")] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testUsingClauseWithStarInProjection(RelToSqlConverterTest.java:9672) Caused by: java.sql.SQLException: Error while preparing statement [select "employee_id", * from "employee" e0 join "employee" e1 using ("employee_id")] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 30 to line 1, column 39: Object 'employee' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateJoin(SqlValidatorImpl.java:3733) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3616) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepa

Linux (JDK 8, latest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L3155

Linux (JDK 8, latest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L5377

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testConvertNestWindowToSql() java.lang.RuntimeException: while preparing [ SELECT RANK() OVER (ORDER BY "daily_sales" DESC) AS "rank1" FROM ( SELECT "product_name", SUM("product_id") OVER (PARTITION BY "product_name") AS "daily_sales" FROM "product" ) subquery] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testConvertNestWindowToSql(RelToSqlConverterTest.java:5377) Caused by: java.sql.SQLException: Error while preparing statement [ SELECT RANK() OVER (ORDER BY "daily_sales" DESC) AS "rank1" FROM ( SELECT "product_name", SUM("product_id") OVER (PARTITION BY "product_name") AS "daily_sales" FROM "product" ) subquery] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 167 to line 1, column 175: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.vali

Linux (JDK 8, latest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L9102

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testInsertValuesWithDynamicParams() java.lang.RuntimeException: while preparing [insert into dept values (?,?,?), (?,?,?)] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testInsertValuesWithDynamicParams(RelToSqlConverterTest.java:9102) Caused by: java.sql.SQLException: Error while preparing statement [insert into dept values (?,?,?), (?,?,?)] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 13 to line 1, column 16: Object 'DEPT' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateInsert(SqlValidatorImpl.java:5314) at org.apache.calcite.sql.SqlInsert.validate(SqlInsert.java:168) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:524) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:492) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:257) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:237) ... 7 more Caused by: org.apache.calcite.sql.validate.SqlValidatorException: Object 'DEPT' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.runtime.Resources$ExInst.ex(Resources.java:605) ... 26 more Next exception 3: [CIRCULAR REFERENCE PlaceholderException] Caused by: [CIRCULAR REFERENCE PlaceholderException]

Linux (JDK 8, latest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L4058

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testCastToCharWithPrecision() java.lang.RuntimeException: while preparing [select cast("product_id" as char(5)) from "product"] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testCastToCharWithPrecision(RelToSqlConverterTest.java:4058) Caused by: java.sql.SQLException: Error while preparing statement [select cast("product_id" as char(5)) from "product"] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 43 to line 1, column 51: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:524) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(Calcite

Linux (JDK 8, latest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L642

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSelectQueryWithHiveCube() java.lang.RuntimeException: while preparing [select "product_class_id", "product_id", count(*) from "product" group by cube("product_class_id", "product_id")] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSelectQueryWithHiveCube(RelToSqlConverterTest.java:642) Caused by: java.sql.SQLException: Error while preparing statement [select "product_class_id", "product_id", count(*) from "product" group by cube("product_class_id", "product_id")] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at org.apache.calcite.prepare.CalciteP

Linux (JDK 8, latest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L7882

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testBitOrAgg() java.lang.RuntimeException: while preparing [select bit_or("product_id") from "product"] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testBitOrAgg(RelToSqlConverterTest.java:7882) Caused by: java.sql.SQLException: Error while preparing statement [select bit_or("product_id") from "product"] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:524) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:492) at org.apac

Linux (JDK 8, latest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L5907

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSubQueryWithSingleValue() java.lang.RuntimeException: while preparing [select "product_class_id" as c from "product" where "net_weight" > (select "product_class_id" from "product")] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSubQueryWithSingleValue(RelToSqlConverterTest.java:5907) Caused by: java.sql.SQLException: Error while preparing statement [select "product_class_id" as c from "product" where "net_weight" > (select "product_class_id" from "product")] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at org.apache.calcite.prepare.CalcitePrepareI

Linux (JDK 8, latest Guava, America/New_York Timezone): RelToSqlConverterTest.java#L621

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSelectQueryWithWhereClauseOfBasicOperators() java.lang.RuntimeException: while preparing [select * from "product" where ("product_id" = 10 OR "product_id" <= 5) AND (80 >= "shelf_width" OR "shelf_width" > 30)] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSelectQueryWithWhereClauseOfBasicOperators(RelToSqlConverterTest.java:621) Caused by: java.sql.SQLException: Error while preparing statement [select * from "product" where ("product_id" = 10 OR "product_id" <= 5) AND (80 >= "shelf_width" OR "shelf_width" > 30)] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:6

Linux (JDK 21): RelToSqlConverterTest.java#L8706

Linux (JDK 21): RelToSqlConverterTest.java#L9672

Linux (JDK 21): RelToSqlConverterTest.java#L5377

Linux (JDK 21): RelToSqlConverterTest.java#L9102

Linux (JDK 21): RelToSqlConverterTest.java#L4058

Linux (JDK 21): RelToSqlConverterTest.java#L642

Linux (JDK 21): RelToSqlConverterTest.java#L7882

Linux (JDK 21): RelToSqlConverterTest.java#L5907

Linux (JDK 21): RelToSqlConverterTest.java#L621

Linux (JDK 21): RelToSqlConverterTest.java#L9796

Linux (JDK 23): RelToSqlConverterTest.java#L8706

Linux (JDK 23): RelToSqlConverterTest.java#L9672

Linux (JDK 23): RelToSqlConverterTest.java#L5377

Linux (JDK 23): RelToSqlConverterTest.java#L3155

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testPositionFunctionForMySql() java.lang.RuntimeException: while preparing [select position('A' IN 'ABC') from "product"] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testPositionFunctionForMySql(RelToSqlConverterTest.java:3155) Caused by: java.sql.SQLException: Error while preparing statement [select position('A' IN 'ABC') from "product"] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 1, column 36 to line 1, column 44: Object 'product' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at app//org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at app//org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(

Linux (JDK 23): RelToSqlConverterTest.java#L727

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testBigQueryFloorPreservesCast() java.lang.RuntimeException: while preparing [SELECT TIMESTAMP_SECONDS(CAST(FLOOR(CAST(3 AS BIGINT)) AS BIGINT)) as created_thing FROM emp] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testBigQueryFloorPreservesCast(RelToSqlConverterTest.java:727) Caused by: java.sql.SQLException: Error while preparing statement [SELECT TIMESTAMP_SECONDS(CAST(FLOOR(CAST(3 AS BIGINT)) AS BIGINT)) as created_thing FROM emp] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 4, column 6 to line 4, column 8: Object 'EMP' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at app//org.apache.calcite.prepare.CalcitePrepareImpl.pre

Linux (JDK 23): RelToSqlConverterTest.java#L9102

Linux (JDK 23): RelToSqlConverterTest.java#L4058

Linux (JDK 23): RelToSqlConverterTest.java#L7989

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testPrestoSqlLength() java.lang.RuntimeException: while preparing [select CHAR_LENGTH("brand_name") from "product"] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testPrestoSqlLength(RelToSqlConverterTest.java:7989) Caused by: java.sql.SQLException: Error while preparing statement [select CHAR_LENGTH("brand_name") from "product"] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 14: Object 'product' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at app//org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at app//org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePr

Linux (JDK 23): RelToSqlConverterTest.java#L9581

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testTrimWithTailing() java.lang.RuntimeException: while preparing [SELECT TRIM(TRAILING ' ' from ' str ') from "reserve_employee"] at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:492) at org.apache.calcite.rel.rel2sql.DialectTestConfig$Dialect.withConnection(DialectTestConfig.java:276) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:483) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testTrimWithTailing(RelToSqlConverterTest.java:9581) Caused by: java.sql.SQLException: Error while preparing statement [SELECT TRIM(TRAILING ' ' from ' str ') from "reserve_employee"] at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement_(CalciteConnectionImpl.java:247) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:226) at org.apache.calcite.jdbc.CalciteConnectionImpl.prepareStatement(CalciteConnectionImpl.java:103) at org.apache.calcite.avatica.AvaticaConnection.prepareStatement(AvaticaConnection.java:178) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$7(RelToSqlFixture.java:484) ... 3 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: org.apache.calcite.runtime.CalciteContextException: From line 2, column 6 to line 2, column 23: Object 'reserve_employee' not found at app//org.apache.calcite.runtime.Resources$ExInstWithCause.ex(Resources.java:511) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:954) at app//org.apache.calcite.sql.SqlUtil.newContextException(SqlUtil.java:939) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.newValidationError(SqlValidatorImpl.java:6024) at app//org.apache.calcite.sql.validate.IdentifierNamespace.resolveImpl(IdentifierNamespace.java:183) at app//org.apache.calcite.sql.validate.IdentifierNamespace.validateImpl(IdentifierNamespace.java:188) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3628) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateFrom(SqlValidatorImpl.java:3607) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateSelect(SqlValidatorImpl.java:4121) at app//org.apache.calcite.sql.validate.SelectNamespace.validateImpl(SelectNamespace.java:62) at app//org.apache.calcite.sql.validate.AbstractNamespace.validate(AbstractNamespace.java:96) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateNamespace(SqlValidatorImpl.java:1208) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateQuery(SqlValidatorImpl.java:1179) at app//org.apache.calcite.sql.SqlSelect.validate(SqlSelect.java:282) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validateScopedExpression(SqlValidatorImpl.java:1145) at app//org.apache.calcite.sql.validate.SqlValidatorImpl.validate(SqlValidatorImpl.java:851) at app//org.apache.calcite.sql2rel.SqlToRelConverter.convertQuery(SqlToRelConverter.java:627) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:258) at app//org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:221) at app//org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:673) at app//org.apache.calcite.prepar

Linux (JDK 23): RelToSqlConverterTest.java#L642

CheckerFramework (JDK 11)

Canceling since a higher priority waiting request for 'ci-main-refs/pull/4206/merge' exists

CheckerFramework (JDK 11)

The operation was canceled.

Windows (JDK 17)

Canceling since a higher priority waiting request for 'ci-main-refs/pull/4206/merge' exists

Windows (JDK 17): RelToSqlConverterStructsTest.java#L87

0.3sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaNestedColumns() java.lang.AssertionError: Expected: is "SELECT \"a\", \"e\", \"n1\".\"n11\".\"b\", \"n2\".\"d\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", \"e\", \"n1\".\"n11\".\"b\", \"n2\".\"d\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaNestedColumns(RelToSqlConverterStructsTest.java:87)

Windows (JDK 17): RelToSqlConverterStructsTest.java#L66

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaSelectStar() java.lang.AssertionError: Expected: is "SELECT \"a\", ROW(ROW(\"n1\".\"n11\".\"b\"), ROW(\"n1\".\"n12\".\"c\")) AS \"n1\", ROW(\"n2\".\"d\") AS \"n2\", \"xs\", \"e\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", ROW(ROW(\"n1\".\"n11\".\"b\"), ROW(\"n1\".\"n12\".\"c\")) AS \"n1\", ROW(\"n2\".\"d\") AS \"n2\", \"xs\", \"e\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaSelectStar(RelToSqlConverterStructsTest.java:66)

Windows (JDK 17): RelToSqlConverterStructsTest.java#L74

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaRootColumns() java.lang.AssertionError: Expected: is "SELECT \"a\", \"e\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", \"e\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaRootColumns(RelToSqlConverterStructsTest.java:74)

Windows (JDK 17): RelToSqlConverterTest.java#L7476

4.2sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testLateralCorrelate() java.lang.AssertionError: Expected: is "SELECT *\nFROM \"foodmart\".\"product\" AS \"$cor0\",\nLATERAL (SELECT *\nFROM TABLE(RAMP(\"$cor0\".\"product_id\"))) AS \"t\"" but: was "SELECT *\r\nFROM \"foodmart\".\"product\" AS \"$cor0\",\r\nLATERAL (SELECT *\r\nFROM TABLE(RAMP(\"$cor0\".\"product_id\"))) AS \"t\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testLateralCorrelate(RelToSqlConverterTest.java:7476)

Windows (JDK 17): RelToSqlConverterTest.java#L7757

0.4sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testCommaCrossJoin() java.lang.AssertionError: Expected: is "SELECT \"t\".\"nation_name\", \"t\".\"cnt1\" - \"t0\".\"cnt2\" AS \"f1\"\nFROM (SELECT \"nation_name\", COUNT(*) AS \"cnt1\"\nFROM \"tpch\".\"customer\"\nGROUP BY \"nation_name\") AS \"t\"\nCROSS JOIN (SELECT COUNT(*) AS \"cnt2\"\nFROM \"tpch\".\"lineitem\") AS \"t0\"\nLEFT JOIN \"tpch\".\"part\" ON \"t\".\"nation_name\" = \"part\".\"p_brand\"" but: was "SELECT \"t\".\"nation_name\", \"t\".\"cnt1\" - \"t0\".\"cnt2\" AS \"f1\"\r\nFROM (SELECT \"nation_name\", COUNT(*) AS \"cnt1\"\r\nFROM \"tpch\".\"customer\"\r\nGROUP BY \"nation_name\") AS \"t\"\r\nCROSS JOIN (SELECT COUNT(*) AS \"cnt2\"\r\nFROM \"tpch\".\"lineitem\") AS \"t0\"\r\nLEFT JOIN \"tpch\".\"part\" ON \"t\".\"nation_name\" = \"part\".\"p_brand\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testCommaCrossJoin(RelToSqlConverterTest.java:7757)

Windows (JDK 17): RelToSqlConverterTest.java#L2616

0.2sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testBigQueryParseDatetimeFunctions() java.lang.AssertionError: Expected: is "SELECT PARSE_TIME('%I:%M:%S', '07:30:00')\nFROM \"foodmart\".\"product\"" but: was "SELECT PARSE_TIME('%I:%M:%S', '07:30:00')\r\nFROM \"foodmart\".\"product\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testBigQueryParseDatetimeFunctions(RelToSqlConverterTest.java:2616)

Windows (JDK 17): RelToSqlConverterTest.java#L3450

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testHiveSubstringWithLength() java.lang.AssertionError: Expected: is "SELECT SUBSTRING('ABC', 2, 3)\nFROM `foodmart`.`reserve_employee`" but: was "SELECT SUBSTRING('ABC', 2, 3)\r\nFROM `foodmart`.`reserve_employee`" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testHiveSubstringWithLength(RelToSqlConverterTest.java:3450)

Windows (JDK 17): RelToSqlConverterTest.java#L1305

0.4sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testOrderByExpressionNotInTheProjectionThatRefersToUnderlyingFieldWithSameAlias() java.lang.AssertionError: Expected: is "SELECT \"EMPNO\"\nFROM (SELECT UPPER(\"ENAME\") AS \"EMPNO\", \"EMPNO\" + 1 AS \"$f1\"\nFROM \"scott\".\"EMP\"\nORDER BY 2) AS \"t0\"" but: was "SELECT \"EMPNO\"\r\nFROM (SELECT UPPER(\"ENAME\") AS \"EMPNO\", \"EMPNO\" + 1 AS \"$f1\"\r\nFROM \"scott\".\"EMP\"\r\nORDER BY 2) AS \"t0\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testOrderByExpressionNotInTheProjectionThatRefersToUnderlyingFieldWithSameAlias(RelToSqlConverterTest.java:1305)

Windows (JDK 17): RelToSqlConverterTest.java#L1485

0.1sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSum0BecomesCoalesce() java.lang.AssertionError: Expected: is "SELECT COALESCE(SUM(`MGR`), 0) AS `s`\nFROM `scott`.`EMP`" but: was "SELECT COALESCE(SUM(`MGR`), 0) AS `s`\r\nFROM `scott`.`EMP`" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSum0BecomesCoalesce(RelToSqlConverterTest.java:1485)

Windows (JDK 17): RelToSqlConverterTest.java#L4187

0.2sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSelectQueryWithGroup() java.lang.AssertionError: Expected: is "SELECT COUNT(*), SUM(\"employee_id\")\nFROM \"foodmart\".\"reserve_employee\"\nWHERE \"hire_date\" > '2015-01-01' AND (\"position_title\" = 'SDE' OR \"position_title\" = 'SDM')\nGROUP BY \"store_id\", \"position_title\"" but: was "SELECT COUNT(*), SUM(\"employee_id\")\r\nFROM \"foodmart\".\"reserve_employee\"\r\nWHERE \"hire_date\" > '2015-01-01' AND (\"position_title\" = 'SDE' OR \"position_title\" = 'SDM')\r\nGROUP BY \"store_id\", \"position_title\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSelectQueryWithGroup(RelToSqlConverterTest.java:4187)

Windows (JDK 21)

Canceling since a higher priority waiting request for 'ci-main-refs/pull/4206/merge' exists

Windows (JDK 21): RelToSqlConverterStructsTest.java#L87

0.7sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaNestedColumns() java.lang.AssertionError: Expected: is "SELECT \"a\", \"e\", \"n1\".\"n11\".\"b\", \"n2\".\"d\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", \"e\", \"n1\".\"n11\".\"b\", \"n2\".\"d\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaNestedColumns(RelToSqlConverterStructsTest.java:87)

Windows (JDK 21): RelToSqlConverterStructsTest.java#L66

0.2sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaSelectStar() java.lang.AssertionError: Expected: is "SELECT \"a\", ROW(ROW(\"n1\".\"n11\".\"b\"), ROW(\"n1\".\"n12\".\"c\")) AS \"n1\", ROW(\"n2\".\"d\") AS \"n2\", \"xs\", \"e\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", ROW(ROW(\"n1\".\"n11\".\"b\"), ROW(\"n1\".\"n12\".\"c\")) AS \"n1\", ROW(\"n2\".\"d\") AS \"n2\", \"xs\", \"e\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaSelectStar(RelToSqlConverterStructsTest.java:66)

Windows (JDK 21): RelToSqlConverterStructsTest.java#L74

Windows (JDK 21): RelToSqlConverterTest.java#L7476

6.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testLateralCorrelate() java.lang.AssertionError: Expected: is "SELECT *\nFROM \"foodmart\".\"product\" AS \"$cor0\",\nLATERAL (SELECT *\nFROM TABLE(RAMP(\"$cor0\".\"product_id\"))) AS \"t\"" but: was "SELECT *\r\nFROM \"foodmart\".\"product\" AS \"$cor0\",\r\nLATERAL (SELECT *\r\nFROM TABLE(RAMP(\"$cor0\".\"product_id\"))) AS \"t\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testLateralCorrelate(RelToSqlConverterTest.java:7476)

Windows (JDK 21): RelToSqlConverterTest.java#L7757

0.7sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testCommaCrossJoin() java.lang.AssertionError: Expected: is "SELECT \"t\".\"nation_name\", \"t\".\"cnt1\" - \"t0\".\"cnt2\" AS \"f1\"\nFROM (SELECT \"nation_name\", COUNT(*) AS \"cnt1\"\nFROM \"tpch\".\"customer\"\nGROUP BY \"nation_name\") AS \"t\"\nCROSS JOIN (SELECT COUNT(*) AS \"cnt2\"\nFROM \"tpch\".\"lineitem\") AS \"t0\"\nLEFT JOIN \"tpch\".\"part\" ON \"t\".\"nation_name\" = \"part\".\"p_brand\"" but: was "SELECT \"t\".\"nation_name\", \"t\".\"cnt1\" - \"t0\".\"cnt2\" AS \"f1\"\r\nFROM (SELECT \"nation_name\", COUNT(*) AS \"cnt1\"\r\nFROM \"tpch\".\"customer\"\r\nGROUP BY \"nation_name\") AS \"t\"\r\nCROSS JOIN (SELECT COUNT(*) AS \"cnt2\"\r\nFROM \"tpch\".\"lineitem\") AS \"t0\"\r\nLEFT JOIN \"tpch\".\"part\" ON \"t\".\"nation_name\" = \"part\".\"p_brand\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testCommaCrossJoin(RelToSqlConverterTest.java:7757)

Windows (JDK 21): RelToSqlConverterTest.java#L2616

0.1sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testBigQueryParseDatetimeFunctions() java.lang.AssertionError: Expected: is "SELECT PARSE_TIME('%I:%M:%S', '07:30:00')\nFROM \"foodmart\".\"product\"" but: was "SELECT PARSE_TIME('%I:%M:%S', '07:30:00')\r\nFROM \"foodmart\".\"product\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testBigQueryParseDatetimeFunctions(RelToSqlConverterTest.java:2616)

Windows (JDK 21): RelToSqlConverterTest.java#L3450

0.1sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testHiveSubstringWithLength() java.lang.AssertionError: Expected: is "SELECT SUBSTRING('ABC', 2, 3)\nFROM `foodmart`.`reserve_employee`" but: was "SELECT SUBSTRING('ABC', 2, 3)\r\nFROM `foodmart`.`reserve_employee`" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testHiveSubstringWithLength(RelToSqlConverterTest.java:3450)

Windows (JDK 21): RelToSqlConverterTest.java#L1305

0.5sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testOrderByExpressionNotInTheProjectionThatRefersToUnderlyingFieldWithSameAlias() java.lang.AssertionError: Expected: is "SELECT \"EMPNO\"\nFROM (SELECT UPPER(\"ENAME\") AS \"EMPNO\", \"EMPNO\" + 1 AS \"$f1\"\nFROM \"scott\".\"EMP\"\nORDER BY 2) AS \"t0\"" but: was "SELECT \"EMPNO\"\r\nFROM (SELECT UPPER(\"ENAME\") AS \"EMPNO\", \"EMPNO\" + 1 AS \"$f1\"\r\nFROM \"scott\".\"EMP\"\r\nORDER BY 2) AS \"t0\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testOrderByExpressionNotInTheProjectionThatRefersToUnderlyingFieldWithSameAlias(RelToSqlConverterTest.java:1305)

Windows (JDK 21): RelToSqlConverterTest.java#L1485

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSum0BecomesCoalesce() java.lang.AssertionError: Expected: is "SELECT COALESCE(SUM(`MGR`), 0) AS `s`\nFROM `scott`.`EMP`" but: was "SELECT COALESCE(SUM(`MGR`), 0) AS `s`\r\nFROM `scott`.`EMP`" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSum0BecomesCoalesce(RelToSqlConverterTest.java:1485)

Windows (JDK 21): RelToSqlConverterTest.java#L4187

0.6sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSelectQueryWithGroup() java.lang.AssertionError: Expected: is "SELECT COUNT(*), SUM(\"employee_id\")\nFROM \"foodmart\".\"reserve_employee\"\nWHERE \"hire_date\" > '2015-01-01' AND (\"position_title\" = 'SDE' OR \"position_title\" = 'SDM')\nGROUP BY \"store_id\", \"position_title\"" but: was "SELECT COUNT(*), SUM(\"employee_id\")\r\nFROM \"foodmart\".\"reserve_employee\"\r\nWHERE \"hire_date\" > '2015-01-01' AND (\"position_title\" = 'SDE' OR \"position_title\" = 'SDM')\r\nGROUP BY \"store_id\", \"position_title\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSelectQueryWithGroup(RelToSqlConverterTest.java:4187)

Windows (JDK 8)

Canceling since a higher priority waiting request for 'ci-main-refs/pull/4206/merge' exists

Windows (JDK 8): RelToSqlConverterStructsTest.java#L87

0.0sec org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest > testNestedSchemaNestedColumns() java.lang.AssertionError: Expected: is "SELECT \"a\", \"e\", \"n1\".\"n11\".\"b\", \"n2\".\"d\"\nFROM \"myDb\".\"myTable\"" but: was "SELECT \"a\", \"e\", \"n1\".\"n11\".\"b\", \"n2\".\"d\"\r\nFROM \"myDb\".\"myTable\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterStructsTest.testNestedSchemaNestedColumns(RelToSqlConverterStructsTest.java:87)

Windows (JDK 8): RelToSqlConverterStructsTest.java#L74

Windows (JDK 8): RelToSqlConverterStructsTest.java#L66

Windows (JDK 8): RelToSqlConverterTest.java#L7476

0.2sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testLateralCorrelate() java.lang.AssertionError: Expected: is "SELECT *\nFROM \"foodmart\".\"product\" AS \"$cor0\",\nLATERAL (SELECT *\nFROM TABLE(RAMP(\"$cor0\".\"product_id\"))) AS \"t\"" but: was "SELECT *\r\nFROM \"foodmart\".\"product\" AS \"$cor0\",\r\nLATERAL (SELECT *\r\nFROM TABLE(RAMP(\"$cor0\".\"product_id\"))) AS \"t\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testLateralCorrelate(RelToSqlConverterTest.java:7476)

Windows (JDK 8): RelToSqlConverterTest.java#L7757

0.3sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testCommaCrossJoin() java.lang.AssertionError: Expected: is "SELECT \"t\".\"nation_name\", \"t\".\"cnt1\" - \"t0\".\"cnt2\" AS \"f1\"\nFROM (SELECT \"nation_name\", COUNT(*) AS \"cnt1\"\nFROM \"tpch\".\"customer\"\nGROUP BY \"nation_name\") AS \"t\"\nCROSS JOIN (SELECT COUNT(*) AS \"cnt2\"\nFROM \"tpch\".\"lineitem\") AS \"t0\"\nLEFT JOIN \"tpch\".\"part\" ON \"t\".\"nation_name\" = \"part\".\"p_brand\"" but: was "SELECT \"t\".\"nation_name\", \"t\".\"cnt1\" - \"t0\".\"cnt2\" AS \"f1\"\r\nFROM (SELECT \"nation_name\", COUNT(*) AS \"cnt1\"\r\nFROM \"tpch\".\"customer\"\r\nGROUP BY \"nation_name\") AS \"t\"\r\nCROSS JOIN (SELECT COUNT(*) AS \"cnt2\"\r\nFROM \"tpch\".\"lineitem\") AS \"t0\"\r\nLEFT JOIN \"tpch\".\"part\" ON \"t\".\"nation_name\" = \"part\".\"p_brand\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testCommaCrossJoin(RelToSqlConverterTest.java:7757)

Windows (JDK 8): RelToSqlConverterTest.java#L2616

Windows (JDK 8): RelToSqlConverterTest.java#L3450

Windows (JDK 8): RelToSqlConverterTest.java#L1305

0.1sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testOrderByExpressionNotInTheProjectionThatRefersToUnderlyingFieldWithSameAlias() java.lang.AssertionError: Expected: is "SELECT \"EMPNO\"\nFROM (SELECT UPPER(\"ENAME\") AS \"EMPNO\", \"EMPNO\" + 1 AS \"$f1\"\nFROM \"scott\".\"EMP\"\nORDER BY 2) AS \"t0\"" but: was "SELECT \"EMPNO\"\r\nFROM (SELECT UPPER(\"ENAME\") AS \"EMPNO\", \"EMPNO\" + 1 AS \"$f1\"\r\nFROM \"scott\".\"EMP\"\r\nORDER BY 2) AS \"t0\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testOrderByExpressionNotInTheProjectionThatRefersToUnderlyingFieldWithSameAlias(RelToSqlConverterTest.java:1305)

Windows (JDK 8): RelToSqlConverterTest.java#L1485

0.4sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSum0BecomesCoalesce() java.lang.AssertionError: Expected: is "SELECT COALESCE(SUM(`MGR`), 0) AS `s`\nFROM `scott`.`EMP`" but: was "SELECT COALESCE(SUM(`MGR`), 0) AS `s`\r\nFROM `scott`.`EMP`" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSum0BecomesCoalesce(RelToSqlConverterTest.java:1485)

Windows (JDK 8): RelToSqlConverterTest.java#L4187

0.5sec org.apache.calcite.rel.rel2sql.RelToSqlConverterTest > testSelectQueryWithGroup() java.lang.AssertionError: Expected: is "SELECT COUNT(*), SUM(\"employee_id\")\nFROM \"foodmart\".\"reserve_employee\"\nWHERE \"hire_date\" > '2015-01-01' AND (\"position_title\" = 'SDE' OR \"position_title\" = 'SDM')\nGROUP BY \"store_id\", \"position_title\"" but: was "SELECT COUNT(*), SUM(\"employee_id\")\r\nFROM \"foodmart\".\"reserve_employee\"\r\nWHERE \"hire_date\" > '2015-01-01' AND (\"position_title\" = 'SDE' OR \"position_title\" = 'SDM')\r\nGROUP BY \"store_id\", \"position_title\"" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.lambda$done$10(RelToSqlFixture.java:530) at com.google.common.collect.RegularImmutableMap.forEach(RegularImmutableMap.java:300) at org.apache.calcite.rel.rel2sql.RelToSqlFixture.done(RelToSqlFixture.java:512) at org.apache.calcite.rel.rel2sql.RelToSqlConverterTest.testSelectQueryWithGroup(RelToSqlConverterTest.java:4187)

CheckerFramework (JDK 11, oldest Guava)

Canceling since a higher priority waiting request for 'ci-main-refs/pull/4206/merge' exists

CheckerFramework (JDK 11, oldest Guava)

The operation was canceled.

macOS (JDK 21)

Canceling since a higher priority waiting request for 'ci-main-refs/pull/4206/merge' exists

macOS (JDK 21)

The operation was canceled.

Linux (JDK 11, Avatica main)

Canceling since a higher priority waiting request for 'ci-main-refs/pull/4206/merge' exists

Linux (JDK 11, Avatica main): RelToSqlConverterTest.java#L8706

Linux (JDK 11, Avatica main): RelToSqlConverterTest.java#L9672

Linux (JDK 11, Avatica main): RelToSqlConverterTest.java#L5377

Linux (JDK 11, Avatica main): RelToSqlConverterTest.java#L9102

Linux (JDK 11, Avatica main): RelToSqlConverterTest.java#L4058

Linux (JDK 11, Avatica main): RelToSqlConverterTest.java#L642

Linux (JDK 11, Avatica main): RelToSqlConverterTest.java#L7882

Linux (JDK 11, Avatica main): RelToSqlConverterTest.java#L5907

Linux (JDK 11, Avatica main): RelToSqlConverterTest.java#L621

Linux (JDK 11, Avatica main): RelToSqlConverterTest.java#L9796

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

[CALCITE-5529] Improve dialect tests, part 1: check each query against a reference dialect #14854

Summary

[CALCITE-5529] Improve dialect tests, part 1: check each query against a reference dialect #14854

Jobs

Run details

main.yml

Annotations