diff options
| author | unknown <serg@serg.mylan> | 2004-02-20 20:38:34 +0100 |
|---|---|---|
| committer | unknown <serg@serg.mylan> | 2004-02-20 20:38:34 +0100 |
| commit | 74fa5f09ef7ef6433423f93378bbc070c091d9b0 (patch) | |
| tree | 40b5e6cdb83d2a91c45651388dc4d63cd2a3fa84 /mysql-test/t/key.test | |
| parent | e2244c94b1f29d176e441e86b7162f520eaa50b2 (diff) | |
| download | mariadb-git-74fa5f09ef7ef6433423f93378bbc070c091d9b0.tar.gz | |
longer myisam keys
mysql-test/r/ctype_utf8.result:
updated
mysql-test/r/key.result:
updated
mysql-test/r/myisam.result:
updated
mysql-test/r/type_blob.result:
updated
mysql-test/t/ctype_utf8.test:
updated
mysql-test/t/key.test:
updated
mysql-test/t/myisam.test:
updated
mysql-test/t/type_blob.test:
updated
Diffstat (limited to 'mysql-test/t/key.test')
| -rw-r--r-- | mysql-test/t/key.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/key.test b/mysql-test/t/key.test index 109cbb91e2f..cdaf6062771 100644 --- a/mysql-test/t/key.test +++ b/mysql-test/t/key.test @@ -191,3 +191,16 @@ SELECT * FROM t1; INSERT INTO t1 (c) VALUES ('a'),('a'); SELECT * FROM t1; drop table t1; + +# +# longer keys +# +create table t1 (i int, a char(200), b text, unique (a), unique (b(300))) charset utf8; +insert t1 values (1, repeat('a',210), repeat('b', 310)); +insert t1 values (2, repeat(0xD0B1,215), repeat(0xD0B1, 310)); +select i, length(a), length(b), char_length(a), char_length(b) from t1; +select i from t1 where a=repeat(_utf8 'a',200); +select i from t1 where a=repeat(_utf8 0xD0B1,200); +select i from t1 where b=repeat(_utf8 'b',310); +drop table t1; + |