Changeset: 51ccb8267777 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/51ccb8267777 Modified Files: sql/test/BugTracker-2024/Tests/All Branch: default Log Message:
Merge with Dec2023 diffs (37 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 @@ -32,3 +32,4 @@ exp-bin-Bug-7462 contains-cast-7463 between-true-and-null-Bug-7465 inner-join-contains-7466 +contains-or-7469 diff --git a/sql/test/BugTracker-2024/Tests/contains-or-7469.test b/sql/test/BugTracker-2024/Tests/contains-or-7469.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/contains-or-7469.test @@ -0,0 +1,24 @@ +statement ok +CREATE TABLE t0(c0 BOOLEAN, c1 VARCHAR) + +statement ok +INSERT INTO t0(c0, c1) VALUES (true, 'a') + +statement ok +INSERT INTO t0(c0, c1) VALUES (true, 'b') + +statement ok +INSERT INTO t0(c0, c1) VALUES (false, 'c') + +query TI rowsort +SELECT t0.c1, t0.c0 FROM t0 WHERE ((CONTAINS(t0.c1, ''))OR(t0.c0)) +---- +a +1 +b +1 +c +0 + +statement ok +DROP TABLE t0 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
