Changeset: 2bd7a015d1fc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2bd7a015d1fc Added Files: sql/test/BugTracker-2025/Tests/7688_not_exists_null.test Branch: Mar2025 Log Message:
add missing test for bug #7688 diffs (17 lines): diff --git a/sql/test/BugTracker-2025/Tests/7688_not_exists_null.test b/sql/test/BugTracker-2025/Tests/7688_not_exists_null.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2025/Tests/7688_not_exists_null.test @@ -0,0 +1,12 @@ + +statement ok +create table a (i int, j int) + +statement ok +insert into a values(0, 1), (2, 4) + +query II +select * from (select cast(null as int), 0 ) b(i,j) where not exists (select 1 from a where a.i = b.i and a.j = b.j) +---- +NULL +0 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
