Select problems in mysqlcc 0.9.0 - 0.9.1

Having problems with mysqlcc 0.9.0 and 0.9.1 when accessing
MySQL 4.0.12 server. Returns "ERROR 1104: The SELECT would examine too many
records and probably take a very long time.Check your WHERE and use SET OPTION
SQL_BIG_SELECTS=1 if the SELECT is ok"

Have tested other programs that work against the server. Even tried
changing in my.cnf on the server without results.

Sincerely
Ignacio Barrientos




--
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: Select problems in mysqlcc 0.9.0 - 0.9.1

Hi!

You probably need to increase the 'Maximum Join Size' property in the Edit
Server dialog under the "MySQL Options" tab. The default is set to 1000000.

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:
To:
Sent: Monday, March 31, 2003 3:23 AM
Subject: Select problems in mysqlcc 0.9.0 - 0.9.1


> Having problems with mysqlcc 0.9.0 and 0.9.1 when accessing
> MySQL 4.0.12 server. Returns "ERROR 1104: The SELECT would examine too
many
> records and probably take a very long time.Check your WHERE and use SET
OPTION
> SQL_BIG_SELECTS=1 if the SELECT is ok"
>
> Have tested other programs that work against the server. Even tried
> changing in my.cnf on the server without results.
>
> Sincerely
> Ignacio Barrientos
>
>
>
>
> --
> MySQL Bugs Mailing List
> For list archives: http://lists.mysql.com/bugs
> To unsubscribe: http://lists.mysql.com/bugs?unsub=jorge@mysql.com
>



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