# 1153 Single-Row Aggregate SELECT Queries Not Working Properly with Expressions Inside of Functions

---

Given is a table "Payments" with one field Payment (BCD). This table just holds two rows: 100 and 50.

select sum(Payment) from Payments

gives the correct result of 150 in one row.

But if I try

select sum(if(Payment > 50 then (-Payment) else (Payment))) from Payments

I don't get a sum anymore - I get two rows (-100 and 50).