SAP Knowledge Base Article - Preview

3356750 - Wrong results from query with GROUP BY when using traceflag 450 - SAP ASE

Symptom

  • When using the traceflag 450:
    set switch on 450 with override
  • A query using GROUP BY and ORDER BY returns incorrect results.
  • There are missing rows.


Read more...

Environment

SAP Adaptive Server Enterprise (ASE)

Product

SAP Adaptive Server Enterprise all versions

Keywords


query incorrect results, GROUP BY issue, ORDER BY problem, missing rows, trace flag, CR 742694, vector aggregation issue, grouping column limit, obsolete trace flag, trace flag 450, predictable ordering, grouping column restriction, database query error , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error

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.