вс, 25 мар. 2018 г., 7:22 Mladen Gogala <gogala.mladen@xxxxxxxxx>:
Reply in-line
On 03/24/2018 10:21 PM, Sayan Malakshinov wrote:
Mladen,
Update statement doesn't support "order by" and I almost never seen anyone
write sorted update statements like
update (select * from t where b=:b order by rowid) set d=:d
So you can easily get deadlock with simple concurrent updates like
"update t set d=:d where b=:b" and "update t set d=:d where c=:c"
How would you get a deadlock on locking a single row in a single table?