From 20739a12c39121a9e7ad3c9a2469ec5a6876199d Mon Sep 17 00:00:00 2001 From: Daniel Baumann Date: Sat, 3 Jun 2023 01:59:40 +0200 Subject: Merging 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