SAP Knowledge Base Article - Preview

2820033 - View returns wrong results with rows limit clause - SAP ASE

Symptom

  • Select from a view using a rows limit clause returns wrong results

SELECT  COL1  FROM VIEW    WHERE COL2 = 'XXX' AND COL3 in ( xxx, xxx)  ORDER BY ORDER_DATETIME desc rows limit 150
go

  •  Optimizer chooses 'merge_join' as the default join strategy

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0
  • Optimization Goal is set to 'allrows_mix'

Product

SAP Adaptive Server Enterprise 16.0

Keywords

select, functions, function, pagination, limit, offset, wrong results, wrong result , 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 ONE Support launchpad (Login required).

Search for additional results

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