Symptom
- Invalid query plan returns wrong results. The showplan has message "Optimized using Parallel Mode",the generated final plan is a serial plan.
- The query has NON-ANSI text, there are columns in a GROUP BY clause that are not in SELECT LIST, it has a column using ISNULL built-in function which is in SELECT LIST.
- There are two subqueries in the query, one subquery is flattened to a join based on trace 281 output.
- Run the query with "set fipsflagger on", may get output "Line number 2 contains Non-ANSI text. The error is caused due to the use of Sybase built-in function: isnull."
Read more...
Environment
ASE version:16.0 SP02 PL09 HF1
Product
SAP Adaptive Server Enterprise 16.0
Keywords
827854, CR 827854, GROUP BY, subquery , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.