Jeremy, ----- Original Message ----- From: "Jeremy Zawodny" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: "Jocelyn Fournier" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 8:25 PM Subject: Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...
> On Wed, Sep 25, 2002 at 09:43:13PM +0300, Heikki Tuuri wrote: > > Jocelyn, > > > > below the latest patch which puts the code as it was in 4.0.3. Some LIKE > > 'abc%' ... DESC queries may return wrong results, but this is the best we > > can get to 4.0.4. > > > > I have to ask Monty about the use of HA_READ_PREFIX_LAST. Other bugs may be > > lurking in the use/non-use of that search flag. > > FYI, my server is happy now too. thank you for testing the source tree! Now we found and fixed these bugs before the actual release was made :). One bug remains: I tested yesterday that WHERE primarykey LIKE 'abc%' ORDER BY primarykey DESC; really works wrong in upcoming InnoDB-4.0.4. It only returns rows where primarykey = 'abc'. But better fix that bug in 4.0.5 since it requires a somewhat more fundamental change. Until that users beware! > I'll rebuild with Monty's latest patch and see that things work as > expected. > > Thanks! > > Jeremy Thank you, Heikki Innobase Oy > -- > Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! > <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ > > MySQL 3.23.51: up 51 days, processed 1,083,975,227 queries (244/sec. avg) --------------------------------------------------------------------- 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 <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
