diff options
Diffstat (limited to 'mysql-test')
| -rw-r--r-- | mysql-test/r/bdb.result | 4 | ||||
| -rw-r--r-- | mysql-test/t/bdb.test | 2 |
2 files changed, 3 insertions, 3 deletions
diff --git a/mysql-test/r/bdb.result b/mysql-test/r/bdb.result index a815f2f8fab..eb97d19136d 100644 --- a/mysql-test/r/bdb.result +++ b/mysql-test/r/bdb.result @@ -133,11 +133,11 @@ id parent_id level 1202 107 2 1204 107 2 update ignore t1 set id=1023 where id=1010; -select * from t1 where parent_id=102; +select * from t1 where parent_id=102 order by parent_id,id; id parent_id level 1008 102 2 -1015 102 2 1010 102 2 +1015 102 2 explain select level from t1 where level=1; table type possible_keys key key_len ref rows Extra t1 ref level level 1 const 1 Using where; Using index diff --git a/mysql-test/t/bdb.test b/mysql-test/t/bdb.test index 0df93b5f220..608d4bf5042 100644 --- a/mysql-test/t/bdb.test +++ b/mysql-test/t/bdb.test @@ -39,7 +39,7 @@ select * from t1; update ignore t1 set id=id+1; # This will change all rows select * from t1; update ignore t1 set id=1023 where id=1010; -select * from t1 where parent_id=102; +select * from t1 where parent_id=102 order by parent_id,id; explain select level from t1 where level=1; explain select level,id from t1 where level=1; explain select level,id,parent_id from t1 where level=1; |