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