SAP Knowledge Base Article - Preview

2145424 - return incorrect values for a column use

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

SAP IQ 16.0

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.