[
https://issues.apache.org/jira/browse/IMPALA-13796?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Steve Carlin resolved IMPALA-13796.
-----------------------------------
Resolution: Fixed
> Calcite Planner: Improper casting on char types
> -----------------------------------------------
>
> Key: IMPALA-13796
> URL: https://issues.apache.org/jira/browse/IMPALA-13796
> Project: IMPALA
> Issue Type: Sub-task
> Reporter: Steve Carlin
> Assignee: Steve Carlin
> Priority: Major
>
> Test found in:
> [test_join_queries.py::TestTPCHJoinQueries::test_outer_joins|https://jenkins.impala.io/view/all/job/calcite-report-prototype/135/artifact/Impala/calcite_report/html/query_test_test_join_queries.py/TestTPCHJoinQueries_test_outer_joins/index.html]
> SELECT COUNT(*) from orders t1 LEFT OUTER JOIN orders t2
> ON cast(t1.o_comment as char(120)) = cast(t2.o_comment as char(120));
> In the join condition, the o_comment is getting cast to the generic "char(1)"
> resulting in a nasty cross join.
>
>
--
This message was sent by Atlassian Jira
(v8.20.10#820010)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
