See 
<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/1970/display/redirect?page=changes>

Changes:

[Yu Xu] [CALCITE-7655] RelToSqlConverter incorrectly removes a subquery when 
grouping by a window function result


------------------------------------------
[...truncated 10.07 MiB...]
CoreQuidemTest > test(String) > [9] sql/join.iq STANDARD_OUT
    Warning: JDBC driver threw non-SQLException

SqlOperatorUnparseTest > testAgePg() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastFormatClauseNumericToString(CastType, SqlOperatorFixture)
          3.6sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[13], [13] sql/cast.iq
          2.9sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[9], [9] sql/join.iq

CoreQuidemTest > test(String) > [13] 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
          1.1sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastIntervalToNumeric(CastType, SqlOperatorFixture)

SqlOperatorUnparseTest > testCase() 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
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCast(CastType, SqlOperatorFixture)

SqlOperatorUnparseTest > testCastFormatClauseDateTimeToString(CastType, 
SqlOperatorFixture) > [1] CAST, 
org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@169a1cd6
 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 > testCastFormatClauseDateTimeToString(CastType, 
SqlOperatorFixture) > [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@11e20666
 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

SqlOperatorUnparseTest > testCastFormatClauseDateTimeToString(CastType, 
SqlOperatorFixture) > [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@35226fe3
 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
          1.6sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastFormatClauseDateTimeToString(CastType, SqlOperatorFixture)
          3.8sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[18], [18] sql/winagg.iq
          4.1sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[13], [13] sql/cast.iq

CoreQuidemTest2 > test(String) > [20] sql/unsigned.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

SqlOperatorUnparseTest > testFindInSetFunc() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          2.2sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testToCharPg()

SqlOperatorUnparseTest > testCastWithRoundingToScalar(CastType, 
SqlOperatorFixture) > [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@44705ddd
 STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          1.2sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastWithRoundingToScalar(CastType, SqlOperatorFixture)

SqlOperatorUnparseTest > testMapKeysFunc() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastApproxNumericLimits(CastType, SqlOperatorFixture)
          3.3sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[18], [18] sql/winagg.iq

CalciteSqlOperatorTest > testIfNullFunc() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          2.3sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testRandomFunc()

CalciteSqlOperatorTest > testParseDatetime() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException

SqlOperatorUnparseTest > testArrayJoinFunc() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException

CalciteSqlOperatorTest > testCurrentDateFuncWithFixedTime() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          5.3sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[22], [22] sql/misc.iq

CoreQuidemTest2 > test(String) > [23] sql/qualify.iq STANDARD_OUT
    Warning: JDBC driver threw non-SQLException

SqlOperatorUnparseTest > testJsonLength() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException

CoreQuidemTest2 > test(String) > [27] sql/spatial.iq STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          2.1sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testPostgresqlSubstrFunction()

SqlOperatorUnparseTest > testFormatDate() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          0.1sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastBooleanToNumeric(CastType, SqlOperatorFixture)

CalciteSqlOperatorTest > testArrayPrependFunc() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          1.7sec,    2 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testTimestampDiff(boolean)
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseNumericToString(CastType, SqlOperatorFixture)

SqlOperatorUnparseTest > testCastToInterval(CastType, SqlOperatorFixture) > [3] 
TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@24ac9444
 STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          6.9sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[22], [22] sql/misc.iq
          0.5sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToInterval(CastType, SqlOperatorFixture)
          7.8sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[27], [27] sql/spatial.iq
          2.9sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testQuantifyCollectionOperators()

SqlOperatorUnparseTest > testCastExactNumericLimits(CastType, 
SqlOperatorFixture) > [1] CAST, 
org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@169a1cd6
 STANDARD_OUT
    Warning: JDBC driver threw non-SQLException

CoreQuidemTest2 > test(String) > [35] sql/scalar.iq STANDARD_OUT
    Warning: JDBC driver threw non-SQLException

CalciteSqlOperatorTest > testCastIntervalToNumeric(CastType, 
SqlOperatorFixture) > [1] CAST, 
org.apache.calcite.test.SqlOperatorFixtureImpl@124de777 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.7sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastIntervalToNumeric(CastType, SqlOperatorFixture)
          0.1sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCast(CastType, SqlOperatorFixture)
          5.6sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[27], [27] sql/spatial.iq
          3.9sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)
          0.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastDateTime(CastType, SqlOperatorFixture)
          0.2sec,    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.2sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastTruncates(CastType, SqlOperatorFixture)

CoreQuidemTest > test(String) > [35] sql/scalar.iq STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException

SqlOperatorUnparseTest > testCompress() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          3.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseDateTimeToString(CastType, SqlOperatorFixture)
          0.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastDecimalToDoubleToInteger(CastType, SqlOperatorFixture)
          2.7sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastWithRoundingToScalar(CastType, SqlOperatorFixture)
         11.6sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[43], [43] sql/agg.iq
        157.2sec,   44 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest2 > test(String)
        157.2sec,   44 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest2
          2.2sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)[2], [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@7dee251d
          3.6sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testRandomFunc()
         12.8sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[43], [43] sql/agg.iq
          2.4sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)[3], [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@51f4abf8
          6.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)
        165.3sec,   44 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest > test(String)
        165.3sec,   44 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest
          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.8sec,    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.9sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastStringToDateTime(CastType, SqlOperatorFixture)
          2.6sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[1], [1] 
CAST, org.apache.calcite.test.SqlOperatorFixtureImpl@34248c49

SqlOperatorUnparseTest > testExtractValue() STANDARD_ERROR
    [Fatal Error] :1:14: The markup in the document following the root element 
must be well-formed.
          4.4sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[2], [2] 
SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@299f0e3f
          4.5sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[3], [3] 
TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@583b2352
         11.5sec,    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.6sec,    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.
          3.3sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testRlikeOperator()
          0.7sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastTruncates(CastType, SqlOperatorFixture)
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastFormatClauseByteToString(CastType, SqlOperatorFixture)
WARNING 142.3sec,  580 completed,   0 failed,   1 
skipped, org.apache.calcite.test.SqlOperatorUnparseTest
          2.4sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testBitAndOperatorScalarFunc()
          0.8sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastDecimalToDoubleToInteger(CastType, SqlOperatorFixture)
          2.0sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCscFunc()
          2.8sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[1], [1] CAST, 
org.apache.calcite.test.SqlOperatorFixtureImpl@6f417b50
          5.6sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[2], [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@6f48fef3
          5.7sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[3], [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@735d8876
         14.1sec,    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.3sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testRandFunc()
          0.6sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToApproxNumeric(CastType, SqlOperatorFixture)
          0.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastIntervalToInterval(CastType, SqlOperatorFixture)
          0.6sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToBoolean(CastType, SqlOperatorFixture)
          2.7sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testSimilarToOperator()
          2.0sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testJdbcFn()
          3.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastStringToDateTime(CastType, SqlOperatorFixture)

CalciteSqlOperatorTest > testExtractValue() STANDARD_ERROR
    [Fatal Error] :1:14: The markup in the document following the root element 
must be well-formed.
          2.9sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testToChar()
          4.1sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testRlikeOperator()
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseByteToString(CastType, SqlOperatorFixture)
WARNING 320.0sec,  582 completed,   0 failed,   1 
skipped, org.apache.calcite.test.CalciteSqlOperatorTest
FAILURE 342.0sec, 15825 completed,   1 failed, 
108 skipped, Gradle Test Run :core:test

15825 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 11m 43s
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-07-21-02-15-03.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