Support for subqueries in V 4.1.1
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? Thanks for any pointers you can provide. Michael Michael Greis [EMAIL PROTECTED] Office: (781) 449-8017 Home: (781) 449-8007
Re: Support for subqueries in V 4.1.1
Had the same problem Are u calling the query from the MysqlCC ??? , it is adding some info to server about limited the query . Try from a sql prompt on server or set the automatically limited Select Queries to - unlimited maximum join size - unlimited on the tab : mysql options (right click on ur server , and choose edit) regards Kim Pedersen 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? Thanks for any pointers you can provide. Michael Michael Greis [EMAIL PROTECTED] Office: (781) 449-8017 Home: (781) 449-8007 mvh Kim G. Pedersen macaos/elprint Development +45 35373808 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Support for subqueries in V 4.1.1
[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]
Re: Support for subqueries in V 4.1.1
Kim, Got it in one! Thank you so much. I was using MysqlCC and, although I was aware of the general issue around limits, I had no idea that it would affect sub-queries. I tried the query from the command line and it worked. For anyone else who runs into this, setting the MySQL option as Kim suggests works, but be sure to do the following: - To set the limit on SELECT queries to unlimited, set Automatically limit SELECT queries to to zero - I couldn't similarly set maximum join size, but as long as it was one less than maximum allowed packet, that seemed to work - Remember to close your query window and re-open it (to create a new connection) after making the changes. At least I think that's what's required - the limit wasn't going away after I'd reset it. Thank you again - I don't think I would have found that on my own. Michael Michael Greis [EMAIL PROTECTED] Office: (781) 449-8017 Home: (781) 449-8007 Kim G. Pedersen [EMAIL PROTECTED] wrote on 01/29/2004 09:14:22 AM: Had the same problem Are u calling the query from the MysqlCC ??? , it is adding some info to server about limited the query . Try from a sql prompt on server or set the automatically limited Select Queries to - unlimited maximum join size - unlimited on the tab : mysql options (right click on ur server , and choose edit) regards Kim Pedersen 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? Thanks for any pointers you can provide. Michael Michael Greis [EMAIL PROTECTED] Office: (781) 449-8017 Home: (781) 449-8007 mvh Kim G. Pedersen macaos/elprint Development +45 35373808
