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 <richard.cyganiak@stripped> wrote:
> 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 * FROM (SELECT * FROM Tbl1, Tbl2) AS foo ORDER BY A;
>
> Why is this? Is it a bug?
>
> Thanks,
> Richard
>
>
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ Gleb.Paharenko@stripped
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
