diff options
author | unknown <cmiller@zippy.cornsilk.net> | 2006-08-09 22:23:41 -0400 |
---|---|---|
committer | unknown <cmiller@zippy.cornsilk.net> | 2006-08-09 22:23:41 -0400 |
commit | 60201f0de84066efa8347c9d41c1e8802a69792d (patch) | |
tree | d69877217b5d46b9f37fd63c1e665f2c8e6d2648 /mysql-test/t/heap_btree.test | |
parent | 899f24e0a2e7d330de464a4d006fde91a3fedb54 (diff) | |
parent | cc12757621220dc1e3c14eb26d39f61af64daee5 (diff) | |
download | mariadb-git-60201f0de84066efa8347c9d41c1e8802a69792d.tar.gz |
Merge zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-4.1
into zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.0
client/mysql.cc:
Auto merged
heap/hp_delete.c:
Auto merged
mysql-test/t/mysqlbinlog.test:
Auto merged
scripts/fill_func_tables.sh:
Auto merged
scripts/mysql_install_db.sh:
Auto merged
sql/mysqld.cc:
Auto merged
sql/set_var.cc:
Auto merged
mysql-test/r/grant2.result:
Manual merge
mysql-test/r/heap_btree.result:
Manual merge
mysql-test/r/mysql_client.result:
Manual merge
mysql-test/t/grant2.test:
Manual merge
mysql-test/t/heap_btree.test:
Manual merge
mysql-test/t/mysql_client.test:
Manual merge
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 |