[jira] [Created] (SPARK-17712) Incorrect result when selecting from aggregate subquery where outer WHERE clause constant-folds to false

["Josh Rosen (JIRA)" <ji...@apache.org>]

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: issues-unsubscribe@spark.apache.org
For additional commands, e-mail: issues-help@spark.apache.org