Symptom
Incorrect result was returned in a simple query with one table.
It can be reproduced with small rows. It looks nothing association with NBIT index at all.
[Query #1]
select RNN, INHB_CORP_RTN, INDV_CORP_DTL_DCD
from XXXX_10row
where RNN = INHB_CORP_RTN
;
[Result #1]
'5100143298610 ','5100143298610 ','0'
Result #1 is a correct result.
But if additional condition with INDV_CORP_DTL_DCD column is added, incorrect result is returned.
[Query #2]
select RNN, INHB_CORP_RTN, INDV_CORP_DTL_DCD
from XXXX_10row
where RNN = INHB_CORP_RTN
and INDV_CORP_DTL_DCD = '0' -- additional condition
;
[Result #2]
'5100143298610 ','5100143298610 ','0'
'119010003298 ','119010003298 ','0' -- incorrect result row
Read more...
Environment
SAP IQ 16 SP08
Product
Keywords
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.