GROUP BY with ORDER BY

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,