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

Changes:

[mbudiu] [CALCITE-7630] BETWEEN unparses incorrectly when left side contains a 
BETWEEN expression

[mbudiu] Unparse should not use sep unless inside a list


------------------------------------------
[...truncated 528.91 KiB...]
    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
    Warning: JDBC driver threw non-SQLException

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

SqlOperatorUnparseTest > testCastIntervalToNumeric(CastType, 
SqlOperatorFixture) > [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@5329e2a7
 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.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastIntervalToNumeric(CastType, SqlOperatorFixture)

SqlOperatorUnparseTest STANDARD_OUT
    Warning: JDBC driver threw non-SQLException

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

SqlOperatorUnparseTest > testCast(CastType, SqlOperatorFixture) > [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@6aba13d8
 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 > testHour() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          2.1sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testBigQuerySubstrFunction()

CalciteSqlOperatorTest > testBitOrScalarFunc() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          3.6sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[18], [18] sql/winagg.iq
          5.4sec, 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

SqlOperatorUnparseTest > testCastFormatClauseDateTimeToString(CastType, 
SqlOperatorFixture) > [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@3ca9b469
 STANDARD_OUT
    Warning: JDBC driver threw non-SQLException

CoreQuidemTest > test(String) > [15] sql/sort.iq STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          2.9sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testToCharPg()
          2.1sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastFormatClauseDateTimeToString(CastType, SqlOperatorFixture)

SqlOperatorUnparseTest > testLessThanOrEqualOperatorInterval() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          2.0sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[21], [21] sql/functions.iq

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

SqlOperatorUnparseTest > testLiteralChain() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          2.1sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[17], [17] sql/measure.iq
          2.1sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testFormatNumber()
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastApproxNumericLimits(CastType, SqlOperatorFixture)
          1.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastWithRoundingToScalar(CastType, SqlOperatorFixture)
          3.8sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[18], [18] sql/winagg.iq

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

CalciteSqlOperatorTest > testParseDatetime() 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) > [23] sql/qualify.iq 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

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

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

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

SqlOperatorUnparseTest > testMinusDateOperator() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          2.2sec, 
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 > testReverseSparkFunc() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException

CalciteSqlOperatorTest > testAgePg() STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
    Warning: JDBC driver threw non-SQLException
          6.5sec, 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)
          8.0sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[27], [27] sql/spatial.iq
          1.6sec,    2 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testTimestampDiff(boolean)
          2.6sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testQuantifyCollectionOperators()

SqlOperatorUnparseTest > testCastToInterval(CastType, SqlOperatorFixture) > [1] 
CAST, 
org.apache.calcite.test.SqlOperatorUnparseTest$SqlOperatorFixtureUnparseImpl@7b5d967
 STANDARD_OUT
    Warning: JDBC driver threw non-SQLException
          0.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToInterval(CastType, SqlOperatorFixture)

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

SqlOperatorUnparseTest > testVariant() 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
          2.2sec,    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.7sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[27], [27] sql/spatial.iq

CoreQuidemTest > test(String) > [35] 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.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)
          0.5sec,    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)
          2.8sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseDateTimeToString(CastType, SqlOperatorFixture)

CalciteSqlOperatorTest > testLiteralChain() STANDARD_ERROR
    [Fatal Error] :1:2: XML document structures must start and end within the 
same entity.
          0.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastTruncates(CastType, SqlOperatorFixture)
          2.4sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastWithRoundingToScalar(CastType, SqlOperatorFixture)
         13.3sec, org.apache.calcite.test.CoreQuidemTest2 > 
test(String)[42], [42] sql/agg.iq
        154.5sec,   43 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest2 > test(String)
        154.5sec,   43 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest2
          0.3sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastDecimalToDoubleToInteger(CastType, SqlOperatorFixture)
          4.3sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testRandomFunc()
         13.0sec, org.apache.calcite.test.CoreQuidemTest > 
test(String)[42], [42] sql/agg.iq
        162.0sec,   43 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest > test(String)
        162.0sec,   43 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CoreQuidemTest
          2.5sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)[2], [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@66febf48
          2.2sec, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastToString(CastType, SqlOperatorFixture)[3], [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@6276f053
          6.2sec,    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.9sec,    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.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)
          1.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToInterval(CastType, SqlOperatorFixture)
          2.0sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testStandardSubstringFunction()
          2.6sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[1], [1] 
CAST, org.apache.calcite.test.SqlOperatorFixtureImpl@692673a4
          1.9sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.SqlOperatorUnparseTest > 
testCastStringToDateTime(CastType, SqlOperatorFixture)
          4.3sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[2], [2] 
SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@2c8dc3af

SqlOperatorUnparseTest > testExtractValue() STANDARD_ERROR
    [Fatal Error] :1:14: The markup in the document following the root element 
must be well-formed.
          4.6sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)[3], [3] 
TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@569264e3
         11.5sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastExactNumericLimits(CastType, SqlOperatorFixture)
          1.3sec,    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.7sec, 
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 157.5sec,  580 completed,   0 failed,   1 
skipped, org.apache.calcite.test.SqlOperatorUnparseTest
          2.5sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testOracleSubstrFunction()
          0.9sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastDecimalToDoubleToInteger(CastType, SqlOperatorFixture)
          2.4sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCscFunc()
          3.0sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[1], [1] CAST, 
org.apache.calcite.test.SqlOperatorFixtureImpl@57553f8d
          5.6sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[2], [2] SAFE_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@417879bc
          5.7sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastToString(CastType, SqlOperatorFixture)[3], [3] TRY_CAST, 
org.apache.calcite.test.SqlOperatorFixtures$SqlOperatorFixtureInvocationHandler@6e399b6f
         14.3sec,    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.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.4sec,    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.7sec, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testRlikeOperator()
          0.0sec,    3 completed,   0 failed,   0 skipped, 
org.apache.calcite.test.CalciteSqlOperatorTest > 
testCastFormatClauseByteToString(CastType, SqlOperatorFixture)
WARNING 311.0sec,  582 completed,   0 failed,   1 
skipped, org.apache.calcite.test.CalciteSqlOperatorTest
FAILURE 334.7sec, 15700 completed,   1 failed, 
109 skipped, Gradle Test Run :core:test

15700 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 11m 27s
472 actionable tasks: 472 executed

See the profiling report at: 
file://<https://ci-builds.apache.org/job/Calcite/job/Calcite-snapshots/ws/build/reports/profile/profile-2026-06-29-23-31-51.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