SAP Knowledge Base Article - Preview

3002986 - SAP IQ 16.1 Left Join displays incorrect behavior


There appears to be an incorrect behavior with the optimizer when using the left outer join.

When initially tested, there are 2 rows in t1, 2 rows in t2 and 2 rows in InstrumentRole to verify the where clause. The test queries both returned 2 rows and queryplan showed left outer join after adding a 100K rows of junk data to InstrumentRole the optimizer went right outer join.



  •  SAP IQ 16.1 SP 4 PL 6


SAP IQ 16.1


KBA , BC-SYB-IQ , Sybase IQ , 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.