diff options
| author | unknown <ram@mysql.r18.ru> | 2003-07-03 18:21:59 +0500 |
|---|---|---|
| committer | unknown <ram@mysql.r18.ru> | 2003-07-03 18:21:59 +0500 |
| commit | 6d1f44e4fdc3eb89ae5a6e5c21660ab5c233819f (patch) | |
| tree | 587db7d7c6f36901f05136752a0ab428e06ab355 /mysql-test | |
| parent | 912d044fcfa6f2ac2f55f0a12ad6e92ce9dd73d9 (diff) | |
| download | mariadb-git-6d1f44e4fdc3eb89ae5a6e5c21660ab5c233819f.tar.gz | |
Fix and test-case for the bug #775: SELECT misses rows in indexed HEAP table columns.
heap/hp_open.c:
Fix for the bug #775: SELECT misses rows in indexed HEAP table columns.
mysql-test/r/heap.result:
Test-case for the bug #775: SELECT misses rows in indexed HEAP table columns.
mysql-test/t/heap.test:
Test-case for the bug #775: SELECT misses rows in indexed HEAP table columns.
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/heap.result | 14 | ||||
| -rw-r--r-- | mysql-test/t/heap.test | 9 |
2 files changed, 23 insertions, 0 deletions
diff --git a/mysql-test/r/heap.result b/mysql-test/r/heap.result index a04ddf3f302..bdf7dc225f3 100644 --- a/mysql-test/r/heap.result +++ b/mysql-test/r/heap.result @@ -197,6 +197,20 @@ a b INSERT INTO t1 VALUES (1,3); Duplicate entry '3' for key 1 DROP TABLE t1; +CREATE TABLE t1 ( +a int default NULL, +key a (a) +) TYPE=HEAP; +INSERT INTO t1 VALUES (10), (10), (10); +EXPLAIN SELECT * FROM t1 WHERE a=10; +table type possible_keys key key_len ref rows Extra +t1 ref a a 5 const 10 Using where +SELECT * FROM t1 WHERE a=10; +a +10 +10 +10 +DROP TABLE t1; CREATE TABLE t1 (a int not null, primary key(a)) type=heap; INSERT into t1 values (1),(2),(3),(4),(5),(6),(7),(8),(9),(10),(11); DELETE from t1 where a < 100; diff --git a/mysql-test/t/heap.test b/mysql-test/t/heap.test index d1e647ae182..b2de58ca083 100644 --- a/mysql-test/t/heap.test +++ b/mysql-test/t/heap.test @@ -129,6 +129,15 @@ SELECT * FROM t1 WHERE b<=>NULL; INSERT INTO t1 VALUES (1,3); DROP TABLE t1; +CREATE TABLE t1 ( + a int default NULL, + key a (a) +) TYPE=HEAP; +INSERT INTO t1 VALUES (10), (10), (10); +EXPLAIN SELECT * FROM t1 WHERE a=10; +SELECT * FROM t1 WHERE a=10; +DROP TABLE t1; + # # Test when deleting all rows # |