Bugs item #2879005, was opened at 2009-10-14 16:01
Message generated for change (Settings changed) made by nielsnes
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: Closed
>Resolution: Fixed
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
----------------------------------------------------------------------
>Comment By: Niels Nes (nielsnes)
Date: 2009-11-11 18:40
Message:
added test to create_table_dup_name.SF-2879005
fixed by disallowing duplicate column names
----------------------------------------------------------------------
You can respond by visiting:
https://sourceforge.net/tracker/?func=detail&atid=482468&aid=2879005&group_id=56967
------------------------------------------------------------------------------
Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
trial. Simplify your report design, integration and deployment - and focus on
what you do best, core application coding. Discover what's new with
Crystal Reports now. http://p.sf.net/sfu/bobj-july
_______________________________________________
Monetdb-bugs mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/monetdb-bugs
