MySQL Bugs: #3630: Server crash by: SELECT * INTO OUTFILE

Bug #3630	Server crash by: SELECT * INTO OUTFILE
Submitted:	2 May 2004 16:04	Modified:	3 May 2004 8:13
Reporter:	Manfred Wiedemeier	Email Updates:
Status:	Duplicate	Impact on me:	None
Category:	MySQL Server	Severity:	S2 (Serious)
Version:	4.1.1a-alpha	OS:	Windows (Windows XP SP1)
Assigned to:		CPU Architecture:	Any

Description:
Server (mysqld-opt.exe) crash by the following command:

SELECT * INTO OUTFILE 'user.dat'
FIELDS TERMINATED BY ','
FROM `MYSQL`.`USER`;

but works with:

SELECT * INTO OUTFILE 'user.dat'
FROM `MYSQL`.`USER`;

But if the outputfile exists, the Server crash again.

How to repeat:

SELECT * INTO OUTFILE 'user.dat'
FIELDS TERMINATED BY ','
FROM `MYSQL`.`USER`;

I wasn't able to repeat the behavior reported:

C:\servers\4.1.1\bin>mysql -uroot mysql
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1 to server version: 4.1.1a-alpha

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> SELECT * INTO OUTFILE 'user.dat'
    -> FIELDS TERMINATED BY ','
    -> FROM `MYSQL`.`USER`;
Query OK, 4 rows affected (0.14 sec)

mysql> SELECT * INTO OUTFILE 'user.dat'
    -> FIELDS TERMINATED BY ','
    -> FROM `MYSQL`.`USER`;
ERROR 1086 (HY000): File 'user.dat' already exists
mysql>

That's BUG#2123, which is fixed in the source development tree since January (so the bug is fixed in the upcoming 4.1.2).
Thank you for your bug report!