From caea5267cb8e1fea3702adbdf6f68fd37d13b3b7 Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 3 Jun 2023 01:59:11 +0200 Subject: Adding upstream version 15.0.0. Signed-off-by: Daniel Baumann --- 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