See
<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/2008/display/redirect?page=changes>
Changes:
[Yu Xu] Test cases for [CALCITE-5418] Nested Queries are not expanded properly
------------------------------------------
[...truncated 10.07 MiB...]
CalciteSqlOperatorTest > testRegexpLike3() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
[0;1m 7.3sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[38], [38] sql/spatial.iq
CalciteSqlOperatorTest > testParseDate() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
2.9sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastIntervalToNumeric(CastType,[0m SqlOperatorFixture)
[0;1m 2.3sec[0m,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastExactNumericLimits(CastType,[0m SqlOperatorFixture)[2], [2]
SAFE_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@3f910533
0.1sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCast(CastType,[0m SqlOperatorFixture)
[0;1m 2.5sec[0m,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastExactNumericLimits(CastType,[0m SqlOperatorFixture)[3], [3]
TRY_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@1c62399c
6.5sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastExactNumericLimits(CastType,[0m SqlOperatorFixture)
0.7sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastDateTime(CastType,[0m SqlOperatorFixture)
0.3sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastFormatClauseStringToDateTime(CastType,[0m SqlOperatorFixture)
SqlOperatorUnparseTest > testXmlTransform() STANDARD_ERROR
[Fatal Error] :1:2: XML document structures must start and end within the
same entity.
0.3sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastTruncates(CastType,[0m SqlOperatorFixture)
3.5sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastFormatClauseDateTimeToString(CastType,[0m SqlOperatorFixture)
[0;1m 14.3sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[40], [40] sql/agg.iq
CoreQuidemTest > test(String) > [42] sql/cast.iq STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
[0;1m 16.3sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest2[0m >
[0;1mtest(String)[0m[40], [40] sql/agg.iq
CoreQuidemTest2 > test(String) > [41] sql/variant.iq STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testEndsWithFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testCastDecimalToDoubleToInteger(CastType,
SqlOperatorFixture) > [1] CAST,
org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@78af4eef
STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testCastDecimalToDoubleToInteger(CastType,
SqlOperatorFixture) > [2] SAFE_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@3ab882f3
STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
1.9sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastWithRoundingToScalar(CastType,[0m SqlOperatorFixture)
CalciteSqlOperatorTest > testMapKeysFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
0.3sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastDecimalToDoubleToInteger(CastType,[0m SqlOperatorFixture)
SqlOperatorUnparseTest > testDateTrunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testPercentileDiscBigQueryFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testArrayRemoveFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testRepeatFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testOrdinalOperator() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testPowFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testBitAndAggFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testArrayRepeatFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testArrayLengthFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testLengthFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testBitXorScalarFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testUserFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testExtractIntervalDayTime() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testMaxFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testApproxCountDistinctFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testAddMonths() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testArrayConcatAggFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
[0;1m 3.7sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[42], [42] sql/cast.iq
CalciteSqlOperatorTest > testAbsFuncIntervals() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testMapValueConstructor() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testContainsSubstrFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testRandomFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
[0;1m 4.4sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest2[0m >
[0;1mtest(String)[0m[42], [42] sql/cast.iq
[0;1m 3.1sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[44], [44] sql/join.iq
[0;1m 4.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestRandomFunc()[0m
165.3sec, 45 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCoreQuidemTest[0m > [0;1mtest(String)[0m
165.3sec, 45 completed, 0 failed, 0 skipped,
org.apache.calcite.test.CoreQuidemTest
[0;1m 2.2sec[0m,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)[2], [2] SAFE_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@60952947
[0;1m 3.5sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest2[0m >
[0;1mtest(String)[0m[44], [44] sql/join.iq
167.7sec, 45 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCoreQuidemTest2[0m > [0;1mtest(String)[0m
167.7sec, 45 completed, 0 failed, 0 skipped,
org.apache.calcite.test.CoreQuidemTest2
[0;1m 2.1sec[0m,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)[3], [3] TRY_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@6c8643bd
5.8sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)
0.3sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastNull(CastType,[0m SqlOperatorFixture)
0.2sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastToApproxNumeric(CastType,[0m SqlOperatorFixture)
0.1sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastIntervalToInterval(CastType,[0m SqlOperatorFixture)
0.3sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastToBoolean(CastType,[0m SqlOperatorFixture)
2.5sec, 2 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestTimestampDiff(boolean)[0m
0.9sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToInterval(CastType,[0m SqlOperatorFixture)
1.8sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastStringToDateTime(CastType,[0m SqlOperatorFixture)
[0;1m 2.5sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastExactNumericLimits(CastType,[0m SqlOperatorFixture)[1], [1]
CAST, org.apache.calcite.test.SqlOperatorFixtureImpl@4a313dcc
SqlOperatorUnparseTest > testExtractValue() STANDARD_ERROR
[Fatal Error] :1:14: The markup in the document following the root element
must be well-formed.
[0;1m 4.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastExactNumericLimits(CastType,[0m SqlOperatorFixture)[2], [2]
SAFE_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@14e194ec
[0;1m 4.3sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastExactNumericLimits(CastType,[0m SqlOperatorFixture)[3], [3]
TRY_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@129b8efa
10.9sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastExactNumericLimits(CastType,[0m SqlOperatorFixture)
1.2sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastDateTime(CastType,[0m SqlOperatorFixture)
0.5sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastFormatClauseStringToDateTime(CastType,[0m SqlOperatorFixture)
CalciteSqlOperatorTest > testXmlTransform() STANDARD_ERROR
[Fatal Error] :1:2: XML document structures must start and end within the
same entity.
0.7sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastTruncates(CastType,[0m SqlOperatorFixture)
[0;1m 2.5sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestBitAndOperatorScalarFunc()[0m
[0;1m 3.7sec[0m,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestRlikeOperator()[0m
0.0sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastFormatClauseByteToString(CastType,[0m SqlOperatorFixture)
[0;34;1mWARNING[0m 151.9sec, 586 completed, 0 failed, [0;34;1m 1[0m
skipped, org.apache.calcite.test.[0;34;1mSqlOperatorUnparseTest[0m
[0;1m 2.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestOracleSubstrFunction()[0m
0.8sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastDecimalToDoubleToInteger(CastType,[0m SqlOperatorFixture)
[0;1m 3.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)[1], [1] CAST,
org.apache.calcite.test.SqlOperatorFixtureImpl@52f621f3
[0;1m 6.0sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)[2], [2] SAFE_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@6209a48d
[0;1m 5.8sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)[3], [3] TRY_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@4e552945
15.0sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)
0.7sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastNull(CastType,[0m SqlOperatorFixture)
[0;1m 2.5sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestRandFunc()[0m
0.6sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToApproxNumeric(CastType,[0m SqlOperatorFixture)
0.4sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastIntervalToInterval(CastType,[0m SqlOperatorFixture)
0.7sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToBoolean(CastType,[0m SqlOperatorFixture)
[0;1m 3.3sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestSimilarToOperator()[0m
[0;1m 2.7sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestJdbcFn()[0m
4.2sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastStringToDateTime(CastType,[0m SqlOperatorFixture)
[0;1m 2.5sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestSecFunc()[0m
CalciteSqlOperatorTest > testExtractValue() STANDARD_ERROR
[Fatal Error] :1:14: The markup in the document following the root element
must be well-formed.
[0;1m 2.0sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestHypotFunc()[0m
[0;1m 2.9sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestToChar()[0m
[0;1m 2.6sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestBigQuerySubstringFunction()[0m
[0;1m 8.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestRlikeOperator()[0m
0.0sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastFormatClauseByteToString(CastType,[0m SqlOperatorFixture)
[0;34;1mWARNING[0m 348.9sec, 587 completed, 0 failed, [0;34;1m 1[0m
skipped, org.apache.calcite.test.[0;34;1mCalciteSqlOperatorTest[0m
[0;31;1mFAILURE[0m 372.1sec, 15891 completed, [0;31;1m 1[0m failed,
[0;34;1m108[0m skipped, [0;31;1mGradle Test Run :core:test[0m
15891 tests completed, 1 failed, 108 skipped
> Task :core:test FAILED
[Incubating] Problems report is available at:
file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/build/reports/problems/problems-report.html>
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>
Deprecated Gradle features were used in this build, making it incompatible with
Gradle 9.0.
You can use '--warning-mode all' to show the individual deprecation warnings
and determine if they come from your own scripts or plugins.
For more on this, please refer to
https://docs.gradle.org/8.14.4/userguide/command_line_interface.html#sec:command_line_warnings
in the Gradle documentation.
BUILD FAILED in 12m 12s
501 actionable tasks: 501 executed
See the profiling report at:
file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/build/reports/profile/profile-2026-08-06-02-03-33.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.