diff options
Diffstat (limited to 'sql/core/src/test/resources/sql-tests')
-rw-r--r-- | sql/core/src/test/resources/sql-tests/inputs/pred-pushdown.sql (renamed from sql/core/src/test/resources/sql-tests/inputs/anti-join.sql) | 7 | ||||
-rw-r--r-- | sql/core/src/test/resources/sql-tests/results/pred-pushdown.sql.out (renamed from sql/core/src/test/resources/sql-tests/results/anti-join.sql.out) | 13 |
2 files changed, 18 insertions, 2 deletions
diff --git a/sql/core/src/test/resources/sql-tests/inputs/anti-join.sql b/sql/core/src/test/resources/sql-tests/inputs/pred-pushdown.sql index 0346f57d60..eff258a066 100644 --- a/sql/core/src/test/resources/sql-tests/inputs/anti-join.sql +++ b/sql/core/src/test/resources/sql-tests/inputs/pred-pushdown.sql @@ -1,7 +1,12 @@ --- SPARK-18597: Do not push down predicates to left hand side in an anti-join CREATE OR REPLACE TEMPORARY VIEW tbl_a AS VALUES (1, 1), (2, 1), (3, 6) AS T(c1, c2); CREATE OR REPLACE TEMPORARY VIEW tbl_b AS VALUES 1 AS T(c1); +-- SPARK-18597: Do not push down predicates to left hand side in an anti-join SELECT * FROM tbl_a LEFT ANTI JOIN tbl_b ON ((tbl_a.c1 = tbl_a.c2) IS NULL OR tbl_a.c1 = tbl_a.c2); + +-- SPARK-18614: Do not push down predicates on left table below ExistenceJoin +SELECT l.c1, l.c2 +FROM tbl_a l +WHERE EXISTS (SELECT 1 FROM tbl_b r WHERE l.c1 = l.c2) OR l.c2 < 2; diff --git a/sql/core/src/test/resources/sql-tests/results/anti-join.sql.out b/sql/core/src/test/resources/sql-tests/results/pred-pushdown.sql.out index 6f38c4d08b..1b8ddbe4c7 100644 --- a/sql/core/src/test/resources/sql-tests/results/anti-join.sql.out +++ b/sql/core/src/test/resources/sql-tests/results/pred-pushdown.sql.out @@ -1,5 +1,5 @@ -- Automatically generated by SQLQueryTestSuite --- Number of queries: 3 +-- Number of queries: 4 -- !query 0 @@ -27,3 +27,14 @@ struct<c1:int,c2:int> -- !query 2 output 2 1 3 6 + + +-- !query 3 +SELECT l.c1, l.c2 +FROM tbl_a l +WHERE EXISTS (SELECT 1 FROM tbl_b r WHERE l.c1 = l.c2) OR l.c2 < 2 +-- !query 3 schema +struct<c1:int,c2:int> +-- !query 3 output +1 1 +2 1 |