Changeset: 751f5d1dc3db for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/751f5d1dc3db Added Files: sql/test/BugTracker-2024/Tests/create-index-query-issue-7430.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for issue 7430 diffs (74 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 @@ -2,3 +2,4 @@ inequality-hash-issue-7426 pkey-check-failed-7425 where-between-issue-7428 where-case-null-issue-7429 +create-index-query-issue-7430 diff --git a/sql/test/BugTracker-2024/Tests/create-index-query-issue-7430.test b/sql/test/BugTracker-2024/Tests/create-index-query-issue-7430.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/create-index-query-issue-7430.test @@ -0,0 +1,61 @@ +statement ok +CREATE TABLE t7430(c0 BOOLEAN, c1 VARCHAR) + +statement ok +INSERT INTO t7430 (c0, c1) VALUES (1, 2), (true, 3), (false, 4) + +query IT rowsort +SELECT t7430.c0, t7430.c1 FROM t7430 +---- +0 +4 +1 +2 +1 +3 + +query IT rowsort +SELECT t7430.c0, t7430.c1 FROM t7430 WHERE ((t7430.c0)AND(((t7430.c1) IS NOT NULL))) +---- +1 +2 +1 +3 + +query IT rowsort +SELECT c0, c1 FROM t7430 WHERE c0 AND c1 IS NOT NULL +---- +1 +2 +1 +3 + +-- the next index causes a problem +statement ok +CREATE UNIQUE INDEX i0t7430 ON t7430(c0 , c1) + +query I rowsort +SELECT ((t7430.c0)AND(((t7430.c1) IS NOT NULL))) FROM t7430 +---- +0 +1 +1 + +query IT rowsort +SELECT t7430.c0, t7430.c1 FROM t7430 WHERE ((t7430.c0)AND(((t7430.c1) IS NOT NULL))) +---- +1 +2 +1 +3 + +query IT rowsort +SELECT c0, c1 FROM t7430 WHERE c0 AND c1 IS NOT NULL +---- +1 +2 +1 +3 + +statement ok +DROP TABLE t7430 _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
