re: 4.1 questions: subqueries which use dual

[Victoria Reznichenko]

On Sunday 22 December 2002 08:06,  wrote:
> Mysql,
>     Selecting from `dual` with a simple query works fine,
>
> mysql> select 1 x from dual;
> +---+
>
> | x |
>
> +---+
>
> | 1 |
>
> +---+
>
> but within a derived table,
>
> mysql> select * from (select 1 x from dual) s;
> ERROR 1146: Table 'test.dual' doesn't exist
>
> Is this an oversight or is it purposefully so?

Sorry, but I couldn't repeat it :(



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Victoria Reznichenko
 / /|_/ / // /\ \/ /_/ / /__   Victoria.Reznichenko@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com