Changeset: b790a95128ef for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/b790a95128ef Added Files: sql/test/BugTracker-2024/Tests/multicolumn_IN_value_list-Bug-7497.test Modified Files: sql/test/BugTracker-2024/Tests/All Branch: Dec2023 Log Message:
Added test for Bug #7497 diffs (73 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 @@ -50,3 +50,4 @@ CMDgen_group-Bug-7486 sql_init_subtype-Bug-7487 orderby-max-over-rows-Bug-7488 rel2bin_select-Bug-7496 +multicolumn_IN_value_list-Bug-7497 diff --git a/sql/test/BugTracker-2024/Tests/multicolumn_IN_value_list-Bug-7497.test b/sql/test/BugTracker-2024/Tests/multicolumn_IN_value_list-Bug-7497.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2024/Tests/multicolumn_IN_value_list-Bug-7497.test @@ -0,0 +1,60 @@ +statement ok +CREATE TABLE l (l1 INT, l2 INT, l3 INT); + +statement ok +INSERT INTO l VALUES (42, 44, 11), (41, 45, 22), (43, 42, 33); + +statement ok +CREATE TABLE s (s1 INT, s2 INT, s3 INT); + +statement ok +INSERT INTO s VALUES (41, 44, 10), (42, 44, 20), (34, 44, 30), (41, 45, 40), (34, 45, 50), (34, 44, 60), (42, 44, 70), (42, 44, 80); + +query III nosort +SELECT * FROM s WHERE (s1, s2) IN ((42,44), (41,45), (43,42)) ORDER BY s3; +---- +42 +44 +20 +41 +45 +40 +42 +44 +70 +42 +44 +80 + +query III nosort +SELECT * FROM s WHERE (s1, s2) IN (VALUES (42,44), (41,45), (43,42)) ORDER BY s3; +---- +42 +44 +20 +41 +45 +40 +42 +44 +70 +42 +44 +80 + +query III nosort +SELECT * FROM s WHERE (s1, s2) IN (SELECT l1, l2 FROM l) ORDER BY s3; +---- +42 +44 +20 +41 +45 +40 +42 +44 +70 +42 +44 +80 + _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
