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.

--
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

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.


--
Are you MySQL certified?, http://www.mysql.com/certification/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Peter Zaitsev <peter [at] mysql.com>
/ /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer
/_/ /_/\_, /___/\___\_\___/ Moscow, Russia
<___/ www.mysql.com


--
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