summaryrefslogtreecommitdiff
path: root/mysql-test/r/heap_btree.result
diff options
context:
space:
mode:
authorunknown <ramil/ram@mysql.com/myoffice.izhnet.ru>2006-08-14 12:59:54 +0500
committerunknown <ramil/ram@mysql.com/myoffice.izhnet.ru>2006-08-14 12:59:54 +0500
commita756f762e868c73ac9e90ebadfd51f1c3d905499 (patch)
tree8f35ef3ec041771e7bb88699c0aeb8ebefee50a5 /mysql-test/r/heap_btree.result
parentbb3efba00c5cac5a8b26eee129a512ab24622adb (diff)
downloadmariadb-git-a756f762e868c73ac9e90ebadfd51f1c3d905499.tar.gz
Make the heap_btree test repeatable.
mysql-test/r/heap_btree.result: Make the heap_btree test repeatable. - 'order by' added where we don't use the 'a' index. mysql-test/t/heap_btree.test: Make the heap_btree test repeatable. - 'order by' added where we don't use the 'a' index.
Diffstat (limited to 'mysql-test/r/heap_btree.result')
-rw-r--r--mysql-test/r/heap_btree.result14
1 files changed, 7 insertions, 7 deletions
diff --git a/mysql-test/r/heap_btree.result b/mysql-test/r/heap_btree.result
index 91c3ec65a13..e6492e90b80 100644
--- a/mysql-test/r/heap_btree.result
+++ b/mysql-test/r/heap_btree.result
@@ -255,27 +255,27 @@ a
3
3
delete from t1 where a < 4;
-select a from t1;
+select a from t1 order by a;
a
insert into t1 values (2), (2), (2), (1), (1), (3), (3), (3), (3);
select a from t1 where a > 4;
a
delete from t1 where a > 4;
-select a from t1;
+select a from t1 order by a;
a
-3
-3
1
-3
-3
1
2
2
2
+3
+3
+3
+3
select a from t1 where a > 3;
a
delete from t1 where a >= 2;
-select a from t1;
+select a from t1 order by a;
a
1
1