See
<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/308/display/redirect?page=changes>
Changes:
[Bertil Chapuis] [CALCITE-5417] Upgrade Proj4J from 1.1.5 to 1.2.2, and restore
it as an included dependency
------------------------------------------
[...truncated 722.95 KB...]
< <![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)
[0;1mat
org.apache.calcite.test.SqlToRelConverterTest.checkActualAndReferenceFiles(SqlToRelConverterTest.java:88)
[0m
[0;31;1mFAILURE[0m 15.0sec, 541 completed, [0;31;1m 1[0m failed,
[0;34;1m 3[0m skipped,
org.apache.calcite.test.[0;31;1mSqlToRelConverterTest[0m
JdbcTest > testCountUnionAll() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
[0;1m 2.1sec[0m, org.apache.calcite.test.[0;1mJdbcTest[0m >
[0;1mtestBushy()[0m
[0;1m 2.4sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCustomTimeFrame()[0m
[0;1m 2.5sec[0m,
org.apache.calcite.test.[0;1mSqlToRelConverterExtendedTest[0m >
[0;1mtestLarge()[0m
[0;34;1mWARNING[0m 17.6sec, 540 completed, 0 failed, [0;34;1m 3[0m
skipped, org.apache.calcite.test.[0;34;1mSqlToRelConverterExtendedTest[0m
[0;1m 3.0sec[0m, org.apache.calcite.test.[0;1mJdbcTest[0m >
[0;1mtestJoinJoin()[0m
[0;1m 2.4sec[0m, org.apache.calcite.test.[0;1mJdbcTest[0m >
[0;1mtestDistinctCountComposite()[0m
[0;1m 2.6sec[0m, org.apache.calcite.test.[0;1mJdbcTest[0m >
[0;1mtestDistinctCount()[0m
[0;1m 5.6sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestSoundexFunc()[0m
[0;1m 2.4sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestGreaterThanOrEqualOperator()[0m
[0;1m 2.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m > [0;1mtestMd5()[0m
[0;1m 5.1sec[0m, org.apache.calcite.test.[0;1mJdbcTest[0m >
[0;1mtestOrderByVarious()[0m
[0;1m 2.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCurrentDateFuncWithFixedTime()[0m
[0;1m 2.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestEndsWithFunction()[0m
[0;1m 6.2sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[5], [5] sql/join.iq
[0;1m 2.9sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestJsonKeys()[0m
[0;1m 5.4sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestLastDayFunc()[0m
[0;1m 3.7sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestMultisetUnionOperator()[0m
[0;1m 7.5sec[0m, org.apache.calcite.test.[0;1mJdbcTest[0m >
[0;1mtestAggMultipleMeasures()[0m
[0;34;1mWARNING[0m 40.9sec, 333 completed, 0 failed, [0;34;1m 17[0m
skipped, org.apache.calcite.test.[0;34;1mJdbcTest[0m
[0;1m 3.0sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m > [0;1mtestCase()[0m
[0;1m 2.0sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestExtractWithDatesBeforeUnixEpoch()[0m
[0;1m 10.4sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestTimestampAdd()[0m
> Task :redis:test
docker[redis:2.8.19] 2022-12-15 23:17:14,523 [ForkJoinPool-1-worker-9] INFO
- Starting container with ID:
0c9bff88a4e84bd263a6a511bd3c7238cbf9023219b6bd9264a4087194471d5c
docker[redis:2.8.19] 2022-12-15 23:17:16,689 [ForkJoinPool-1-worker-9] INFO
- Container redis:2.8.19 is starting:
0c9bff88a4e84bd263a6a511bd3c7238cbf9023219b6bd9264a4087194471d5c
docker[redis:2.8.19] 2022-12-15 23:17:16,967 [ForkJoinPool-1-worker-9] INFO
- Container redis:2.8.19 started in PT38.069S
[0;1m 6.1sec[0m,
org.apache.calcite.adapter.redis.[0;1mRedisAdapterCaseBase[0m >
[0;1mtestSqlWithJoin()[0m
86.9sec, 2 completed, 0 failed, 0 skipped,
org.apache.calcite.adapter.redis.RedisAdapterCaseBase
[0;34;1mWARNING[0m 91.4sec, 3 completed, 0 failed, [0;34;1m 1[0m
skipped, [0;34;1mGradle Test Run :redis:test[0m
> Task :redis:check
> Task :redis:build
> Task :redis:publish
> Task :core:test
[0;1m 3.3sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[6], [6] sql/conditions.iq
[0;1m 2.0sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestSubMultisetOfOperator()[0m
[0;1m 3.6sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestRightFunc()[0m
[0;1m 3.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestJsonExists()[0m
[0;1m 3.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestBetween()[0m
[0;1m 2.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestJsonDepth()[0m
[0;1m 2.9sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestJsonLength()[0m
> Task :cassandra:test
CassandraAdapterDataTypesTest STANDARD_OUT
2022-12-15 23:17:31,485 [s0-io-3] WARN - [s0] Detected a keyspace change
at runtime (<none> => cassandraunitkeyspace). This is an anti-pattern that
should be avoided in production (see 'advanced.request.warn-if-set-keyspace' in
the configuration).
2022-12-15 23:17:33,248 [s0-io-3] WARN - [s0] Detected a keyspace change
at runtime (cassandraunitkeyspace => dtcassandra). This is an anti-pattern that
should be avoided in production (see 'advanced.request.warn-if-set-keyspace' in
the configuration).
> Task :core:test
[0;1m 3.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestJsonValue()[0m
[0;1m 9.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestPostgresqlSubstrFunction()[0m
[0;1m 10.9sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestBigQuerySubstrFunction()[0m
[0;1m 4.0sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestJsonQuery()[0m
[0;1m 13.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestRandIntegerFunc()[0m
[0;1m 3.6sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestTimestampDiff()[0m
[0;1m 2.8sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestIlikeOperator()[0m
[0;1m 2.5sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestConcatFunc()[0m
[0;1m 7.4sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestMysqlSubstrFunction()[0m
[0;1m 6.8sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestStandardSubstringFunction()[0m
[0;1m 2.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestPositionFunc()[0m
[0;1m 2.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestExceptOperator()[0m
[0;1m 3.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastStringToDateTime()[0m
[0;1m 8.5sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastExactNumericLimits()[0m
[0;1m 3.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestExtractDate()[0m
[0;1m 7.3sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestOracleSubstrFunction()[0m
[0;1m 2.4sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestRegexpReplaceFunc()[0m
[0;1m 28.8sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestPeriodOperators()[0m
[0;1m 47.2sec[0m,
org.apache.calcite.test.[0;1mReflectiveSchemaTest[0m > [0;1mtestOp()[0m
[0;34;1mWARNING[0m 53.7sec, 45 completed, 0 failed, [0;34;1m 5[0m
skipped, org.apache.calcite.test.[0;34;1mReflectiveSchemaTest[0m
[0;1m 6.0sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestRandFunc()[0m
[0;1m 8.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToString()[0m
[0;1m 4.0sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestSimilarToOperator()[0m
[0;1m 3.4sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestJdbcFn()[0m
[0;34;1mWARNING[0m 62.3sec, 315 completed, 0 failed, [0;34;1m 1[0m
skipped, org.apache.calcite.test.[0;34;1mCalciteSqlOperatorTest[0m
[0;1m 16.8sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[7], [7] sql/sub-query.iq
CoreQuidemTest > test(String) >
org.apache.calcite.test.CoreQuidemTest.test(String)[18] STANDARD_OUT
Warning: JDBC driver threw non-SQLException
[0;1m 5.8sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[19], [19] sql/agg.iq
> Task :cassandra:test
[0;1m 4.1sec[0m,
org.apache.calcite.test.[0;1mCassandraAdapterDataTypesTest[0m >
[0;1mtestCollectionsRowType()[0m
103.8sec, 11 completed, 0 failed, 0 skipped,
org.apache.calcite.test.CassandraAdapterDataTypesTest
> Task :core:test FAILED
CoreQuidemTest > test(String) >
org.apache.calcite.test.CoreQuidemTest.test(String)[25] STANDARD_OUT
Warning: JDBC driver threw non-SQLException
[0;1m 4.9sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[25], [25] sql/misc.iq
83.9sec, 25 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCoreQuidemTest[0m > [0;1mtest(String)[0m
83.9sec, 25 completed, 0 failed, 0 skipped,
org.apache.calcite.test.CoreQuidemTest
[0;31;1mFAILURE[0m 111.3sec, 7402 completed, [0;31;1m 1[0m failed,
[0;34;1m105[0m skipped, [0;31;1mGradle Test Run :core:test[0m
7402 tests completed, 1 failed, 105 skipped
> Task :cassandra:test
CassandraAdapterTest STANDARD_OUT
2022-12-15 23:18:13,366 [s0-io-3] WARN - [s0] Detected a keyspace change
at runtime (dtcassandra => cassandraunitkeyspace). This is an anti-pattern that
should be avoided in production (see 'advanced.request.warn-if-set-keyspace' in
the configuration).
2022-12-15 23:18:37,283 [s0-io-3] WARN - [s0] Detected a keyspace change
at runtime (cassandraunitkeyspace => twissandra). This is an anti-pattern that
should be avoided in production (see 'advanced.request.warn-if-set-keyspace' in
the configuration).
2022-12-15 23:18:37,289 [s0-admin-0] WARN - Query '[0 values] CREATE
MATERIALIZED VIEW twissandra."Tweets_By_User" AS SELECT username, tweet_id FROM
twissandra.tweets WHERE username IS NOT NULL AND tweet_id IS NOT NULL PRIMARY
KEY (username, tweet_id);' generated server side warning(s): Materialized views
are experimental and are not recommended for production use.
36.8sec, 11 completed, 0 failed, 0 skipped,
org.apache.calcite.test.CassandraAdapterTest
Gradle Test Executor 22 STANDARD_OUT
2022-12-15 23:18:43,155 [s1-admin-0] WARN - [s1|localhost/127.0.0.1:9142]
Error while opening new channel (ConnectionInitException: [s1|connecting...]
Protocol initialization request, step 1 (STARTUP {CQL_VERSION=3.0.0,
DRIVER_NAME=DataStax Java driver for Apache Cassandra(R),
DRIVER_VERSION=4.13.0, CLIENT_ID=494c23ff-7561-4a11-a855-49aa1e8a9d35}): failed
to send request (io.netty.channel.StacklessClosedChannelException))
2022-12-15 23:18:43,155 [s2-admin-0] WARN - [s2|localhost/127.0.0.1:9142]
Error while opening new channel (ConnectionInitException: [s2|connecting...]
Protocol initialization request, step 1 (STARTUP {CQL_VERSION=3.0.0,
DRIVER_NAME=DataStax Java driver for Apache Cassandra(R),
DRIVER_VERSION=4.13.0, CLIENT_ID=eb660675-e27a-4df0-8bae-50d8dda1b99a}): failed
to send request (io.netty.channel.StacklessClosedChannelException))
2022-12-15 23:18:45,099 [s1-admin-0] WARN - [s1|localhost/127.0.0.1:9142]
Error while opening new channel (ConnectionInitException: [s1|connecting...]
Protocol initialization request, step 1 (STARTUP {CQL_VERSION=3.0.0,
DRIVER_NAME=DataStax Java driver for Apache Cassandra(R),
DRIVER_VERSION=4.13.0, CLIENT_ID=494c23ff-7561-4a11-a855-49aa1e8a9d35}): failed
to send request (io.netty.channel.StacklessClosedChannelException))
2022-12-15 23:18:45,380 [s2-admin-0] WARN - [s2|localhost/127.0.0.1:9142]
Error while opening new channel (ConnectionInitException: [s2|connecting...]
Protocol initialization request, step 1 (STARTUP {CQL_VERSION=3.0.0,
DRIVER_NAME=DataStax Java driver for Apache Cassandra(R),
DRIVER_VERSION=4.13.0, CLIENT_ID=eb660675-e27a-4df0-8bae-50d8dda1b99a}): failed
to send request (io.netty.channel.StacklessClosedChannelException))
152.5sec, 22 completed, 0 failed, 0 skipped, Gradle Test Run
:cassandra:test
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 10m 8s
462 actionable tasks: 462 executed
See the profiling report at:
file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/build/reports/profile/profile-2022-12-15-23-08-47.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-12-15-23-09-43.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.
