diff options
| author | cmiller@zippy.cornsilk.net <> | 2006-08-09 22:23:41 -0400 |
|---|---|---|
| committer | cmiller@zippy.cornsilk.net <> | 2006-08-09 22:23:41 -0400 |
| commit | 543fcde9b9ba65ebb061606e95dbe6eb8710db16 (patch) | |
| tree | d69877217b5d46b9f37fd63c1e665f2c8e6d2648 /mysql-test/t/heap_btree.test | |
| parent | 5f3d231f5706d43572a1f90873db6ee98226bfcb (diff) | |
| parent | 5fc215e2e322b1c8223ba0c7b996bef2f8e07db8 (diff) | |
| download | mariadb-git-543fcde9b9ba65ebb061606e95dbe6eb8710db16.tar.gz | |
Merge zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-4.1
into zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.0
Diffstat (limited to 'mysql-test/t/heap_btree.test')
| -rw-r--r-- | mysql-test/t/heap_btree.test | 21 |
1 files changed, 20 insertions, 1 deletions
diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test index fb715fccefe..71743d0d850 100644 --- a/mysql-test/t/heap_btree.test +++ b/mysql-test/t/heap_btree.test @@ -165,6 +165,26 @@ SELECT * from t1; DROP TABLE t1; # +# Bug #9719: problem with delete +# + +create table t1(a int not null, key using btree(a)) engine=heap; +insert into t1 values (2), (2), (2), (1), (1), (3), (3), (3), (3); +select a from t1 where a > 2; +delete from t1 where a < 4; +select a from t1; +insert into t1 values (2), (2), (2), (1), (1), (3), (3), (3), (3); +select a from t1 where a > 4; +delete from t1 where a > 4; +select a from t1; +select a from t1 where a > 3; +delete from t1 where a >= 2; +select a from t1; +drop table t1; + +--echo End of 4.1 tests + +# # BUG#18160 - Memory-/HEAP Table endless growing indexes # CREATE TABLE t1(val INT, KEY USING BTREE(val)) ENGINE=memory; @@ -184,4 +204,3 @@ CREATE TABLE t1 (a INT, UNIQUE USING BTREE(a)) ENGINE=MEMORY; INSERT INTO t1 VALUES(NULL),(NULL); DROP TABLE t1; -# End of 4.1 tests |