New answers tagged sybase
Got the solution: CREATE TRIGGER test_utrig ON test FOR UPDATE AS if UPDATE(id) and exists(select id from inserted where id not in (select id from inserted)) begin insert into test_a select 'update', UPDATE_BY(), GETDATE(), inserted.* FROM inserted
Sybase ASE uses blocking locks for transaction isolation, meaning that readers block writers and writers block readers (unlike other databases which use versioning so that writers don't block readers and vice versa). So each SELECT is blocked by the exclusive lock taken out by the earlier UPDATE on the table it is selecting from, since that update was done ...
Top 50 recent answers are included