SAP Knowledge Base Article - Preview

3285975 - UPDATE of a bit columns for an existing DOL table returns wrong result - SAP ASE

Symptom

  • UPDATE of a bit column for an existing DOL table returns wrong result.

  • For example, if you run the following SQL on the MYTABLE table with two columns BITCOL1 and BITCOL2 defined as BIT datatype and not nullable:

    select * from MYTABLE where MYID = 2000000000017224
    go
    update MYTABLE set BITCOL1 = 1, BITCOL2=0 where MYID = 2000000000017224
    go
    select * from MYTABLE where MYID = 2000000000017224 and BITCOL1 = 1 and BITCOL2=0
    go 

    the UPDATE query says (1 row affected), but no row qualifies the next SELECT query.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7 SP132

Product

SAP Adaptive Server Enterprise 15.7

Keywords

CR785109, CR#785109, 785109 , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.