Re: Bug in UNION statement with alias '*'

Hi,

>> Description:
>   When issuing a UNION query with a column having an alias starting
>   with a '*' (star/asterisk) character, the database returns an
>   error:
>   ERROR 1051: Unknown table ''
> 
>> How-To-Repeat:
> 
>   select version() as `*` UNION select user() as `anything`;
>   Notice that the '*' is properly quoted with inverse quotes.
>   The simple statement
>      SELECT version() AS `*`;
>   works fine. The error only shows up with UNION.

Thanks for a fine bug report. This has been filed as bug #1249. You can
follow its progress at: http://bugs.mysql.com/bug.php?id=1249


Rgds,
Indrek

-- 
|  Indrek Siitan, MySQL AB, Support Engineer & Bugmaster
|  Uuemõisa, Haapsalu, Estonia
+- 
|  Are you MySQL Certified? http://www.mysql.com/certification/
--


-- 
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe:    http://lists.mysql.com/[email protected]