The following issue has been RESOLVED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=636 ====================================================================== Reported By: andy Assigned To: paul ====================================================================== Project: DBMail Issue ID: 636 Category: Database layer Reproducibility: always Severity: minor Priority: normal Status: resolved target: Resolution: fixed Fixed in Version: 2.3.0 ====================================================================== Date Submitted: 02-Aug-07 17:27 CEST Last Modified: 30-Sep-07 15:27 CEST ====================================================================== Summary: key or unique constraint in table dbmail_sievescripts (mysql/innodb) missing Description: Obviously the dbmail_sievecmd expects and works with the unique constraint (owner_idnr, name).
Anyhow this constraint is missing in the DB create script and it is possible to insert several columns with the same (owner_idnr, name). The behaviour is then inconsistent, because dbmail_sievecmd will drop all those columns and replace by 1. This is right, but there should be never several columns with same (owner_idnr, name). ====================================================================== ---------------------------------------------------------------------- aaron - 02-Aug-07 20:52 ---------------------------------------------------------------------- Good point, thanks. I'm going to assign this bug toward 2.3 development. ---------------------------------------------------------------------- paul - 30-Sep-07 15:27 ---------------------------------------------------------------------- fixed in the trunk Issue History Date Modified Username Field Change ====================================================================== 02-Aug-07 17:27 andy New Issue 02-Aug-07 20:52 aaron Note Added: 0002317 09-Aug-07 08:20 aaron Status new => acknowledged 30-Sep-07 15:27 paul Note Added: 0002390 30-Sep-07 15:27 paul Assigned To => paul 30-Sep-07 15:27 paul Status acknowledged => resolved 30-Sep-07 15:27 paul Resolution open => fixed 30-Sep-07 15:27 paul Fixed in Version => 2.3.0 ====================================================================== _______________________________________________ Dbmail-dev mailing list [email protected] http://twister.fastxs.net/mailman/listinfo/dbmail-dev
