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 for Me (Login required).

Search for additional results

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