diff options
| author | unknown <ramil/ram@mysql.com/myoffice.izhnet.ru> | 2006-08-14 12:59:54 +0500 |
|---|---|---|
| committer | unknown <ramil/ram@mysql.com/myoffice.izhnet.ru> | 2006-08-14 12:59:54 +0500 |
| commit | a756f762e868c73ac9e90ebadfd51f1c3d905499 (patch) | |
| tree | 8f35ef3ec041771e7bb88699c0aeb8ebefee50a5 /mysql-test/t/heap_btree.test | |
| parent | bb3efba00c5cac5a8b26eee129a512ab24622adb (diff) | |
| download | mariadb-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/t/heap_btree.test')
| -rw-r--r-- | mysql-test/t/heap_btree.test | 6 |
1 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/t/heap_btree.test b/mysql-test/t/heap_btree.test index f510f97fe9b..9aa820becd9 100644 --- a/mysql-test/t/heap_btree.test +++ b/mysql-test/t/heap_btree.test @@ -172,14 +172,14 @@ 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; +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; +select a from t1 order by a; select a from t1 where a > 3; 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 |