SAP Knowledge Base Article - Preview

3498889 - Incorrect result when GROUP SORTED is used in query plan for SAP ASE

Symptom

  • Incorrect result returned for SELECT 
    For example one row is supposed to be returned but two rows got returned .
  • INNER JOIN might be used
  • Table may has column in TEXT type 
  • Query plan shows that GROUP SORTED is used
           |   |   | Using Worktable1 for internal storage.
           |   |   |
           |   |   |   |RESTRICT Operator (VA = 24)(0)(0)(0)(7)(0)
           |   |   |   |
           |   |   |   |   |GROUP SORTED Operator (VA = 23)
           |   |   |   |   |  Evaluate Grouped MAXIMUM AGGREGATE.
    ...


Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0 SP03 PL12 HF1

Product

SAP Adaptive Server Enterprise 16.0

Keywords

CR829638, CR#829638, QP, queryplan, showplan, statement, wrong, group_sorted , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , Problem

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.