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.