Symptom
- A query using previous cached parallel plan with variable returned wrong results.
- Parallelism is on server wide.
- The query or statement has a search clause with variable or parameter.
- The query plan uses previous cached parallel plan which has merge join operator.
- This may affect:
- Ad-hoc query having constant in search clause when 'statement cache size' > 0 and ‘literal autoparam’ = 1.
- Query inside a procedure or trigger.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 16.0 SP03
- SAP Adaptive Server Enterprise (ASE) 16.0 SP04
Product
SAP Adaptive Server Enterprise 16.0
Keywords
wrong result, CR 825779, 825779, parallel plan, merge join, statement cache , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Known Error
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.