Major bug fixed in InnoDB optimizer in ... WHERE col > x
am 28.01.2003 00:52:49 von Heikki TuuriHi!
Over the past 2 years several users have complained about optimization of
queries of type
.... WHERE col < x;
.... WHERE col <= x;
.... WHERE col > x;
.... WHERE col >= x;
and, indeed, there was a major bug in the InnoDB query estimator. The fix
appears in 4.0.10 and 3.23.56.
"
MySQL/InnoDB-3.23.56, February xx, 2003
Fixed a major bug in InnoDB query optimization: queries of type SELECT ...
WHERE indexcolumn < x and SELECT ... WHERE indexcolumn > x could cause a
table scan even if the selectivity would have been very good.
"
Best regards,
Heikki
Innobase Oy
For mail filters:
How-to-Repeat:
sql query
------------------------------------------------------------ ---------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail
To unsubscribe, e-mail
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php