SAP Knowledge Base Article - Preview

2064891 - SELECT row_count() against system tables returns incorrect results after upgrading from 12.5.4 - ASE

Symptom

  • Incorrect results from row_count() occur after upgrading from ASE 12.5.4 to ASE 15.7
  • In ASE 12.5.4, the result of rowcnt is correct:

    select rowcnt(sysindexes.doampg) from sysindexes where id = 5
    go
     ---------------------
              599
    (1 row affected)

  • After upgrading to ASE 15.7, the result of the row_count() function is incorrect:

    select row_count(5,5)
    go
     ---------------------
                  0              <== incorrect result
    (1 row affected)


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7

Keywords

function , 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.