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
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
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
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
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
-----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
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 sjoerd@acm.org 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
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
On 2013-11-26 16:00, Pedro Salgueiro wrote:
Great, the SP6 version works as expected, thanks!
Is this release candidate as stable as SP5?
Hopefully even better.
Is there any expected release date?
No, but sometime soon, I think. I want to have a few more testers to get a warm fuzzy feeling before releasing.
Pedro Salgueiro
On Tue, Nov 26, 2013 at 1:50 PM, Sjoerd Mullender <sjoerd@acm.org mailto:sjoerd@acm.org> wrote:
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 mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org mailto:users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
- -- Sjoerd Mullender
participants (3)
-
Pedro Salgueiro
-
Roberto Cornacchia
-
Sjoerd Mullender