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: Possible bug in InnoDB
>Hi!
>
>What are the table definitions like? How big tables?
>How many rows should be returned by the query?
>What does EXPLAIN SELECT ... say for InnoDB,
>respectively MyISAM tables? Does it work with smaller
>tables? What does EXPLAIN say for small tables?
>Do you have a lot of free space in your disk?
>
>Regards,
>
>Heikki
>
>
>Copied message:
>.........................
>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 withInnoDB.
>Here is the query which generates ERROR 1028: Sort aborted.
>SELECT service.sowid,servdate,removedate FROM service,sowherd WHERE
>service.sowid=sowherd.sowid AND servdate > removedate ORDER BY servdate;
>
>I was NOT able to produce a small test example although I tried my best.
>If someone is interested in solving the problem, I can give you thedataset.
>
>On Tue, 3 Jul 2001, Sinisa Milivojevic wrote:
>> Cal Evans writes:
>> > MySQL Error:
>> >> > ERROR 1028: Sort aborted> >
>> > Anybody know what this means? Ok, I can figure out what it MEANS, I'm
>> > getting it on a rather complicated select statement with an order by
>clause.
>> > Does it mean something specific like 'you need a better index' or is it
>just
>> > exactly what it means?> >>
>>>
>> Cal> > http://www.calevans.com>
>> Hi!>
>> This is a rare error and usually caused by no space in TMPDIR or by
>> bad disk or RAM.>>
>
---------------------------------------------------------------------
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
