[CALCITE-6140] Add percentile test on SqlParserTest #11232

0.0sec org.apache.calcite.test.LintTest > testLintLog() java.lang.AssertionError: Expected: an empty collection but: <[invalid git log message '[CALCITE-6140] add percentile test on SqlParserTest'; Message must start with upper-case letter, invalid git log message '[CALCITE-6140] add percentile test on SqlParserTest'; Message must start with upper-case letter]> at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.test.LintTest.testLintLog(LintTest.java:296)

Linux (JDK 19): task ':core:test'#L1

Execution failed for task ':core:test': org.gradle.api.tasks.VerificationException: There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/core/build/reports/tests/test/index.html

Linux (JDK 19)

Execution failed for task ':core:test'. > There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/core/build/reports/tests/test/index.html

Linux (JDK 11), Pacific/Chatham Timezone: LintTest.java#L296

Linux (JDK 11), Pacific/Chatham Timezone: task ':core:test'#L1

Linux (JDK 11), Pacific/Chatham Timezone

Execution failed for task ':core:test'. > There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/core/build/reports/tests/test/index.html

Linux (JDK 8), oldest Guava, America/New_York Timezone: LintTest.java#L296

Linux (JDK 8), oldest Guava, America/New_York Timezone: task ':core:test'#L1

Linux (JDK 8), oldest Guava, America/New_York Timezone

Execution failed for task ':core:test'. > There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/core/build/reports/tests/test/index.html

Linux (JDK 17): LintTest.java#L296

Linux (JDK 17): task ':core:test'#L1

Linux (JDK 17)

Execution failed for task ':core:test'. > There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/core/build/reports/tests/test/index.html

Druid Tests: DruidAdapter2IT.java#L2025

0.2sec org.apache.calcite.test.DruidAdapter2IT > testInterleaveBetweenAggregateAndGroupOrderByOnMetrics() java.lang.AssertionError: Expected: "store_state=CA; brand_name=King; A=21.4632\nstore_state=OR; brand_name=Symphony; A=32.176\nstore_state=CA; brand_name=Toretti; A=32.2465\nstore_state=WA; brand_name=King; A=34.6104\nstore_state=OR; brand_name=Toretti; A=36.3" but: was "store_state=OR; brand_name=ADJ; A=83.8764\nstore_state=WA; brand_name=Akron; A=85.8402\nstore_state=OR; brand_name=American; A=86.7898\nstore_state=WA; brand_name=ADJ; A=97.6488\nstore_state=CA; brand_name=ADJ; A=98.0076" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.test.CalciteAssert.lambda$checkResult$6(CalciteAssert.java:453) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:582) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1495) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1434) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1493) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1483) at org.apache.calcite.test.CalciteAssert$AssertQuery.returnsOrdered(CalciteAssert.java:1509) at org.apache.calcite.test.DruidAdapter2IT.testInterleaveBetweenAggregateAndGroupOrderByOnMetrics(DruidAdapter2IT.java:2025) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1, sql=select "store_state", "brand_name", "A" from ( select sum("store_sales")-sum("store_cost") as a, "store_state", "brand_name" from "foodmart" group by "store_state", "brand_name" ) subq order by "A" limit 5 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:389) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 6 more

Druid Tests: DruidAdapterIT.java#L2336

0.2sec org.apache.calcite.test.DruidAdapterIT > testInterleaveBetweenAggregateAndGroupOrderByOnMetrics() java.lang.AssertionError: Expected: "store_state=CA; brand_name=King; A=21.4632\nstore_state=OR; brand_name=Symphony; A=32.176\nstore_state=CA; brand_name=Toretti; A=32.2465\nstore_state=WA; brand_name=King; A=34.6104\nstore_state=OR; brand_name=Toretti; A=36.3" but: was "store_state=OR; brand_name=ADJ; A=83.8764\nstore_state=WA; brand_name=Akron; A=85.8402\nstore_state=OR; brand_name=American; A=86.7898\nstore_state=WA; brand_name=ADJ; A=97.6488\nstore_state=CA; brand_name=ADJ; A=98.0076" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.test.CalciteAssert.lambda$checkResult$6(CalciteAssert.java:453) at org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:582) at org.apache.calcite.test.CalciteAssert$AssertQuery.lambda$returns$1(CalciteAssert.java:1495) at org.apache.calcite.test.CalciteAssert$AssertQuery.withConnection(CalciteAssert.java:1434) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1493) at org.apache.calcite.test.CalciteAssert$AssertQuery.returns(CalciteAssert.java:1483) at org.apache.calcite.test.CalciteAssert$AssertQuery.returnsOrdered(CalciteAssert.java:1509) at org.apache.calcite.test.DruidAdapterIT.testInterleaveBetweenAggregateAndGroupOrderByOnMetrics(DruidAdapterIT.java:2336) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1, sql=select "store_state", "brand_name", "A" from ( select sum("store_sales")-sum("store_cost") as a, "store_state", "brand_name" from "foodmart" group by "store_state", "brand_name" ) subq order by "A" limit 5 at app//org.apache.calcite.util.TestUtil.rethrow(TestUtil.java:389) at app//org.apache.calcite.test.CalciteAssert.assertQuery(CalciteAssert.java:598) ... 6 more

