[arch-general] MariaDB and DBMail: do not switch from mysql
Sergej Pupykin
ml at sergej.pp.ru
Wed Apr 3 05:14:47 EDT 2013
Hello,
it looks like mariadb has problems in "order by". Following query
returns data in wrong order:
SELECT
l.part_key,
l.part_depth,
l.part_order,
l.is_header,
DATE_FORMAT(ph.internal_date,GET_FORMAT(DATETIME,'ISO')),
data
FROM
dbmail_mimeparts p
JOIN dbmail_partlists l ON p.id = l.part_id
JOIN dbmail_physmessage ph ON ph.id = l.physmessage_id
WHERE l.physmessage_id = <ID>
ORDER BY l.part_key,l.part_order ASC;
I've had headache with my mail server. Switching back to mysql helps.
More information about the arch-general
mailing list