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
          7.3sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[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.CalciteSqlOperatorTest > 
testCastIntervalToNumeric(CastType, SqlOperatorFixture)
          2.3sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[2], [2] 
SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@3f910533
          0.1sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCast(CastType, SqlOperatorFixture)
          2.5sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[3], [3] 
TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@1c62399c
          6.5sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)
          0.7sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastDateTime(CastType, SqlOperatorFixture)
          0.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastFormatClauseStringToDateTime(CastType, 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.SqlOperatorUnparseTest > 
testCastTruncates(CastType, SqlOperatorFixture)
          3.5sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseDateTimeToString(CastType, SqlOperatorFixture)
         14.3sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[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
         16.3sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[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.CalciteSqlOperatorTest > 
testCastWithRoundingToScalar(CastType, SqlOperatorFixture)

CalciteSqlOperatorTest > testMapKeysFunc() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          0.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastDecimalToDoubleToInteger(CastType, 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
          3.7sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[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
          4.4sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[42], [42] sql/cast.iq
          3.1sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[44], [44] sql/join.iq
          4.1sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testRandomFunc()
        165.3sec,   45 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest > test(String)
        165.3sec,   45 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest
          2.2sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)[2], [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@60952947
          3.5sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[44], [44] sql/join.iq
        167.7sec,   45 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest2 > test(String)
        167.7sec,   45 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest2
          2.1sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)[3], [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@6c8643bd
          5.8sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)
          0.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastNull(CastType, SqlOperatorFixture)
          0.2sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToApproxNumeric(CastType, SqlOperatorFixture)
          0.1sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastIntervalToInterval(CastType, SqlOperatorFixture)
          0.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToBoolean(CastType, SqlOperatorFixture)
          2.5sec,    2 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testTimestampDiff(boolean)
          0.9sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToInterval(CastType, SqlOperatorFixture)
          1.8sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastStringToDateTime(CastType, SqlOperatorFixture)
          2.5sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, 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.
          4.1sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[2], [2] 
SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@14e194ec
          4.3sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[3], [3] 
TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@129b8efa
         10.9sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)
          1.2sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastDateTime(CastType, SqlOperatorFixture)
          0.5sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseStringToDateTime(CastType, 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.CalciteSqlOperatorTest > 
testCastTruncates(CastType, SqlOperatorFixture)
          2.5sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testBitAndOperatorScalarFunc()
          3.7sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testRlikeOperator()
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastFormatClauseByteToString(CastType, SqlOperatorFixture)
WARNING 151.9sec,  586 completed,   0 failed,   1 
skipped, org.apache.calcite.test.SqlOperatorUnparseTest
          2.1sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testOracleSubstrFunction()
          0.8sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastDecimalToDoubleToInteger(CastType, SqlOperatorFixture)
          3.2sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[1], [1] CAST, 
org.apache.calcite.test.SqlOperatorFixtureImpl@52f621f3
          6.0sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[2], [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@6209a48d
          5.8sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[3], [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@4e552945
         15.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)
          0.7sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastNull(CastType, SqlOperatorFixture)
          2.5sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testRandFunc()
          0.6sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToApproxNumeric(CastType, SqlOperatorFixture)
          0.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastIntervalToInterval(CastType, SqlOperatorFixture)
          0.7sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToBoolean(CastType, SqlOperatorFixture)
          3.3sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testSimilarToOperator()
          2.7sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testJdbcFn()
          4.2sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastStringToDateTime(CastType, SqlOperatorFixture)
          2.5sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testSecFunc()

CalciteSqlOperatorTest > testExtractValue() STANDARD_ERROR
    [Fatal Error] :1:14: The markup in the document following the root element 
must be well-formed.
          2.0sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testHypotFunc()
          2.9sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testToChar()
          2.6sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testBigQuerySubstringFunction()
          8.2sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testRlikeOperator()
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseByteToString(CastType, SqlOperatorFixture)
WARNING 348.9sec,  587 completed,   0 failed,   1 
skipped, org.apache.calcite.test.CalciteSqlOperatorTest
FAILURE 372.1sec, 15891 completed,   1 failed, 
108 skipped, Gradle Test Run :core:test

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.

Reply via email to