yiguolei commented on code in PR #17569:
URL: https://github.com/apache/doris/pull/17569#discussion_r1129277585
##########
regression-test/suites/correctness_p0/test_null_predicate.groovy:
##########
@@ -115,4 +115,21 @@ suite("test_null_predicate") {
"""
qt_select15 """ select * from test_null_predicate2 where `value` is null
order by id; """
+
+ sql """ DROP TABLE IF EXISTS test_null_predicate"""
+ sql """
+ create table test_null_predicate (
+ id boolean null,
+ value int null
+ ) duplicate key(id)
+ DISTRIBUTED BY HASH(id) buckets 1
+ PROPERTIES ("replication_allocation" = "tag.location.default: 1");
+ """
Review Comment:
value column is not the key column, the scan key does have affect on this?
I think it's better to add a case that the predicate column is nullable and
it is also part of duplcate column.
--
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]
