SAP Knowledge Base Article - Preview

2573783 - Query with hash join and off-row text column returns wrong results - SAP ASE

Symptom

  • A wrong result is returned for a query involving:
    • datalength() function
    • on an off-row text column
    • using hash join
  • A NOT NULL can be returned when a NULL is expected


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP02 or above

Product

SAP Adaptive Server Enterprise 16.0

Keywords

offrow, output, CR803755, CR#803755, 803755, in-row, inrow, hash_join , datalength , 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.