Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Simple query fails with 'identifier not found' #3385

Closed
monetdb-team opened this issue Nov 30, 2020 · 0 comments
Closed

Simple query fails with 'identifier not found' #3385

monetdb-team opened this issue Nov 30, 2020 · 0 comments

Comments

@monetdb-team
Copy link

@monetdb-team monetdb-team commented Nov 30, 2020

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.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Linked pull requests

Successfully merging a pull request may close this issue.

None yet
1 participant