Major bug fixed in InnoDB optimizer in ... WHERE col > x

Hi!

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