Derived temporary tables not working?

"Kinyon, Rob" <[email protected]>
Newsgroups gmane.comp.db.mysql.bugs
Message-ID <[email protected]>
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
lmpx.com only provides a reader for public news (NNTP) servers. It is not affiliated with the servers or forums shown here and is not responsible for the content of articles, which is written by their respective authors.