Symptom
- A query returned error 206 with state 2 during compilation:
"Msg 206, Level 16, State 2:
Operand type clash: INT is incompatible with DATETIME"
- Optimizer diagnostics ‘set option show_abstract_plan on’ shows merge join ‘m_join’ is in the abstract plan output.
Read more...
Environment
SAP Adaptive Server Enterprise (ASE) 16.0 SP04 PL0X.
Product
SAP Adaptive Server Enterprise 16.0
Keywords
CR 828438, 828438, error 206, Operand type clash, merge join, set merge_join off , 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.