-----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-----