Bugs item #2879005, was opened at 2009-10-14 18:01
Message generated for change (Tracker Item Submitted) made by vzzzbx
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2879005&group_id=56967
Please note that this message will contain a full copy of the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: SQL/Core
Group: SQL "stable"
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Wouter Alink (vzzzbx)
Assigned to: Niels Nes (nielsnes)
Summary: SQL: duplicate column name
Initial Comment:
(Aug2009, todays checkout)
The script below generates a table with two 'name' columns.
Besides the duplicate column names, it also yields the wrong result (expected 4
tuples: a-a, a-b, b-a, and b-b)
I don't know whether these two bugs are related, or that they should be
reported seperately.
CREATE TABLE a (name VARCHAR(10));
CREATE TABLE b (name VARCHAR(10));
INSERT INTO a VALUES ('a'),('b');
INSERT INTO b VALUES ('a'),('b');
CREATE TABLE ab AS SELECT * FROM a,b WITH DATA;
SELECT * FROM ab;
+-------+-------+
| name | name |
+=======+=======+
| a | a |
| a | a |
| b | b |
| b | b |
| a | a |
| b | b |
| a | a |
| b | b |
+-------+-------+
8 tuples
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2879005&group_id=56967
------------------------------------------------------------------------------
Come build with us! The BlackBerry(R) Developer Conference in SF, CA
is the only developer event you need to attend this year. Jumpstart your
developing skills, take BlackBerry mobile applications to market and stay
ahead of the curve. Join us from November 9 - 12, 2009. Register now!
http://p.sf.net/sfu/devconference
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
