Re: Possible bug in InnoDB

2001-07-03 Thread Heikki Tuuri
Hi! One more question: does the query work if you remove the ORDER BY? What does EXPLAIN say then? Regards, Heikki -Original Message- From: Heikki Tuuri <[EMAIL PROTECTED]> To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: Tuesday, July 03, 2001 9:44 PM Subject: Re: Pos

Possible bug in InnoDB

2001-07-03 Thread tianlin
I have the same problem with Mysql-3.23.39 compiled by myself running in Linux box. However the problem goes away if I alter table type from InnoDB to MyISAM. Therefore this problem is related with InnoDB. Here is the query which generates ERROR 1028: Sort aborted. SELECT service.sowid,servdate,re