Skip to content

[CALCITE-6322] Casts to DECIMAL types are ignored #12217

[CALCITE-6322] Casts to DECIMAL types are ignored

[CALCITE-6322] Casts to DECIMAL types are ignored #12217

Triggered via pull request March 13, 2024 21:40
Status Failure
Total duration 16m 32s
Artifacts

main.yml

on: pull_request
Windows (JDK 8)
15m 43s
Windows (JDK 8)
Windows (JDK 17)
15m 0s
Windows (JDK 17)
Linux (JDK 8), oldest Guava, America/New_York Timezone
10m 4s
Linux (JDK 8), oldest Guava, America/New_York Timezone
Linux (JDK 8), latest Guava, America/New_York Timezone
11m 21s
Linux (JDK 8), latest Guava, America/New_York Timezone
Linux (JDK 11), Pacific/Chatham Timezone
10m 5s
Linux (JDK 11), Pacific/Chatham Timezone
Linux (JDK 17)
9m 50s
Linux (JDK 17)
Linux (JDK 19)
9m 8s
Linux (JDK 19)
Linux (JDK 11), Avatica main
11m 45s
Linux (JDK 11), Avatica main
macOS (JDK 19)
16m 20s
macOS (JDK 19)
Error Prone (JDK 11), latest Guava
3m 58s
Error Prone (JDK 11), latest Guava
CheckerFramework (JDK 11)
10m 0s
CheckerFramework (JDK 11)
CheckerFramework (JDK 11), oldest Guava
10m 12s
CheckerFramework (JDK 11), oldest Guava
Linux (JDK 8) Slow Tests
0s
Linux (JDK 8) Slow Tests
Druid Tests
7m 6s
Druid Tests
Fit to window
Zoom out
Zoom in

Annotations

4 errors and 26 warnings
Druid Tests: DruidAdapter2IT.java#L1917
0.1sec org.apache.calcite.test.DruidAdapter2IT > testPartiallyPostAggregation() java.lang.AssertionError: Expected: a string containing "PLAN=EnumerableInterpreter\n DruidQuery(table=[[foodmart, foodmart]], intervals=[[1900-01-09T00:00:00.000Z/2992-01-10T00:00:00.000Z]], projects=[[$63, $90, $91, $89]], groups=[{0}], aggs=[[SUM($1), SUM($2), SUM($3)]], post_projects=[[$0, /($1, $2), CASE(=($3, 0), 1.0:DECIMAL(19, 0), CAST($3):DECIMAL(19, 0))]], sort0=[1], dir0=[DESC])\n" but: was "PLAN=EnumerableInterpreter\n DruidQuery(table=[[foodmart, foodmart]], intervals=[[1900-01-09T00:00:00.000Z/2992-01-10T00:00:00.000Z]], projects=[[$63, $90, $91, $89]], groups=[{0}], aggs=[[SUM($1), SUM($2), SUM($3)]], post_projects=[[$0, /($1, $2), CASE(=($3, 0), CAST(1:DECIMAL(19, 0)):DECIMAL(19, 0), CAST($3):DECIMAL(19, 0))]], sort0=[1], dir0=[DESC])\n\n" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.test.CalciteAssert.lambda$checkResultContains$7(CalciteAssert.java:468) 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.explainMatches(CalciteAssert.java:1691) at org.apache.calcite.test.CalciteAssert$AssertQuery.explainContains(CalciteAssert.java:1587) at org.apache.calcite.test.DruidAdapter2IT.testPartiallyPostAggregation(DruidAdapter2IT.java:1917) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1, sql=explain plan for select "store_state", sum("store_sales") / sum("store_cost") as a, case when sum("unit_sales")=0 then 1.0 else sum("unit_sales") end as b from "foodmart" group by "store_state" order by a desc 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#L2225
0.0sec org.apache.calcite.test.DruidAdapterIT > testPartiallyPostAggregation() java.lang.AssertionError: Expected: a string containing "DruidQuery(table=[[foodmart, foodmart]], intervals=[[1900-01-09T00:00:00.000Z/2992-01-10T00:00:00.000Z]], projects=[[$63, $90, $91, $89]], groups=[{0}], aggs=[[SUM($1), SUM($2), SUM($3)]], post_projects=[[$0, /($1, $2), CASE(=($3, 0), 1.0:DECIMAL(19, 0), CAST($3):DECIMAL(19, 0))]], sort0=[1], dir0=[DESC])" but: was "PLAN=EnumerableInterpreter\n DruidQuery(table=[[foodmart, foodmart]], intervals=[[1900-01-09T00:00:00.000Z/2992-01-10T00:00:00.000Z]], projects=[[$63, $90, $91, $89]], groups=[{0}], aggs=[[SUM($1), SUM($2), SUM($3)]], post_projects=[[$0, /($1, $2), CASE(=($3, 0), CAST(1:DECIMAL(19, 0)):DECIMAL(19, 0), CAST($3):DECIMAL(19, 0))]], sort0=[1], dir0=[DESC])\n\n" at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:18) at org.hamcrest.MatcherAssert.assertThat(MatcherAssert.java:6) at org.apache.calcite.test.CalciteAssert.lambda$checkResultContains$7(CalciteAssert.java:468) 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.explainMatches(CalciteAssert.java:1691) at org.apache.calcite.test.CalciteAssert$AssertQuery.explainContains(CalciteAssert.java:1587) at org.apache.calcite.test.DruidAdapterIT.testPartiallyPostAggregation(DruidAdapterIT.java:2225) Suppressed: org.apache.calcite.util.TestUtil$ExtraInformation: With materializationsEnabled=false, limit=-1, sql=explain plan for select "store_state", sum("store_sales") / sum("store_cost") as a, case when sum("unit_sales")=0 then 1.0 else sum("unit_sales") end as b from "foodmart" group by "store_state" order by a desc 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
Error Prone (JDK 11), latest Guava
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
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/
Druid Tests
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/setup-java@v2, actions/checkout@v3, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Druid Tests
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)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 19)
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 17)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 17)
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/
CheckerFramework (JDK 11)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
CheckerFramework (JDK 11)
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 8), oldest Guava, America/New_York Timezone
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 8), oldest Guava, America/New_York Timezone
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 11), Pacific/Chatham Timezone
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 11), Pacific/Chatham Timezone
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/
CheckerFramework (JDK 11), oldest Guava
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
CheckerFramework (JDK 11), oldest 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 8), latest Guava, America/New_York Timezone
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 8), latest Guava, America/New_York Timezone
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 11), Avatica main
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/setup-java@v2, burrunan/gradle-cache-action@v1, actions/checkout@v3. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Linux (JDK 11), Avatica main
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/
Windows (JDK 17)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Windows (JDK 17)
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/
Windows (JDK 8)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
Windows (JDK 8)
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/
macOS (JDK 19)
Node.js 16 actions are deprecated. Please update the following actions to use Node.js 20: actions/checkout@v3, actions/setup-java@v2, burrunan/gradle-cache-action@v1. For more information see: https://github.blog/changelog/2023-09-22-github-actions-transitioning-from-node-16-to-node-20/.
macOS (JDK 19)
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/