Changeset: f72bc39e262a for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/f72bc39e262a Added Files: sql/test/BugTracker-2024/Tests/contains-between-issue-7459.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: default Log Message:
add test for bug 7459 diffs (19 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 @@ -25,3 +25,4 @@ concat_order-7455 order-by-false-or-false-Bug-7456 constant-expression-issue-7457 sign-issue-7458 +contains-between-issue-7459 diff --git a/sql/test/BugTracker-2024/Tests/contains-between-issue-7459.test b/sql/test/BugTracker-2024/Tests/contains-between-issue-7459.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/contains-between-issue-7459.test @@ -0,0 +1,6 @@ +statement ok +CREATE TABLE t0(c0 INTEGER, c1 VARCHAR(500)) + +query IT +SELECT * FROM t0 ORDER BY CONTAINS(((CASE '1' WHEN t0.c0 THEN '' ELSE t0.c0 END ) NOT BETWEEN 0 AND t0.c0>=t0.c1), t0.c1) DESC +---- _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org