SAP Knowledge Base Article - Preview

3340696 - A GROUP BY query having subqueries and NON-ANSI text may return wrong result when parallelism is on.

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.