From caea5267cb8e1fea3702adbdf6f68fd37d13b3b7 Mon Sep 17 00:00:00 2001
From: Daniel Baumann <daniel.baumann@progress-linux.org>
Date: Sat, 3 Jun 2023 01:59:11 +0200
Subject: Adding upstream version 15.0.0.

Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
---
 tests/fixtures/optimizer/normalize_identifiers.sql | 57 ++++++++++++++++++++++
 1 file changed, 57 insertions(+)
 create mode 100644 tests/fixtures/optimizer/normalize_identifiers.sql

(limited to 'tests/fixtures/optimizer/normalize_identifiers.sql')

diff --git a/tests/fixtures/optimizer/normalize_identifiers.sql b/tests/fixtures/optimizer/normalize_identifiers.sql
new file mode 100644
index 0000000..ddb755f
--- /dev/null
+++ b/tests/fixtures/optimizer/normalize_identifiers.sql
@@ -0,0 +1,57 @@
+SELECT a FROM x;
+SELECT a FROM x;
+
+# dialect: snowflake
+SELECT A FROM X;
+SELECT A FROM X;
+
+SELECT "A" FROM "X";
+SELECT "A" FROM "X";
+
+SELECT a AS A FROM x;
+SELECT a AS a FROM x;
+
+# dialect: snowflake
+SELECT A AS a FROM X;
+SELECT A AS A FROM X;
+
+SELECT * FROM x;
+SELECT * FROM x;
+
+SELECT A FROM x;
+SELECT a FROM x;
+
+# dialect: snowflake
+SELECT a FROM X;
+SELECT A FROM X;
+
+SELECT a FROM X;
+SELECT a FROM x;
+
+# dialect: snowflake
+SELECT A FROM x;
+SELECT A FROM X;
+
+SELECT A AS A FROM (SELECT a AS A FROM x);
+SELECT a AS a FROM (SELECT a AS a FROM x);
+
+SELECT a AS B FROM x ORDER BY B;
+SELECT a AS b FROM x ORDER BY b;
+
+SELECT A FROM x ORDER BY A;
+SELECT a FROM x ORDER BY a;
+
+SELECT A AS B FROM X GROUP BY A HAVING SUM(B) > 0;
+SELECT a AS b FROM x GROUP BY a HAVING SUM(b) > 0;
+
+SELECT A AS B, SUM(B) AS C FROM X GROUP BY A HAVING C > 0;
+SELECT a AS b, SUM(b) AS c FROM x GROUP BY a HAVING c > 0;
+
+SELECT A FROM X UNION SELECT A FROM X;
+SELECT a FROM x UNION SELECT a FROM x;
+
+SELECT A AS A FROM X UNION SELECT A AS A FROM X;
+SELECT a AS a FROM x UNION SELECT a AS a FROM x;
+
+(SELECT A AS A FROM X);
+(SELECT a AS a FROM x);
-- 
cgit v1.2.3

