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.