0.0sec org.apache.calcite.sql.test.SqlAdvisorTest > testJoin() java.lang.AssertionError: Expected: is "CATALOG(CATALOG)\nKEYWORD(()\nKEYWORD(LATERAL)\nKEYWORD(TABLE)\nKEYWORD(UNNEST)\nSCHEMA(CATALOG.CUSTOMER)\nSCHEMA(CATALOG.SALES)\nSCHEMA(CATALOG.SALES.NEST)\nSCHEMA(CATALOG.STRUCT)\nTABLE(CATALOG.SALES.BONUS)\nTABLE(CATALOG.SALES.DEPT)\nTABLE(CATALOG.SALES.DEPTNULLABLES)\nTABLE(CATALOG.SALES.DEPT_NESTED)\nTABLE(CATALOG.SALES.DEPT_NESTED_EXPANDED)\nTABLE(CATALOG.SALES.DEPT_R)\nTABLE(CATALOG.SALES.DEPT_SINGLE)\nTABLE(CATALOG.SALES.EMP)\nTABLE(CATALOG.SALES.EMPDEFAULTS)\nTABLE(CATALOG.SALES.EMPNULLABLES)\nTABLE(CATALOG.SALES.EMPNULLABLES_20)\nTABLE(CATALOG.SALES.EMPTY_PRODUCTS)\nTABLE(CATALOG.SALES.EMP_20)\nTABLE(CATALOG.SALES.EMP_ADDRESS)\nTABLE(CATALOG.SALES.EMP_B)\nTABLE(CATALOG.SALES.EMP_R)\nTABLE(CATALOG.SALES.ORDERS)\nTABLE(CATALOG.SALES.PRODUCTS)\nTABLE(CATALOG.SALES.PRODUCTS_TEMPORAL)\nTABLE(CATALOG.SALES.SALGRADE)\nTABLE(CATALOG.SALES.SHIPMENTS)\nTABLE(CATALOG.SALES.SUPPLIERS)\n" but: was "CATALOG(CATALOG)\nKEYWORD(()\nKEYWORD(LATERAL)\nKEYWORD(TABLE)\nKEYWORD(UNNEST)\nSCHEMA(CATALOG.CUSTOMER)\nSCHEMA(CATALOG.SALES)\nSCHEMA(CATALOG.SALES.NEST)\nSCHEMA(CATALOG.STRUCT)\nTABLE(CATALOG.SALES.BONUS)\nTABLE(CATALOG.SALES.DEPT)\nTABLE(CATALOG.SALES.DEPTNULLABLES)\nTABLE(CATALOG.SALES.DEPT_NESTED)\nTABLE(CATALOG.SALES.DEPT_NESTED_EXPANDED)\nTABLE(CATALOG.SALES.DEPT_R)\nTABLE(CATALOG.SALES.DEPT_SINGLE)\nTABLE(CATALOG.SALES.EMP)\nTABLE(CATALOG.SALES.EMPDEFAULTS)\nTABLE(CATALOG.SALES.EMPNULLABLES)\nTABLE(CATALOG.SALES.EMPNULLABLES_20)\nTABLE(CATALOG.SALES.EMPTY_PRODUCTS)\nTABLE(CATALOG.SALES.EMP_20)\nTABLE(CATALOG.SALES.EMP_ADDRESS)\nTABLE(CATALOG.SALES.EMP_B)\nTABLE(CATALOG.SALES.EMP_R)\nTABLE(CATALOG.SALES.ORDERS)\nTABLE(CATALOG.SALES.PRODUCTS)\nTABLE(CATALOG.SALES.PRODUCTS_TEMPORAL)\nTABLE(CATALOG.SALES.PROJECT)\nTABLE(CATALOG.SALES.SALGRADE)\nTABLE(CATALOG.SALES.SHIPMENTS)\nTABLE(CATALOG.SALES.SUPPLIERS)\n" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.sql.test.SqlAdvisorTest$Fixture.assertHint(SqlAdvisorTest.java:1574) at org.apache.calcite.sql.test.SqlAdvisorTest$Fixture.assertHint(SqlAdvisorTest.java:1558) at org.apache.calcite.sql.test.SqlAdvisorTest.testJoin(SqlAdvisorTest.java:471)

