Nattavut Sutyanyong created SPARK-18863:
-------------------------------------------
Summary: Output non-aggregate expression without a GROUP BY clause
in a subquery does not yield a syntax error
Key: SPARK-18863
URL: https://issues.apache.org/jira/browse/SPARK-18863
Project: Spark
Issue Type: Bug
Components: SQL
Affects Versions: 2.0.0
Reporter: Nattavut Sutyanyong
Priority: Minor
[~smilegator] has found that the following query does not raise a syntax error
(note the GROUP BY clause is commented out):
{{code}}
SELECT pk, cv
FROM p, c
WHERE p.pk = c.ck
AND c.cv = (SELECT max(avg)
FROM (SELECT c1.cv, avg(c1.cv) avg
FROM c c1
WHERE c1.ck = p.pk
-- GROUP BY c1.cv
))
{{code}}
There could be multiple values of {{c1.cv}} for each value of avg(c1.cv).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
