Bug #4559 mysql server crash after error 1086 on windows XP

• Submitted: 15 Jul 2004 8:16
• Modified: 22 Jul 2004 19:55
• Reporter: [ name withheld ]
• Status: Closed
• Category: MySQL Server
• Severity: S2 (Serious)
• Version: 5.0.0 alpha-max-nt
• OS: Windows (Windows XP)
• CPU Architecture: Any

[15 Jul 2004 8:16] [ name withheld ]

Description:
When executing query 

SELECT * into outfile "c:\\a.txt" FROM `a` 

and table "c:\\a.txt" already exists, system returned  

ERROR 1086 (HY000): File 'c:\a.txt' already exists 

and mysql server crashed.

How to repeat:
always

[22 Jul 2004 16:56] MySQL Verification Team

The crash happens when actually the file already exists. 
I will test this with latest source tree.

Thank you for the bug report.

[22 Jul 2004 19:55] MySQL Verification Team

I am closing this bug report because it was already fixed in the latest
source 5.0 tree. The fix will be present in the next release 5.0.1.

C:\mysql\bin>mysql -uroot test
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 3 to server version: 5.0.1-alpha-debug-log

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

mysql> create table a (name char(12));
Query OK, 0 rows affected (0.08 sec)

mysql> insert into a values ("myname"),("yourname");
Query OK, 2 rows affected (0.02 sec)
Records: 2  Duplicates: 0  Warnings: 0

mysql> SELECT * into outfile "c:\\a.txt" FROM `a`;
Query OK, 2 rows affected (0.02 sec)

mysql> SELECT * into outfile "c:\\a.txt" FROM `a`;
ERROR 1086 (HY000): File 'c:\a.txt' already exists
mysql> SELECT * into outfile "c:\\a.txt" FROM `a`;
ERROR 1086 (HY000): File 'c:\a.txt' already exists
mysql> select version();
+-----------------------+
| version()             |
+-----------------------+
| 5.0.1-alpha-debug-log |
+-----------------------+
1 row in set (0.02 sec)

Thank you for the bug report.

[15 Feb 2010 4:09] aguss pras

i have a similiar problem with mysql version 5.1.37.
select into outfile
error #1086 - File 'tabel4.txt' already exists