Druid Tests: task ':druid:test'#L1

Execution failed for task ':druid:test': org.gradle.api.tasks.VerificationException: There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/calcite/druid/build/reports/tests/test/index.html

Druid Tests

Execution failed for task ':druid:test'. > There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/calcite/druid/build/reports/tests/test/index.html

Linux (JDK 11), Avatica main: LintTest.java#L296

0.1sec org.apache.calcite.test.LintTest > testLintLog() java.lang.AssertionError: Expected: an empty collection but: <[invalid git log message '[CALCITE-6140] add percentile test on SqlParserTest'; Message must start with upper-case letter, invalid git log message '[CALCITE-6140] add percentile test on SqlParserTest'; Message must start with upper-case letter]> at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.test.LintTest.testLintLog(LintTest.java:296)

Linux (JDK 11), Avatica main: task ':core:test'#L1

Linux (JDK 11), Avatica main

Execution failed for task ':core:test'. > There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/core/build/reports/tests/test/index.html

Linux (JDK 8), latest Guava, America/New_York Timezone: LintTest.java#L296

Linux (JDK 8), latest Guava, America/New_York Timezone: task ':core:test'#L1

Linux (JDK 8), latest Guava, America/New_York Timezone

Execution failed for task ':core:test'. > There were failing tests. See the report at: file:///home/runner/work/calcite/calcite/core/build/reports/tests/test/index.html

Windows (JDK 8): LintTest.java#L296

5.0sec org.apache.calcite.test.LintTest > testLintLog() java.lang.AssertionError: Expected: an empty collection but: <[invalid git log message '[CALCITE-6140] add percentile test on SqlParserTest'; Message must start with upper-case letter, invalid git log message '[CALCITE-6140] add percentile test on SqlParserTest'; Message must start with upper-case letter]> at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.test.LintTest.testLintLog(LintTest.java:296)

Windows (JDK 8): task ':core:test'#L1

Execution failed for task ':core:test': org.gradle.api.tasks.VerificationException: There were failing tests. See the report at: file:///D:/a/calcite/calcite/core/build/reports/tests/test/index.html

Windows (JDK 8)

Execution failed for task ':core:test'. > There were failing tests. See the report at: file:///D:/a/calcite/calcite/core/build/reports/tests/test/index.html

macOS (JDK 19): LintTest.java#L296

macOS (JDK 19): task ':core:test'#L1

Execution failed for task ':core:test': org.gradle.api.tasks.VerificationException: There were failing tests. See the report at: file:///Users/runner/work/calcite/calcite/core/build/reports/tests/test/index.html

macOS (JDK 19)

Execution failed for task ':core:test'. > There were failing tests. See the report at: file:///Users/runner/work/calcite/calcite/core/build/reports/tests/test/index.html

Windows (JDK 17): LintTest.java#L296

2.1sec org.apache.calcite.test.LintTest > testLintLog() java.lang.AssertionError: Expected: an empty collection but: <[invalid git log message '[CALCITE-6140] add percentile test on SqlParserTest'; Message must start with upper-case letter, invalid git log message '[CALCITE-6140] add percentile test on SqlParserTest'; Message must start with upper-case letter]> at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.test.LintTest.testLintLog(LintTest.java:296)

Windows (JDK 17): task ':core:test'#L1

Execution failed for task ':core:test': org.gradle.api.tasks.VerificationException: There were failing tests. See the report at: file:///D:/a/calcite/calcite/core/build/reports/tests/test/index.html

Windows (JDK 17)

Execution failed for task ':core:test'. > There were failing tests. See the report at: file:///D:/a/calcite/calcite/core/build/reports/tests/test/index.html

Error Prone (JDK 11), latest Guava

The following actions uses node12 which is deprecated and will be forced to run on node16: actions/setup-java@v2. For more info: https://github.blog/changelog/2023-06-13-github-actions-all-actions-will-run-on-node16-instead-of-node12-by-default/

Linux (JDK 19)