Description:
mysql> select distinct * from TOOL order by NAME;
ERROR 1 (HY000): Can't create/write to file '\tmp\#sql_f0c_0.MYI' (Errcode: 2)
mysql>
How to repeat:
...
[mysqld]
skip-innodb
...
see:
mysql> desc TOOL;
+---------+--------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+--------------+------+-----+---------+-------+
| TOOL_ID | int(11) | | PRI | 0 | |
| NAME | varchar(255) | | | | |
+---------+--------------+------+-----+---------+-------+
2 rows in set (0.03 sec)
mysql> select * from TOOL;
+---------+-------------------------------+
| TOOL_ID | NAME |
+---------+-------------------------------+
| 1 | RTest |
| 2 | C++Test |
| 3 | Bugs Tracking Systems Scanner |
+---------+-------------------------------+
3 rows in set (0.00 sec)
mysql> select * from TOOL order by 2;
+---------+-------------------------------+
| TOOL_ID | NAME |
+---------+-------------------------------+
| 3 | Bugs Tracking Systems Scanner |
| 2 | C++Test |
| 1 | RTest |
+---------+-------------------------------+
3 rows in set (0.00 sec)
mysql> select * from TOOL order by NAME;
+---------+-------------------------------+
| TOOL_ID | NAME |
+---------+-------------------------------+
| 3 | Bugs Tracking Systems Scanner |
| 2 | C++Test |
| 1 | RTest |
+---------+-------------------------------+
3 rows in set (0.02 sec)
mysql> select distinct * from TOOL order by NAME;
ERROR 1 (HY000): Can't create/write to file '\tmp\#sql_f0c_0.MYI' (Errcode: 2)
mysql>
Suggested fix:
?