diff options
| author | sergefp@mysql.com <> | 2005-02-08 23:44:51 +0300 |
|---|---|---|
| committer | sergefp@mysql.com <> | 2005-02-08 23:44:51 +0300 |
| commit | dcc65b77a676bfa545135295fdda20ec2af4de0d (patch) | |
| tree | 6a54fa75f12baa5932602964a2ca08830e947d0a /mysql-test/r/heap_hash.result | |
| parent | 1c2f4ffecb5ee57c91f8961544f20a73de360bc3 (diff) | |
| download | mariadb-git-dcc65b77a676bfa545135295fdda20ec2af4de0d.tar.gz | |
Fix for BUG#8371: wrong rec_per_key value for hash index on temporary table
Diffstat (limited to 'mysql-test/r/heap_hash.result')
| -rw-r--r-- | mysql-test/r/heap_hash.result | 10 |
1 files changed, 10 insertions, 0 deletions
diff --git a/mysql-test/r/heap_hash.result b/mysql-test/r/heap_hash.result index 4f5de197858..d3673cd2a63 100644 --- a/mysql-test/r/heap_hash.result +++ b/mysql-test/r/heap_hash.result @@ -355,3 +355,13 @@ id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE t1 ref heap_idx heap_idx 20 const 7 Using where 1 SIMPLE t3 ref a a 40 func,const 6 Using where drop table t1, t2, t3; +create temporary table t1 ( a int, index (a) ) engine=memory; +insert into t1 values (1),(2),(3),(4),(5); +select a from t1 where a in (1,3); +a +1 +3 +explain select a from t1 where a in (1,3); +id select_type table type possible_keys key key_len ref rows Extra +1 SIMPLE t1 range a a 5 NULL 2 Using where +drop table t1; |