Bug #285 Trying to view entries of tabels in MySQLCC creates Error 1104
Submitted: 13 Apr 2003 19:56 Modified: 14 Apr 2003 6:26
Reporter: Bengt Lassen Email Updates:
Status: Closed Impact on me:
None 
Category:MySQLGUI Severity:S3 (Non-critical)
Version:0.9.1beta OS:Windows (Win2k SP2)
Assigned to: CPU Architecture:Any

[13 Apr 2003 19:56] Bengt Lassen 
Description:
There are some problems with displaying the entries of the user table in the MySQLCC. 
Issuing the following statement 
SELECT User FROM `user` WHERE User = "root" LIMIT 0 , 30

generates this:
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

The user table contains 3 lines.
The SQL_BIG_SELECTS=1 is set to 1 

If the previous SQL-statement is used in the CLI it does not create the same problems.

How to repeat:
Double clicking on the user table in the mysql db in the tree view
[14 Apr 2003 6:26] MySQL Verification Team 
This is a known issue of 0.9.1 and has been fixed in 0.9.2.