Steve Carlin created IMPALA-13796:
-------------------------------------
Summary: 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
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]
