Skip to content
  • Kailasnath Nagarkar's avatar
    8d03b05c
    Bug #24714857: FOUND_ROWS() RETURNS 1 WHEN NO ROWS FOUND · 8d03b05c
    Kailasnath Nagarkar authored
    This patch is specific to mysql-5.7
    
    ISSUE: FOUND_ROWS() returned 1 even though the previous
           select did not return any rows. This was happening
           because the statistics returned by InnoDB returned
           1 for the select even though there are no rows.
           The same count was further returned by FOUND_ROWS().
    
    FIX: In InnoDB, while determining statistics, check whether
         its for temporary table. If its temporary table,
         do not increment the row count.
    8d03b05c
    Bug #24714857: FOUND_ROWS() RETURNS 1 WHEN NO ROWS FOUND
    Kailasnath Nagarkar authored
    This patch is specific to mysql-5.7
    
    ISSUE: FOUND_ROWS() returned 1 even though the previous
           select did not return any rows. This was happening
           because the statistics returned by InnoDB returned
           1 for the select even though there are no rows.
           The same count was further returned by FOUND_ROWS().
    
    FIX: In InnoDB, while determining statistics, check whether
         its for temporary table. If its temporary table,
         do not increment the row count.
Loading