diff options
| author | unknown <mskold@mysql.com> | 2006-06-12 15:35:47 +0200 |
|---|---|---|
| committer | unknown <mskold@mysql.com> | 2006-06-12 15:35:47 +0200 |
| commit | b10b25fbb59fb10527c207154bbb65270beddb84 (patch) | |
| tree | ee1a9ed489895f1b1cf5bd02087e780fb87e60a7 /mysql-test/r/ndb_lock.result | |
| parent | 7b207a8301e9adc7191c2771f57f309005eea86f (diff) | |
| download | mariadb-git-b10b25fbb59fb10527c207154bbb65270beddb84.tar.gz | |
Added order by
Diffstat (limited to 'mysql-test/r/ndb_lock.result')
| -rw-r--r-- | mysql-test/r/ndb_lock.result | 8 |
1 files changed, 4 insertions, 4 deletions
diff --git a/mysql-test/r/ndb_lock.result b/mysql-test/r/ndb_lock.result index 281b02b8228..875dcd775e6 100644 --- a/mysql-test/r/ndb_lock.result +++ b/mysql-test/r/ndb_lock.result @@ -78,10 +78,10 @@ ERROR HY000: Lock wait timeout exceeded; try restarting transaction rollback; commit; begin; -select * from t1 where y = 'one' or y = 'three' for update; +select * from t1 where y = 'one' or y = 'three' order by x for update; x y z -3 three 3 1 one 1 +3 three 3 begin; select * from t1 where x = 2 for update; x y z @@ -118,10 +118,10 @@ ERROR HY000: Lock wait timeout exceeded; try restarting transaction rollback; commit; begin; -select * from t1 where y = 'one' or y = 'three' lock in share mode; +select * from t1 where y = 'one' or y = 'three' order by x lock in share mode; x y z -3 three 3 1 one 1 +3 three 3 begin; select * from t1 where y = 'one' lock in share mode; x y z |