At Thu, 20 Sep 2012 10:46:52 +0800,
zamri <[email protected]> wrote:
> MariaDB is fully compatible with MySQL. Migration is done. So far so good.
> Phewww!...
>
> Now I need to do some research on tuning mariadb if needed.
I found that after migration following SQL returns wrong sorted data:
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;
however when I run it from command line it works well.
Probably it does not fail always because of not all emails damaged.
Not sure if it caused by migration to mariadb, but problem appeared
near same time.
_______________________________________________
DBmail mailing list
[email protected]
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail
