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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.