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]
