[jira] [Created] (DRILL-5856) invariant violated: conversion result not null when aggregate used in a PARTITION

[N Campbell (JIRA)]

N Campbell created DRILL-5856:
---------------------------------

             Summary:  invariant violated: conversion result not null when 
aggregate used in a PARTITION
                 Key: DRILL-5856
                 URL: https://issues.apache.org/jira/browse/DRILL-5856
             Project: Apache Drill
          Issue Type: Bug
          Components: SQL Parser
    Affects Versions: 1.10.0
         Environment: Drill 1.10
            Reporter: N Campbell


If the partition specification of a windowed aggregate includes a regular 
aggregate, the query will fail with Error: SYSTEM ERROR: AssertionError: 
Internal error: invariant violated: conversion result not null


SELECT
    `SNO` AS `C1`, 
    SUM(`QTY`) AS `C2`, 
    SUM(MAX(`QTY`))
        OVER(
            PARTITION BY
                `SNO`, 
                 MAX(`QTY` * 10)
        ) AS `C3`
FROM
    ( values ( 'A', 1) ) T1 ( SNO, QTY ) 
GROUP BY 
    `SNO`






--
This message was sent by Atlassian JIRA
(v6.4.14#64029)