Changeset: 5d61258827d1 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/5d61258827d1 Added Files: sql/test/BugTracker-2025/Tests/7644_antijoin_crash.test sql/test/BugTracker-2025/Tests/7646_leftjoin_crash.test Modified Files: sql/test/BugTracker-2025/Tests/All Branch: Mar2025 Log Message:
add tests for bugs #7644 and #7646 diffs (41 lines): diff --git a/sql/test/BugTracker-2025/Tests/7644_antijoin_crash.test b/sql/test/BugTracker-2025/Tests/7644_antijoin_crash.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2025/Tests/7644_antijoin_crash.test @@ -0,0 +1,15 @@ +statement ok +CREATE TABLE database0_t2(c0 DOUBLE) + +statement ok +CREATE TABLE database0_t4(c0 DOUBLE) + +statement ok +INSERT INTO database0_t2 VALUES(1.0) + +statement ok +INSERT INTO database0_t4 VALUES(1.0) + +query I +SELECT * FROM database0_t2 WHERE NOT EXISTS(SELECT 1 FROM database0_t4 WHERE (database0_t2.c0) IN (database0_t4.c0, database0_t2.c0)) +---- diff --git a/sql/test/BugTracker-2025/Tests/7646_leftjoin_crash.test b/sql/test/BugTracker-2025/Tests/7646_leftjoin_crash.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2025/Tests/7646_leftjoin_crash.test @@ -0,0 +1,7 @@ +statement ok +CREATE TABLE t1(c0 INT) + +query II +SELECT * FROM t1 LEFT JOIN (SELECT 1) ON EXISTS (SELECT (VALUES (1))); +---- + diff --git a/sql/test/BugTracker-2025/Tests/All b/sql/test/BugTracker-2025/Tests/All --- a/sql/test/BugTracker-2025/Tests/All +++ b/sql/test/BugTracker-2025/Tests/All @@ -11,3 +11,5 @@ 7632-crash-leftjoin-exists 7633-crash-leftjoin-any 7634_join_with_subquery_crash 7636_antijoin_crash +7644_antijoin_crash +7646_leftjoin_crash _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
