1 files changed, 68 insertions, 0 deletions
diff --git a/tests/fixtures/optimizer/eliminate_ctes.sql b/tests/fixtures/optimizer/eliminate_ctes.sql
index 11e5e4f..f1f78f4 100644
--- a/tests/fixtures/optimizer/eliminate_ctes.sql
+++ b/tests/fixtures/optimizer/eliminate_ctes.sql
@@ -46,3 +46,71 @@ FROM x;
 SELECT
   a
 FROM x;
+
+# title: CTE reference in subquery where alias matches outer table name
+WITH q AS (
+  SELECT
+    a
+  FROM y
+)
+SELECT
+  a
+FROM x AS q
+WHERE
+  a IN (
+    SELECT
+      a
+    FROM q
+  );
+WITH q AS (
+  SELECT
+    a
+  FROM y
+)
+SELECT
+  a
+FROM x AS q
+WHERE
+  a IN (
+    SELECT
+      a
+    FROM q
+  );
+
+# title: CTE reference in subquery where alias matches outer table name and outer alias is also CTE
+WITH q AS (
+  SELECT
+    a
+  FROM y
+), q2 AS (
+  SELECT
+    a
+  FROM y
+)
+SELECT
+  a
+FROM q2 AS q
+WHERE
+  a IN (
+    SELECT
+      a
+    FROM q
+  );
+WITH q AS (
+  SELECT
+    a
+  FROM y
+), q2 AS (
+  SELECT
+    a
+  FROM y
+)
+SELECT
+  a
+FROM q2 AS q
+WHERE
+  a IN (
+    SELECT
+      a
+    FROM q
+  );
+\ No newline at end of file