0.0sec org.apache.calcite.sql.test.SqlAdvisorTest > testFrom() java.lang.AssertionError: Expected: is "CATALOG(CATALOG)\nKEYWORD(()\nKEYWORD(LATERAL)\nKEYWORD(TABLE)\nKEYWORD(UNNEST)\nSCHEMA(CATALOG.CUSTOMER)\nSCHEMA(CATALOG.SALES)\nSCHEMA(CATALOG.SALES.NEST)\nSCHEMA(CATALOG.STRUCT)\nTABLE(CATALOG.SALES.BONUS)\nTABLE(CATALOG.SALES.DEPT)\nTABLE(CATALOG.SALES.DEPTNULLABLES)\nTABLE(CATALOG.SALES.DEPT_NESTED)\nTABLE(CATALOG.SALES.DEPT_NESTED_EXPANDED)\nTABLE(CATALOG.SALES.DEPT_R)\nTABLE(CATALOG.SALES.DEPT_SINGLE)\nTABLE(CATALOG.SALES.EMP)\nTABLE(CATALOG.SALES.EMPDEFAULTS)\nTABLE(CATALOG.SALES.EMPNULLABLES)\nTABLE(CATALOG.SALES.EMPNULLABLES_20)\nTABLE(CATALOG.SALES.EMPTY_PRODUCTS)\nTABLE(CATALOG.SALES.EMP_20)\nTABLE(CATALOG.SALES.EMP_ADDRESS)\nTABLE(CATALOG.SALES.EMP_B)\nTABLE(CATALOG.SALES.EMP_R)\nTABLE(CATALOG.SALES.ORDERS)\nTABLE(CATALOG.SALES.PRODUCTS)\nTABLE(CATALOG.SALES.PRODUCTS_TEMPORAL)\nTABLE(CATALOG.SALES.SALGRADE)\nTABLE(CATALOG.SALES.SHIPMENTS)\nTABLE(CATALOG.SALES.SUPPLIERS)\n" but: was "CATALOG(CATALOG)\nKEYWORD(()\nKEYWORD(LATERAL)\nKEYWORD(TABLE)\nKEYWORD(UNNEST)\nSCHEMA(CATALOG.CUSTOMER)\nSCHEMA(CATALOG.SALES)\nSCHEMA(CATALOG.SALES.NEST)\nSCHEMA(CATALOG.STRUCT)\nTABLE(CATALOG.SALES.BONUS)\nTABLE(CATALOG.SALES.DEPT)\nTABLE(CATALOG.SALES.DEPTNULLABLES)\nTABLE(CATALOG.SALES.DEPT_NESTED)\nTABLE(CATALOG.SALES.DEPT_NESTED_EXPANDED)\nTABLE(CATALOG.SALES.DEPT_R)\nTABLE(CATALOG.SALES.DEPT_SINGLE)\nTABLE(CATALOG.SALES.EMP)\nTABLE(CATALOG.SALES.EMPDEFAULTS)\nTABLE(CATALOG.SALES.EMPNULLABLES)\nTABLE(CATALOG.SALES.EMPNULLABLES_20)\nTABLE(CATALOG.SALES.EMPTY_PRODUCTS)\nTABLE(CATALOG.SALES.EMP_20)\nTABLE(CATALOG.SALES.EMP_ADDRESS)\nTABLE(CATALOG.SALES.EMP_B)\nTABLE(CATALOG.SALES.EMP_R)\nTABLE(CATALOG.SALES.ORDERS)\nTABLE(CATALOG.SALES.PRODUCTS)\nTABLE(CATALOG.SALES.PRODUCTS_TEMPORAL)\nTABLE(CATALOG.SALES.PROJECT)\nTABLE(CATALOG.SALES.SALGRADE)\nTABLE(CATALOG.SALES.SHIPMENTS)\nTABLE(CATALOG.SALES.SUPPLIERS)\n" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.sql.test.SqlAdvisorTest$Fixture.assertHint(SqlAdvisorTest.java:1574) at org.apache.calcite.sql.test.SqlAdvisorTest$Fixture.assertHint(SqlAdvisorTest.java:1558) at org.apache.calcite.sql.test.SqlAdvisorTest.testFrom(SqlAdvisorTest.java:437)

