summaryrefslogtreecommitdiff
path: root/mysql-test
diff options
context:
space:
mode:
authorMichael Widenius <monty@askmonty.org>2011-09-15 10:36:17 +0300
committerMichael Widenius <monty@askmonty.org>2011-09-15 10:36:17 +0300
commitda223f146add111c01275b914ad586fc42b461ff (patch)
treed0157a929baea4192e99fc4302134fc1aed93783 /mysql-test
parent0e06d3c1073f3ac1576e7cdd8c2980c48a999bff (diff)
downloadmariadb-git-da223f146add111c01275b914ad586fc42b461ff.tar.gz
Fixed test to be repeatable
Diffstat (limited to 'mysql-test')
-rw-r--r--mysql-test/suite/pbxt/r/limit.result2
-rw-r--r--mysql-test/suite/pbxt/t/limit.test2
2 files changed, 2 insertions, 2 deletions
diff --git a/mysql-test/suite/pbxt/r/limit.result b/mysql-test/suite/pbxt/r/limit.result
index 9bbf54fcfe9..dd53cb7deec 100644
--- a/mysql-test/suite/pbxt/r/limit.result
+++ b/mysql-test/suite/pbxt/r/limit.result
@@ -23,7 +23,7 @@ a b
2 2
3 2
4 4
-delete from t1 where b=2 limit 1;
+delete from t1 where b=2 order by a limit 1;
select * from t1 order by a;
a b
0 0
diff --git a/mysql-test/suite/pbxt/t/limit.test b/mysql-test/suite/pbxt/t/limit.test
index 0844af8705d..a65d5060e4d 100644
--- a/mysql-test/suite/pbxt/t/limit.test
+++ b/mysql-test/suite/pbxt/t/limit.test
@@ -15,7 +15,7 @@ update t1 set b=2 where b=1 limit 2;
select * from t1 order by a; # PBXT: required for consistent result
update t1 set b=4 where b=1;
select * from t1 order by a; # PBXT: required for consistent result
-delete from t1 where b=2 limit 1;
+delete from t1 where b=2 order by a limit 1;
select * from t1 order by a; # PBXT: required for consistent result
delete from t1 limit 1;
select * from t1 order by a; # PBXT: required for consistent result