Josh Rosen created SPARK-17712:
----------------------------------
Summary: Incorrect result when selecting from aggregate subquery
where outer WHERE clause constant-folds to false
Key: SPARK-17712
URL: https://issues.apache.org/jira/browse/SPARK-17712
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 2.0.0, 1.6.2, 2.0.2
Reporter: Josh Rosen
Let {{diamonds}} be a non-empty table. The following two queries should both
return no rows, but the first returns a single row:
{code}
SELECT
1
FROM (
SELECT
count(*)
FROM diamonds
) t1
WHERE
false
{code}
{code}
SELECT
1
FROM (
SELECT
*
FROM diamonds
) t1
WHERE
false
{code}
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
