Aggregation over two columns is broken

[monetdb-team]

Date: 2014-02-04 14:51:54 +0100
From: Alex Shestakov <<shura.shestakov>>
To: SQL devs <>
Version: 11.17.9 (Jan2014)
CC: @njnes

Last updated: 2014-02-20 15:02:53 +0100

Comment 19523

Date: 2014-02-04 14:51:54 +0100
From: Alex Shestakov <<shura.shestakov>>

User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/32.0.1700.76 Safari/537.36
Build Identifier:

A valid SQL query cannot be processed.

Reproducible: Always

Steps to Reproduce:

create table t(
a real,
b real);

insert into t values (null, 1);
insert into t values (2, 1);

select sum(a) , sum(a * b) from t;

Actual Results:

Error: inputs not the same size.
SQLState: 22000
ErrorCode: 0

Expected Results:

2

Broken in the latest release candidate (11.17.3) as well as in RC1 (11.17.1).

Comment 19524

Date: 2014-02-04 16:17:46 +0100
From: MonetDB Mercurial Repository <>

Changeset 917086517922 made by Sjoerd Mullender sjoerd@acm.org in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=917086517922

Changeset description:

Added test for bug #3428.

Comment 19540

Date: 2014-02-05 11:38:41 +0100
From: @njnes

the combination used the wrong input (a). Fixed in sql_gencode.c

Comment 19545

Date: 2014-02-05 13:00:18 +0100
From: MonetDB Mercurial Repository <>

Changeset be0051b026da made by Niels Nes niels@cwi.nl in the MonetDB repo, refers to this bug.

For complete details, see http//devmonetdborg/hg/MonetDB?cmd=changeset;node=be0051b026da

Changeset description:

approved output for bug #3427 (also use auto commit mode)
fixed bug #3430, ie check if local temporary tables are stored in the 'tmp' schema
fixed bug #3428, don't overwrite the statement number, but use a temporary structure to store the
NotNil select statements. Solves the problem that the sum(a), sub(a*b) uses the a after nil
removal in the a*b.

fixed bug #3425, correctly add the timezone with the proper type (ie second interval (ie with scale 3))

Comment 19611

Date: 2014-02-20 15:02:53 +0100
From: @sjoerdmullender

Jan2014 has been released.