diff options
| author | sergefp@mysql.com <> | 2005-06-20 08:56:37 +0000 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2005-06-20 08:56:37 +0000 |
| commit | 014fe01512711d3d1296f1dd5326420810b35b79 (patch) | |
| tree | 2ca651f70035f153df50f4c32d0a10a615ff23d3 /mysql-test/t/index_merge_innodb.test | |
| parent | e58054ad164b061cee0e084a34ac42d7f8f52114 (diff) | |
| download | mariadb-git-014fe01512711d3d1296f1dd5326420810b35b79.tar.gz | |
Fix for BUG#8441: in index_merge code when creating index search tuples use
KEY_PART_INFO::store_length, not KEY_PART_INFO::length (like range code does)
Diffstat (limited to 'mysql-test/t/index_merge_innodb.test')
| -rw-r--r-- | mysql-test/t/index_merge_innodb.test | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/t/index_merge_innodb.test b/mysql-test/t/index_merge_innodb.test index 5e270c161a2..c10ce3b9688 100644 --- a/mysql-test/t/index_merge_innodb.test +++ b/mysql-test/t/index_merge_innodb.test @@ -120,3 +120,14 @@ select count(*) from t1 where drop table t1,t2; +# Test for BUG#8441 +create table t1 ( + id1 int, + id2 date , + index idx2 (id1,id2), + index idx1 (id2) +) engine = innodb; +insert into t1 values(1,'20040101'), (2,'20040102'); +select * from t1 where id1 = 1 and id2= '20040101'; +drop table t1; + |