MySQL Bugs: #10505: MysqlImport not support to all date format

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

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.

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)

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