SAP Knowledge Base Article - Preview

3379593 - A query raised error 206 with state 2 during compilation due to invalid merge join plan – SAP ASE

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.