[MonetDB-users] Bug with average of decimals when an empty table is returned
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
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
Hi Fabian, I would if I could. But when I hit the reporting-link I get the error: "Permission: User Not Found: Only members of this project have permission to view this page (you are not listed as a member of this project)." So its a bit difficult when sf.net won't let me :-) https://sourceforge.net/tracker/reporting/?group_id=56967&atid=482468 In case you need it, my userid on sf.net is 212222 Best regards, Arjen van der Meijden On 24-5-2005 15:33, Fabian wrote:
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
ohw. this is really strange. I will ask around about this. Thanks for letting me know. Arjen van der Meijden wrote:
Hi Fabian,
I would if I could. But when I hit the reporting-link I get the error: "Permission: User Not Found: Only members of this project have permission to view this page (you are not listed as a member of this project)."
So its a bit difficult when sf.net won't let me :-) https://sourceforge.net/tracker/reporting/?group_id=56967&atid=482468
In case you need it, my userid on sf.net is 212222
Best regards,
Arjen van der Meijden
On 24-5-2005 15:33, Fabian wrote:
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
Solved. you hit the 'reporting' link, and you should hit the 'submit new' link from the bugs page ;) Arjen van der Meijden wrote:
Hi Fabian,
I would if I could. But when I hit the reporting-link I get the error: "Permission: User Not Found: Only members of this project have permission to view this page (you are not listed as a member of this project)."
So its a bit difficult when sf.net won't let me :-) https://sourceforge.net/tracker/reporting/?group_id=56967&atid=482468
In case you need it, my userid on sf.net is 212222
Best regards,
Arjen van der Meijden
On 24-5-2005 15:33, Fabian wrote:
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
participants (2)
-
Arjen van der Meijden -
Fabian