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.
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
2 messages in com.mysql.lists.bugsRe: MySQLCC 0.9.2B Open Table error
