Debian Codegraph @

mysql-test/suite/engines/funcs/t/in_string_set_enum_fail.test

raw
1 --disable_warnings
2 DROP TABLE IF EXISTS t7;
3 --enable_warnings
4 SET SQL_MODE='TRADITIONAL';
5 CREATE TABLE t7(c1 SET('a','b','c') NULL);
6 --error 1265
7 INSERT INTO t7(c1) VALUES('abc');
8 SELECT * FROM t7;
9 --error 1265
10 INSERT INTO t7(c1) VALUES(123);
11 SELECT * FROM t7;
12 --error 1265
13 INSERT INTO t7(c1) VALUES(0x878A);
14 SELECT * FROM t7;
15 --error 1265
16 INSERT INTO t7(c1) VALUES(NOW());
17 SELECT * FROM t7;
18 DROP TABLE t7;
19 SET SQL_MODE='';
20 SET SQL_MODE='TRADITIONAL';
21 CREATE TABLE t7(c1 ENUM('a','b','c') NULL);
22 --error 1265
23 INSERT INTO t7(c1) VALUES('abc');
24 SELECT * FROM t7;
25 --error 1265
26 INSERT INTO t7(c1) VALUES(123);
27 SELECT * FROM t7;
28 --error 1265
29 INSERT INTO t7(c1) VALUES(0x878A);
30 SELECT * FROM t7;
31 --error 1265
32 INSERT INTO t7(c1) VALUES(NOW());
33 SELECT * FROM t7;
34 DROP TABLE t7;
35 SET SQL_MODE='';
36