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.
>
