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

[10 May 2005 14:46] Disha
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)
[10 May 2005 15:03] Miguel Solorzano
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