Details
-
Bug
-
Status: Closed (View Workflow)
-
Critical
-
Resolution: Not a Bug
-
10.1.38
-
None
-
MyISAM
Description
sample data: test table
id, name, date
1, John, 2019-03-10 16:28:58
2, john, 2019-03-12 16:29:08
SELECT *
FROM
(
SELECT *
FROM test
ORDER BY DATE DESC
) a
GROUP BY a.name
The result in:
MySQL 5.1.41
2, john, 2019-03-12 16:29:08 - correct answer
10.1.37-MariaDB-cll-lve - MariaDB Server
1 John 2019-03-10 16:28:58
I tried with GROUP BY DESC but result is same,