Viewing all changes in revision 3027.
- Committer: sanja at askmonty
- Date: 2011-09-08 13:57:46 UTC
- Revision ID: sanja@askmonty.org-20110908135746-vq1kmkrl8q1w1z9a
LP BUG#813418 fix.
The problem was that optimization code did not take into account later feature when instad of NOT before BETWEEN it has negated flag into the Item_func_between inherited from Item_func_neg_opt. So optimizer tried process NOT BETWEEN as BETWEEN.
The patch just switches off the optimisation for NOT BETWEEN as it was before when NOT function was really used.
The problem was that optimization code did not take into account later feature when instad of NOT before BETWEEN it has negated flag into the Item_func_between inherited from Item_func_neg_opt. So optimizer tried process NOT BETWEEN as BETWEEN.
The patch just switches off the optimisation for NOT BETWEEN as it was before when NOT function was really used.
- files modified:
- mysql-test/r/func_group.result
expand all
collapse all
added
removed
