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 ] | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL Server | Severity: | S2 (Serious) |
Version: | 5.0.0 alpha-max-nt | OS: | Windows (Windows XP) |
Assigned to: | CPU Architecture: | Any |
[15 Jul 2004 8:16]
[ name withheld ]
[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