diff options
| author | unknown <jimw@mysql.com> | 2005-12-01 11:11:03 -0800 |
|---|---|---|
| committer | unknown <jimw@mysql.com> | 2005-12-01 11:11:03 -0800 |
| commit | 4b4f7f7612083abf43876ed4beaaef6cb5dba5f9 (patch) | |
| tree | a5543f9b6e059f508ad2e6227895eca157e4fb0e /mysql-test/t/innodb.test | |
| parent | 3c8a8de47e6f2fcc6358d4805e0aec885e18564a (diff) | |
| download | mariadb-git-4b4f7f7612083abf43876ed4beaaef6cb5dba5f9.tar.gz | |
Enable key lengths of up to 3K on 32-bit platforms.
mysql-test/r/bdb.result:
Add new results
mysql-test/r/innodb.result:
Add new results
mysql-test/t/bdb.test:
Add simple test that large keys are allowed
mysql-test/t/innodb.test:
Add simple test that large keys are allowed
sql/unireg.h:
Allow key length of 3K even on 32-bit platforms
Diffstat (limited to 'mysql-test/t/innodb.test')
| -rw-r--r-- | mysql-test/t/innodb.test | 19 |
1 files changed, 19 insertions, 0 deletions
diff --git a/mysql-test/t/innodb.test b/mysql-test/t/innodb.test index cf0e08e2e66..a73ecf7c3eb 100644 --- a/mysql-test/t/innodb.test +++ b/mysql-test/t/innodb.test @@ -1751,3 +1751,22 @@ insert into t2 values (4,_ucs2 0x05612020,_ucs2 0x05612020,'taken'); drop table t1; drop table t2; commit; + +# +# Test that we can create a large (>1K) key +# +create table t1 (a varchar(255) character set utf8, + b varchar(255) character set utf8, + c varchar(255) character set utf8, + d varchar(255) character set utf8, + key (a,b,c,d)) engine=innodb; +drop table t1; +--error ER_TOO_LONG_KEY +create table t1 (a varchar(255) character set utf8, + b varchar(255) character set utf8, + c varchar(255) character set utf8, + d varchar(255) character set utf8, + e varchar(255) character set utf8, + key (a,b,c,d,e)) engine=innodb; + +--echo End of 5.0 tests |