[EMAIL PROTECTED] wrote:
>
> I've upgraded a MySQL 4.0.14 server to 4.1.1-alpha version because I
> wanted to experiment with the support for subqueries. Not being an expert
> on SQL at this point, I tried a couple of simple subqueries and got the
> following error message:
>
> ERROR 1235: This version of MySQL doesn't yet support 'LIMIT &
> IN/ALL/ANY/SOME subquery'
>
> That doesn't seem to fit with what I've read in the MySQL 4.1.1
> documentation. I also tried some queries using a sample database from a
> MySQL book (which presumably reduces the possibility that I made some
> mindless error with my queries) and got the same response. When I issue a
> SELECT version(); SQL command, I get 4.1.1-alpha-standard as I would
> expect.
>
> Could something have gone wrong with the upgrade or am I missing something
> obvious about the subquery support in 4.1.1?
Errors that are related to subqueries you can find at:
http://www.mysql.com/doc/en/Subquery_errors.html
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
