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).
... : Insert for '#TEMP_CHK' completed in 11 seconds. 422 rows inserted. <= incorrect in node3
... : 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 , ...
FROM #TMP_RNN_T A ;
, CAST( TRIM(REPLACE(A.KRN_CSM,' ','')) AS CHAR(010))
, CAST( TRIM(REPLACE(B.KRN_CSM,' ','')) AS CHAR(010))
, CAST(0 AS INTEGER)
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,' ','')) ;
"Incorrect result" ; "Join Varchar" ; , 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.