There have been lots of posts about this problem in the list. I have
tried the recommended solution, but still have no luck.
Just to be clear, this is recommended solution, as I understood it:
in MySQL Options, set
Automatically limit SELECT queries: 10000
in Query Window Options, set
SQL_BIG_SELECTS: 1
Having done that, I still consistently get this message when querying a
table with more than 1 row:
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
What am I missing here? Is anybody actually running 0.9.1 without this
problem? If not, what version should I downgrade to?
Thanks in advance.
- taso
4 messages in com.mysql.lists.gui-toolsv0.9.1: SQL_BIG_SELECTS - still not w...