As said in my initial post 5.5.32 and if you read the whole post you see also that this exists very long *please* read my whole initial post - I *can not* send test data because it is *not* reproduceable in a terminal so how should I as ordinary user verify that whatever I send is qualified to prove the problem - so please do not insist that I should provide the test data because with the queries from my initial post and some lines code using libzdb this should be easy to verify - as php developer I can not provide it mail's with multiple mime parts are broken and reconstructed in the wrong order and so destroyed - so install dbmail and send such test mail's - you not "maybe" have a order by problem you *have* have one which wasted a lot of hours to debug a mailserver because a software claiming to be a drop-in replacement is broken - and I would not be that angry if I had not tried to bring MariaDB upstream to the problem a other user reported months ago and nobody cared -------- Ursprüngliche Nachricht -------- Von: Roberto Spadim <roberto@spadim.com.br> Gesendet: Mon Sep 02 06:28:48 MESZ 2013 An: Reindl Harald <h.reindl@thelounge.net> CC: Mailing-List mariadb <maria-discuss@lists.launchpad.net>, Mailing-List dbmail <dbmail@dbmail.org> Betreff: Re: [Maria-discuss] Fwd: [Dbmail] MariaDB and dbmail please send the mariadb version too 2013/9/2 Roberto Spadim <roberto@spadim.com.br>:
please Reindl provide some data to test, i found some information, we can add a bug at jira (bug tracker) of mariadb and solve this problem... (if it exists...)
here one report from archlinux guys similar to your report, maybe we (mariadb) have a problem with order by (?) https://mailman.archlinux.org/pipermail/arch-general/2013-April/033282.html
here the create tables: -------------------------------------------------------- CREATE TABLE IF NOT EXISTS `dbmail_mimeparts` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `hash` char(128) NOT NULL, `data` longblob NOT NULL, `size` bigint(20) NOT NULL DEFAULT '0', PRIMARY KEY (`id`), KEY `hash` (`hash`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- CREATE TABLE IF NOT EXISTS `dbmail_partlists` ( `physmessage_id` bigint(20) unsigned NOT NULL DEFAULT '0', `is_header` tinyint(1) NOT NULL DEFAULT '0', `part_key` smallint(6) NOT NULL DEFAULT '0', `part_depth` smallint(6) NOT NULL DEFAULT '0', `part_order` smallint(6) NOT NULL DEFAULT '0', `part_id` bigint(20) unsigned NOT NULL DEFAULT '0', UNIQUE KEY `message_parts` (`physmessage_id`,`part_key`,`part_depth`,`part_order`), KEY `physmessage_id` (`physmessage_id`), KEY `part_id` (`part_id`), CONSTRAINT `dbmail_partlists_ibfk_1` FOREIGN KEY (`physmessage_id`) REFERENCES `dbmail_physmessage` (`id`) ON DELETE CASCADE ON UPDATE CASCADE, CONSTRAINT `dbmail_partlists_ibfk_2` FOREIGN KEY (`part_id`) REFERENCES `dbmail_mimeparts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE ) ENGINE=InnoDB DEFAULT CHARSET=utf8; --- CREATE TABLE IF NOT EXISTS `dbmail_physmessage` ( `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `messagesize` bigint(20) unsigned NOT NULL DEFAULT '0', `rfcsize` bigint(20) unsigned NOT NULL DEFAULT '0', `internal_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; ---
-- Reindl Harald (mobile) the lounge interactive design GmbH A-1060 Vienna, Hofmühlgasse 17 CTO / CISO / Software-Development +43 (676) 40 221 40 http://www.thelounge.net