[#MDEV-9357] Identical queries but LIMIT 100 returns 0 rows, LIMIT 99 returns what you would expect.

With the query attached (not a pretty query, but that doesn't matter) with limit set to 100 on 10.1.10 I am returned 0 rows, but if I change 100 to 99, it returns the rows I'd expect. This issue does not exist on MySQL 5.5.36 or 10.0.23.

SELECT `a`.*,`a`.`content` AS `date`,`lawyer`.`content` AS `lawyer`,`lawyer_name`.`title` AS `lawyer_name`,`locationName`.`content` AS `locationName`,`name`.`content` AS `name`,`email`.`content` AS `email`,`phone`.`content` AS `phone`,`best_contact_time`.`content` AS `best_contact_time`,`legal_issue`.`content` AS `legal_issue` FROM `contact` AS `a`LEFT JOIN `contact` AS `lawyer` ON (`lawyer`.`object` = `a`.`id` AND `lawyer`.`type` = "lawyer") LEFT JOIN `content` AS `lawyer_name` ON (`lawyer`.`content` = `lawyer_name`.`id` AND `lawyer_name`.`type` = "lawyer") LEFT JOIN `contact` AS `locationName` ON (`locationName`.`object` = `a`.`id` AND `locationName`.`type` = "locationName") LEFT JOIN `contact` AS `name` ON (`name`.`object` = `a`.`id` AND `name`.`type` = "name") LEFT JOIN `contact` AS `email` ON (`email`.`object` = `a`.`id` AND `email`.`type` = "email") LEFT JOIN `contact` AS `phone` ON (`phone`.`object` = `a`.`id` AND `phone`.`type` = "phone") LEFT JOIN `contact` AS `best_contact_time` ON (`best_contact_time`.`object` = `a`.`id` AND `best_contact_time`.`type` = "best_contact_time") LEFT JOIN `contact` AS `legal_issue` ON (`legal_issue`.`object` = `a`.`id` AND `legal_issue`.`type` = "legal_issue") WHERE `a`.`content` >= CONVERT_TZ("2016-01-01 00:00", "America/Vancouver", "UTC") AND `a`.`content` <= CONVERT_TZ("2016-01-04 23:59", "America/Vancouver", "UTC") AND `a`.`object` = "1712" AND `a`.`type` = "contact" ORDER BY `date` DESC LIMIT 100

[MDEV-9357] Identical queries but LIMIT 100 returns 0 rows, LIMIT 99 returns what you would expect. Created: 2016-01-04 Updated: 2016-02-10 Resolved: 2016-02-10
Status:	Closed
Project:	MariaDB Server
Component/s:	OTHER
Affects Version/s:	10.1.10
Fix Version/s:	N/A

[MDEV-9357] Identical queries but LIMIT 100 returns 0 rows, LIMIT 99 returns what you would expect. Created: 2016-01-04 Updated: 2016-02-10 Resolved: 2016-02-10