From: Daniel C. Heidebrecht
Date: August 19 1999 8:07pm
Subject: Re: Error caused by ORDER BY clause
List-Archive: http://lists.mysql.com/win32/372
Message-Id: <007001beea7e$66a7e290$c30a49d1@commandz.com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

I have the same result on version 3.22.23b but it works in version 3.22.20

OS = NT4 sp4

Dan.

----- Original Message -----
From: Leon Atkinson <leon@stripped>
To: <win32@stripped>
Sent: Thursday, August 19, 1999 2:20 PM
Subject: Error caused by ORDER BY clause


> This is with version 3.22.24-debug on Windows NT 4.0.  It does it in
version
> 3.22.22, too.
>
>
> mysql> select *
>     -> from invoice_status x, invoice i
>     -> where x.invoice = i.ID;
> {snip}
> 8 rows in set (0.01 sec)
>
>
> mysql> select *
>     -> from invoice_status x, invoice i
>     -> where x.invoice = i.ID
>     -> order by i.ID;
> ERROR 1: Can't create/write to file '\\sql127_0.ism' (Errcode: 2)
>
> C:\mysql>perror 1
>
>
> C:\mysql>
>
>
> I don't get this behavior with an identical (using mysqldump) database on
> Solaris and MySQL 3.22.21.
>
> Anyone have any ideas?
>
> TIA,
> Leon
>
>
> ---------------------------------------------------------------------
> Please check "http://www.mysql.com/Manual_chapter/manual_toc.html" before
> posting. To request this thread, e-mail win32-thread371@stripped
>
> To unsubscribe, send a message to the address shown in the
> List-Unsubscribe header of this message. If you cannot see it,
> e-mail win32-unsubscribe@stripped instead.
>