0.1sec org.apache.calcite.sql.test.SqlAdvisorTest > testSubQuery() java.lang.AssertionError: Completion hints for select t.x from (select 1 as x, 2 as y from sales.^)^ as t Expected: is "SCHEMA(CATALOG.SALES)\nSCHEMA(CATALOG.SALES.NEST)\nTABLE(CATALOG.SALES.BONUS)\nTABLE(CATALOG.SALES.DEPT)\nTABLE(CATALOG.SALES.DEPTNULLABLES)\nTABLE(CATALOG.SALES.DEPT_NESTED)\nTABLE(CATALOG.SALES.DEPT_NESTED_EXPANDED)\nTABLE(CATALOG.SALES.DEPT_R)\nTABLE(CATALOG.SALES.DEPT_SINGLE)\nTABLE(CATALOG.SALES.EMP)\nTABLE(CATALOG.SALES.EMPDEFAULTS)\nTABLE(CATALOG.SALES.EMPNULLABLES)\nTABLE(CATALOG.SALES.EMPNULLABLES_20)\nTABLE(CATALOG.SALES.EMPTY_PRODUCTS)\nTABLE(CATALOG.SALES.EMP_20)\nTABLE(CATALOG.SALES.EMP_ADDRESS)\nTABLE(CATALOG.SALES.EMP_B)\nTABLE(CATALOG.SALES.EMP_R)\nTABLE(CATALOG.SALES.ORDERS)\nTABLE(CATALOG.SALES.PRODUCTS)\nTABLE(CATALOG.SALES.PRODUCTS_TEMPORAL)\nTABLE(CATALOG.SALES.SALGRADE)\nTABLE(CATALOG.SALES.SHIPMENTS)\nTABLE(CATALOG.SALES.SUPPLIERS)\n" but: was "SCHEMA(CATALOG.SALES)\nSCHEMA(CATALOG.SALES.NEST)\nTABLE(CATALOG.SALES.BONUS)\nTABLE(CATALOG.SALES.DEPT)\nTABLE(CATALOG.SALES.DEPTNULLABLES)\nTABLE(CATALOG.SALES.DEPT_NESTED)\nTABLE(CATALOG.SALES.DEPT_NESTED_EXPANDED)\nTABLE(CATALOG.SALES.DEPT_R)\nTABLE(CATALOG.SALES.DEPT_SINGLE)\nTABLE(CATALOG.SALES.EMP)\nTABLE(CATALOG.SALES.EMPDEFAULTS)\nTABLE(CATALOG.SALES.EMPNULLABLES)\nTABLE(CATALOG.SALES.EMPNULLABLES_20)\nTABLE(CATALOG.SALES.EMPTY_PRODUCTS)\nTABLE(CATALOG.SALES.EMP_20)\nTABLE(CATALOG.SALES.EMP_ADDRESS)\nTABLE(CATALOG.SALES.EMP_B)\nTABLE(CATALOG.SALES.EMP_R)\nTABLE(CATALOG.SALES.ORDERS)\nTABLE(CATALOG.SALES.PRODUCTS)\nTABLE(CATALOG.SALES.PRODUCTS_TEMPORAL)\nTABLE(CATALOG.SALES.PROJECT)\nTABLE(CATALOG.SALES.SALGRADE)\nTABLE(CATALOG.SALES.SHIPMENTS)\nTABLE(CATALOG.SALES.SUPPLIERS)\n" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.SqlAdvisorTest$Fixture.assertComplete(SqlAdvisorTest.java:1623) at org.apache.calcite.sql.test.SqlAdvisorTest$Fixture.assertComplete(SqlAdvisorTest.java:1598) at org.apache.calcite.sql.test.SqlAdvisorTest$Fixture.assertComplete(SqlAdvisorTest.java:1591) at org.apache.calcite.sql.test.SqlAdvisorTest.testSubQuery(SqlAdvisorTest.java:822)

