diff options
| author | cmiller@zippy.cornsilk.net <> | 2006-09-05 16:45:25 -0400 |
|---|---|---|
| committer | cmiller@zippy.cornsilk.net <> | 2006-09-05 16:45:25 -0400 |
| commit | b023f5d3f5509d0bda5df992af20ac07f1c99f35 (patch) | |
| tree | f63fe1824005f741bc70481de39657f5e0106960 /mysql-test/t/heap_btree.test | |
| parent | fa13c3213ea7cba8262a7cb44ea9b3ceac15ac48 (diff) | |
| parent | dc4b2a4f1dc6ea2533e75f3eb8397c5c1ad9fbf8 (diff) | |
| download | mariadb-git-b023f5d3f5509d0bda5df992af20ac07f1c99f35.tar.gz | |
Merge zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.0-maint
into zippy.cornsilk.net:/home/cmiller/work/mysql/mysql-5.1-maint
Diffstat (limited to 'mysql-test/t/heap_btree.test')
| -rw-r--r-- | mysql-test/t/heap_btree.test | 13 |
1 files changed, 13 insertions, 0 deletions
diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test index e74e9723ca6..931d4e40d3e 100644 --- a/mysql-test/t/heap_btree.test +++ b/mysql-test/t/heap_btree.test @@ -204,3 +204,16 @@ CREATE TABLE t1 (a INT, UNIQUE USING BTREE(a)) ENGINE=MEMORY; INSERT INTO t1 VALUES(NULL),(NULL); DROP TABLE t1; +select a from t1 where a > 2; +delete from t1 where a < 4; +select a from t1 order by a; +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 order by a; +select a from t1 where a > 3; +delete from t1 where a >= 2; +select a from t1 order by a; +drop table t1; + +--echo End of 4.1 tests |