Changeset: 20a2cc3713af for MonetDB
URL: https://dev.monetdb.org/hg/MonetDB/rev/20a2cc3713af
Added Files:
        sql/test/BugTracker-2024/Tests/7542-column-name-resolution.test
Modified Files:
        sql/test/BugTracker-2024/Tests/All
Branch: Dec2023
Log Message:

Add test for #7542


diffs (26 lines):

diff --git a/sql/test/BugTracker-2024/Tests/7542-column-name-resolution.test 
b/sql/test/BugTracker-2024/Tests/7542-column-name-resolution.test
new file mode 100644
--- /dev/null
+++ b/sql/test/BugTracker-2024/Tests/7542-column-name-resolution.test
@@ -0,0 +1,13 @@
+
+-- https://github.com/MonetDB/MonetDB/issues/7542
+
+query I nosort
+WITH "E" AS ( SELECT 2 AS "F" )
+  SELECT 3 AS "Z" FROM (
+    SELECT "B"."X" FROM ( SELECT 2 AS "Y" FROM "E" ) AS "A" 
+    LEFT OUTER JOIN ( SELECT 2 AS "X" ) AS "B" ON 1 = 1
+  ) AS "C"
+  ORDER BY "Z" DESC LIMIT 1
+----
+3
+
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
@@ -59,3 +59,4 @@ 7528-jarowinkler-null
 7537-prepare_stmt_with_dropped_table
 7536-mclient-forgets-to-flush
 7541-levenshtein
+7542-column-name-resolution
_______________________________________________
checkin-list mailing list -- checkin-list@monetdb.org
To unsubscribe send an email to checkin-list-le...@monetdb.org

Reply via email to