Changeset: 2aeb8a1150cc for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/2aeb8a1150cc Added Files: sql/test/BugTracker-2024/Tests/where-cond-issue-7447.test sql/test/BugTracker-2024/Tests/where-cond-issue-7448.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add tests for issues 7447 and 7448. diffs (79 lines): diff --git a/sql/test/BugTracker-2024/Tests/All b/sql/test/BugTracker-2024/Tests/All --- a/sql/test/BugTracker-2024/Tests/All +++ b/sql/test/BugTracker-2024/Tests/All @@ -16,3 +16,5 @@ is-col-uniq-crash-7441 unaligned_mats-7442 recursive-merge-table-crash-7443 greatest-as-colname-7444 +where-cond-issue-7447 +where-cond-issue-7448 diff --git a/sql/test/BugTracker-2024/Tests/where-cond-issue-7447.test b/sql/test/BugTracker-2024/Tests/where-cond-issue-7447.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/where-cond-issue-7447.test @@ -0,0 +1,32 @@ +statement ok +CREATE TABLE t0(c0 INTEGER, c1 BOOLEAN, PRIMARY KEY(c0)) + +statement ok +CREATE TABLE t1(c1 INTEGER) + +statement ok +INSERT INTO t1 (c1) VALUES (null) + +statement ok +INSERT INTO t0 (c0, c1) VALUES (-1, false) + +query I +SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t0.c1 NOT BETWEEN t1.c1 AND t0.c0) +---- +-1 + +query I +SELECT (t1.c1>1) IS NULL FROM t0 INNER JOIN t1 ON (t0.c1 NOT BETWEEN t1.c1 AND t0.c0) +---- +1 + +query I +SELECT t0.c0 FROM t0 INNER JOIN t1 ON (t0.c1 NOT BETWEEN t1.c1 AND t0.c0) WHERE (t1.c1>1) IS NULL +---- +-1 + +statement ok +DROP TABLE t0 CASCADE + +statement ok +DROP TABLE t1 CASCADE diff --git a/sql/test/BugTracker-2024/Tests/where-cond-issue-7448.test b/sql/test/BugTracker-2024/Tests/where-cond-issue-7448.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/where-cond-issue-7448.test @@ -0,0 +1,28 @@ +statement ok +CREATE TABLE t0(c0 BOOLEAN, c1 VARCHAR) + +statement ok +INSERT INTO t0 (c0, c1) VALUES (true, true) + +statement ok +CREATE INDEX i0 ON t0(c1 , c0 ) + +query IT +SELECT * FROM t0 +---- +1 +true + +query I +SELECT (t0.c1=(t0.c0 OR true))AND(t0.c0) FROM t0 +---- +1 + +query IT +SELECT * FROM t0 WHERE ((t0.c1=(t0.c0 OR true))AND(t0.c0)) +---- +1 +true + +statement ok +DROP TABLE t0 CASCADE _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
