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

"Incorrect result count"; "Like clause" ; , KBA , BC-SYB-IQ , Sybase IQ , Problem