SAP Knowledge Base Article - Preview

2830358 - HG index could cause incorrect result - SAP IQ

Symptom

Incorrect result could be seen when

  • a query involves a view with union all of several tables
  • HG index exists on the same column of each of the underlying tables.
  • the optimizer uses the HG indexes
  • the query has a IN clause with a subselect on another table

The SQL looks like the following:

SELECT COUNT(*) FROM TEST_VIEW
WHERE
DT = DATE('2019-05-31')
AND VAL IN ( SELECT DISTINCT VAL FROM MASTER WHERE STATIC_VAL = '1515')

  • The HG indexes are on the column VAL in the underlying tables of the view TEST_VIEW.
  • When those HG indexes are deleted, the query returns the correct result.

Read more...

Environment

SAP IQ 16.1

Product

SAP IQ 16.1

Keywords

CR819905 ; CR#819905 ; 819905 ; "union all" ; IN ; "IN clause" , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.