1SET SQL_MODE="TRADITIONAL,ANSI";
2DROP TABLE IF EXISTS t7;
3CREATE TABLE t7(c1 ENUM('a','abcdefghijabcdefghijabcdefghijabcdefghijabcdefghij') NULL);
4INSERT INTO t7(c1) VALUES(NULL);
5INSERT INTO t7(c1) VALUES('');
6ERROR 01000: Data truncated for column 'c1' at row 1
7INSERT INTO t7(c1) VALUES('a');
8INSERT INTO t7(c1) VALUES('abcdefghijabcdefghijabcdefghijabcdefghijabcdefghij');
9INSERT INTO t7(c1) VALUES('abcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghijabcdefghij');
10ERROR 01000: Data truncated for column 'c1' at row 1
11SELECT * FROM t7;
12c1
13NULL
14a
15abcdefghijabcdefghijabcdefghijabcdefghijabcdefghij
16DROP TABLE t7;
17