Hi!

If in the Tables folder I choose a table an either double-click on it or choose "open
table" I get the error message

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

wherever the table is not empty, even if I have only one record in it. If I enter

SET OPTION SQL_BIG_SELECTS=1;
SELECT * FROM $$$$$ LIMIT 1000

everything is OK. If I submit the query

SELECT * FROM $$$$$

from inside a Java program, I also get the expected results.

In my opinion this phenomen is not very helpful und utterly disturbing in this
otherwise excellent program.

Best regards,

Ákos





--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs [at] m.gmane.org

Sorry, I forgot to add that this is the Windows version, others I have not tried. Also
this is a new "feature", missing from an older version I have used.

2003. 05. 15. 10:44:03, Darth Vader <darth.vader [at] freemail.hu> wrote:

>Hi!
>
>If in the Tables folder I choose a table an either double-click on it or choose "open
>table" I get the error message
>
>[localhost] 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
>
>wherever the table is not empty, even if I have only one record in it. If I enter
>
>SET OPTION SQL_BIG_SELECTS=1;
>SELECT * FROM $$$$$ LIMIT 1000
>
>everything is OK. If I submit the query
>
>SELECT * FROM $$$$$
>
>from inside a Java program, I also get the expected results.
>
>In my opinion this phenomen is not very helpful und utterly disturbing in this
>otherwise excellent program.
>
>Best regards,
>
>Ákos
>
>
>




--
MySQL Bugs Mailing List
For list archives: http://lists.mysql.com/bugs
To unsubscribe: http://lists.mysql.com/bugs?unsub=gcdmb-bugs [at] m.gmane.org