EmmyMiao87 opened a new issue #2194: Null safe equal join filter the null value URL: https://github.com/apache/incubator-doris/issues/2194 **Describe the bug** The null value has been filtered by null safe equal join **To Reproduce** mysql> select * From nullable_table; +------+------+------+------+------+------+------------+---------------------+------+------+------+ | k1 | k2 | k3 | k4 | k5 | k6 | k10 | k11 | k7 | k8 | k9 | +------+------+------+------+------+------+------------+---------------------+------+------+------+ | 1 | 2 | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | 2 | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | | NULL | NULL | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | +------+------+------+------+------+------+------------+---------------------+------+------+------+ mysql> select * from nullable_table t1, nullable_table t2 where t1.k1<=>t2.k1 ; +------+------+------+------+------+------+------------+---------------------+------+------+------+------+------+------+------+------+------+------------+---------------------+------+------+------+ | k1 | k2 | k3 | k4 | k5 | k6 | k10 | k11 | k7 | k8 | k9 | k1 | k2 | k3 | k4 | k5 | k6 | k10 | k11 | k7 | k8 | k9 | +------+------+------+------+------+------+------------+---------------------+------+------+------+------+------+------+------+------+------+------------+---------------------+------+------+------+ | 1 | 2 | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | 1 | 2 | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | +------+------+------+------+------+------+------------+---------------------+------+------+------+------+------+------+------+------+------+------------+---------------------+------+------+------+ 1 row in set (0.12 sec) **Expected behavior** mysql> select * from nullable_table t1, nullable_table t2 where t1.k1<=>t2.k1 ; +------+------+------+------+------+------+------------+---------------------+------+------+------+------+------+------+------+------+------+------------+---------------------+------+------+------+ | k1 | k2 | k3 | k4 | k5 | k6 | k10 | k11 | k7 | k8 | k9 | k1 | k2 | k3 | k4 | k5 | k6 | k10 | k11 | k7 | k8 | k9 | +------+------+------+------+------+------+------------+---------------------+------+------+------+------+------+------+------+------+------+------------+---------------------+------+------+------+ | 1 | 2 | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | 1 | 2 | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | 2 | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | 2 | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | NULL | NULL | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | | NULL | 2 | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | NULL | 2 | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | | NULL | 2 | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | NULL | NULL | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | NULL | NULL | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | | NULL | NULL | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | NULL | 2 | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | | NULL | NULL | 3 | 4 | 5 | 6 | 2019-10-10 | 2019-10-10 00:00:00 | 7 | 8 | 9 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | +------+------+------+------+------+------+------------+---------------------+------+------+------+------+------+------+------+------+------+------------+---------------------+------+------+------+ 10 rows in set (0.14 sec)
---------------------------------------------------------------- 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. For queries about this service, please contact Infrastructure at: us...@infra.apache.org With regards, Apache Git Services --------------------------------------------------------------------- To unsubscribe, e-mail: commits-unsubscr...@doris.apache.org For additional commands, e-mail: commits-h...@doris.apache.org
