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
IQ 16.0 SP10.08
KBA , BC-SYB-IQ , Sybase IQ , Problem
About this pageThis 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.