Changeset: 448186016c1f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/448186016c1f Added Files: sql/test/BugTracker-2024/Tests/contains-cast-7463.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Add test for issue #7463 diffs (58 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 @@ -26,3 +26,4 @@ order-by-false-or-false-Bug-7456 constant-expression-issue-7457 sign-issue-7458 unicode-escape-7461 +contains-cast-7463 diff --git a/sql/test/BugTracker-2024/Tests/contains-cast-7463.test b/sql/test/BugTracker-2024/Tests/contains-cast-7463.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/contains-cast-7463.test @@ -0,0 +1,45 @@ +statement ok +CREATE TABLE t0(c0 INT, c1 INT) + +statement ok +INSERT INTO t0 (c0) VALUES (0) + +statement ok +INSERT INTO t0 (c0, c1) VALUES (1, 1) + +query II +SELECT * FROM t0 +---- +0 +NULL +1 +1 + +query IIT +SELECT t0.c0, CONTAINS(0, t0.c0), CAST(CONTAINS(0, t0.c0) AS VARCHAR) FROM t0 +---- +0 +1 +true +1 +0 +false + +query I +SELECT (t0.c1)AND(CAST(CONTAINS(0, t0.c0) AS VARCHAR)) FROM t0 +---- +NULL +0 + +query II +SELECT * FROM t0 WHERE ((t0.c1)AND(CAST(CONTAINS(0, t0.c0) AS VARCHAR))) +----- + +query II +SELECT * FROM t0 WHERE (NOT ((t0.c1)AND(CAST(CONTAINS(0, t0.c0) AS VARCHAR)))) +---- +1 +1 + +statement ok +DROP TABLE t0 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
