Re: 4.1.16: updates not using index prefixes

2006-01-09 Thread Christian Meisinger
Pete Harlan wrote: FYI, 4.1.16 appears not to be using prefixes of compound indexes when doing updates. Reverting to 4.1.15, or adding an index consisting of only the desired field, restores reasonable behavior. I have added feedback to a possibly-related bug,

4.1.16: updates not using index prefixes

2006-01-05 Thread Pete Harlan
FYI, 4.1.16 appears not to be using prefixes of compound indexes when doing updates. Reverting to 4.1.15, or adding an index consisting of only the desired field, restores reasonable behavior. I have added feedback to a possibly-related bug, http://bugs.mysql.com/bug.php?id=15935, but wanted to