Hi, thanks for your interest. Could you report this as a bug on our SourceForge bug page under the SQL/Core category? http://sourceforge.net/tracker/?group_id=56967&atid=482468 Regards, Fabian Arjen van der Meijden wrote:
Hi list,
I noticed a weird result from AVG when doing one of my queries; -1.7976931348623158e+307
Appearantly it happens with this minimal testcase: monetdb-> create table emptyone (field decimal(3,1)); Operation successful
monetdb-> select avg(field) from emptyone; +------------------------+ | scale_down_avg_field | +========================+ | -1.7976931348623158E307 | +------------------------+ 1 row
The result should afaik be NULL, not this value. With a decimal(3) it works correctly by the way. The same behaviour is seen with numeric(3,1) vs numeric(3).
Best regards,
Arjen
------------------------------------------------------- This SF.Net email is sponsored by Oracle Space Sweepstakes Want to be the first software developer in space? Enter now for the Oracle Space Sweepstakes! http://ads.osdn.com/?ad_id=7412&alloc_id=16344&op=click _______________________________________________ MonetDB-users mailing list MonetDB-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/monetdb-users