summaryrefslogtreecommitdiff
path: root/mysql-test/t/heap_btree.test
diff options
context:
space:
mode:
authorunknown <cmiller@zippy.cornsilk.net>2006-08-10 12:39:18 -0400
committerunknown <cmiller@zippy.cornsilk.net>2006-08-10 12:39:18 -0400
commit12eb42acf98d1594b9e50dbbf0c77d82f95279ed (patch)
tree16dfb2cb6e8074ee4ca0d394c2cc9237f4f96510 /mysql-test/t/heap_btree.test
parent78c9885fe017db8b4cd58d8c5f76af8294541a29 (diff)
downloadmariadb-git-12eb42acf98d1594b9e50dbbf0c77d82f95279ed.tar.gz
Merge updates.
mysql-test/r/grant2.result: Merge update: Change between versions, it appears. mysql-test/r/heap_btree.result: Merge update: Add deterministic ordering of data, as the order is different between versions. mysql-test/r/mysql_client.result: Merge update: Help options changed between versions. mysql-test/t/heap_btree.test: Merge update: Add deterministic ordering of data, as the order is different between versions. BitKeeper/deleted/.del-bug20328.test~c76d766fe3e1eb5: Delete: mysql-test/t/bug20328.test BitKeeper/deleted/.del-bug20328.result~4fee68989442c2a3: Delete: mysql-test/r/bug20328.result
Diffstat (limited to 'mysql-test/t/heap_btree.test')
-rw-r--r--mysql-test/t/heap_btree.test12
1 files changed, 6 insertions, 6 deletions
diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test
index 71743d0d850..e74e9723ca6 100644
--- a/mysql-test/t/heap_btree.test
+++ b/mysql-test/t/heap_btree.test
@@ -170,16 +170,16 @@ DROP TABLE t1;
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;
+select a from t1 where a > 2 order by a;
delete from t1 where a < 4;
-select a from t1;
+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;
+select a from t1 where a > 4 order by a;
delete from t1 where a > 4;
-select a from t1;
-select a from t1 where a > 3;
+select a from t1 order by a;
+select a from t1 where a > 3 order by a;
delete from t1 where a >= 2;
-select a from t1;
+select a from t1 order by a;
drop table t1;
--echo End of 4.1 tests