radu created CALCITE-1740:
-----------------------------

             Summary: Distinct aggregate flag in window function
                 Key: CALCITE-1740
                 URL: https://issues.apache.org/jira/browse/CALCITE-1740
             Project: Calcite
          Issue Type: Bug
          Components: core
            Reporter: radu
            Assignee: Julian Hyde


When parsing queries such as
SELECT B1, SUM(DISTINCT B2) OVER  (ORDER BY  B4 RANGE BETWEEN INTERVAL '10' 
SECOND PRECEDING AND CURRENT ROW) FROM T

The aggregates in the LogicalWindow do not have any marker of being distinct. 
isDistinct() flag is not set. Probably some rule(s) silently swallow the 
DISTINCT keyword


The LogicalWindow object that result is

LogicalWindow(window#0=[window(partition {} order by [2] range between $3 
PRECEDING and CURRENT ROW aggs [COUNT($1), $SUM0($1)])])




--
This message was sent by Atlassian JIRA
(v6.3.15#6346)

Reply via email to