Hi!
I've upgraded from 3.23.51 to 4.0.20 .
The query: SELECT e.id, sum(c.quantity) FROM Execution e left join
Couple c on c.executionRef=e.id GROUP BY e.id;
If there's no Couple for an Execution the value of the sum(c.quantity)
is 0 in 3.23.51 and NULL in 4.0.20.
Was it a bug, or is it a
Victor Pendleton wrote:
This is the way the SUM() operator works. If there are not any rows it will
return NULL.
http://dev.mysql.com/doc/mysql/en/GROUP-BY-Functions.html
Thanks! But I found , that it returns null only from version 3.23, in
the earlier versions it was 0.
The query: SELECT