diff options
Diffstat (limited to 'mysql-test/main/ctype_mb.test')
-rw-r--r-- | mysql-test/main/ctype_mb.test | 28 |
1 files changed, 28 insertions, 0 deletions
diff --git a/mysql-test/main/ctype_mb.test b/mysql-test/main/ctype_mb.test new file mode 100644 index 00000000000..cd5ab503d55 --- /dev/null +++ b/mysql-test/main/ctype_mb.test @@ -0,0 +1,28 @@ +# +# 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 IGNORE 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 |