MySQL CC 0.9.1

------=_NextPart_000_01DE_01C2F846.5DC2C580
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: 7bit

Hi,



Ive just installed an updated MySQL CC for Windows. When I try and return
all rows it only returns the first top row. Ive enabled the SQL_BIG_SELECT
to 1. I can do a fetch rows ok no problem which is what im using at the
moment.



Many thanks



Matthew


------=_NextPart_000_01DE_01C2F846.5DC2C580--

Re: MySQL CC 0.9.1

Hi!

A minor bug managed to slip by 0.9.1 where the "Register Server" screen
didn't set the correct defaults for some newly introduced features....
That's why you're getting that error message; the problem is some mysql
variables are being initialized too small for actual usage.

To fix this you can either

a) Edit your server and in the "MySQL Options" tab, set a reasonable value
for "Automatically limit SELECT queries to" and set the value for "Maximum
Join Size" to 1000000. That should fix these problems.

or

b) wait for 0.9.2

BTW, this is already fixed in my local bk tree!

Regards,
Jorge
--
For technical support contracts, visit https://order.mysql.com/?ref=mjdc
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Mr. Jorge del Conde
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Mexico City, Mexico
<___/ www.mysql.com

MySQL Users Conference and Expo
http://www.mysql.com/events/uc2003/

----- Original Message -----
From: "Matthew Moore"
To:
Sent: Tuesday, April 01, 2003 5:01 AM
Subject: MySQL CC 0.9.1


> Hi,
>
>
>
> Ive just installed an updated MySQL CC for Windows. When I try and return
> all rows it only returns the first top row. Ive enabled the SQL_BIG_SELECT
> to 1. I can do a fetch rows ok no problem which is what im using at the
> moment.
>
>
>
> Many thanks
>
>
>
> Matthew
>
>



--
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

Re: MySQL CC 0.9.1

> a) Edit your server and in the "MySQL Options" tab, set a reasonable
> value
> for "Automatically limit SELECT queries to" and set the value for > >
> "Maximum
> Join Size" to 1000000. That should fix these problems.

Sorry if this is obvious. I can't locate the "MySQL Options" tab. How
do I get to it?

When will 0.9.2 be available?

Thanks!

Steve


--
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