2 messages in com.mysql.lists.gui-toolsSQL_BIG_SELECTS=1 option not working!
FromSent OnAttachments
Adam Sim12 May 2003 12:31 
Adam Hooper14 May 2003 07:31 
Subject:SQL_BIG_SELECTS=1 option not working!
From:Adam Sim (Adam@trivininc.com)
Date:05/12/2003 12:31:58 PM
List:com.mysql.lists.gui-tools

Hi,

I'm new to using MySQL and just recently installed the MySQL Control Center
0.9.2-beta application on my Windows 2000 PC. I'm trying to view the contents of
a table and whether I run my own select statement, or use the Open Table Return
All Rows / Return Limit feature I receive the following error message:

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

No data is returned. I've gone into the Query options menu and modified the
SQL_BIG_SELECTS option to = 1. I still get the error message and no data is
returned.

I just wanted to pass this information on to you. Thank you for taking the time
to read my comments.

Sincerely,