Changeset: 86b13fec3ed2 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/86b13fec3ed2 Added Files: sql/test/BugTracker-2024/Tests/7541-levenshtein.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Test for #7541. diffs (51 lines): diff --git a/sql/test/BugTracker-2024/Tests/7541-levenshtein.test b/sql/test/BugTracker-2024/Tests/7541-levenshtein.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/7541-levenshtein.test @@ -0,0 +1,38 @@ +statement ok +CREATE TABLE t0 (c0 BOOLEAN) + +statement ok +CREATE TABLE t1 (c1 INT) + +statement ok +INSERT INTO t1(c1) VALUES (1) + +statement ok +INSERT INTO t0(c0) VALUES (false) + +statement ok +INSERT INTO t0(c0) VALUES (true) + +query II rowsort +SELECT * FROM t1 LEFT JOIN t0 ON LEVENSHTEIN(t0.c0, true) +---- +1 +0 + +query II rowsort +SELECT * FROM t1 LEFT JOIN t0 ON LEVENSHTEIN(t0.c0, true) WHERE t0.c0 UNION ALL SELECT * FROM t1 LEFT JOIN t0 ON LEVENSHTEIN(t0.c0, true) WHERE (NOT t0.c0) UNION ALL SELECT * FROM t1 LEFT JOIN t0 ON LEVENSHTEIN(t0.c0, true) WHERE ((t0.c0) IS NULL) +---- +1 +0 + +query I rowsort +SELECT LEVENSHTEIN(true, true) +---- +0 + +query I rowsort +SELECT LEVENSHTEIN(t0.c0, true) FROM t0 +---- +0 +4 + 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 @@ -58,3 +58,4 @@ 7513-uri-authority-parse-issue 7528-jarowinkler-null 7537-prepare_stmt_with_dropped_table 7536-mclient-forgets-to-flush +7541-levenshtein _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
