Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-26 Thread Jocelyn Fournier
;[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> > Sent: Thursday, September 26, 2002 9:53 PM > Subject: Re: InnoDB: Assertion failure in file ha

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-26 Thread Heikki Tuuri
<[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 9:53 PM Subject: Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180... > Heikki, Jeremy, > > FYI, I've just tested latest pull (including Monty's patch) without Heikki > 1.1318 changeset (Remove the flag HA_N

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-26 Thread Jocelyn Fournier
r 26, 2002 8:39 PM > Subject: Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180... > > > > Jeremy, > > > > ----- Original Message - > > From: "Jeremy Zawodny" <[EMAIL PROTECTED]> > > To: "Heikki Tuuri" <[EMAIL PROTECTED]&

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-26 Thread Jocelyn Fournier
L PROTECTED]> To: <[EMAIL PROTECTED]> Cc: "Jocelyn Fournier" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, September 26, 2002 8:39 PM Subject: Re: InnoDB

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-26 Thread Heikki Tuuri
;[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 whi

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-26 Thread Jeremy Zawodny
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_P

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-25 Thread Heikki Tuuri
hat search flag. - Original Message - From: "Jocelyn Fournier" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 9:04 PM Subject: Re: InnoDB: Assertion failure in

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-25 Thread Jocelyn Fournier
, Jocelyn - Original Message - From: "Heikki Tuuri" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Wednesday, September 25, 2002 7:09 PM Subject: Re: InnoDB: Assertion failure in file ha_innodb.cc line 21

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-25 Thread Jeremy Zawodny
On Wed, Sep 25, 2002 at 08:09:08PM +0300, Heikki Tuuri wrote: > Jeremy, Jocelyn, > > can you try the following this patch? I'm building a new binary row. > The flag which bans MySQL using a descending cursor to calculate > > column LIKE 'jhghj%' ORDER BY column DESC > > queries was apparently

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-25 Thread Heikki Tuuri
Jeremy, Jocelyn, can you try the following this patch? The flag which bans MySQL using a descending cursor to calculate column LIKE 'jhghj%' ORDER BY column DESC queries was apparently put to the wrong place in ha_innodb.h. The assertion I had added to 4.0.4 revealed this hidden bug. The patc

Re: InnoDB: Assertion failure in file ha_innodb.cc line 2180...

2002-09-25 Thread Jocelyn Fournier
Hi Jeremy, Same problem for me, I submitted a bug report with a repeatable testcase yesterday to the bugs list. Reading the source code and changeset 1.1287, it appears this part of the source code should be desactivated ? (ChangeSet 1.1287 02/09/15 02:23:53 [EMAIL PROTECTED] +2 -0 ha_innodb