diff options
| author | ramil@mysql.com <> | 2005-04-26 19:46:52 +0500 |
|---|---|---|
| committer | ramil@mysql.com <> | 2005-04-26 19:46:52 +0500 |
| commit | db2b729c737cb5de3b56d7bc1870f0778ef71f2c (patch) | |
| tree | 0491b7d62c87d9264d6fc023e653de4309c83d75 /mysql-test/r/myisam.result | |
| parent | 50ada0a01c9cd9a0d50f82db44de19d07fcee986 (diff) | |
| download | mariadb-git-db2b729c737cb5de3b56d7bc1870f0778ef71f2c.tar.gz | |
A fix (bug #10176: problem with varchar keys).
Diffstat (limited to 'mysql-test/r/myisam.result')
| -rw-r--r-- | mysql-test/r/myisam.result | 9 |
1 files changed, 9 insertions, 0 deletions
diff --git a/mysql-test/r/myisam.result b/mysql-test/r/myisam.result index 539df03e6f9..1a8ace98d05 100644 --- a/mysql-test/r/myisam.result +++ b/mysql-test/r/myisam.result @@ -1157,6 +1157,15 @@ select length(v) from t1 where v=repeat('a',65530); length(v) 65530 drop table t1; +create table t1(a int, b varchar(12), key ba(b, a)); +insert into t1 values (1, 'A'), (20, NULL); +explain select * from t1 where a=20 and b is null; +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 ref ba ba 20 const,const 1 Using where; Using index +select * from t1 where a=20 and b is null; +a b +20 NULL +drop table t1; create table t1 (v varchar(65530), key(v)); Warnings: Warning 1071 Specified key was too long; max key length is 1000 bytes |