-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Try out the release candidate for Feb2013-SP6 at
http://dev.monetdb.org/downloads/testing.  It produces the output you
expect.  If you're happy with that, then you don't need to open a new
report for this one.

On 2013-11-26 13:09, Pedro Salgueiro wrote:
> Hi,
>
> A few weeks ago we encountered an issue with monetdb when summing
> nulls, grouped by some column. We managed to create a simple test
> case which reproduces this scenario:
>
> create table test (number int, name varchar(50));
>
>
>
> insert into test values(1,'jonh'); insert into test
> values(2,'mike'); insert into test values(3,'mary'); insert into
> test values(null,'austin'); insert into test values(null,'jonh');
> insert into test values(null,'mary');
>
>
>
> select name, sum(number) from test group by name;
>
>
>
> The result of this query is:
>
> austin | 0 jonh | 1 mary | 3 mike | 2
>
>
> But the expected result is:
>
> austin | null jonh | 1 mary | 3 mike | 2
>
>
> The version that we are using is Feb2013-SP5.
>
> We found a bug report that could be related to this one, but we are
> not sure: http://bugs.monetdb.org/show_bug.cgi?id=3388
>
> Should we open a new issue for this one?
>
> Thank you, Pedro Salgueiro
>
>
>
>
>
>

> _______________________________________________ users-list mailing
> list users-list@monetdb.org
> https://www.monetdb.org/mailman/listinfo/users-list
>

- --
Sjoerd Mullender
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.15 (GNU/Linux)
Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/

iQCVAwUBUpSnFj7g04AjvIQpAQKT3wQAlwOmfEmpb5Etz32SYh0NgEQcW4At4NR5
wnJ31a2NokCsJi8bSLhKGGj5XmDs8i/aKKP5/MeVYhvyOyrdzPUMyhC328CCML87
VJjWxx5sRcYvPiFvtnQstgMs4+QcsQDygEan72NrxK7z4NsDWVd6+nuiYfJlOUuZ
7P0MJIzIGfw=
=JB0U
-----END PGP SIGNATURE-----

_______________________________________________
users-list mailing list
users-list@monetdb.org
https://www.monetdb.org/mailman/listinfo/users-list