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
  • SAP IQ 16.0

Product

SAP IQ 16.0 ; 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 for Me (Login required).

Search for additional results

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