SAP Knowledge Base Article - Preview

2741087 - Inconsistent behavior inserting a new row, a null value found, even though a new record is committed - SAP ASE

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.

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.