Bug #10546 'Mysqlimport' fill error value in 'ENUM' and 'SET' data type
Submitted: 11 May 2005 11:58 Modified: 11 May 2005 14:11
Reporter: Disha Email Updates:
Status: Can't repeat Impact on me:
None 
Category:MySQL Server Severity:S2 (Serious)
Version:5.0.5-beta-nt OS:Windows (Windows xp)
Assigned to: CPU Architecture:Any

[11 May 2005 11:58] Disha
Description:
If I try to import data into table using 'Mysqlimport' it is inserting may be special error value in column.

A) Values for file t1.txt
a
b
c

How to repeat:
A) Execute following 'sql' commands  
    1. set @@sql_mode='STRICT_ALL_TABLES'//
    2. create table t1 (s1 enum('a','b','c') not null default 'a')//

B) execute following statment from command prompt
    1. mysqlimport -u root test01  c:\t1.txt

C) Execute following 'sql' commands  
    1.Selete * from t1//

D) Expected Result: Sucessful data import
   
E) Actual Result: 	+----+
		| s1 |
		+----+
		|     |
		|     |
		| c  |
		+----+
[11 May 2005 14:11] MySQL Verification Team
miguel@hegel:~/dbs/5.0$ bin/mysqlimport -uroot test01 /home/miguel/f
f          fail.txt   falta.txt  files      fix.txt    fix.txt~
miguel@hegel:~/dbs/5.0$ bin/mysqlimport -uroot test01 /home/miguel/f/t1.txt
test01.t1: Records: 3  Deleted: 0  Skipped: 0  Warnings: 0
miguel@hegel:~/dbs/5.0$ bin/mysql -uroot test01
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

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

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

mysql> select * from t1;
+----+
| s1 |
+----+
| a  |
| b  |
| c  |
+----+
3 rows in set (0.00 sec)