SAP Knowledge Base Article - Preview

2627950 - Incorrect result for distinct join query - SAP IQ

Symptom

  • Incorrect result for select distinct Join query
  • Result contains more rows  than expected
  • Query plan contains Sort merge
  • Without "Distinct", query restuns expected result
  • Mismatch in joined columns datatypes


Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

Sybase, CR814394, CR#814394, 814394, sort merge, DML_Options2=8388608, distinct, , KBA , BC-SYB-IQ , Sybase IQ , Bug Filed

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.