| Bug #10514 | 'SET' data type ignored 'traditional' mode | ||
|---|---|---|---|
| Submitted: | 10 May 2005 14:46 | Modified: | 12 May 2005 20:39 |
| Reporter: | Disha | Email Updates: | |
| Status: | Not a Bug | Impact on me: | |
| Category: | MySQL Server | Severity: | S2 (Serious) |
| Version: | 5.0.5-beta-nt | OS: | Windows (window xp) |
| Assigned to: | CPU Architecture: | Any | |
[10 May 2005 15:03]
MySQL Verification Team
Verified on linux.
[12 May 2005 20:39]
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/set.html
Description: 'SET' data type does not support 'traditional' mode and insert data into table. How to repeat: 1. execute the following command. set @@sql_mode='traditional'// Create table t1 (s1 set('a','b','c'))// 2. execute the following insert statment insert into t1 (s1) values ('')// insert into t1 (s1) values (null)// 3. execute the following select statment select * from t1// 4. Expected Result: ignore insert statment 5.Actual Result: +------+ | s1 | +------+ | | +------+ 1 row in set (0.00 sec)