Derived temporary tables not working?

------_=_NextPart_001_01C4382C.B39BC66E
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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.

=20

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:

=20

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

=20

(I didn't provide a test case because I'm attempting to run the example
in the manual.)

=20

Is this something that isn't supported in 4.0.18?

=20

Thanks,

Rob


------_=_NextPart_001_01C4382C.B39BC66E--

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
/ /|_/ / // /\ \/ /_/ / /__ 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/bugs?unsub=gcdmb-bugs@m.gmane.org