[
Date Prev][
Date Next][
Thread Prev][
Thread Next][
Date Index][
Thread Index]
[jira] [Created] (CALCITE-2757) DISTINCT not being handled correctly in RelToSqlConverter
KrishnaKant Agrawal created CALCITE-2757:
--------------------------------------------
Summary: DISTINCT not being handled correctly in RelToSqlConverter
Key: CALCITE-2757
URL: https://issues.apache.org/jira/browse/CALCITE-2757
Project: Calcite
Issue Type: Bug
Components: core
Reporter: KrishnaKant Agrawal
Assignee: Julian Hyde
SELECT DISTINCT sum(x) OVER (PARTITION BY y) FROM t
is valid (per SQL standard) but
SELECT sum(x) OVER (PARTITION BY y)
FROM t
GROUP BY sum(x) OVER (PARTITION BY y)
is not. For example, given the query
select sum(deptno) over (partition by loc)
from dept
group by sum(deptno) over (partition by loc);
Oracle gives
ORA-00934: group function is not allowed here
Therefore we should generate a sub-query, something like this:
SELECT c1
FROM (
SELECT sum(deptno) OVER (PARTITION BY loc)
FROM dept) AS t
GROUP BY c1;
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)