See
<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/1727/display/redirect?page=changes>
Changes:
[Zhen Chen] Included cases for [CALCITE-2359]
------------------------------------------
[...truncated 10.03 MiB...]
SqlOperatorUnparseTest > testMysqlSubstrFunction() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
[0;1m 2.3sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestLogMysqlSparkFunc()[0m
[0;1m 2.4sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest2[0m >
[0;1mtest(String)[0m[33], [33] sql/functions.iq
0.0sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastFormatClauseNumericToString(CastType,[0m SqlOperatorFixture)
1.1sec, 2 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestTimestampDiff(boolean)[0m
[0;1m 6.9sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[33], [33] sql/spatial.iq
0.4sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastToInterval(CastType,[0m SqlOperatorFixture)
SqlOperatorUnparseTest > testReplaceFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
[0;1m 2.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestQuantifyCollectionOperators()[0m
2.0sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastIntervalToNumeric(CastType,[0m SqlOperatorFixture)
0.1sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCast(CastType,[0m SqlOperatorFixture)
4.6sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastExactNumericLimits(CastType,[0m SqlOperatorFixture)
0.5sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastDateTime(CastType,[0m SqlOperatorFixture)
0.2sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastFormatClauseStringToDateTime(CastType,[0m SqlOperatorFixture)
[0;1m 11.7sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest2[0m >
[0;1mtest(String)[0m[34], [34] sql/agg.iq
CoreQuidemTest2 > test(String) > [36] sql/cast.iq STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testXmlTransform() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testXmlTransform() STANDARD_ERROR
[Fatal Error] :1:2: XML document structures must start and end within the
same entity.
SqlOperatorUnparseTest > testXmlTransform() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
2.8sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastFormatClauseDateTimeToString(CastType,[0m SqlOperatorFixture)
CalciteSqlOperatorTest > testLessThanOrEqualOperatorInterval() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testCastTruncates(CastType, SqlOperatorFixture) > [3]
TRY_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@27169a4f
STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testFromHex() 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
0.4sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastTruncates(CastType,[0m SqlOperatorFixture)
CalciteSqlOperatorTest > testFloorFuncDateTime() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testMssqlConvert() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testModeFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testTanhFunc() 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 11.5sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[35], [35] sql/agg.iq
CoreQuidemTest > test(String) > [36] sql/variant.iq STANDARD_OUT
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testRadiansFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testMapConcatFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testCardinalityFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testSnowflakeStartsWithFunc() 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
CoreQuidemTest > test(String) > [37] 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
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 > testFindInSetFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testSortArrayFunc() 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
SqlOperatorUnparseTest > testLikeOperator() 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.2sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest2[0m >
[0;1mtest(String)[0m[36], [36] sql/cast.iq
SqlOperatorUnparseTest > testBoolAndFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testCoshFunc() 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 > testCastWithRoundingToScalar(CastType,
SqlOperatorFixture) STANDARD_OUT
Warning: JDBC driver threw non-SQLException
CalciteSqlOperatorTest > testCastWithRoundingToScalar(CastType,
SqlOperatorFixture) > [3] TRY_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@1c2a31bb
STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testStringToArrayFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testParseTimestamp() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testLogicalOrFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testCothFunc() STANDARD_OUT
Warning: JDBC driver threw non-SQLException
SqlOperatorUnparseTest > testOracleSubstrFunction() 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
2.2sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastWithRoundingToScalar(CastType,[0m SqlOperatorFixture)
[0;1m 4.0sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[37], [37] sql/cast.iq
0.4sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastDecimalToDoubleToInteger(CastType,[0m SqlOperatorFixture)
[0;1m 3.2sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest2[0m >
[0;1mtest(String)[0m[38], [38] sql/join.iq
143.6sec, 39 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCoreQuidemTest2[0m > [0;1mtest(String)[0m
143.6sec, 39 completed, 0 failed, 0 skipped,
org.apache.calcite.test.CoreQuidemTest2
[0;1m 3.1sec[0m, org.apache.calcite.test.[0;1mCoreQuidemTest[0m >
[0;1mtest(String)[0m[39], [39] sql/join.iq
146.7sec, 40 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCoreQuidemTest[0m > [0;1mtest(String)[0m
146.7sec, 40 completed, 0 failed, 0 skipped,
org.apache.calcite.test.CoreQuidemTest
[0;1m 4.0sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestRandomFunc()[0m
[0;1m 2.3sec[0m,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)[2], [2] SAFE_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@7b92a536
[0;1m 2.3sec[0m,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)[3], [3] TRY_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@3abdfa68
5.8sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)
0.4sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastNull(CastType,[0m SqlOperatorFixture)
0.3sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastToApproxNumeric(CastType,[0m SqlOperatorFixture)
2.7sec, 2 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestTimestampDiff(boolean)[0m
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)
0.8sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToInterval(CastType,[0m SqlOperatorFixture)
1.9sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mSqlOperatorUnparseTest[0m >
[0;1mtestCastStringToDateTime(CastType,[0m SqlOperatorFixture)
[0;1m 2.3sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastExactNumericLimits(CastType,[0m SqlOperatorFixture)[1], [1]
CAST, org.apache.calcite.test.SqlOperatorFixtureImpl@5502dfd2
SqlOperatorUnparseTest > testExtractValue() STANDARD_ERROR
[Fatal Error] :1:14: The markup in the document following the root element
must be well-formed.
[0;1m 4.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastExactNumericLimits(CastType,[0m SqlOperatorFixture)[2], [2]
SAFE_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@571cb351
[0;1m 4.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastExactNumericLimits(CastType,[0m SqlOperatorFixture)[3], [3]
TRY_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@7a5e8ea5
10.6sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastExactNumericLimits(CastType,[0m SqlOperatorFixture)
1.3sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastDateTime(CastType,[0m SqlOperatorFixture)
0.6sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastFormatClauseStringToDateTime(CastType,[0m SqlOperatorFixture)
SqlOperatorUnparseTest > testAsindFunc() 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.4sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestBitAndOperatorScalarFunc()[0m
[0;1m 3.1sec[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 149.3sec, 577 completed, 0 failed, [0;34;1m 1[0m
skipped, org.apache.calcite.test.[0;34;1mSqlOperatorUnparseTest[0m
[0;1m 2.2sec[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 2.1sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCscFunc()[0m
[0;1m 3.4sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)[1], [1] CAST,
org.apache.calcite.test.SqlOperatorFixtureImpl@2447f4b
[0;1m 6.2sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)[2], [2] SAFE_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@3de476e3
[0;1m 6.4sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)[3], [3] TRY_CAST,
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@307a216e
16.0sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastToString(CastType,[0m SqlOperatorFixture)
0.9sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastNull(CastType,[0m SqlOperatorFixture)
[0;1m 2.6sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestRandFunc()[0m
0.7sec, 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.4sec[0m,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestSimilarToOperator()[0m
2.8sec, 3 completed, 0 failed, 0 skipped,
org.apache.calcite.test.[0;1mCalciteSqlOperatorTest[0m >
[0;1mtestCastStringToDateTime(CastType,[0m SqlOperatorFixture)
CalciteSqlOperatorTest > testExtractValue() STANDARD_ERROR
[Fatal Error] :1:14: The markup in the document following the root element
must be well-formed.
[0;1m 4.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 302.3sec, 579 completed, 0 failed, [0;34;1m 1[0m
skipped, org.apache.calcite.test.[0;34;1mCalciteSqlOperatorTest[0m
[0;31;1mFAILURE[0m 325.3sec, 15363 completed, [0;31;1m 1[0m failed,
[0;34;1m107[0m skipped, [0;31;1mGradle Test Run :core:test[0m
15363 tests completed, 1 failed, 107 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>
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.7/userguide/command_line_interface.html#sec:command_line_warnings
in the Gradle documentation.
BUILD FAILED in 11m 27s
497 actionable tasks: 497 executed
See the profiling report at:
file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/build/reports/profile/profile-2026-02-12-17-48-10.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.