Re: Derived temporary tables not working?

Kinyon, Rob writes:
> I'm using MySQL 4.0.18 on RH 9. I installed the binary version that was
> on mysql.com as of May 11, 2004.
> 
>  
> 
> I copied the example from
> http://dev.mysql.com/doc/mysql/en/Unnamed_views.html and attempted to
> run it and received the following error:
> 
>  
> 
> Error 1064: You have an error in your SQL syntax.  Check the manual that
> corresponds to your MySQL server version for the right syntax to use
> near 'SELECT s1 AS sb, s2 AS sb2, s3*2 AS sb3 FROM t1) AS sb
> 
>  
> 
> (I didn't provide a test case because I'm attempting to run the example
> in the manual.)
> 
>  
> 
> Is this something that isn't supported in 4.0.18?
> 
>  
> 
> Thanks,
> 
> Rob


Hi!

Thank you for writting to us.

The above is not a bug as derived tables were introduce in 4.1.0. 

-- 

Sincerely,

-- 
For technical support contracts, go to https://order.mysql.com/?ref=msmi
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Mr. Sinisa Milivojevic <[email protected]>
 / /|_/ / // /\ \/ /_/ / /__   MySQL AB
/_/  /_/\_, /___/\___\_\___/   Full time Developer and Support Coordinator
       <___/   www.mysql.com   Larnaca, Cyprus



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