0.0sec org.apache.calcite.sql.test.SqlAdvisorTest > testFromComplete() java.lang.AssertionError: Completion hints for select a.empno, b.deptno from dummy a, sales.^^ Expected: is "SCHEMA(CATALOG.SALES)\nSCHEMA(CATALOG.SALES.NEST)\nTABLE(CATALOG.SALES.BONUS)\nTABLE(CATALOG.SALES.DEPT)\nTABLE(CATALOG.SALES.DEPTNULLABLES)\nTABLE(CATALOG.SALES.DEPT_NESTED)\nTABLE(CATALOG.SALES.DEPT_NESTED_EXPANDED)\nTABLE(CATALOG.SALES.DEPT_R)\nTABLE(CATALOG.SALES.DEPT_SINGLE)\nTABLE(CATALOG.SALES.EMP)\nTABLE(CATALOG.SALES.EMPDEFAULTS)\nTABLE(CATALOG.SALES.EMPNULLABLES)\nTABLE(CATALOG.SALES.EMPNULLABLES_20)\nTABLE(CATALOG.SALES.EMPTY_PRODUCTS)\nTABLE(CATALOG.SALES.EMP_20)\nTABLE(CATALOG.SALES.EMP_ADDRESS)\nTABLE(CATALOG.SALES.EMP_B)\nTABLE(CATALOG.SALES.EMP_R)\nTABLE(CATALOG.SALES.ORDERS)\nTABLE(CATALOG.SALES.PRODUCTS)\nTABLE(CATALOG.SALES.PRODUCTS_TEMPORAL)\nTABLE(CATALOG.SALES.SALGRADE)\nTABLE(CATALOG.SALES.SHIPMENTS)\nTABLE(CATALOG.SALES.SUPPLIERS)\n" but: was "SCHEMA(CATALOG.SALES)\nSCHEMA(CATALOG.SALES.NEST)\nTABLE(CATALOG.SALES.BONUS)\nTABLE(CATALOG.SALES.DEPT)\nTABLE(CATALOG.SALES.DEPTNULLABLES)\nTABLE(CATALOG.SALES.DEPT_NESTED)\nTABLE(CATALOG.SALES.DEPT_NESTED_EXPANDED)\nTABLE(CATALOG.SALES.DEPT_R)\nTABLE(CATALOG.SALES.DEPT_SINGLE)\nTABLE(CATALOG.SALES.EMP)\nTABLE(CATALOG.SALES.EMPDEFAULTS)\nTABLE(CATALOG.SALES.EMPNULLABLES)\nTABLE(CATALOG.SALES.EMPNULLABLES_20)\nTABLE(CATALOG.SALES.EMPTY_PRODUCTS)\nTABLE(CATALOG.SALES.EMP_20)\nTABLE(CATALOG.SALES.EMP_ADDRESS)\nTABLE(CATALOG.SALES.EMP_B)\nTABLE(CATALOG.SALES.EMP_R)\nTABLE(CATALOG.SALES.ORDERS)\nTABLE(CATALOG.SALES.PRODUCTS)\nTABLE(CATALOG.SALES.PRODUCTS_TEMPORAL)\nTABLE(CATALOG.SALES.PROJECT)\nTABLE(CATALOG.SALES.SALGRADE)\nTABLE(CATALOG.SALES.SHIPMENTS)\nTABLE(CATALOG.SALES.SUPPLIERS)\n" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.apache.calcite.sql.test.SqlAdvisorTest$Fixture.assertComplete(SqlAdvisorTest.java:1623) at org.apache.calcite.sql.test.SqlAdvisorTest$Fixture.assertComplete(SqlAdvisorTest.java:1598) at org.apache.calcite.sql.test.SqlAdvisorTest$Fixture.assertComplete(SqlAdvisorTest.java:1591) at org.apache.calcite.sql.test.SqlAdvisorTest.testFromComplete(SqlAdvisorTest.java:453)

