[jira] [Created] (LENS-1411) Queries not rewritten correctly when aggregate expression used inside "case when..."

["Sushil Mohanty (JIRA)" <ji...@apache.org>]

Sushil Mohanty created LENS-1411:
------------------------------------

             Summary: Queries not rewritten correctly when aggregate expression used inside "case when..."
                 Key: LENS-1411
                 URL: https://issues.apache.org/jira/browse/LENS-1411
             Project: Apache Lens
          Issue Type: Bug
          Components: cube
            Reporter: Sushil Mohanty
            Assignee: Sushil Mohanty


Found error in rewritten query when aggregate expressions used inside "case when" statement. 
for eg  : 
{CODE}
CASE
    WHEN (sum((db.msr1)) = 0) THEN 0
    ELSE ((sum((db.msr2)) / sum((db.msr1))) * 1000)
END AS `expr1`
{CODE}



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