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/lower_identities.sql | 41 --------------------------- 1 file changed, 41 deletions(-) delete mode 100644 tests/fixtures/optimizer/lower_identities.sql (limited to 'tests/fixtures/optimizer/lower_identities.sql') 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); -- cgit v1.2.3