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