Skip to content
CI

[CALCITE-6090] Jdbc adapter may create wrong sql for joins #35

Sign in to view logs

[CALCITE-6090] Jdbc adapter may create wrong sql for joins

[CALCITE-6090] Jdbc adapter may create wrong sql for joins #35

Triggered via push November 8, 2023 08:59
@kramerulkramerul
pushed c0bf690
calcite-1.35.0+hotfix
Status Failure
Total duration 12m 59s
Artifacts –

main.yml

on: push
Windows (JDK 8)
5m 50s
Windows (JDK 8)
Windows (JDK 17)
7m 33s
Windows (JDK 17)
Linux (JDK 8), Oldest Guava, America/New_York Timezone
6m 24s
Linux (JDK 8), Oldest Guava, America/New_York Timezone
Linux (JDK 8), Latest Guava, America/New_York Timezone
7m 26s
Linux (JDK 8), Latest Guava, America/New_York Timezone
Linux (JDK 11), Pacific/Chatham Timezone
4m 3s
Linux (JDK 11), Pacific/Chatham Timezone
Linux (JDK 17)
4m 35s
Linux (JDK 17)
Linux (JDK 19)
3m 24s
Linux (JDK 19)
Linux (JDK 11), Avatica main
5m 54s
Linux (JDK 11), Avatica main
macOS (JDK 19)
7m 0s
macOS (JDK 19)
Error Prone (JDK 11), Guava 31
6m 11s
Error Prone (JDK 11), Guava 31
CheckerFramework (JDK 11)
12m 46s
CheckerFramework (JDK 11)
CheckerFramework (JDK 11), Guava 29
9m 51s
CheckerFramework (JDK 11), Guava 29
Linux (JDK 8) Slow Tests
0s
Linux (JDK 8) Slow Tests
Druid Tests
6m 12s
Druid Tests
Fit to window
Zoom out
Zoom in

Annotations

