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

Changes:

[Yu Xu] [CALCITE-7620] Result of FILTER clause in window functions is incorrect


------------------------------------------
[...truncated 10.07 MiB...]
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException

CalciteSqlOperatorTest > testBigQuerySubstrFunction() 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
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException

SqlOperatorUnparseTest > testBitCountFunc() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          2.3sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testBigQuerySubstrFunction()
          1.6sec,    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
          3.8sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[18], [18] sql/winagg.iq

CoreQuidemTest2 > test(String) > [19] sql/some.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 > testCast(CastType, SqlOperatorFixture) > [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@2e1067a4
 STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          0.1sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCast(CastType, SqlOperatorFixture)

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

SqlOperatorUnparseTest > testSha1() 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 > testYear() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException

SqlOperatorUnparseTest > testExtractWithDatesBeforeUnixEpoch() 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 > testOverlayFunc() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException

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

SqlOperatorUnparseTest > testFloorFunc() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          4.9sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[13], [13] sql/cast.iq
          2.6sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testToCharPg()

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

CoreQuidemTest2 > test(String) > [22] sql/misc.iq STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          2.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastFormatClauseDateTimeToString(CastType, SqlOperatorFixture)
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastApproxNumericLimits(CastType, SqlOperatorFixture)
          2.1sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[17], [17] sql/measure.iq

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

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

SqlOperatorUnparseTest > testBitXorScalarFunc() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          6.4sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[22], [22] sql/misc.iq
          2.1sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[19], [19] sql/some.iq

SqlOperatorUnparseTest > 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
          2.3sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testPostgresqlSubstrFunction()

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

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

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

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

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

SqlOperatorUnparseTest > testMysqlSubstrFunction() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          7.2sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[22], [22] sql/misc.iq
          9.5sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[27], [27] sql/spatial.iq
          2.2sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testQuantifyCollectionOperators()
          1.4sec,    2 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testTimestampDiff(boolean)

CoreQuidemTest2 > test(String) > [34] sql/scalar.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 > testNullOperand() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          0.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToInterval(CastType, SqlOperatorFixture)
          2.1sec,    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.9sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[27], [27] sql/spatial.iq
          2.4sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[2], [2] 
SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@3a6820f6

CoreQuidemTest > test(String) > [34] sql/scalar.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
          3.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseDateTimeToString(CastType, SqlOperatorFixture)
          2.3sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[3], [3] 
TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@5259a54
          6.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)
          0.6sec,    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)

CoreQuidemTest > test(String) > [41] sql/agg.iq 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)
          2.7sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastWithRoundingToScalar(CastType, SqlOperatorFixture)
         13.4sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[41], [41] sql/agg.iq
        181.4sec,   42 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest2 > test(String)
        181.4sec,   42 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest2
          0.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastDecimalToDoubleToInteger(CastType, SqlOperatorFixture)
          4.8sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testRandomFunc()
         13.6sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[41], [41] sql/agg.iq
        190.3sec,   42 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest > test(String)
        190.3sec,   42 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest
          2.6sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)[2], [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@7b5db4d
          2.6sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)[3], [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@6942c214
          6.6sec,    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)
          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)
          0.3sec,    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, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[1], [1] 
CAST, org.apache.calcite.test.SqlOperatorFixtureImpl@10578f06
          4.3sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[2], [2] 
SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@3c342428
          2.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastStringToDateTime(CastType, SqlOperatorFixture)
          4.3sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[3], [3] 
TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@2b7b1455
         11.1sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)

SqlOperatorUnparseTest > testExtractValue() STANDARD_ERROR
    [Fatal Error] :1:14: The markup in the document following the root element 
must be well-formed.
          1.1sec,    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)

SqlOperatorUnparseTest > testAndOperator2() STANDARD_ERROR
    [Fatal Error] :1:2: XML document structures must start and end within the 
same entity.
          0.8sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastTruncates(CastType, SqlOperatorFixture)
          2.6sec, 
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 176.0sec,  580 completed,   0 failed,   1 
skipped, org.apache.calcite.test.SqlOperatorUnparseTest
          2.0sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testOracleSubstrFunction()
          0.7sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastDecimalToDoubleToInteger(CastType, SqlOperatorFixture)
          2.9sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[1], [1] CAST, 
org.apache.calcite.test.SqlOperatorFixtureImpl@2844eccd
          5.4sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[2], [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@12b319ca
          5.5sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[3], [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@26e3691f
         13.8sec,    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.4sec, 
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.6sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testSimilarToOperator()
          2.2sec,    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.
          5.0sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testRlikeOperator()
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseByteToString(CastType, SqlOperatorFixture)
WARNING 337.2sec,  582 completed,   0 failed,   1 
skipped, org.apache.calcite.test.CalciteSqlOperatorTest
FAILURE 363.9sec, 15693 completed,   1 failed, 
109 skipped, Gradle Test Run :core:test

15693 tests completed, 1 failed, 109 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 13m 5s
474 actionable tasks: 474 executed

See the profiling report at: 
file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/build/reports/profile/profile-2026-06-26-01-55-30.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