See
<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/267/display/redirect?page=changes>
Changes:
[Benchao Li] [CALCITE-4982] Do not push 'cast to not null' through Join in
ProjectJoinTransposeRule
------------------------------------------
[...truncated 749.00 KB...]
< <Resource name="sql">
< <![CDATA[select * from emp
< where exists (
< with dept2 as (select * from dept where dept.deptno >= emp.deptno)
< select 1 from dept2 where deptno <= emp.deptno)]]>
< </Resource>
< <Resource name="plan">
< <![CDATA[
< LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3], HIREDATE=[$4],
SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
< LogicalFilter(condition=[EXISTS({
< LogicalFilter(condition=[<=($0, $cor1.DEPTNO)])
< LogicalProject(DEPTNO=[$0], NAME=[$1])
< LogicalFilter(condition=[>=($0, $cor1.DEPTNO)])
< LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
< })], variablesSet=[[$cor1]])
< LogicalTableScan(table=[[CATALOG, SALES, EMP]])
< ]]>
< </Resource>
< </TestCase>
< <TestCase name="testWithOrder">
< <Resource name="sql">
< <![CDATA[with emp2 as (select * from emp)
< select * from emp2 order by deptno]]>
< </Resource>
< <Resource name="plan">
< <![CDATA[
< LogicalSort(sort0=[$7], dir0=[ASC])
< LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3],
HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
< LogicalTableScan(table=[[CATALOG, SALES, EMP]])
< ]]>
< </Resource>
< </TestCase>
< <TestCase name="testWithUnion">
< <Resource name="sql">
< <![CDATA[with emp2 as (select * from emp where deptno > 10)
< select empno from emp2 where deptno < 30
< union all
< select deptno from emp]]>
< </Resource>
< <Resource name="plan">
< <![CDATA[
< LogicalUnion(all=[true])
< LogicalProject(EMPNO=[$0])
< LogicalFilter(condition=[<($7, 30)])
< LogicalProject(EMPNO=[$0], ENAME=[$1], JOB=[$2], MGR=[$3],
HIREDATE=[$4], SAL=[$5], COMM=[$6], DEPTNO=[$7], SLACKER=[$8])
< LogicalFilter(condition=[>($7, 10)])
< LogicalTableScan(table=[[CATALOG, SALES, EMP]])
< LogicalProject(DEPTNO=[$7])
< LogicalTableScan(table=[[CATALOG, SALES, EMP]])
< ]]>
< </Resource>
< </TestCase>
< <TestCase name="testWithUnionOrder">
< <Resource name="sql">
< <![CDATA[with emp2 as (select empno, deptno as x from emp)
< select * from emp2
< union all
< select * from emp2
< order by empno + x]]>
< </Resource>
< <Resource name="plan">
< <![CDATA[
< LogicalProject(EMPNO=[$0], X=[$1])
< LogicalSort(sort0=[$2], dir0=[ASC])
< LogicalProject(EMPNO=[$0], X=[$1], EXPR$2=[+($0, $1)])
< LogicalUnion(all=[true])
< LogicalProject(EMPNO=[$0], X=[$7])
< LogicalTableScan(table=[[CATALOG, SALES, EMP]])
< LogicalProject(EMPNO=[$0], X=[$7])
< LogicalTableScan(table=[[CATALOG, SALES, EMP]])
< ]]>
< </Resource>
< </TestCase>
< <TestCase name="testWithinDistinct1">
< <Resource name="sql">
< <![CDATA[select avg(empno) within distinct (deptno)
< from emp]]>
< </Resource>
< <Resource name="plan">
< <![CDATA[
< LogicalAggregate(group=[{}], EXPR$0=[AVG($0) WITHIN DISTINCT ($1)])
< LogicalProject(EMPNO=[$0], DEPTNO=[$7])
< LogicalTableScan(table=[[CATALOG, SALES, EMP]])
< ]]>
< </Resource>
< </TestCase>
< <TestCase name="testWithinGroup1">
< <Resource name="sql">
< <![CDATA[select deptno,
< collect(empno) within group (order by deptno, hiredate desc)
< from emp
< group by deptno]]>
< </Resource>
< <Resource name="plan">
< <![CDATA[
< LogicalAggregate(group=[{0}], EXPR$1=[COLLECT($1) WITHIN GROUP ([0, 2
DESC])])
< LogicalProject(DEPTNO=[$7], EMPNO=[$0], HIREDATE=[$4])
< LogicalTableScan(table=[[CATALOG, SALES, EMP]])
< ]]>
< </Resource>
< </TestCase>
< <TestCase name="testWithinGroup2">
< <Resource name="sql">
< <![CDATA[select dept.deptno,
< collect(sal) within group (order by sal desc) as s,
< collect(sal) within group (order by 1)as s1,
< collect(sal) within group (order by sal)
< filter (where sal > 2000) as s2
< from emp
< join dept using (deptno)
< group by dept.deptno]]>
< </Resource>
< <Resource name="plan">
< <![CDATA[
< LogicalAggregate(group=[{0}], S=[COLLECT($1) WITHIN GROUP ([1 DESC])],
S1=[COLLECT($1) WITHIN GROUP ([2])], S2=[COLLECT($1) WITHIN GROUP ([1]) FILTER
$3])
< LogicalProject(DEPTNO=[$9], SAL=[$5], $f2=[1], $f3=[>($5, 2000)])
< LogicalJoin(condition=[=($7, $9)], joinType=[inner])
< LogicalTableScan(table=[[CATALOG, SALES, EMP]])
< LogicalTableScan(table=[[CATALOG, SALES, DEPT]])
< ]]>
< </Resource>
< </TestCase>
< <TestCase name="testWithinGroup3">
< <Resource name="sql">
< <![CDATA[select deptno,
< collect(empno) within group (order by empno not in (1, 2)), count(*)
< from emp
< group by deptno]]>
< </Resource>
< <Resource name="plan">
< <![CDATA[
< LogicalAggregate(group=[{0}], EXPR$1=[COLLECT($1) WITHIN GROUP ([2])],
EXPR$2=[COUNT()])
< LogicalProject(DEPTNO=[$7], EMPNO=[$0], $f2=[SEARCH($0, Sarg[(-?..1),
(1..2), (2..+?)])])
< LogicalTableScan(table=[[CATALOG, SALES, EMP]])
< ]]>
< </Resource>
< </TestCase>
< </Root>
at
org.apache.calcite.test.DiffRepository.checkActualAndReferenceFiles(DiffRepository.java:260)
at
org.apache.calcite.test.SqlToRelConverterTest.checkActualAndReferenceFiles(SqlToRelConverterTest.java:86)
[0;0;90mat
org.junit.platform.commons.util.ReflectionUtils.invokeMethod(ReflectionUtils.java:725)
[0m [0;0;90mat
org.junit.jupiter.engine.execution.MethodInvocation.proceed(MethodInvocation.java:60)
[0m [0;0;90mat
org.junit.jupiter.engine.execution.InvocationInterceptorChain$ValidatingInvocation.proceed(InvocationInterceptorChain.java:131)
[0m [0;0;90mat
org.junit.jupiter.engine.extension.TimeoutInvocation.proceed(TimeoutInvocation.java:46)
[0m [0;0;90mat
org.junit.jupiter.engine.extension.TimeoutExtension.intercept(TimeoutExtension.java:149)
[0m [0;0;90mat
org.junit.jupiter.engine.extension.TimeoutExtension.interceptLifecycleMethod(TimeoutExtension.java:126)
[0m [0;0;90mat
org.junit.jupiter.engine.extension.TimeoutExtension.interceptAfterAllMethod(TimeoutExtension.java:116)
[0m [0;0;90mat
org.junit.jupiter.engine.execution.ExecutableInvoker$ReflectiveInterceptorCall.lambda$ofVoidMethod$0(ExecutableInvoker.java:115)
[0m [0;0;90mat
org.junit.jupiter.engine.execution.ExecutableInvoker.lambda$invoke$0(ExecutableInvoker.java:105)
[0m [0;0;90mat
org.junit.jupiter.engine.execution.InvocationInterceptorChain$InterceptedInvocation.proceed(InvocationInterceptorChain.java:106)
[0m [0;0;90mat
org.junit.jupiter.engine.execution.InvocationInterceptorChain.proceed(InvocationInterceptorChain.java:64)
[0m [0;0;90mat
org.junit.jupiter.engine.execution.InvocationInterceptorChain.chainAndInvoke(InvocationInterceptorChain.java:45)
[0m [0;0;90mat
org.junit.jupiter.engine.execution.InvocationInterceptorChain.invoke(InvocationInterceptorChain.java:37)
[0m [0;0;90mat
org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:104)
[0m [0;0;90mat
org.junit.jupiter.engine.execution.ExecutableInvoker.invoke(ExecutableInvoker.java:98)
[0m [0;0;90mat
org.junit.jupiter.engine.descriptor.ClassBasedTestDescriptor.lambda$invokeAfterAllMethods$13(ClassBasedTestDescriptor.java:425)
[0m [0;0;90mat
org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
[0m [0;0;90mat
org.junit.jupiter.engine.descriptor.ClassBasedTestDescriptor.lambda$invokeAfterAllMethods$14(ClassBasedTestDescriptor.java:423)
[0m at java.util.ArrayList.forEach(ArrayList.java:1259)
at
java.util.Collections$UnmodifiableCollection.forEach(Collections.java:1082)
[0;0;90mat
org.junit.jupiter.engine.descriptor.ClassBasedTestDescriptor.invokeAfterAllMethods(ClassBasedTestDescriptor.java:423)
[0m [0;0;90mat
org.junit.jupiter.engine.descriptor.ClassBasedTestDescriptor.after(ClassBasedTestDescriptor.java:225)
[0m [0;0;90mat
org.junit.jupiter.engine.descriptor.ClassBasedTestDescriptor.after(ClassBasedTestDescriptor.java:80)
[0m [0;0;90mat
org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$7(NodeTestTask.java:161)
[0m [0;0;90mat
org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
[0m [0;0;90mat
org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$8(NodeTestTask.java:161)
[0m [0;0;90mat
org.junit.platform.engine.support.hierarchical.Node.around(Node.java:137)
[0m [0;0;90mat
org.junit.platform.engine.support.hierarchical.NodeTestTask.lambda$executeRecursively$9(NodeTestTask.java:139)
[0m [0;0;90mat
org.junit.platform.engine.support.hierarchical.ThrowableCollector.execute(ThrowableCollector.java:73)
[0m [0;0;90mat
org.junit.platform.engine.support.hierarchical.NodeTestTask.executeRecursively(NodeTestTask.java:138)
[0m [0;0;90mat
org.junit.platform.engine.support.hierarchical.NodeTestTask.execute(NodeTestTask.java:95)
[0m
[0;31;1mFAILURE[0m 7.4sec, 536 completed, [0;31;1m 1[0m failed,
[0;34;1m 3[0m skipped,
org.apache.calcite.test.[0;31;1mSqlToRelConverterExtendedTest[0m
0.9sec, 17 completed, 0 failed, 0 skipped,
org.apache.calcite.test.enumerable.EnumerableUncollectTest
[0;34;1mWARNING[0m 7.4sec, 535 completed, 0 failed, [0;34;1m 3[0m
skipped, org.apache.calcite.test.[0;34;1mSqlToRelConverterTest[0m
2.3sec, 25 completed, 0 failed, 0 skipped,
testHierarchy(boolean, int[], String, boolean, int, String[])
2.3sec, 25 completed, 0 failed, 0 skipped,
org.apache.calcite.test.enumerable.EnumerableRepeatUnionHierarchyTest
[0;1m 2.6sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestMultisetUnionOperator()[0m
[0;1m 2.6sec[0m, org.apache.calcite.test.[0;1mJdbcTest[0m >
[0;1mtestMixedEqualAndIsNotDistinctJoin()[0m
[0;1m 2.4sec[0m, org.apache.calcite.test.[0;1mJdbcTest[0m >
[0;1mtestDistinctCount()[0m
[0;1m 28.3sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[5], [5] sql/sub-query.iq
[0;1m 2.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestLikeOperator()[0m
[0;1m 8.9sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestMysqlSubstrFunction()[0m
[0;1m 2.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestExtractTimestamp()[0m
[0;1m 24.7sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[21], [21] sql/agg.iq
30.2sec, 24 completed, 0 failed, 0 skipped, test(String)
30.2sec, 24 completed, 0 failed, 0 skipped,
org.apache.calcite.test.CoreQuidemTest
[0;1m 3.0sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestIlikeOperator()[0m
[0;1m 6.3sec[0m, org.apache.calcite.test.[0;1mJdbcTest[0m >
[0;1mtestAggMultipleMeasures()[0m
[0;1m 3.0sec[0m, org.apache.calcite.test.[0;1mJdbcTest[0m >
[0;1mtestOrderByVarious()[0m
[0;34;1mWARNING[0m 26.3sec, 333 completed, 0 failed, [0;34;1m 17[0m
skipped, org.apache.calcite.test.[0;34;1mJdbcTest[0m
[0;1m 2.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestExceptOperator()[0m
[0;1m 28.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestPeriodOperators()[0m
[0;1m 7.0sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestStandardSubstringFunction()[0m
[0;1m 2.7sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestExtractDate()[0m
[0;1m 2.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestRegexpReplaceFunc()[0m
[0;1m 2.0sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastStringToDateTime()[0m
[0;1m 7.4sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastExactNumericLimits()[0m
[0;1m 5.9sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestOracleSubstrFunction()[0m
[0;1m 3.6sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestJdbcFn()[0m
[0;1m 4.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestSimilarToOperator()[0m
[0;1m 5.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestRandFunc()[0m
[0;1m 6.7sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToString()[0m
[0;34;1mWARNING[0m 34.7sec, 310 completed, 0 failed, [0;34;1m 1[0m
skipped, org.apache.calcite.test.[0;34;1mCalciteSqlOperatorTest[0m
[0;1m 25.8sec[0m,
org.apache.calcite.test.[0;1mReflectiveSchemaTest[0m > [0;1mtestOp()[0m
[0;34;1mWARNING[0m 28.4sec, 45 completed, 0 failed, [0;34;1m 5[0m
skipped, org.apache.calcite.test.[0;34;1mReflectiveSchemaTest[0m
Gradle Test Executor 22 STANDARD_OUT
2022-11-05 08:53:46,700 [ForkJoinPool-1-worker-25] INFO - Rex fuzzing
results: number of cases tested=9, failed cases=0, duplicate failures=0, fuzz
rate=0 per second
[0;1m 27.4sec[0m,
org.apache.calcite.test.fuzzer.[0;1mRexProgramFuzzyTest[0m >
[0;1mdefaultFuzzTest()[0m
[0;34;1mWARNING[0m 30.4sec, 4 completed, 0 failed, [0;34;1m 2[0m
skipped, org.apache.calcite.test.fuzzer.[0;34;1mRexProgramFuzzyTest[0m
[0;31;1mFAILURE[0m 59.2sec, 7368 completed, [0;31;1m 1[0m failed,
[0;34;1m105[0m skipped, [0;31;1mGradle Test Run :core:test[0m
7368 tests completed, 1 failed, 105 skipped
> Task :core:test FAILED
FAILURE: Build failed with an exception.
* What went wrong:
Execution failed for task ':core:test'.
> There were failing tests. See the report at:
> file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/core/build/reports/tests/test/index.html>
* Try:
> Run with --stacktrace option to get the stack trace.
> Run with --info or --debug option to get more log output.
> Run with --scan to get full insights.
* Get more help at https://help.gradle.org
Deprecated Gradle features were used in this build, making it incompatible with
Gradle 8.0.
You can use '--warning-mode all' to show the individual deprecation warnings
and determine if they come from your own scripts or plugins.
See
https://docs.gradle.org/7.4.2/userguide/command_line_interface.html#sec:command_line_warnings
BUILD FAILED in 5m 12s
469 actionable tasks: 469 executed
See the profiling report at:
file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/build/reports/profile/profile-2022-11-05-08-48-39.html>
A fine-grained performance profile is available: use the --scan option.
See the profiling report at:
file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/buildSrc/build/reports/profile/profile-2022-11-05-08-48-41.html>
A fine-grained performance profile is available: use the --scan option.
Build step 'Invoke Gradle script' changed build result to FAILURE
Build step 'Invoke Gradle script' marked build as failure
Recording test results
[Checks API] No suitable checks publisher found.
