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 for Me (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.