| 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: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.0.5-beta-nt | OS: | Windows (Windows xp) |
| Assigned to: | CPU Architecture: | Any | |
[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)
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 | +----+