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 | d278381ec88fd4a0b45244517e7305f70b6ccf7b (patch) | |
| tree | d69877217b5d46b9f37fd63c1e665f2c8e6d2648 /mysql-test/t/heap_btree.test | |
| parent | 51bb3b2a7f906af25b5dd0ef91491aa415615a4b (diff) | |
| parent | 842ec2334118f67541c77bb824a7baffe5ba2b62 (diff) | |
| download | mariadb-git-d278381ec88fd4a0b45244517e7305f70b6ccf7b.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 |