MySQL Bugs: #16476: SUM returns NULL

Bug #16476	SUM returns NULL
Submitted:	13 Jan 2006 8:30	Modified:	13 Jan 2006 11:44
Reporter:	Raul Da Silva	Email Updates:
Status:	Can't repeat	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	5.0.15	OS:	Windows (Windows 2000)
Assigned to:		CPU Architecture:	Any

View
Add Comment
Files
Developer
Edit Submission
View Progress Log
Contributions

Description:
Select SUM returns NULL instead of 0

How to repeat:
Select SUM FROM "TableName".... where you know that the result should be empty. It will return a NULL value instead of 0.

Not enough information was provided for us to be able
to handle this bug. Please re-read the instructions at
http://bugs.mysql.com/how-to-report.php

If you can provide more information, feel free to add it
to this bug and change the status back to 'Open'.

Thank you for your interest in MySQL.