Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
5.5.56-galera
-
Centos 7..4.1708 x64
Description
After executing a query which includes SQL_CALC_FOUND_ROWS directive, if the query returns zero results, the FOUND_ROWS() function returns '1'.
Example:
SELECT SQL_CALC_FOUND_ROWS * FROM table_name WHERE some_field = 'some value that matches 0 rows';
SELECT FOUND_ROWS() as count_of_rows;
returns count_of_rows = 1
Version 5.5.56 is the latest version available in my distro's packages. Is this bug fixed with newer versions?
This bug seems to be similar to MySQL bug 83110: https://bugs.mysql.com/bug.php?id=83110