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

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 2.7
• Component/s: cube
• Assignee: SushilMohanty
• Reporter: SushilMohanty
• Created: 18/Apr/17 08:42
• Updated: 20/Aug/17 20:42
• Resolved: 24/Apr/17 09:27

Description

Found error in rewritten query when aggregate expressions used inside "case when" statement.
for eg :

CASE
    WHEN (sum((db.msr1)) = 0) THEN 0
    ELSE ((sum((db.msr2)) / sum((db.msr1))) * 1000)
END AS `expr1`