diff options
| author | unknown <ramil@mysql.com> | 2005-04-26 19:46:52 +0500 |
|---|---|---|
| committer | unknown <ramil@mysql.com> | 2005-04-26 19:46:52 +0500 |
| commit | 86d285197ab517ccd16a2175881ee51b5e0dde40 (patch) | |
| tree | 0491b7d62c87d9264d6fc023e653de4309c83d75 /mysql-test/include/varchar.inc | |
| parent | c8683be463c0618e9d42fe964b1c4e8831fec0e4 (diff) | |
| download | mariadb-git-86d285197ab517ccd16a2175881ee51b5e0dde40.tar.gz | |
A fix (bug #10176: problem with varchar keys).
myisam/mi_key.c:
A fix (bug #10176: problem with varchar keys).
Should skip key pack length for 'old' too.
Diffstat (limited to 'mysql-test/include/varchar.inc')
| -rw-r--r-- | mysql-test/include/varchar.inc | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/include/varchar.inc b/mysql-test/include/varchar.inc index 3ec9d00d05d..13b4315f2b8 100644 --- a/mysql-test/include/varchar.inc +++ b/mysql-test/include/varchar.inc @@ -226,3 +226,13 @@ create table t1 (v varchar(65530), key(v(10))); insert into t1 values(repeat('a',65530)); select length(v) from t1 where v=repeat('a',65530); drop table t1; + +# +# Bug #9489: problem with hash indexes +# + +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; +select * from t1 where a=20 and b is null; +drop table t1; |