SAP Knowledge Base Article - Preview

2284743 - Whenever executes a 'LIKE' query, it returns incorrect result count , in IQ16 SP10.8.


  After upgraded to IQ16 SP10.8, IBK found an existing batch job returned various different result count.
  When I saw query scripts, after inserted data to table 'TEST01', following query with 'LIKE' returned
  various different result count.  But inserted base table ‘TEST01’ has same count..
  It looks below select query works incorrectly. I don’t have query plan and request IBK to send some plans.

      SELECT count(*) from TEST01    -- always 20892 rows
      WHERE RM_DCD NOT LIKE 'R%'  -- witht this clause, returned different result rows as 20706 & 20703
          AND POINT > 0.0;        -- when added this,  returned different result rows as 11000 as 10999

  Above query made incorrect results under DML_Options17=ON and/or dml_options14=8.

     - DML_Options17=ON  --verify Bitmaps
     - DML_Options14=8   -- turn off the width minimize optimization



IQ 16.0 SP10.08


SAP IQ 16.0


"Incorrect result count"; "Like clause" ; , 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.