Bug #10505 MysqlImport not support to all date format
Submitted: 10 May 2005 12:07 Modified: 13 May 2005 10:30
Reporter: Disha Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.5-beta-nt OS:Windows (Window XP)
Assigned to: CPU Architecture:Any

[10 May 2005 12:07] Disha
Description:
Create a table using 'date' datatype. If inserted the data using INSERT
statement the data gets load properly. But if used 'MysqlImport' utility to
insert the data , the proper data does not get inserted.
          Create a file named 't1.txt' at 'C:\' which contains the data
as follows,

'19970505'
'19970505'
'97-05-05'
'1997.05.05'
'1997 05 05'
'0000-00-00'
19970505
19970505
97-05-05
1997.05.05
1997 05 05
0000-00-00

How to repeat:
1. delimiter//
2. create database test01//
3. use test01
4. set @@sql_mode='TRADITIONAL,NO_ZERO_DATE,NO_ZERO_IN_DATE '//
5. create table t1 (d1  date )//
6. execute the following commands from 'dos' command prompt
    mysqlimport -u root test01  c:\t1.txt 
7. Expected Result: 'mysqlimport' statement should load the data sucessfully.
8. Actual Result: The proper data does not get inserted.
[10 May 2005 16:16] MySQL Verification Team
Verified on Linux:

Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 9 to server version: 5.0.6-beta-debug

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

mysql> select * from t1;
+------------+
| d1         |
+------------+
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
| 1997-05-05 |
| 1997-05-05 |
| 1997-05-05 |
| 1997-05-05 |
| 0000-00-00 |
| 0000-00-00 |
| 0000-00-00 |
+------------+
13 rows in set (0.00 sec)
[13 May 2005 10:30] Sergei Golubchik
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

http://dev.mysql.com/doc/mysql/en/datetime.html