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

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 ..., ADWDBA.PLS_ENCRYPT_B64_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
           , ADWOWN.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 ONE Support launchpad (Login required).

Search for additional results

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