diff options
author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-06-02 23:59:11 +0000 |
---|---|---|
committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-06-02 23:59:11 +0000 |
commit | caea5267cb8e1fea3702adbdf6f68fd37d13b3b7 (patch) | |
tree | f06f1da1ab3b6906beca1c3c7222d28ff00766ac /tests/fixtures/optimizer/lower_identities.sql | |
parent | Adding upstream version 12.2.0. (diff) | |
download | sqlglot-caea5267cb8e1fea3702adbdf6f68fd37d13b3b7.tar.xz sqlglot-caea5267cb8e1fea3702adbdf6f68fd37d13b3b7.zip |
Adding upstream version 15.0.0.upstream/15.0.0
Signed-off-by: Daniel Baumann <daniel.baumann@progress-linux.org>
Diffstat (limited to 'tests/fixtures/optimizer/lower_identities.sql')
-rw-r--r-- | tests/fixtures/optimizer/lower_identities.sql | 41 |
1 files changed, 0 insertions, 41 deletions
diff --git a/tests/fixtures/optimizer/lower_identities.sql b/tests/fixtures/optimizer/lower_identities.sql deleted file mode 100644 index cea346f..0000000 --- a/tests/fixtures/optimizer/lower_identities.sql +++ /dev/null @@ -1,41 +0,0 @@ -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; - -SELECT * FROM x; -SELECT * FROM x; - -SELECT A FROM x; -SELECT a FROM x; - -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); |