Peeyush Gupta created ASTERIXDB-3116:
----------------------------------------

             Summary: Incorrect answer with parameterized query with case 
expression inside aggregates
                 Key: ASTERIXDB-3116
                 URL: https://issues.apache.org/jira/browse/ASTERIXDB-3116
             Project: Apache AsterixDB
          Issue Type: Bug
            Reporter: Peeyush Gupta


// param args:json=[1]

select value sum(case when t.y > $1 then t.x else 0 end)
from [
{ "x": 10, "y": 1 },
{ "x": 20, "y": 2 },
{ "x": 15, "y": 3 }
] t
 
Return 0 instead of 35



--
This message was sent by Atlassian Jira
(v8.20.10#820010)

Reply via email to