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.
Attachments
Activity
| Field | Original Value | New Value |
|---|---|---|
| Description |
when use innodb table query:
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 use spider table query ,return 3 rows; update_date is a datatime column, with null field. |
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. |
| Fix Version/s | 10.1 [ 16100 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Assignee | Jacob Mathew [ jacob-mathew ] |
| Attachment | phms_family_spider_dll.sql [ 46013 ] |
| Status | Open [ 1 ] | In Progress [ 3 ] |
| Assignee | Jacob Mathew [ jacob-mathew ] | Kentoku [ kentoku ] |
| Status | In Progress [ 3 ] | In Review [ 10002 ] |
| Assignee | Kentoku [ kentoku ] | Jacob Mathew [ jacob-mathew ] |
| Status | In Review [ 10002 ] | Stalled [ 10000 ] |
| Status | Stalled [ 10000 ] | In Progress [ 3 ] |
| Fix Version/s | 10.2.18 [ 23112 ] | |
| Fix Version/s | 10.1.37 [ 23204 ] | |
| Fix Version/s | 10.2 [ 14601 ] | |
| Fix Version/s | 10.1 [ 16100 ] | |
| Resolution | Fixed [ 1 ] | |
| Status | In Progress [ 3 ] | Closed [ 6 ] |
| Workflow | MariaDB v3 [ 88780 ] | MariaDB v4 [ 154759 ] |