[MDEV-16912] Spider Order By column[datatime] limit 5 returns 3 rows Created: 2018-08-07  Updated: 2018-09-13  Resolved: 2018-09-13

Status: Closed
Project: MariaDB Server
Component/s: Storage Engine - Spider
Affects Version/s: 10.1.34, 10.2.16
Fix Version/s: 10.2.18, 10.1.37

Type: Bug Priority: Critical
Reporter: LostInForest Assignee: Jacob Mathew (Inactive)
Resolution: Fixed Votes: 0
Labels: None
Environment:

windows 7,MariaDB 10.2.16 msi

Attachments: Text File phms_family.sql     Text File phms_family_spider_dll.sql    

 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.

 Comments   
Comment by Jacob Mathew (Inactive) [ 2018-09-12 ]

Kentoku, please review my fix for this problem in commit eb2ca3d on my branch.

Comment by Kentoku Shiba (Inactive) [ 2018-09-13 ]

It's OK to push.

Comment by Jacob Mathew (Inactive) [ 2018-09-13 ]

Fix is pushed to 10.1 and 10.2. Comments and test case are merged to 10.3 and 10.4.

Generated at Thu Feb 08 08:32:29 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.