Changeset: 3f9e28a4565f for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/3f9e28a4565f Added Files: sql/test/BugTracker-2025/Tests/7761-semijoin-string-comparison.test Modified Files: sql/test/BugTracker-2025/Tests/All Branch: default Log Message:
add test for fixed issue #7761, issue was fixed by the string casting in comparisons changes diffs (25 lines): diff --git a/sql/test/BugTracker-2025/Tests/7761-semijoin-string-comparison.test b/sql/test/BugTracker-2025/Tests/7761-semijoin-string-comparison.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2025/Tests/7761-semijoin-string-comparison.test @@ -0,0 +1,9 @@ +statement ok +CREATE TABLE t0(c0 INTEGER, c1 INTEGER) + +statement ok rowcount 1 +INSERT INTO t0 (c0, c1) VALUES (-9, -1) + +query II +SELECT * FROM t0 WHERE EXISTS (SELECT 1 FROM (SELECT CAST(t0.c1 AS VARCHAR) AS col0 FROM t0) AS subQuery WHERE ((t0.c0)>(subQuery.col0))) +---- diff --git a/sql/test/BugTracker-2025/Tests/All b/sql/test/BugTracker-2025/Tests/All --- a/sql/test/BugTracker-2025/Tests/All +++ b/sql/test/BugTracker-2025/Tests/All @@ -83,6 +83,7 @@ 7753-like-in-projection 7752-union-sum 7756-anti-join-null 7759-replace-wrong-error +7761-semijoin-string-comparison 7763-exits-with-null 7760-groupby_posarg_CP 7768-not-in _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
