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