34 errors and 13 warnings
Linux (JDK 19): task ':core:autostyleJavaCheck'#L1
Execution failed for task ':core:autostyleJavaCheck': See 'What went wrong' below
Linux (JDK 19)
Execution failed for task ':core:autostyleJavaCheck'. > The following files have format violations: core/src/main/java/org/apache/calcite/schema/Schemas.java @@ -132,7 +132,7 @@ public static SchemaPlus getExistingSubSchema(SchemaPlus schema, String name){ SchemaPlus subSchema = schema.getSubSchema(name); -····if·(·subSchema·==·null·)·{␊ +····if·(·subSchema·==·null)·{␊ throw new NoSuchElementException("Sub schema " + name + " not found in " + schema.getName()); } return subSchema; core/src/test/java/org/apache/calcite/test/JdbcAdapterTest.java @@ -1232,12 +1232,18 @@ @test void testAmbiguousColumn() { CalciteAssert.model(JdbcTest.FOODMART_SCOTT_MODEL) -········.query("select\n"·+␊ -············"··················\"store_id\"·\"latest_id\",\n"·+␊ -············"··················max(\"store_type\")·\"latest_store_type\"\n"·+␊ -············"················from\n"·+␊ -············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"·+␊ -············"················group·by\n"·+␊ +········.query("select\n"␊ +··+␊ +············"··················\"store_id\"·\"latest_id\",\n"␊ +··+␊ +············"··················max(\"store_type\")·\"latest_store_type\"\n"␊ +··+␊ +············"················from\n"␊ +··+␊ +············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"␊ +··+␊ +············"················group·by\n"␊ +··+␊ " \"store_id\"") .runs() .enable(CalciteAssert.DB == CalciteAssert.DatabaseInstance.HSQLDB) Run './gradlew autostyleApply' to fix the violations.
Linux (JDK 11), Pacific/Chatham Timezone: task ':core:autostyleJavaCheck'#L1
Execution failed for task ':core:autostyleJavaCheck': See 'What went wrong' below
Linux (JDK 11), Pacific/Chatham Timezone
Execution failed for task ':core:autostyleJavaCheck'. > The following files have format violations: core/src/main/java/org/apache/calcite/schema/Schemas.java @@ -132,7 +132,7 @@ public static SchemaPlus getExistingSubSchema(SchemaPlus schema, String name){ SchemaPlus subSchema = schema.getSubSchema(name); -····if·(·subSchema·==·null·)·{␊ +····if·(·subSchema·==·null)·{␊ throw new NoSuchElementException("Sub schema " + name + " not found in " + schema.getName()); } return subSchema; core/src/test/java/org/apache/calcite/test/JdbcAdapterTest.java @@ -1232,12 +1232,18 @@ @test void testAmbiguousColumn() { CalciteAssert.model(JdbcTest.FOODMART_SCOTT_MODEL) -········.query("select\n"·+␊ -············"··················\"store_id\"·\"latest_id\",\n"·+␊ -············"··················max(\"store_type\")·\"latest_store_type\"\n"·+␊ -············"················from\n"·+␊ -············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"·+␊ -············"················group·by\n"·+␊ +········.query("select\n"␊ +··+␊ +············"··················\"store_id\"·\"latest_id\",\n"␊ +··+␊ +············"··················max(\"store_type\")·\"latest_store_type\"\n"␊ +··+␊ +············"················from\n"␊ +··+␊ +············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"␊ +··+␊ +············"················group·by\n"␊ +··+␊ " \"store_id\"") .runs() .enable(CalciteAssert.DB == CalciteAssert.DatabaseInstance.HSQLDB) Run './gradlew autostyleApply' to fix the violations.
Linux (JDK 17): task ':core:autostyleJavaCheck'#L1
Execution failed for task ':core:autostyleJavaCheck': See 'What went wrong' below
Linux (JDK 17)
Execution failed for task ':core:autostyleJavaCheck'. > The following files have format violations: core/src/main/java/org/apache/calcite/schema/Schemas.java @@ -132,7 +132,7 @@ public static SchemaPlus getExistingSubSchema(SchemaPlus schema, String name){ SchemaPlus subSchema = schema.getSubSchema(name); -····if·(·subSchema·==·null·)·{␊ +····if·(·subSchema·==·null)·{␊ throw new NoSuchElementException("Sub schema " + name + " not found in " + schema.getName()); } return subSchema; core/src/test/java/org/apache/calcite/test/JdbcAdapterTest.java @@ -1232,12 +1232,18 @@ @test void testAmbiguousColumn() { CalciteAssert.model(JdbcTest.FOODMART_SCOTT_MODEL) -········.query("select\n"·+␊ -············"··················\"store_id\"·\"latest_id\",\n"·+␊ -············"··················max(\"store_type\")·\"latest_store_type\"\n"·+␊ -············"················from\n"·+␊ -············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"·+␊ -············"················group·by\n"·+␊ +········.query("select\n"␊ +··+␊ +············"··················\"store_id\"·\"latest_id\",\n"␊ +··+␊ +············"··················max(\"store_type\")·\"latest_store_type\"\n"␊ +··+␊ +············"················from\n"␊ +··+␊ +············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"␊ +··+␊ +············"················group·by\n"␊ +··+␊ " \"store_id\"") .runs() .enable(CalciteAssert.DB == CalciteAssert.DatabaseInstance.HSQLDB) Run './gradlew autostyleApply' to fix the violations.
Linux (JDK 11), Avatica main: task ':core:autostyleJavaCheck'#L1
Execution failed for task ':core:autostyleJavaCheck': See 'What went wrong' below
Linux (JDK 11), Avatica main
Execution failed for task ':core:autostyleJavaCheck'. > The following files have format violations: core/src/main/java/org/apache/calcite/schema/Schemas.java @@ -132,7 +132,7 @@ public static SchemaPlus getExistingSubSchema(SchemaPlus schema, String name){ SchemaPlus subSchema = schema.getSubSchema(name); -····if·(·subSchema·==·null·)·{␊ +····if·(·subSchema·==·null)·{␊ throw new NoSuchElementException("Sub schema " + name + " not found in " + schema.getName()); } return subSchema; core/src/test/java/org/apache/calcite/test/JdbcAdapterTest.java @@ -1232,12 +1232,18 @@ @test void testAmbiguousColumn() { CalciteAssert.model(JdbcTest.FOODMART_SCOTT_MODEL) -········.query("select\n"·+␊ -············"··················\"store_id\"·\"latest_id\",\n"·+␊ -············"··················max(\"store_type\")·\"latest_store_type\"\n"·+␊ -············"················from\n"·+␊ -············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"·+␊ -············"················group·by\n"·+␊ +········.query("select\n"␊ +··+␊ +············"··················\"store_id\"·\"latest_id\",\n"␊ +··+␊ +············"··················max(\"store_type\")·\"latest_store_type\"\n"␊ +··+␊ +············"················from\n"␊ +··+␊ +············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"␊ +··+␊ +············"················group·by\n"␊ +··+␊ " \"store_id\"") .runs() .enable(CalciteAssert.DB == CalciteAssert.DatabaseInstance.HSQLDB) Run './gradlew autostyleApply' to fix the violations.
Windows (JDK 8): task ':core:autostyleJavaCheck'#L1
Execution failed for task ':core:autostyleJavaCheck': See 'What went wrong' below
Windows (JDK 8)
Execution failed for task ':core:autostyleJavaCheck'. > The following files have format violations: core\src\main\java\org\apache\calcite\schema\Schemas.java @@ -132,7 +132,7 @@ public static SchemaPlus getExistingSubSchema(SchemaPlus schema, String name){ SchemaPlus subSchema = schema.getSubSchema(name); - if ( subSchema == null ) {\r\n + if ( subSchema == null) {\r\n throw new NoSuchElementException("Sub schema " + name + " not found in " + schema.getName()); } return subSchema; core\src\test\java\org\apache\calcite\test\JdbcAdapterTest.java @@ -1232,12 +1232,18 @@ @test void testAmbiguousColumn() { CalciteAssert.model(JdbcTest.FOODMART_SCOTT_MODEL) - .query("select\n" +\r\n - " \"store_id\" \"latest_id\",\n" +\r\n - " max(\"store_type\") \"latest_store_type\"\n" +\r\n - " from\n" +\r\n - " ( SELECT \"store_id\",\"store_type\" FROM \"foodmart\".\"store\") \n" +\r\n - " group by\n" +\r\n + .query("select\n"\r\n + +\r\n + " \"store_id\" \"latest_id\",\n"\r\n + +\r\n + " max(\"store_type\") \"latest_store_type\"\n"\r\n + +\r\n + " from\n"\r\n + +\r\n + " ( SELECT \"store_id\",\"store_type\" FROM \"foodmart\".\"store\") \n"\r\n + +\r\n + " group by\n"\r\n + +\r\n " \"store_id\"") .runs() .enable(CalciteAssert.DB == CalciteAssert.DatabaseInstance.HSQLDB) Run './gradlew autostyleApply' to fix the violations.
Druid Tests: DruidAdapterIT.java#L4136
1.9sec org.apache.calcite.test.DruidAdapterIT > testAggOverStringToLong() java.sql.SQLException: Error while executing SQL "SELECT SUM(cast("product_id" AS INTEGER)) FROM "foodmart"": Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return java.lang.Integer.class; } at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:164) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:228) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$queryContains$10(CalciteAssert.java:1736) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1420) at org.apache.calcite.test.CalciteAssert$AssertQuery.queryContains(CalciteAssert.java:1735) at org.apache.calcite.test.DruidAdapterIT.testAggOverStringToLong(DruidAdapterIT.java:4136) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:387) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 4 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: java.lang.RuntimeException: Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return java.lang.Integer.class; } at org.apache.calcite.avatica.Helper.wrap(Helper.java:37) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:128) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1169) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:324) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:220) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:665) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:519) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:487) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:236) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:630) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:677) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:157) ... 6 more Caused by: org.codehaus.commons.compiler.CompileException: Line 3, Column 57: Assignment conversion not possible from type "java.lang.Object" to type "org.apache.calcite.rel.RelNode" at app//org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:13014) at app//org.codehaus.janino.UnitCompiler.assignmentConversion(UnitCompiler.java:11263) at app//org.codehaus.
Druid Tests: DruidAdapter2IT.java#L3475
1.9sec org.apache.calcite.test.DruidAdapter2IT > testAggOverStringToLong() java.sql.SQLException: Error while executing SQL "SELECT SUM(cast("product_id" AS INTEGER)) FROM "foodmart"": Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return java.lang.Integer.class; } at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:164) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:228) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$queryContains$10(CalciteAssert.java:1736) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1420) at org.apache.calcite.test.CalciteAssert$AssertQuery.queryContains(CalciteAssert.java:1735) at org.apache.calcite.test.DruidAdapter2IT.testAggOverStringToLong(DruidAdapter2IT.java:3475) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:387) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 4 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: java.lang.RuntimeException: Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return java.lang.Integer.class; } at org.apache.calcite.avatica.Helper.wrap(Helper.java:37) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:128) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1169) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:324) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:220) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:665) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:519) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:487) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:236) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:630) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:677) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:157) ... 6 more Caused by: org.codehaus.commons.compiler.CompileException: Line 3, Column 57: Assignment conversion not possible from type "java.lang.Object" to type "org.apache.calcite.rel.RelNode" at app//org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:13014) at app//org.codehaus.janino.UnitCompiler.assignmentConversion(UnitCompiler.java:11263) at app//org.codeha
Druid Tests: DruidAdapter2IT.java#L2710
0.5sec org.apache.calcite.test.DruidAdapter2IT > testIsNotNull() java.sql.SQLException: Error while executing SQL "select count(*) as c from "foodmart" where "product_id" is not null": Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return long.class; } at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:164) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:228) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$queryContains$10(CalciteAssert.java:1736) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1420) at org.apache.calcite.test.CalciteAssert$AssertQuery.queryContains(CalciteAssert.java:1735) at org.apache.calcite.test.DruidAdapter2IT.testIsNotNull(DruidAdapter2IT.java:2710) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:387) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 4 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: java.lang.RuntimeException: Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return long.class; } at org.apache.calcite.avatica.Helper.wrap(Helper.java:37) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:128) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1169) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:324) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:220) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:665) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:519) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:487) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:236) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:630) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:677) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:157) ... 6 more Caused by: org.codehaus.commons.compiler.CompileException: Line 3, Column 57: Assignment conversion not possible from type "java.lang.Object" to type "org.apache.calcite.rel.RelNode" at app//org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:13014) at app//org.codehaus.janino.UnitCompiler.assignmentConversion(UnitCompiler.java:11263) at app//org.codehaus.janino.UnitCompiler.access$3900(U
Druid Tests: DruidAdapter2IT.java#L3004
0.6sec org.apache.calcite.test.DruidAdapter2IT > testExpressionsFilterWithExtract() java.sql.SQLException: Error while executing SQL "SELECT COUNT(*) FROM "foodmart" where CAST((EXTRACT(MONTH FROM "timestamp") - 1 ) / 3 + 1 AS INTEGER) = 1": Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return long.class; } at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:164) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:228) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$queryContains$10(CalciteAssert.java:1736) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1420) at org.apache.calcite.test.CalciteAssert$AssertQuery.queryContains(CalciteAssert.java:1735) at org.apache.calcite.test.DruidAdapter2IT.testExpressionsFilterWithExtract(DruidAdapter2IT.java:3004) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:387) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 4 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: java.lang.RuntimeException: Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return long.class; } at org.apache.calcite.avatica.Helper.wrap(Helper.java:37) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:128) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1169) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:324) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:220) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:665) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:519) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:487) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:236) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:630) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:677) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:157) ... 6 more Caused by: org.codehaus.commons.compiler.CompileException: Line 3, Column 57: Assignment conversion not possible from type "java.lang.Object" to type "org.apache.calcite.rel.RelNode" at app//org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:13014) at app//org.codehaus.janino.UnitCompiler.assignmentConversion(UnitCompiler.j
Druid Tests: DruidAdapter2IT.java#L2346
0.2sec org.apache.calcite.test.DruidAdapter2IT > testOuterFilterFalseAfterFactorSimplification() java.sql.SQLException: Error while executing SQL "select sum("store_sales") filter (where "the_year" > 1997) from "foodmart" where "the_year" <= 1997": Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return java.lang.Double.class; } at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:164) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:228) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$queryContains$10(CalciteAssert.java:1736) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1420) at org.apache.calcite.test.CalciteAssert$AssertQuery.queryContains(CalciteAssert.java:1735) at org.apache.calcite.test.DruidAdapter2IT.testOuterFilterFalseAfterFactorSimplification(DruidAdapter2IT.java:2346) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:387) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 4 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: java.lang.RuntimeException: Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return java.lang.Double.class; } at org.apache.calcite.avatica.Helper.wrap(Helper.java:37) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:128) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1169) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:324) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:220) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:665) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:519) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:487) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:236) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:630) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:677) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:157) ... 6 more Caused by: org.codehaus.commons.compiler.CompileException: Line 3, Column 57: Assignment conversion not possible from type "java.lang.Object" to type "org.apache.calcite.rel.RelNode" at app//org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:13014) at app//org.codehaus.janino.UnitC
Druid Tests: DruidAdapter2IT.java#L1115
0.3sec org.apache.calcite.test.DruidAdapter2IT > testFilterTimestamp() java.sql.SQLException: Error while executing SQL "select count(*) as c from "foodmart" where extract(year from "timestamp") = 1997 and extract(month from "timestamp") in (4, 6) ": Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return long.class; } at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:164) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:228) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1481) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1420) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1479) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1469) at org.apache.calcite.test.CalciteAssert$AssertQuery.returnsUnordered(CalciteAssert.java:1491) at org.apache.calcite.test.DruidAdapter2IT.testFilterTimestamp(DruidAdapter2IT.java:1115) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:387) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 6 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: java.lang.RuntimeException: Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return long.class; } at org.apache.calcite.avatica.Helper.wrap(Helper.java:37) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:128) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1169) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:324) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:220) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:665) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:519) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:487) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:236) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:630) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:677) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:157) ... 8 more Caused by: org.codehaus.commons.compiler.CompileException: Line 3, Column 57: Assignment conversion not possible from type "java.lang.Object" to type "org.apache.calcite.rel.RelNode"
Druid Tests: DruidAdapter2IT.java#L1829
0.4sec org.apache.calcite.test.DruidAdapter2IT > testRecursiveArithmeticOperation() java.sql.SQLException: Error while executing SQL "select "store_state", -1 * (a + b) as c from (select (sum("store_sales")-sum("store_cost")) / (count(*) * 3) AS a,sum("unit_sales") AS b, "store_state" from "foodmart" group by "store_state") order by c desc": Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return interpreter; } public Class getElementType() { return java.lang.Object[].class; } at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:164) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:228) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1481) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1420) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1479) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1469) at org.apache.calcite.test.CalciteAssert$AssertQuery.returnsOrdered(CalciteAssert.java:1495) at org.apache.calcite.test.DruidAdapter2IT.testRecursiveArithmeticOperation(DruidAdapter2IT.java:1829) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:387) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 6 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: java.lang.RuntimeException: Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return interpreter; } public Class getElementType() { return java.lang.Object[].class; } at org.apache.calcite.avatica.Helper.wrap(Helper.java:37) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:128) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1169) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:324) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:220) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:665) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:519) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:487) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:236) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:630) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:677) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:157) ... 8 more Caused by: org.codehaus.commons.compiler.CompileException: Line 3, Column 57: Assignment conversion not possible from type "java.lang.Object" to type "
Druid Tests: DruidAdapter2IT.java#L743
0.2sec org.apache.calcite.test.DruidAdapter2IT > testGroupByOneColumnReversed() java.sql.SQLException: Error while executing SQL "select count(*) as c, "state_province" from "foodmart" group by "state_province" order by "state_province"": Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return interpreter; } public Class getElementType() { return java.lang.Object[].class; } at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:164) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:228) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1481) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1420) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1479) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1469) at org.apache.calcite.test.CalciteAssert$AssertQuery.returnsOrdered(CalciteAssert.java:1495) at org.apache.calcite.test.DruidAdapter2IT.testGroupByOneColumnReversed(DruidAdapter2IT.java:743) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=2 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:387) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 6 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: java.lang.RuntimeException: Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return interpreter; } public Class getElementType() { return java.lang.Object[].class; } at org.apache.calcite.avatica.Helper.wrap(Helper.java:37) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:128) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1169) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:324) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:220) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:665) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:519) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:487) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:236) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:630) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:677) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:157) ... 8 more Caused by: org.codehaus.commons.compiler.CompileException: Line 3, Column 57: Assignment conversion not possible from type "java.lang.Object" to type "org.apache.calcite.rel.RelNode" at app//org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.ja
Druid Tests: DruidAdapter2IT.java#L3107
0.1sec org.apache.calcite.test.DruidAdapter2IT > testCastPlusMathOps() java.sql.SQLException: Error while executing SQL "SELECT COUNT(*) FROM "foodmart"WHERE (CAST("product_id" AS INTEGER) + 1 * "store_sales")/("store_cost" - 5) <= floor("store_sales") * 25 + 2": Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return long.class; } at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:164) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:228) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$queryContains$10(CalciteAssert.java:1736) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1420) at org.apache.calcite.test.CalciteAssert$AssertQuery.queryContains(CalciteAssert.java:1735) at org.apache.calcite.test.DruidAdapter2IT.testCastPlusMathOps(DruidAdapter2IT.java:3107) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:387) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 4 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: java.lang.RuntimeException: Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return org.apache.calcite.runtime.Enumerables.slice0(interpreter); } public Class getElementType() { return long.class; } at org.apache.calcite.avatica.Helper.wrap(Helper.java:37) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:128) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1169) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:324) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:220) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:665) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:519) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:487) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:236) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:630) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:677) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:157) ... 6 more Caused by: org.codehaus.commons.compiler.CompileException: Line 3, Column 57: Assignment conversion not possible from type "java.lang.Object" to type "org.apache.calcite.rel.RelNode" at app//org.codehaus.janino.UnitCompiler.compileError(UnitCompiler.java:13014) at app//org.codehaus.janino.UnitCompiler.assignmentConversion(UnitCo
Druid Tests: DruidAdapterIT.java#L2133
0.5sec org.apache.calcite.test.DruidAdapterIT > testRecursiveArithmeticOperation() java.sql.SQLException: Error while executing SQL "select "store_state", -1 * (a + b) as c from (select (sum("store_sales")-sum("store_cost")) / (count(*) * 3) AS a,sum("unit_sales") AS b, "store_state" from "foodmart" group by "store_state") order by c desc": Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return interpreter; } public Class getElementType() { return java.lang.Object[].class; } at org.apache.calcite.avatica.Helper.createException(Helper.java:56) at org.apache.calcite.avatica.Helper.createException(Helper.java:41) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:164) at org.apache.calcite.avatica.AvaticaStatement.executeQuery(AvaticaStatement.java:228) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:566) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1481) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1420) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1479) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1469) at org.apache.calcite.test.CalciteAssert$AssertQuery.returnsOrdered(CalciteAssert.java:1495) at org.apache.calcite.test.DruidAdapterIT.testRecursiveArithmeticOperation(DruidAdapterIT.java:2133) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:387) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 6 more Next exception 1: [CIRCULAR REFERENCE SQLException] Next exception 2: java.lang.RuntimeException: Error while compiling generated Java code: public org.apache.calcite.linq4j.Enumerable bind(final org.apache.calcite.DataContext root) { final org.apache.calcite.rel.RelNode v1stashed = root.get("v1stashed", org.apache.calcite.rel.RelNode.class); final org.apache.calcite.interpreter.Interpreter interpreter = new org.apache.calcite.interpreter.Interpreter( root, v1stashed); return interpreter; } public Class getElementType() { return java.lang.Object[].class; } at org.apache.calcite.avatica.Helper.wrap(Helper.java:37) at org.apache.calcite.adapter.enumerable.EnumerableInterpretable.toBindable(EnumerableInterpretable.java:128) at org.apache.calcite.prepare.CalcitePrepareImpl$CalcitePreparingStmt.implement(CalcitePrepareImpl.java:1169) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:324) at org.apache.calcite.prepare.Prepare.prepareSql(Prepare.java:220) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare2_(CalcitePrepareImpl.java:665) at org.apache.calcite.prepare.CalcitePrepareImpl.prepare_(CalcitePrepareImpl.java:519) at org.apache.calcite.prepare.CalcitePrepareImpl.prepareSql(CalcitePrepareImpl.java:487) at org.apache.calcite.jdbc.CalciteConnectionImpl.parseQuery(CalciteConnectionImpl.java:236) at org.apache.calcite.jdbc.CalciteMetaImpl.prepareAndExecute(CalciteMetaImpl.java:630) at org.apache.calcite.avatica.AvaticaConnection.prepareAndExecuteInternal(AvaticaConnection.java:677) at org.apache.calcite.avatica.AvaticaStatement.executeInternal(AvaticaStatement.java:157) ... 8 more Caused by: org.codehaus.commons.compiler.CompileException: Line 3, Column 57: Assignment conversion not possible from type "java.lang.Object" to type "org
Linux (JDK 8), Oldest Guava, America/New_York Timezone: task ':core:autostyleJavaCheck'#L1
Execution failed for task ':core:autostyleJavaCheck': See 'What went wrong' below
Linux (JDK 8), Oldest Guava, America/New_York Timezone
Execution failed for task ':core:autostyleJavaCheck'. > The following files have format violations: core/src/main/java/org/apache/calcite/schema/Schemas.java @@ -132,7 +132,7 @@ public static SchemaPlus getExistingSubSchema(SchemaPlus schema, String name){ SchemaPlus subSchema = schema.getSubSchema(name); -····if·(·subSchema·==·null·)·{␊ +····if·(·subSchema·==·null)·{␊ throw new NoSuchElementException("Sub schema " + name + " not found in " + schema.getName()); } return subSchema; core/src/test/java/org/apache/calcite/test/JdbcAdapterTest.java @@ -1232,12 +1232,18 @@ @test void testAmbiguousColumn() { CalciteAssert.model(JdbcTest.FOODMART_SCOTT_MODEL) -········.query("select\n"·+␊ -············"··················\"store_id\"·\"latest_id\",\n"·+␊ -············"··················max(\"store_type\")·\"latest_store_type\"\n"·+␊ -············"················from\n"·+␊ -············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"·+␊ -············"················group·by\n"·+␊ +········.query("select\n"␊ +··+␊ +············"··················\"store_id\"·\"latest_id\",\n"␊ +··+␊ +············"··················max(\"store_type\")·\"latest_store_type\"\n"␊ +··+␊ +············"················from\n"␊ +··+␊ +············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"␊ +··+␊ +············"················group·by\n"␊ +··+␊ " \"store_id\"") .runs() .enable(CalciteAssert.DB == CalciteAssert.DatabaseInstance.HSQLDB) Run './gradlew autostyleApply' to fix the violations.
macOS (JDK 19): task ':core:autostyleJavaCheck'#L1
Execution failed for task ':core:autostyleJavaCheck': See 'What went wrong' below
macOS (JDK 19)
Execution failed for task ':core:autostyleJavaCheck'. > The following files have format violations: core/src/main/java/org/apache/calcite/schema/Schemas.java @@ -132,7 +132,7 @@ public static SchemaPlus getExistingSubSchema(SchemaPlus schema, String name){ SchemaPlus subSchema = schema.getSubSchema(name); -····if·(·subSchema·==·null·)·{␊ +····if·(·subSchema·==·null)·{␊ throw new NoSuchElementException("Sub schema " + name + " not found in " + schema.getName()); } return subSchema; core/src/test/java/org/apache/calcite/test/JdbcAdapterTest.java @@ -1232,12 +1232,18 @@ @test void testAmbiguousColumn() { CalciteAssert.model(JdbcTest.FOODMART_SCOTT_MODEL) -········.query("select\n"·+␊ -············"··················\"store_id\"·\"latest_id\",\n"·+␊ -············"··················max(\"store_type\")·\"latest_store_type\"\n"·+␊ -············"················from\n"·+␊ -············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"·+␊ -············"················group·by\n"·+␊ +········.query("select\n"␊ +··+␊ +············"··················\"store_id\"·\"latest_id\",\n"␊ +··+␊ +············"··················max(\"store_type\")·\"latest_store_type\"\n"␊ +··+␊ +············"················from\n"␊ +··+␊ +············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"␊ +··+␊ +············"················group·by\n"␊ +··+␊ " \"store_id\"") .runs() .enable(CalciteAssert.DB == CalciteAssert.DatabaseInstance.HSQLDB) Run './gradlew autostyleApply' to fix the violations.
Linux (JDK 8), Latest Guava, America/New_York Timezone: task ':core:autostyleJavaCheck'#L1
Execution failed for task ':core:autostyleJavaCheck': See 'What went wrong' below
Linux (JDK 8), Latest Guava, America/New_York Timezone
Execution failed for task ':core:autostyleJavaCheck'. > The following files have format violations: core/src/main/java/org/apache/calcite/schema/Schemas.java @@ -132,7 +132,7 @@ public static SchemaPlus getExistingSubSchema(SchemaPlus schema, String name){ SchemaPlus subSchema = schema.getSubSchema(name); -····if·(·subSchema·==·null·)·{␊ +····if·(·subSchema·==·null)·{␊ throw new NoSuchElementException("Sub schema " + name + " not found in " + schema.getName()); } return subSchema; core/src/test/java/org/apache/calcite/test/JdbcAdapterTest.java @@ -1232,12 +1232,18 @@ @test void testAmbiguousColumn() { CalciteAssert.model(JdbcTest.FOODMART_SCOTT_MODEL) -········.query("select\n"·+␊ -············"··················\"store_id\"·\"latest_id\",\n"·+␊ -············"··················max(\"store_type\")·\"latest_store_type\"\n"·+␊ -············"················from\n"·+␊ -············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"·+␊ -············"················group·by\n"·+␊ +········.query("select\n"␊ +··+␊ +············"··················\"store_id\"·\"latest_id\",\n"␊ +··+␊ +············"··················max(\"store_type\")·\"latest_store_type\"\n"␊ +··+␊ +············"················from\n"␊ +··+␊ +············"··················(·SELECT·\"store_id\",\"store_type\"·FROM·\"foodmart\".\"store\")·\n"␊ +··+␊ +············"················group·by\n"␊ +··+␊ " \"store_id\"") .runs() .enable(CalciteAssert.DB == CalciteAssert.DatabaseInstance.HSQLDB) Run './gradlew autostyleApply' to fix the violations.
Windows (JDK 17): task ':core:autostyleJavaCheck'#L1
Execution failed for task ':core:autostyleJavaCheck': See 'What went wrong' below
Windows (JDK 17)
Execution failed for task ':core:autostyleJavaCheck'. > The following files have format violations: core\src\main\java\org\apache\calcite\schema\Schemas.java @@ -132,7 +132,7 @@ public static SchemaPlus getExistingSubSchema(SchemaPlus schema, String name){ SchemaPlus subSchema = schema.getSubSchema(name); - if ( subSchema == null ) {\r\n + if ( subSchema == null) {\r\n throw new NoSuchElementException("Sub schema " + name + " not found in " + schema.getName()); } return subSchema; core\src\test\java\org\apache\calcite\test\JdbcAdapterTest.java @@ -1232,12 +1232,18 @@ @test void testAmbiguousColumn() { CalciteAssert.model(JdbcTest.FOODMART_SCOTT_MODEL) - .query("select\n" +\r\n - " \"store_id\" \"latest_id\",\n" +\r\n - " max(\"store_type\") \"latest_store_type\"\n" +\r\n - " from\n" +\r\n - " ( SELECT \"store_id\",\"store_type\" FROM \"foodmart\".\"store\") \n" +\r\n - " group by\n" +\r\n + .query("select\n"\r\n + +\r\n + " \"store_id\" \"latest_id\",\n"\r\n + +\r\n + " max(\"store_type\") \"latest_store_type\"\n"\r\n + +\r\n + " from\n"\r\n + +\r\n + " ( SELECT \"store_id\",\"store_type\" FROM \"foodmart\".\"store\") \n"\r\n + +\r\n + " group by\n"\r\n + +\r\n " \"store_id\"") .runs() .enable(CalciteAssert.DB == CalciteAssert.DatabaseInstance.HSQLDB) Run './gradlew autostyleApply' to fix the violations.
CheckerFramework (JDK 11), Guava 29: task ':core:compileJava'#L1
Execution failed for task ':core:compileJava': org.gradle.api.internal.tasks.compile.CompilationFailedException: Compilation failed; see the compiler error output for details. at org.gradle.api.internal.tasks.compile.JdkJavaCompiler.execute(JdkJavaCompiler.java:58) at org.gradle.api.internal.tasks.compile.JdkJavaCompiler.execute(JdkJavaCompiler.java:41) at org.gradle.api.internal.tasks.compile.daemon.AbstractDaemonCompiler$CompilerWorkAction.execute(AbstractDaemonCompiler.java:135) at org.gradle.workers.internal.DefaultWorkerServer.execute(DefaultWorkerServer.java:63) at org.gradle.workers.internal.AbstractClassLoaderWorker$1.create(AbstractClassLoaderWorker.java:49) at org.gradle.workers.internal.AbstractClassLoaderWorker$1.create(AbstractClassLoaderWorker.java:43) at org.gradle.internal.classloader.ClassLoaderUtils.executeInClassloader(ClassLoaderUtils.java:100) at org.gradle.workers.internal.AbstractClassLoaderWorker.executeInClassLoader(AbstractClassLoaderWorker.java:43) at org.gradle.workers.internal.FlatClassLoaderWorker.run(FlatClassLoaderWorker.java:32) at org.gradle.workers.internal.FlatClassLoaderWorker.run(FlatClassLoaderWorker.java:22) at org.gradle.workers.internal.WorkerDaemonServer.run(WorkerDaemonServer.java:87) at org.gradle.workers.internal.WorkerDaemonServer.run(WorkerDaemonServer.java:56) at org.gradle.process.internal.worker.request.WorkerAction$1.call(WorkerAction.java:138) at org.gradle.process.internal.worker.child.WorkerLogEventListener.withWorkerLoggingProtocol(WorkerLogEventListener.java:41) at org.gradle.process.internal.worker.request.WorkerAction.run(WorkerAction.java:135) at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:36) at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24) at org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:182) at org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:164) at org.gradle.internal.remote.internal.hub.MessageHub$Handler.run(MessageHub.java:414) at org.gradle.internal.concurrent.ExecutorPolicy$CatchAndRecordFailures.onExecute(ExecutorPolicy.java:64) at org.gradle.internal.concurrent.ManagedExecutorImpl$1.run(ManagedExecutorImpl.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829)
CheckerFramework (JDK 11), Guava 29
Execution failed for task ':core:compileJava'. > Compilation failed; see the compiler error output for details.
CheckerFramework (JDK 11), Guava 29: core/src/main/java/org/apache/calcite/adapter/jdbc/JdbcSchema.java#L297
[Task :core:compileJava] [return.type.incompatible] incompatible types in return. if ( string == null) return null; ^ type of expression: null (NullType)
CheckerFramework (JDK 11): task ':core:compileJava'#L1
Execution failed for task ':core:compileJava': org.gradle.api.internal.tasks.compile.CompilationFailedException: Compilation failed; see the compiler error output for details. at org.gradle.api.internal.tasks.compile.JdkJavaCompiler.execute(JdkJavaCompiler.java:58) at org.gradle.api.internal.tasks.compile.JdkJavaCompiler.execute(JdkJavaCompiler.java:41) at org.gradle.api.internal.tasks.compile.daemon.AbstractDaemonCompiler$CompilerWorkAction.execute(AbstractDaemonCompiler.java:135) at org.gradle.workers.internal.DefaultWorkerServer.execute(DefaultWorkerServer.java:63) at org.gradle.workers.internal.AbstractClassLoaderWorker$1.create(AbstractClassLoaderWorker.java:49) at org.gradle.workers.internal.AbstractClassLoaderWorker$1.create(AbstractClassLoaderWorker.java:43) at org.gradle.internal.classloader.ClassLoaderUtils.executeInClassloader(ClassLoaderUtils.java:100) at org.gradle.workers.internal.AbstractClassLoaderWorker.executeInClassLoader(AbstractClassLoaderWorker.java:43) at org.gradle.workers.internal.FlatClassLoaderWorker.run(FlatClassLoaderWorker.java:32) at org.gradle.workers.internal.FlatClassLoaderWorker.run(FlatClassLoaderWorker.java:22) at org.gradle.workers.internal.WorkerDaemonServer.run(WorkerDaemonServer.java:87) at org.gradle.workers.internal.WorkerDaemonServer.run(WorkerDaemonServer.java:56) at org.gradle.process.internal.worker.request.WorkerAction$1.call(WorkerAction.java:138) at org.gradle.process.internal.worker.child.WorkerLogEventListener.withWorkerLoggingProtocol(WorkerLogEventListener.java:41) at org.gradle.process.internal.worker.request.WorkerAction.run(WorkerAction.java:135) at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:36) at org.gradle.internal.dispatch.ReflectionDispatch.dispatch(ReflectionDispatch.java:24) at org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:182) at org.gradle.internal.remote.internal.hub.MessageHubBackedObjectConnection$DispatchWrapper.dispatch(MessageHubBackedObjectConnection.java:164) at org.gradle.internal.remote.internal.hub.MessageHub$Handler.run(MessageHub.java:414) at org.gradle.internal.concurrent.ExecutorPolicy$CatchAndRecordFailures.onExecute(ExecutorPolicy.java:64) at org.gradle.internal.concurrent.ManagedExecutorImpl$1.run(ManagedExecutorImpl.java:49) at java.base/java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) at java.base/java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) at java.base/java.lang.Thread.run(Thread.java:829)
CheckerFramework (JDK 11)
Execution failed for task ':core:compileJava'. > Compilation failed; see the compiler error output for details.
CheckerFramework (JDK 11): core/src/main/java/org/apache/calcite/adapter/jdbc/JdbcSchema.java#L297
[Task :core:compileJava] [return.type.incompatible] incompatible types in return. if ( string == null) return null; ^ type of expression: null (NullType)
Linux (JDK 19)
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Linux (JDK 11), Pacific/Chatham Timezone
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Linux (JDK 17)
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Linux (JDK 11), Avatica main
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Windows (JDK 8)
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Druid Tests
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Error Prone (JDK 11), Guava 31
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Linux (JDK 8), Oldest Guava, America/New_York Timezone
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
macOS (JDK 19)
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Linux (JDK 8), Latest Guava, America/New_York Timezone
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
Windows (JDK 17)
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
CheckerFramework (JDK 11), Guava 29
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/
CheckerFramework (JDK 11)
The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/