I've encountered a strange bug when trying to sort DOM items by specific params.
My code looks like this:
$manager = new DataObjectManager(
'Title' => 'Title',
'Date' => 'Date',
'Title DESC, ID DESC'
The manager works just fine, but when I try to open a pop-up, an SQL error occurs.
I noticed that the problem is with the sorting params, the SQL statement for the popup contains a following piece of code:
ORDER BY Title DESC, ID DESC ASC LIMIT 10
Notice that the 'ASC' param is added unnecessarely.
How do I fix that?