Debian Codegraph @

mysql-test/suite/engines/funcs/r/in_string_set_enum_fail.result

raw
1 DROP TABLE IF EXISTS t7;
2 SET SQL_MODE='TRADITIONAL';
3 CREATE TABLE t7(c1 SET('a','b','c') NULL);
4 INSERT INTO t7(c1) VALUES('abc');
5 ERROR 01000: Data truncated for column 'c1' at row 1
6 SELECT * FROM t7;
7 c1
8 INSERT INTO t7(c1) VALUES(123);
9 ERROR 01000: Data truncated for column 'c1' at row 1
10 SELECT * FROM t7;
11 c1
12 INSERT INTO t7(c1) VALUES(0x878A);
13 ERROR 01000: Data truncated for column 'c1' at row 1
14 SELECT * FROM t7;
15 c1
16 INSERT INTO t7(c1) VALUES(NOW());
17 ERROR 01000: Data truncated for column 'c1' at row 1
18 SELECT * FROM t7;
19 c1
20 DROP TABLE t7;
21 SET SQL_MODE='';
22 SET SQL_MODE='TRADITIONAL';
23 CREATE TABLE t7(c1 ENUM('a','b','c') NULL);
24 INSERT INTO t7(c1) VALUES('abc');
25 ERROR 01000: Data truncated for column 'c1' at row 1
26 SELECT * FROM t7;
27 c1
28 INSERT INTO t7(c1) VALUES(123);
29 ERROR 01000: Data truncated for column 'c1' at row 1
30 SELECT * FROM t7;
31 c1
32 INSERT INTO t7(c1) VALUES(0x878A);
33 ERROR 01000: Data truncated for column 'c1' at row 1
34 SELECT * FROM t7;
35 c1
36 INSERT INTO t7(c1) VALUES(NOW());
37 ERROR 01000: Data truncated for column 'c1' at row 1
38 SELECT * FROM t7;
39 c1
40 DROP TABLE t7;
41 SET SQL_MODE='';