List:General Discussion« Previous MessageNext Message »
From:Victoria Reznichenko Date:December 24 2002 3:55pm
Subject:re: 4.1 questions: subqueries which use dual
View as plain text  
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




Thread
Return every Nth row in a result setSpamSucks8622 Dec
  • RE: Return every Nth row in a result setJamesD22 Dec
  • 4.1 questions: subqueries which use dualric22 Dec
    • re: 4.1 questions: subqueries which use dualVictoria Reznichenko24 Dec
  • Re: Return every Nth row in a result setric22 Dec
    • RE: Return every Nth row in a result setSpamSucks8622 Dec
      • Re: Return every Nth row in a result setBenjamin Pflugmann22 Dec
        • RE: Return every Nth row in a result setSpamSucks8622 Dec
          • Re: Return every Nth row in a result setRichard Clarke22 Dec
          • Re: Return every Nth row in a result setric22 Dec
  • Re: 4.1 questions: subqueries which use dualRichard Clarke24 Dec
    • Re: 4.1 questions: subqueries which use dualDan Nelson24 Dec
  • Re: 4.1 questions: subqueries which use dualRichard Clarke24 Dec
    • Re: 4.1 questions: subqueries which use dualMark Matthews24 Dec