1# 2# CHAR column types 3# 4 5--disable_warnings 6DROP TABLE IF EXISTS t1; 7--enable_warnings 8 9eval CREATE TABLE t1 ( 10 c CHAR $extra_col_opts, 11 c0 CHAR(0) $extra_col_opts, 12 c1 CHAR(1) $extra_col_opts, 13 c20 CHAR(20) $extra_col_opts, 14 c255 CHAR(255) $extra_col_opts, 15 PRIMARY KEY (c255) 16) ENGINE=rocksdb; 17 18SHOW COLUMNS IN t1; 19 20# Valid values 21 22INSERT INTO t1 (c,c0,c1,c20,c255) VALUES ('','','','',''); 23INSERT INTO t1 (c,c0,c1,c20,c255) VALUES ('a','','b','abcdefghi klmnopqrst', 'Creating an article for the Knowledgebase is similar to asking questions. First, navigate to the category where you feel the article should be. Once there, double check that an article doesn\'t already exist which would work.'); 24 25--sorted_result 26SELECT c,c0,c1,c20,c255 FROM t1; 27 28# Invalid values 29 30INSERT INTO t1 (c,c0,c1,c20,c255) VALUES ('abc', 'a', 'abc', REPEAT('a',21), REPEAT('x',256)); 31INSERT INTO t1 (c,c0,c1,c20,c255) SELECT c255, c255, c255, c255, CONCAT('a',c255,c1) FROM t1; 32 33--sorted_result 34SELECT c,c0,c1,c20,c255 FROM t1; 35 36--sorted_result 37SELECT DISTINCT c20, REPEAT('a',LENGTH(c20)), COUNT(*) FROM t1 GROUP BY c1, c20; 38 39--error ER_TOO_BIG_FIELDLENGTH 40eval ALTER TABLE t1 ADD COLUMN c257 CHAR(257) $extra_col_opts; 41 42DROP TABLE t1; 43 44 45 46