Garn,
I've been building and testing debian packages with sqlite support with the imap
test-suite in test-scripts/.
The testFetch fails until there are enough testmessages in the dbmail_messages
table. After there are at least 10 messages (10 failure runs of the test), that
one works just fine.
But the test-suite encounters one problem with uniqueness constraints for
SETACL.
sqlite> select * from dbmail_acl;
3|3|0|0|0|0|0|0|0|0|0
sqlite> UPDATE dbmail_acl SET lookup_flag = '1' WHERE user_id = '3' AND
mailbox_id = '3';
SQL error: UNIQUEness constraint violation
Shouldn't below trigger read "...foo.a > 1..." ??
CREATE TRIGGER dbmail_acl_constraint_update
BEFORE UPDATE ON dbmail_acl
BEGIN
SELECT CASE WHEN foo.a > 0 THEN RAISE(ROLLBACK, 'UNIQUEness
constraint violation')
ELSE 1 END FROM (
SELECT COUNT(*) AS a FROM dbmail_acl
WHERE new.user_id = dbmail_acl.user_id
AND new.mailbox_id = dbmail_acl.mailbox_id
) AS foo;
END;
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
