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