Hello.
It seems a bug for me. Any columns in the subquery select list
must have unique names according to:
http://dev.mysq.com/doc/mysql/en/unnamed-views.html
I've reported a bug. You could add your comments at:
http://bugs.mysql.com/bug.php?id=11864
Richard Cyganiak <[EMAIL
Hi,
Suppose I have two tables Tbl1 and Tbl2. Both have a column called A.
MySQL 5.0.7 rejects this query as ambiguous:
SELECT A from Tbl1, Tbl2;
But it accepts this and returns the A column from Tbl1:
SELECT A FROM (SELECT * FROM Tbl1, Tbl2) AS foo;
But this query is rejected again:
SELECT *