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

Test_PStypes fails due to ambigous identifier #2800

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

Test_PStypes fails due to ambigous identifier #2800

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

Comments

@monetdb-team
Copy link

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

Date: 2011-04-06 14:57:28 +0200
From: @grobian
To: SQL devs <>
Version: 11.3.1 (Apr2011) [obsolete]
CC: @njnes

Last updated: 2011-04-28 16:25:39 +0200

Comment 15726

Date: 2011-04-06 14:57:28 +0200
From: @grobian

see, e.g.:
http://monetdb.cwi.nl/testing/projects/monetdb/testweb/tests/39764:8690368fe891/GNU-Darwin-powerpc/sql/mTests/jdbc/tests/Test_PStypes.out.diff.html

CREATE TABLE htmtest (
htmid bigint NOT NULL,
ra double ,
decl double ,
dra double ,
ddecl double ,
flux double ,
dflux double ,
freq double ,
bw double ,
type decimal(1,0),
imageurl varchar(100),
comment varchar(100),
CONSTRAINT htmtest_htmid_pkey PRIMARY KEY (htmid)
);

CREATE INDEX htmid ON htmtest (htmid);

INSERT INTO HTMTEST (HTMID,RA,DECL,FLUX,COMMENT) VALUES (1, 1.2, 2.4, 3.2, 'vlabla');

-- fails:
UPDATE HTMTEST set COMMENT='some update' WHERE HTMID=1;

actual output:
sql>UPDATE HTMTEST set COMMENT='some update' WHERE HTMID=1;
SELECT: identifier 'htmid' ambiguous
sql>

I think sql gets confused by the equally named index here.

Comment 15736

Date: 2011-04-20 13:24:32 +0200
From: @njnes

Changeset b4d7e8ed93d1 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=b4d7e8ed93d1

Changeset description:

fix bug #2800 (now idx have independent aliases during query compilation)

Comment 15737

Date: 2011-04-20 13:30:46 +0200
From: @njnes

added test to BugTracker 2011 (ambigous_idx_name.Bug-2800)

fixed. Indices now have aliases in the relational algebra (prefixed by %).

Comment 15754

Date: 2011-04-28 16:25:39 +0200
From: @sjoerdmullender

The Apr2011 release has been uploaded.

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