SAP Knowledge Base Article - Preview

2145424 - return incorrect values for a column use


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



SAP IQ 16 SP08


SAP IQ 16.0


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.