Date: 2013-10-15 23:52:53 +0200
From: Tim H. <<monetdb.bug.reporter>>
To: SQL devs <>
Version: 11.15.7 (Feb2013-SP2)
CC: @hannesmuehleisen, @njnes, @drstmane

Last updated: 2013-12-03 13:59:39 +0100

Comment 19273

Date: 2013-10-15 23:52:53 +0200
From: Tim H. <<monetdb.bug.reporter>>

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

A simple query fails with 'identifier not found', but the identifier is referring to a column name in the table being queried.

Reproducible: Always

Steps to Reproduce:

create table err_stddev2(col1 double);
insert into err_stddev2 values(2.4);
insert into err_stddev2 values(2.6);
SELECT sys.stddev_pop(col1) * sys.stddev_pop(col1) FROM err_stddev2;

Actual Results:

SELECT: identifier 'col1' unknown

Expected Results:

Comment 19274

Date: 2013-10-16 00:01:30 +0200
From: Tim H. <<monetdb.bug.reporter>>

-- this works
SELECT sys.stddev_pop(col1) * avg(col1) FROM err_stddev2;
SELECT sys.stddev_pop(col1), avg(col1) FROM err_stddev2;

-- this fails: SELECT: identifier 'col1' unknown
SELECT avg(col1) * sys.stddev_pop(col1) FROM err_stddev2;
SELECT avg(col1), sys.stddev_pop(col1) FROM err_stddev2;

Comment 19275

Date: 2013-10-16 08:35:22 +0200
From: @hannesmuehleisen

Interesting bug, this is also still an issue with Feb2013-SP5 and in the default branch.

Comment 19278

Date: 2013-10-16 12:56:45 +0200
From: @drstmane

I can reproduce the problem with the latest (post Feb2013-SP5 release candidate) version of the Feb2013 branch:

sql>create table err_stddev2(col1 double);
operation successful (0.928ms)
sql>insert into err_stddev2 values(2.4);
1 affected row (0.616ms)
sql>insert into err_stddev2 values(2.6);
1 affected row (0.306ms)
sql>SELECT sys.stddev_pop(col1) * sys.stddev_pop(col1) FROM err_stddev2;
SELECT: identifier 'col1' unknown
sql>
sql>SELECT sys.stddev_pop(col1) * avg(col1) FROM err_stddev2;
+--------------------------+
| sql_mul_L1 |
+==========================+
| 0.25000000000000022 |
+--------------------------+
1 tuple (1.522ms)
sql>SELECT sys.stddev_pop(col1), avg(col1) FROM err_stddev2;
+--------------------------+--------------------------+
| L1 | L2 |
+==========================+==========================+
| 0.10000000000000009 | 2.5 |
+--------------------------+--------------------------+
1 tuple (5.862ms)
sql>
sql>SELECT avg(col1) * sys.stddev_pop(col1) FROM err_stddev2;
SELECT: identifier 'col1' unknown
sql>SELECT avg(col1), sys.stddev_pop(col1) FROM err_stddev2;
SELECT: identifier 'col1' unknown

Comment 19289

Date: 2013-10-20 17:26:14 +0200
From: @njnes

fixed by falling back to an aggregate when the unary operator fails

Comment 19387

Date: 2013-12-03 13:59:39 +0100
From: @sjoerdmullender

Feb2013-SP6 has been released.