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

Changes:

[Sergey Nuyanzin] [CALCITE-7480] Unparse of `MATCH_RECOGNIZE` with `PARTITION 
BY` or `ORDER BY` produces invalid SQL


------------------------------------------
[...truncated 486.45 KiB...]
    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 > testToTimestamp() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException

CoreQuidemTest2 > test(String) > [17] sql/measure.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 > testArrayPrependFunc() 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
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastFormatClauseNumericToString(CastType, SqlOperatorFixture)

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

CalciteSqlOperatorTest > testGreatestPgFunc() 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

CalciteSqlOperatorTest > testAbsFunc() 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

CalciteSqlOperatorTest > testRegexpExtractFunc() 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

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

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

CalciteSqlOperatorTest > testToBase64() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          4.7sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[13], [13] sql/cast.iq
          3.3sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[18], [18] sql/winagg.iq
          1.5sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastIntervalToNumeric(CastType, SqlOperatorFixture)
          0.1sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCast(CastType, SqlOperatorFixture)

> Task :cassandra:test FAILED
FAILURE 215.4sec,    3 completed,   3 failed,   0 
skipped, Gradle Test Run :cassandra:test

3 tests completed, 3 failed

> Task :core:test
          2.2sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testBigQuerySubstrFunction()

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

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

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

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

SqlOperatorUnparseTest > testCastFormatClauseDateTimeToString(CastType, 
SqlOperatorFixture) > [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@45d7fe34
 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.3sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testToCharPg()
          1.9sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastFormatClauseDateTimeToString(CastType, SqlOperatorFixture)
          3.6sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[18], [18] sql/winagg.iq
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastApproxNumericLimits(CastType, SqlOperatorFixture)

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

SqlOperatorUnparseTest > testCastWithRoundingToScalar(CastType, 
SqlOperatorFixture) > [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@6bccb051
 STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException

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

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

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

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

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

SqlOperatorUnparseTest > testMinusDateOperator() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          2.7sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testPostgresqlSubstrFunction()

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

SqlOperatorUnparseTest > testJsonQuery() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          6.3sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[22], [22] sql/misc.iq
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseNumericToString(CastType, SqlOperatorFixture)
          7.7sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[27], [27] sql/spatial.iq

CoreQuidemTest2 > test(String) > [28] sql/lateral.iq STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          1.3sec,    2 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testTimestampDiff(boolean)
          2.2sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testQuantifyCollectionOperators()

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

SqlOperatorUnparseTest > testCastToInterval(CastType, SqlOperatorFixture) > [2] 
SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@5ec0cb7e
 STANDARD_OUT
    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.SqlOperatorUnparseTest > 
testCastToInterval(CastType, SqlOperatorFixture)
          6.1sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[27], [27] sql/spatial.iq
          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)

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
          5.1sec,    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.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastFormatClauseStringToDateTime(CastType, SqlOperatorFixture)
          3.1sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseDateTimeToString(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)
          2.6sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastWithRoundingToScalar(CastType, SqlOperatorFixture)
         13.6sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[39], [39] sql/agg.iq
        123.7sec,   40 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest2 > test(String)
        123.7sec,   40 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)
         12.9sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[39], [39] sql/agg.iq
        128.5sec,   40 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest > test(String)
        128.5sec,   40 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest
          4.2sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testRandomFunc()
          2.5sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)[2], [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@8a498ef
          2.5sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)[3], [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@3016dffb
          6.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)
          0.4sec,    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.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToApproxNumeric(CastType, SqlOperatorFixture)
          0.2sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastIntervalToInterval(CastType, SqlOperatorFixture)
          0.9sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToInterval(CastType, SqlOperatorFixture)
          0.4sec,    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@55cb367
          2.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastStringToDateTime(CastType, SqlOperatorFixture)
          4.2sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[2], [2] 
SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@7bf90d86

SqlOperatorUnparseTest > testExtractValue() STANDARD_ERROR
    [Fatal Error] :1:14: The markup in the document following the root element 
must be well-formed.
          4.3sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[3], [3] 
TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@ca92162
         11.1sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)
          1.4sec,    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.
          0.8sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastTruncates(CastType, SqlOperatorFixture)
          2.5sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testBitAndOperatorScalarFunc()
          4.5sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testRlikeOperator()
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastFormatClauseByteToString(CastType, SqlOperatorFixture)
WARNING 160.3sec,  579 completed,   0 failed,   1 
skipped, org.apache.calcite.test.SqlOperatorUnparseTest
          2.4sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testOracleSubstrFunction()
          0.7sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastDecimalToDoubleToInteger(CastType, SqlOperatorFixture)
          3.1sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[1], [1] CAST, 
org.apache.calcite.test.SqlOperatorFixtureImpl@3d94489
          5.7sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[2], [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@7707d4bc
          5.3sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[3], [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@3cf485d7
         14.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)
          0.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastNull(CastType, SqlOperatorFixture)
          0.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToApproxNumeric(CastType, SqlOperatorFixture)
          0.2sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastIntervalToInterval(CastType, SqlOperatorFixture)
          0.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToBoolean(CastType, SqlOperatorFixture)
          2.5sec,    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.
          4.4sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testRlikeOperator()
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseByteToString(CastType, SqlOperatorFixture)
WARNING 265.7sec,  581 completed,   0 failed,   1 
skipped, org.apache.calcite.test.CalciteSqlOperatorTest
WARNING 292.3sec, 15449 completed,   0 failed, 107 
skipped, Gradle Test Run :core:test

[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 ':cassandra:test'.
> There were failing tests. See the report at: 
> file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/cassandra/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 2s
493 actionable tasks: 493 executed

See the profiling report at: 
file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/build/reports/profile/profile-2026-04-20-08-54-47.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