Edit File: in_string_set_enum_fail.test
--disable_warnings DROP TABLE IF EXISTS t7; --enable_warnings SET SQL_MODE='TRADITIONAL'; CREATE TABLE t7(c1 SET('a','b','c') NULL); --error 1265 INSERT INTO t7(c1) VALUES('abc'); SELECT * FROM t7; --error 1265 INSERT INTO t7(c1) VALUES(123); SELECT * FROM t7; --error 1265 INSERT INTO t7(c1) VALUES(0x878A); SELECT * FROM t7; --error 1265 INSERT INTO t7(c1) VALUES(NOW()); SELECT * FROM t7; DROP TABLE t7; SET SQL_MODE=''; SET SQL_MODE='TRADITIONAL'; CREATE TABLE t7(c1 ENUM('a','b','c') NULL); --error 1265 INSERT INTO t7(c1) VALUES('abc'); SELECT * FROM t7; --error 1265 INSERT INTO t7(c1) VALUES(123); SELECT * FROM t7; --error 1265 INSERT INTO t7(c1) VALUES(0x878A); SELECT * FROM t7; --error 1265 INSERT INTO t7(c1) VALUES(NOW()); SELECT * FROM t7; DROP TABLE t7; SET SQL_MODE='';
Back to File Manager