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

• 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."

ASE version:16.0 SP02 PL09 HF1

827854, CR 827854, GROUP BY, subquery , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem