Edit File: ctype_mb.test
# # Test of alter table # --disable_warnings drop table if exists t1; --enable_warnings CREATE TABLE t1 SELECT _utf8'test' as c1, _utf8'ัะตัั' as c2; SHOW CREATE TABLE t1; DELETE FROM t1; ALTER TABLE t1 ADD c3 CHAR(4) CHARACTER SET utf8; SHOW CREATE TABLE t1; INSERT INTO t1 VALUES ('aaaabbbbccccdddd','aaaabbbbccccdddd','aaaabbbbccccdddd'); SELECT * FROM t1; DROP TABLE t1; CREATE TABLE t1 (a CHAR(4) CHARACTER SET utf8, KEY key_a(a(3))); SHOW CREATE TABLE t1; SHOW KEYS FROM t1; ALTER TABLE t1 CHANGE a a CHAR(4); SHOW CREATE TABLE t1; SHOW KEYS FROM t1; ALTER TABLE t1 CHANGE a a CHAR(4) CHARACTER SET utf8; SHOW CREATE TABLE t1; SHOW KEYS FROM t1; DROP TABLE t1; # End of 4.1 tests
Back to File Manager