SAP Knowledge Base Article - Preview

2581962 - Discrepancy seen in Query Text in Html Query Plan and actual query executed - SAP IQ

Symptom

A discrepancy between the actual query executed and the Query Text captured in Html Query Plan.

In the original query there are Inner joins, however in the query text printed in Html query plan,

  • no Inner joins printed
  • where conditions on join columns are added
  • where conditions "is not null" on join columns are added


Read more...

Environment

  • SAP IQ 16.1
  • SAP IQ 16.0
  • SAP IQ 15.4

Product

SAP IQ 16.0 ; SAP IQ 16.1 ; SAP Sybase IQ 15.2 ; SAP Sybase IQ 15.4 ; Sybase IQ 12.7

Keywords

query, html, query text, join, inner join, inner, "is not null", optimizer, parser , 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.