Details
-
Type:
Bug
-
Status: Closed (View Workflow)
-
Priority:
Critical
-
Resolution: Fixed
-
Affects Version/s: 10.1.34, 10.2.16
-
Component/s: Storage Engine - Spider
-
Labels:None
-
Environment: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.