On Wed, 2003-05-14 at 22:03, Юрий Деревянко wrote:
Dear sirs!
I have repeated bug trying to open ANY table by doubleclick or simple 'SELECT *
FROM table' statement in MySQL Control Center.
CC reports the next:
-->
[testserver] 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
-->
SET OPTION for big selects to 1 or 0 has no effect. The only case when I can get
a row from table I discovered is using WHERE clause on numeric fields (e.g.
WHERE id=1). Works '=' ONLY. Operators '>=' or '<=' doesn't work.
Dear Youriy,
This bug was fixed in latest MySQL CC release, please upgrade.
And thank you for taking a time to write the bug report.
2 messages in com.mysql.lists.bugsRe: MySQL CC 0.9.1 & 2 bug report
