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 <robe...@spadim.com.br> Gesendet: Mon Sep 02 06:28:48 MESZ 2013 An: Reindl Harald <h.rei...@thelounge.net> CC: Mailing-List mariadb <maria-discuss@lists.launchpad.net>, Mailing-List dbmail <dbm...@dbmail.org> Betreff: Re: [Maria-discuss] Fwd: [Dbmail] MariaDB and dbmail please send the mariadb version too 2013/9/2 Roberto Spadim <robe...@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 _______________________________________________ Mailing list: https://launchpad.net/~maria-discuss Post to : maria-discuss@lists.launchpad.net Unsubscribe : https://launchpad.net/~maria-discuss More help : https://help.launchpad.net/ListHelp
