Actually, I also think the sum should be 0 for austin, as the sum over an empty set is mathematically defined as 0 ( http://en.wikipedia.org/wiki/Empty_sum) So this result is what I would expect: austin | 0 jonh | null mary | null mike | null On Tue, Nov 26, 2013 at 1:12 PM, Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:

Personally I believe the expected result is null in all cases except mike.

3 + null is nulll, not 3, right?

On Tue, Nov 26, 2013 at 1:09 PM, Pedro Salgueiro < pedro.salgueiro@cortex-intelligence.com> 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

OK, forget my last remark about the empty set, I had overlooked the austin case (it does have a null). Sorry for sending remarks too quickly, I stand by my first reaction, I would expect (even though most SQL implementations do differently): austin | null jonh | null mary | null mike | 2 On Tue, Nov 26, 2013 at 2:25 PM, Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:

Sorry, I meant this:

austin | 0 jonh | null mary | null mike | 2

On Tue, Nov 26, 2013 at 2:24 PM, Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:

...

Actually, I also think the sum should be 0 for austin, as the sum over an empty set is mathematically defined as 0 ( http://en.wikipedia.org/wiki/Empty_sum)

So this result is what I would expect:

austin | 0 jonh | null mary | null mike | null

On Tue, Nov 26, 2013 at 1:12 PM, Roberto Cornacchia < roberto.cornacchia@gmail.com> wrote:

...

Personally I believe the expected result is null in all cases except mike.

3 + null is nulll, not 3, right?

On Tue, Nov 26, 2013 at 1:09 PM, Pedro Salgueiro < pedro.salgueiro@cortex-intelligence.com> 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

Great, the SP6 version works as expected, thanks! Is this release candidate as stable as SP5? Is there any expected release date? Pedro Salgueiro On Tue, Nov 26, 2013 at 1:50 PM, Sjoerd Mullender wrote:

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