diff options
| author | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-06-02 23:59:40 +0000 |
|---|---|---|
| committer | Daniel Baumann <daniel.baumann@progress-linux.org> | 2023-06-02 23:59:46 +0000 |
| commit | 20739a12c39121a9e7ad3c9a2469ec5a6876199d (patch) | |
| tree | c000de91c59fd29b2d9beecf9f93b84e69727f37 /tests/fixtures/optimizer/lower_identities.sql | |
| parent | Releasing debian version 12.2.0-1. (diff) | |
| download | sqlglot-20739a12c39121a9e7ad3c9a2469ec5a6876199d.tar.xz sqlglot-20739a12c39121a9e7ad3c9a2469ec5a6876199d.zip | |
Merging upstream version 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); |