Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Fixed
-
10.1.34, 10.2.16
-
None
-
windows 7,MariaDB 10.2.16 msi
Description
when quering with innodb table:
SELECT *
FROM phms_family
WHERE region_code LIKE "%510411106%"
AND region = 510411
AND delete_status != 1
ORDER BY update_date LIMIT 5 OFFSET 1
return 5 rows;
but spider table ,return 3 rows;
update_date is a datatime column, with null field.