2281797 - SAP IQ16 : A complex query returns Incorrect result, but it wroked well in IQ12.7

Symptom

Customer found that a analytic query returns some incorrect outputs.
Customer created a modified query using temporary tables instead of derived tables which were used by the original query in order to compare the output values.
Customer found that some output values were incorrect in the result of comparison.
Customer did not know why this symptom could be seen and wanted to know the root cause and workaround to make 2 queries to return the same output values.

DBA tried to run original query test with below options, but all trials made same incorrect result.

   - set temporary option DML_Options8=8; -- (1) disable shadow parallelism
   - set temporary option DML_Options13=16; -- (2) disable parallel build of the hash
   - set temporary option CORE_Options14=256; -- (3) disable "fast hash" optimization
   - set temporary option JOIN_PREFERENCE = -4; --(4) Avoid hash join algorithm

Environment

IQ 16.0 SP10.08

Product

SAP IQ 16.0

Keywords

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.