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,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 the
dataset.
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
