[
https://issues.apache.org/jira/browse/IMPALA-14167?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
weihua zhang updated IMPALA-14167:
----------------------------------
Summary: Calcite Planner: union return different result (was: Calcite
Planner: union return diffrent result)
> Calcite Planner: union return different result
> ----------------------------------------------
>
> Key: IMPALA-14167
> URL: https://issues.apache.org/jira/browse/IMPALA-14167
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: weihua zhang
> Priority: Trivial
>
> {code:sql}
> CREATE TABLE test_unionall (date_col DATE);
> INSERT INTO test_unionall values('2025-03-18');
> set use_calcite_planner=0;
> SELECT * FROM (
> SELECT date_col FROM test_unionall
> UNION ALL
> SELECT '2025-03-17 12:00:00' FROM test_unionall
> ) AS t1;
> +------------+
> | date_col |
> +------------+
> | 2025-03-18 |
> | 2025-03-17 |
> +------------+
> {code}
> but
> {code:sql}
> set use_calcite_planner=1;
> SELECT * FROM (
> SELECT date_col FROM test_unionall
> UNION ALL
> SELECT '2025-03-17 12:00:00' FROM test_unionall
> ) AS t1;
> +---------------------+
> | date_col |
> +---------------------+
> | 2025-03-18 |
> | 2025-03-17 12:00:00 |
> +---------------------+
> {code}
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
