List:MySQL on Win32« Previous MessageNext Message »
From:Leon Atkinson Date:August 19 1999 6:20pm
Subject:Error caused by ORDER BY clause
View as plain text  
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

Thread
Error caused by ORDER BY clauseLeon Atkinson19 Aug
  • Re: Error caused by ORDER BY clauseDaniel C. Heidebrecht19 Aug
Re: Error caused by ORDER BY clausePeter WR19 Aug
  • RE: Error caused by ORDER BY clauseLeon Atkinson20 Aug
Re: Error caused by ORDER BY clausePeter WR20 Aug
  • Re: Error caused by ORDER BY clauseMichael Widenius23 Aug