SAP Knowledge Base Article - Preview

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

Symptom

  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


Read more...

Environment

IQ 16.0 SP10.08

Product

SAP IQ 16.0

Keywords

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

Search for additional results

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