kasakrisz commented on code in PR #5681:
URL: https://github.com/apache/hive/pull/5681#discussion_r1986764052
##########
ql/src/test/queries/clientpositive/cbo_case_when_type_conversion.q:
##########
@@ -0,0 +1,17 @@
+CREATE TABLE t1 (col1 char(3));
+
+INSERT INTO t1 VALUES ('A'),('b'),('c'),(null);
+
+explain cbo
+select col1, case upper(col1) when 'A' then 'OK' else 'N/A' end as col2 from
t1;
+explain
+select col1, case upper(col1) when 'A' then 'OK' else 'N/A' end as col2 from
t1;
+
+select col1, case upper(col1) when 'A' then 'OK' else 'N/A' end as col2 from
t1;
+
+select col1,
Review Comment:
I wanted to add a test when the case expression has multiple when branches.
I actually checked the AST and the Calcite plan of this query via debug and
forgot to remove it.
I add `explain cbo` to see the output in the q.out
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For queries about this service, please contact Infrastructure at:
us...@infra.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: gitbox-unsubscr...@hive.apache.org
For additional commands, e-mail: gitbox-h...@hive.apache.org
