kasakrisz commented on code in PR #6082:
URL: https://github.com/apache/hive/pull/6082#discussion_r2371664130
##########
ql/src/test/queries/clientpositive/pointlookup6.q:
##########
@@ -17,3 +17,12 @@ WHERE r_table.string_col = l_table.string_col AND
l_table.string_col IN ('AAA111
SELECT l_table.string_col from l_table, r_table
WHERE r_table.string_col = l_table.string_col AND l_table.string_col IN
('AAA111', 'BBB222') AND r_table.string_col IN ('AAA111', 'BBB222');
+
+explain cbo
+SELECT * FROM r_table
+WHERE ( (
+ MINUTE(string_col) = 2 OR
+ MINUTE(string_col) = 10
+ )
+ OR (MINUTE(string_col) IS NULL)
+ );
Review Comment:
With `UPPER(string_col)` a Search operator is introduced and the issue is
not reproducible.
The additional OR nesting is not necessary.
--
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: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
