Symptom
create table foo (a int) lock datarows
go
insert into foo values (1)
go
Session 1:
begin tran
delete foo where a = 1
go
insert into foo values (1)
go
Session 2:
select @@isolation , count(*) , sum(a) from foo
go
Go back to session 1 and commit the data:
The first time it returns the data
The second time it returns null. Why?
Read more...
Environment
Adaptive Server Enterprise All versions.
Product
SAP Adaptive Server Enterprise all versions
Keywords
KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , How To
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.