Bug #809 LOAD DATA INFILE
Submitted: 8 Jul 2003 7:06 Modified: 13 Jul 2003 22:35
Reporter: Stefano Locati Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Server Severity:S3 (Non-critical)
Version:4.1.0-alpha-standard OS:Linux (Linux Debian unstable)
Assigned to: Ramil Kalimullin CPU Architecture:Any

[8 Jul 2003 7:06] Stefano Locati
Description:
Show warnings was supposed to work with load data infile as stated in the manual, but it didn't work in my case.

Thankyou
Stefano

How to repeat:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 8 to server version: 4.1.0-alpha-standard

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

mysql> use appo
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> LOAD DATA LOCAL INFILE '_docu_in.csv' INTO TABLE _docu_in FIELDS TERMINATED BY ';'
    -> OPTIONALLY ENCLOSED BY '"';
Query OK, 3533 rows affected (0.29 sec)
Records: 3533  Deleted: 0  Skipped: 0  Warnings: 26

mysql> SHOW WARNINGS;
Empty set (0.00 sec)
[13 Jul 2003 22:35] Ramil Kalimullin
Thank you for your bug report. This issue has been fixed in the latest
development tree for that product. You can find more information about
accessing our development trees at 
    http://www.mysql.com/doc/en/Installing_source_tree.html