diff options
| author | unknown <sergefp@mysql.com> | 2005-06-20 08:56:37 +0000 |
|---|---|---|
| committer | unknown <sergefp@mysql.com> | 2005-06-20 08:56:37 +0000 |
| commit | b603e47d90cec89f9fdf33b1429e503699b3f06e (patch) | |
| tree | 2ca651f70035f153df50f4c32d0a10a615ff23d3 /mysql-test/r/index_merge_innodb.result | |
| parent | c7e49b6bd689b9adf3a7f6f28766fc05efb78f41 (diff) | |
| download | mariadb-git-b603e47d90cec89f9fdf33b1429e503699b3f06e.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)
mysql-test/r/index_merge_innodb.result:
Testcase for BUG8441
mysql-test/t/index_merge_innodb.test:
Testcase for BUG8441
Diffstat (limited to 'mysql-test/r/index_merge_innodb.result')
| -rw-r--r-- | mysql-test/r/index_merge_innodb.result | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/mysql-test/r/index_merge_innodb.result b/mysql-test/r/index_merge_innodb.result index 52e2a4046cf..662fffe1ba1 100644 --- a/mysql-test/r/index_merge_innodb.result +++ b/mysql-test/r/index_merge_innodb.result @@ -123,3 +123,14 @@ key1a = 2 and key1b is null and key3a = 2 and key3b is null; count(*) 4 drop table t1,t2; +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'; +id1 id2 +1 2004-01-01 +drop table t1; |