SAP Knowledge Base Article - Preview

2590534 - A SQL returns different results when it's executed on MPX nodes each -- SAP IQ

Symptom

A simple 'Select ~ Into ~' query returns incorrect result only on two secondary nodes(node3 & node4).
  However same query returns always correct result on coordinator node(node1) and the 1st secondary node(node2).

    ... [20896]: Insert for '#TEMP_CHK' completed in 11 seconds.  422 rows inserted. <= incorrect in node3

    ... [20896]: Insert for '#TEMP_CHK' completed in 6 seconds.  438 rows inserted. <= Correct on node1


  * problematic query : below second SQL ran into incorrect results.

      SELECT ..., ...ID(A.RNN, 101) AS RNN , ...
        INTO #TMP_RNN
        FROM #TMP_RNN_T A ;
     
      SELECT A.RNN
           , CAST( TRIM(REPLACE(A.KRN_CSM,' ','')) AS CHAR(010))
           , CAST( TRIM(REPLACE(B.KRN_CSM,' ','')) AS CHAR(010))
           , CAST(0 AS INTEGER)
        INTO #TEMP_CHK
        FROM #TMP_RNN              A
           , ***.TB_ADW_CSC101P B
       WHERE B.BASE_YM  = '201712'
         AND B.LDGR_SCD = '1'
         AND A.RNN      = B.RNN
         AND TRIM(REPLACE(A.KRN_CSM,' ','')) <>  TRIM(REPLACE(B.KRN_CSM,' ','')) ;


Read more...

Product

SAP IQ 16.0

Keywords

"Incorrect result" ;  "Join Varchar" ; , 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.