0.0sec org.apache.calcite.test.RelOptRulesTest > testNestedExistsSubQueriesWithCommonCorrelationVariable() java.lang.AssertionError: contains $cor0 at org.apache.calcite.util.Litmus.lambda$static$0(Litmus.java:31) at org.apache.calcite.plan.RelOptUtil.notContainsCorrelation(RelOptUtil.java:345) at org.apache.calcite.rel.core.Correlate.isValid(Correlate.java:147) at org.apache.calcite.rel.core.Correlate.<init>(Correlate.java:109) at org.apache.calcite.rel.logical.LogicalCorrelate.<init>(LogicalCorrelate.java:73) at org.apache.calcite.rel.logical.LogicalCorrelate.copy(LogicalCorrelate.java:133) at org.apache.calcite.rel.logical.LogicalCorrelate.copy(LogicalCorrelate.java:49) at org.apache.calcite.rel.core.Correlate.copy(Correlate.java:152) at org.apache.calcite.rel.rules.FilterCorrelateRule.onMatch(FilterCorrelateRule.java:109) at org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:350) at org.apache.calcite.plan.hep.HepPlanner.applyRule(HepPlanner.java:556) at org.apache.calcite.plan.hep.HepPlanner.applyRules(HepPlanner.java:420) at org.apache.calcite.plan.hep.HepPlanner.executeRuleInstance(HepPlanner.java:243) at org.apache.calcite.plan.hep.HepInstruction$RuleInstance$State.execute(HepInstruction.java:178) at org.apache.calcite.plan.hep.HepPlanner.lambda$executeProgram$0(HepPlanner.java:211) at com.google.common.collect.ImmutableList.forEach(ImmutableList.java:408) at org.apache.calcite.plan.hep.HepPlanner.executeProgram(HepPlanner.java:210) at org.apache.calcite.plan.hep.HepProgram$State.execute(HepProgram.java:118) at org.apache.calcite.plan.hep.HepPlanner.executeProgram(HepPlanner.java:205) at org.apache.calcite.plan.hep.HepPlanner.findBestExp(HepPlanner.java:191) at org.apache.calcite.sql2rel.RelDecorrelator.decorrelate(RelDecorrelator.java:313) at org.apache.calcite.sql2rel.RelDecorrelator.decorrelateQuery(RelDecorrelator.java:250) at org.apache.calcite.sql2rel.RelDecorrelator.decorrelateQuery(RelDecorrelator.java:210) at org.apache.calcite.test.RelOptFixture.checkPlanning(RelOptFixture.java:392) at org.apache.calcite.test.RelOptFixture.check(RelOptFixture.java:334) at org.apache.calcite.test.RelOptFixture.check(RelOptFixture.java:318) at org.apache.calcite.test.RelOptRulesTest.testNestedExistsSubQueriesWithCommonCorrelationVariable(RelOptRulesTest.java:8446)

Execution failed for task ':core:test': org.gradle.api.internal.exceptions.MarkedVerificationException: There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/core/build/reports/tests/test/index.html

