Changeset: 915fd99cd779 for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/915fd99cd779
Added Files:
sql/test/BugTracker-2025/Tests/7680-union-all.test
Modified Files:
sql/test/BugTracker-2025/Tests/All
Branch: Mar2025
Log Message:
added test for issue # 7680
diffs (45 lines):
diff --git a/sql/test/BugTracker-2025/Tests/7680-union-all.test
b/sql/test/BugTracker-2025/Tests/7680-union-all.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2025/Tests/7680-union-all.test
@@ -0,0 +1,32 @@
+statement ok
+CREATE TABLE "cases" (caseid varchar(255))
+
+statement ok
+INSERT INTO "cases" (caseid) VALUES ('DL1-1')
+
+query TT
+SELECT
+ caseid as caseid,
+ caseid as "delivery.caseid"
+FROM
+ "cases"
+UNION ALL
+SELECT
+ caseid as caseid,
+ cast(null as varchar(255)) as "delivery.caseid"
+FROM
+ "cases"
+UNION ALL
+SELECT
+ caseid as caseid,
+ cast(null as varchar(255)) as "delivery.caseid"
+FROM
+ "cases"
+order by caseid, "delivery.caseid"
+-----
+DL1-1
+NULL
+DL1-1
+NULL
+DL1-1
+DL1-1
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
@@ -22,3 +22,4 @@ 7654_non_monetdb_user_remote_table_exec
7656_incorrect_error
7659_trigger_crashes
7671-lag-over-empty-bat
+7680-union-all
_______________________________________________
checkin-list mailing list -- [email protected]
To unsubscribe send an email to [email protected]
