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