Bug #667 Control centre will not retrieve rcords
Submitted: 18 Jun 2003 2:27 Modified: 21 Aug 2003 0:33
Reporter: Martin Purdy Email Updates:
Status: Closed Impact on me:
None 
Category:MySQLCC Severity:S2 (Serious)
Version:9.2-beta OS:Windows (Windows 2000)
Assigned to: Bugs System CPU Architecture:Any

[18 Jun 2003 2:27] Martin Purdy
Description:
If a table contains more than one record the following error is produced

[Local] 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

even if the SQL_BIG_SELECTS is set as below

SET OPTION SQL_BIG_SELECTS=1;SELECT * FROM `e4action`

the same error occurs.

Setting the SQL_BIG_SELECTS through Query Options also has no affect.

How to repeat:
select * from table where table has more than one record
[18 Aug 2003 2:21] Martin Purdy
This error only occurs on LOCALHOST.

If the localhost is registered as a server, say LH, and the queries made on LH the error disappears. The same 'return all rows' query errors on localhost
[21 Aug 2003 0:33] Jorge del Conde
Thank you for your bug report. This issue has been committed to our
source repository of that product and will be incorporated into the
next release.

If necessary, you can access the source repository and build the latest
available version, including the bugfix, yourself. More information 
about accessing the source trees is available at
    http://www.mysql.com/doc/en/Installing_source_tree.html