Changeset: a8669c7acd0f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/a8669c7acd0f Added Files: sql/test/BugTracker-2024/Tests/constant-expression-issue-7457.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
add test for issue #7457 diffs (43 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 @@ -23,3 +23,4 @@ where_null-7450 between-boolean-7451 concat_order-7455 order-by-false-or-false-Bug-7456 +constant-expression-issue-7457 diff --git a/sql/test/BugTracker-2024/Tests/constant-expression-issue-7457.test b/sql/test/BugTracker-2024/Tests/constant-expression-issue-7457.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/constant-expression-issue-7457.test @@ -0,0 +1,30 @@ +statement ok +CREATE TABLE t0(c0 VARCHAR(500), c1 BOOLEAN) + +statement ok +INSERT INTO t0 (c0, c1) VALUES ('a', false) + +statement ok +INSERT INTO t0 (c0) VALUES ('b') + +query TT +SELECT * FROM t0 +---- +a +False +b +NULL + +query T +SELECT (1 AND 3) FROM t0 +---- +True +True + +query TT +SELECT * FROM t0 WHERE (1 AND 3) +---- +a +False +b +NULL _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org