diff options
| author | unknown <cmiller@zippy.cornsilk.net> | 2006-09-05 16:45:25 -0400 |
|---|---|---|
| committer | unknown <cmiller@zippy.cornsilk.net> | 2006-09-05 16:45:25 -0400 |
| commit | a33614345f31a51e9407203f923488af094ae3fb (patch) | |
| tree | f63fe1824005f741bc70481de39657f5e0106960 /mysql-test/t/heap_btree.test | |
| parent | 40f8bb4f384de789be66453888c8fbc2f6eafd55 (diff) | |
| parent | a756f762e868c73ac9e90ebadfd51f1c3d905499 (diff) | |
| download | mariadb-git-a33614345f31a51e9407203f923488af094ae3fb.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
mysql-test/r/heap_btree.result:
Auto merged
mysql-test/t/heap_btree.test:
Manually merged.
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 |