Changeset: 8641cb70a305 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/8641cb70a305 Added Files: sql/test/BugTracker-2023/Tests/union-query-7401.test Modified Files: sql/test/BugTracker-2023/Tests/All Branch: default Log Message:
Add test for issue #7401 diffs (60 lines): diff --git a/sql/test/BugTracker-2023/Tests/All b/sql/test/BugTracker-2023/Tests/All --- a/sql/test/BugTracker-2023/Tests/All +++ b/sql/test/BugTracker-2023/Tests/All @@ -10,3 +10,4 @@ rollback-alter-drop-col-crash-7385 view-on-alias-crash-7386 alter-inc-seq-crash-7387 misc-crashes-7390 +union-query-7401 diff --git a/sql/test/BugTracker-2023/Tests/union-query-7401.test b/sql/test/BugTracker-2023/Tests/union-query-7401.test new file mode 100644 --- /dev/null +++ b/sql/test/BugTracker-2023/Tests/union-query-7401.test @@ -0,0 +1,47 @@ +statement ok +create table t7401(a int, b int) + +statement ok +insert into t7401 values (1,10) + +statement ok +insert into t7401 values (2,20) + +query II nosort +select b as a, a as b from t7401 +---- +10 +1 +20 +2 + +query II nosort +select a as a, b as b from t7401 +UNION +select b as a, a as b from t7401 +---- +1 +10 +2 +20 +10 +1 +20 +2 + +query II nosort +select a as a, b as b from t7401 +UNION ALL +select b as a, a as b from t7401 +---- +1 +10 +2 +20 +10 +1 +20 +2 + +statement ok +drop table t7401 _______________________________________________ checkin-list mailing list -- checkin-list@monetdb.org To unsubscribe send an email to checkin-list-le...@monetdb.org
