[CALCITE-6525] Query with one-to-many join of measure to regular table (draft) #13498
Annotations
4 errors and 2 warnings
org.apache.calcite.test.CoreQuidemTest > test(String)[18%5D#L1
2.1sec org.apache.calcite.test.CoreQuidemTest > test(String)[18], [18] sql/measure.iq
org.opentest4j.AssertionFailedError: Files differ: /home/runner/work/calcite/calcite/core/build/quidem/test/sql/measure.iq /home/runner/work/calcite/calcite/core/build/resources/test/sql/measure.iq
403a404,569
> java.sql.SQLException: Error while executing SQL "with deptm as
> (select deptno, dname, avg(char_length(dname)) as measure m
> from dept)
> select aggregate(m) as m
> from deptm join emp using (deptno)": expand(rel#188724:LogicalJoin.NONE.[](left=HepRelVertex#188720,right=HepRelVertex#188723,condition==($0, $3),joinType=inner), 1, org.apache.calcite.rel.metadata.RelMdMeasure$Contexts$1@466aa03d
> 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 net.hydromatic.quidem.Quidem.checkResult(Quidem.java:299)
> at net.hydromatic.quidem.Quidem.access$2600(Quidem.java:57)
> at net.hydromatic.quidem.Quidem$ContextImpl.checkResult(Quidem.java:1636)
> at net.hydromatic.quidem.Quidem$CheckResultCommand.execute(Quidem.java:941)
> at net.hydromatic.quidem.Quidem$CompositeCommand.execute(Quidem.java:1437)
> at net.hydromatic.quidem.Quidem.execute(Quidem.java:190)
> at org.apache.calcite.test.QuidemTest.checkRun(QuidemTest.java:178)
> at org.apache.calcite.test.QuidemTest.test(QuidemTest.java:239)
> at jdk.internal.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
> at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
> at java.base/java.lang.reflect.Method.invoke(Method.java:566)
> at org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:727)
> at org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
> at org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
> at org.junit.jupiter.engine.extension.SameThreadTimeoutInvocation.proceed(SameThreadTimeoutInvocation.java:45)
> at org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:156)
> at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestableMethod(TimeoutExtension.java:147)
> at org.junit.jupiter.engine.extension.TimeoutExtension.interceptTestTemplateMethod(TimeoutExtension.java:94)
> at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(InterceptingExecutableInvoker.java:103)
> at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.lambda$invoke$0(InterceptingExecutableInvoker.java:93)
> at org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
> at org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
> at org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
> at org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
> at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:92)
> at org.junit.jupiter.engine.execution.InterceptingExecutableInvoker.invoke(InterceptingExecutableInvoker.java:86)
> at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.lambda$invokeTestMethod$7(TestMethodTestDescriptor.java:217)
> at org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
> at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.invokeTestMethod(TestMethodTestDescriptor.java:213)
> at org.junit.jupiter.engine.descriptor.TestMethodTestDescriptor.execute(TestMethodTestDescriptor.java:138)
> at org.junit.jupiter.engine.descriptor.Te
|
RelOptRulesTest.java#L6080
0.0sec org.apache.calcite.test.RelOptRulesTest > testMeasureJoin()
java.lang.UnsupportedOperationException: expand(rel#528968:LogicalJoin.(left=HepRelVertex#528966,right=HepRelVertex#528967,condition==($0, $10),joinType=inner), 2, org.apache.calcite.rel.metadata.RelMdMeasure$Contexts$1@5ab560f5
at org.apache.calcite.rel.metadata.RelMdMeasure.expand(RelMdMeasure.java:80)
at org.apache.calcite.rel.metadata.RelMetadataQuery.expand(RelMetadataQuery.java:842)
at org.apache.calcite.rel.metadata.RelMdMeasure.expand(RelMdMeasure.java:109)
at org.apache.calcite.rel.metadata.RelMetadataQuery.expand(RelMetadataQuery.java:842)
at org.apache.calcite.rel.metadata.RelMdMeasure.expand(RelMdMeasure.java:144)
at org.apache.calcite.rel.metadata.RelMetadataQuery.expand(RelMetadataQuery.java:842)
at org.apache.calcite.rel.rules.MeasureRules$AggregateMeasure2Rule.lambda$onMatch$3(MeasureRules.java:311)
at org.apache.calcite.rel.rules.MeasureRules$AggregateMeasure2Rule.lambda$bind$8(MeasureRules.java:335)
at java.base/java.util.ArrayList.forEach(ArrayList.java:1541)
at org.apache.calcite.rel.rules.MeasureRules$AggregateMeasure2Rule.lambda$bind$9(MeasureRules.java:335)
at org.apache.calcite.rel.rules.MeasureRules$AggregateMeasure2Rule.onMatch(MeasureRules.java:325)
at org.apache.calcite.plan.AbstractRelOptPlanner.fireRule(AbstractRelOptPlanner.java:336)
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:422)
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.test.RelOptFixture.checkPlanning(RelOptFixture.java:383)
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.testMeasureJoin(RelOptRulesTest.java:6080)
|
task ':core:test'#L1
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
|
|
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/
|
The following actions use a deprecated Node.js version and will be forced to run on node20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more info: https://github.blog/changelog/2024-03-07-github-actions-all-actions-will-run-on-node20-instead-of-node16-by-default/
|
This job failed
Loading