Execution failed for task ':core:checkstyleTest': org.gradle.workers.internal.DefaultWorkerExecutor$WorkExecutionException: A failure occurred while executing org.gradle.api.plugins.quality.internal.CheckstyleAction at org.gradle.workers.internal.DefaultWorkerExecutor$WorkItemExecution.waitForCompletion(DefaultWorkerExecutor.java:287) at org.gradle.internal.work.DefaultAsyncWorkTracker.lambda$waitForItemsAndGatherFailures$2(DefaultAsyncWorkTracker.java:130) at org.gradle.internal.Factories$1.create(Factories.java:31) at org.gradle.internal.work.DefaultWorkerLeaseService.withoutLocks(DefaultWorkerLeaseService.java:336) at org.gradle.internal.work.DefaultWorkerLeaseService.withoutLocks(DefaultWorkerLeaseService.java:319) at org.gradle.internal.work.DefaultWorkerLeaseService.withoutLock(DefaultWorkerLeaseService.java:324) at org.gradle.internal.work.DefaultAsyncWorkTracker.waitForItemsAndGatherFailures(DefaultAsyncWorkTracker.java:126) at org.gradle.internal.work.DefaultAsyncWorkTracker.lambda$waitForItemsAndGatherFailures$0(DefaultAsyncWorkTracker.java:100) at org.gradle.internal.Factories$1.create(Factories.java:31) at org.gradle.internal.work.DefaultWorkerLeaseService.withoutLocks(DefaultWorkerLeaseService.java:336) at org.gradle.internal.work.DefaultWorkerLeaseService.runAsIsolatedTask(DefaultWorkerLeaseService.java:212) at org.gradle.internal.work.DefaultWorkerLeaseService.runAsIsolatedTask(DefaultWorkerLeaseService.java:201) at org.gradle.internal.work.DefaultAsyncWorkTracker.waitForItemsAndGatherFailures(DefaultAsyncWorkTracker.java:100) at org.gradle.internal.work.DefaultAsyncWorkTracker.waitForAll(DefaultAsyncWorkTracker.java:78) at org.gradle.internal.work.DefaultAsyncWorkTracker.waitForCompletion(DefaultAsyncWorkTracker.java:66) at org.gradle.api.internal.tasks.execution.TaskExecution$3.run(TaskExecution.java:252) at org.gradle.internal.operations.DefaultBuildOperationRunner$1.execute(DefaultBuildOperationRunner.java:29) at org.gradle.internal.operations.DefaultBuildOperationRunner$1.execute(DefaultBuildOperationRunner.java:26) at org.gradle.internal.operations.DefaultBuildOperationRunner$2.execute(DefaultBuildOperationRunner.java:66) at org.gradle.internal.operations.DefaultBuildOperationRunner$2.execute(DefaultBuildOperationRunner.java:59) at org.gradle.internal.operations.DefaultBuildOperationRunner.execute(DefaultBuildOperationRunner.java:157) at org.gradle.internal.operations.DefaultBuildOperationRunner.execute(DefaultBuildOperationRunner.java:59) at org.gradle.internal.operations.DefaultBuildOperationRunner.run(DefaultBuildOperationRunner.java:47) at org.gradle.internal.operations.DefaultBuildOperationExecutor.run(DefaultBuildOperationExecutor.java:68) at org.gradle.api.internal.tasks.execution.TaskExecution.executeAction(TaskExecution.java:229) at org.gradle.api.internal.tasks.execution.TaskExecution.executeActions(TaskExecution.java:212) at org.gradle.api.internal.tasks.execution.TaskExecution.executeWithPreviousOutputFiles(TaskExecution.java:195) at org.gradle.api.internal.tasks.execution.TaskExecution.execute(TaskExecution.java:162) at org.gradle.internal.execution.steps.ExecuteStep.executeInternal(ExecuteStep.java:105) at org.gradle.internal.execution.steps.ExecuteStep.access$000(ExecuteStep.java:44) at org.gradle.internal.execution.steps.ExecuteStep$1.call(ExecuteStep.java:59) at org.gradle.internal.execution.steps.ExecuteStep$1.call(ExecuteStep.java:56) at org.gradle.internal.operations.DefaultBuildOperationRunner$CallableBuildOperationWorker.execute(DefaultBuildOperationRunner.java:200) at org.gradle.internal.operations.DefaultBuildOperationRunner$CallableBuildOperationWorker.execute(DefaultBuildOperationRunner.java:195) at org.gradle.internal.operations.DefaultBuildOperationRunner$2.execute(DefaultBuildOperationRunner.j

Execution failed for task ':core:test'. > There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/core/build/reports/tests/test/index.html ============================================================================== 2: Task failed with an exception. -----------

[Task :core:checkstyleTest] [WhitespaceAround] '=' is not followed by whitespace.

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/