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.
SAP Knowledge Base Article - Preview