MySQL Bugs: #87644: Order by on 'datetime' column not working with LIMIT <row

Bug #87644	Order by on 'datetime' column not working with LIMIT <row_count>
Submitted:	1 Sep 2017 22:19	Modified:	25 Apr 2018 13:37
Reporter:	KORBULY Francois	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Server: Optimizer	Severity:	S2 (Serious)
Version:	5.7.18	OS:	CentOS (6 (x86_64))
Assigned to:		CPU Architecture:	Any
Tags:	datetime, limit, no sorting, order by

File:	Maximum allowed size is 50MB.
Description:
Privacy:

If the data you need to attach is more than 50MB, you should create a compressed archive of the data, split it to 50MB chunks, and upload each of them as a separate attachment.

To split a large file:

On *nix platforms use the split command e.g. split -b 50MB <my_large_archive> <my_split_archive_prefix>
On windows use WinZip or a similar utility to split the large file

Screenshot of issue with limit

Attachment: mysql-bug-87644-with_limit.jpg (image/jpeg, text), 382.03 KiB.

Screenshot of issue without limit

Attachment: mysql-bug-87644-without_limit.jpg (image/jpeg, text), 330.42 KiB.