(calcite) branch main updated: [CALCITE-3128] Joining two tables producing only NULLs will return 0 rows

[zhenchen]

This is an automated email from the ASF dual-hosted git repository.

zhenchen pushed a commit to branch main
in repository https://gitbox.apache.org/repos/asf/calcite.git


The following commit(s) were added to refs/heads/main by this push:
     new 6db44aa583 [CALCITE-3128] Joining two tables producing only NULLs will 
return 0 rows
6db44aa583 is described below

commit 6db44aa583699af7d08a9e70e451171142f19a78
Author: Zhen Chen <czjour...@163.com>
AuthorDate: Sun Dec 21 22:15:07 2025 +0800

    [CALCITE-3128] Joining two tables producing only NULLs will return 0 rows
---
 core/src/test/resources/sql/join.iq | 24 ++++++++++++++++++++++++
 1 file changed, 24 insertions(+)

diff --git a/core/src/test/resources/sql/join.iq 
b/core/src/test/resources/sql/join.iq
index 7911edbf6b..ea04212757 100644
--- a/core/src/test/resources/sql/join.iq
+++ b/core/src/test/resources/sql/join.iq
@@ -1113,4 +1113,28 @@ WHERE "t"."EMPNO" = "t2"."EMPNO" AND "t"."EMPNO" > 
"t2"."EMPNO");
 
 !ok
 
+# [CALCITE-3128] Joining two tables producing only NULLs will return 0 rows
+SELECT * FROM (SELECT NULLIF(5, 5)) a , (SELECT NULLIF(5, 5)) b;
++--------+---------+
+| EXPR$0 | EXPR$00 |
++--------+---------+
+|        |         |
++--------+---------+
+(1 row)
+
+!ok
+
+SELECT * FROM (VALUES (NULLIF(5, 5)), (NULLIF(5, 5))) a, (VALUES (NULLIF(5, 
5)), (NULLIF(5, 5))) b;
++---+---+
+| A | B |
++---+---+
+|   |   |
+|   |   |
+|   |   |
+|   |   |
++---+---+
+(4 rows)
+
+!ok
+
 # End join.iq