Dashboard query is incompatible with MySQL 4.1

The dashboard query fails in a mysql 4.1 setup. Since it works in other cases I suspect it's due to mysql 1.4 support.

The query uses a max() in the order

This is the generated query:
select distinct doc.space, doc.name, max(ni.date) from XWikiDocument as doc , XWikiRCSNodeInfo as ni where doc.id=ni.id.docId and ni.id.version2=1 group by doc.space, doc.name order by max(ni.date) desc

The hql is:

#set ($sql = ", XWikiRCSNodeInfo as ni where doc.id=ni.id.docId and ni.id.version2=1 group by doc.space, doc.name order by max(ni.date) desc")

if you change it to the following it works

#set ($sql = ", XWikiRCSNodeInfo as ni where doc.id=ni.id.docId and ni.id.version2=1 group by doc.space, doc.name order by 3 desc")