3430799 - "wait on uncomitted insert" is not enforced -ASE

• ASE server is set to isoloation level 1

1> select @@isolation
2> go

 -----------
           1

(1 row affected)

• Level 1 – prevents dirty reads. Such reads occur when one transaction modifies a row, and a second transaction reads that row before the first 
• The locking scheme for the server is set to datarows

1> sp_configure "lock scheme"
2> go
 Parameter Name                   Default                Memory Used                Config Value                 Run Value                Unit     Type
 -------------------------------- ---------------------- -------------------------- ---------------------------- ------------------------ -------- --------------
 lock scheme                         allpages                      0                    datarows                     datarows             name     dynamic

(1 row affected)
(return status = 0)

• sp_configure "wait on uncommited inserts" is set to 1

1> sp_configure "wait on uncommitted insert"
2> go
 Parameter Name                                       Default                Memory Used                Config Value                 Run Value                Unit         Type
 ---------------------------------------------------- ---------------------- -------------------------- ---------------------------- ------------------------ ------------ --------------
 wait on uncommitted insert                                     0                      0                           1                            1             number       dynamic

(1 row affected)
(return status = 0)

• "wait on uncommitted insert" is not working properly

SAP Adaptive Server Enterprise (ASE) 16.0

KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Product Enhancement