The following issue has been RESOLVED. ====================================================================== http://www.dbmail.org/mantis/view.php?id=471 ====================================================================== Reported By: lkneschke Assigned To: paul ====================================================================== Project: DBMail Issue ID: 471 Category: IMAP daemon Reproducibility: always Severity: minor Priority: normal Status: resolved target: Resolution: fixed Fixed in Version: 2.2.2 ====================================================================== Date Submitted: 10-Dec-06 22:56 CET Last Modified: 16-Dec-06 19:55 CET ====================================================================== Summary: OR SEARCH not working: SEARCH OR FROM "alarm" SUBJECT "alarm" Description: This search
SEARCH OR FROM "alarm" SUBJECT "alarm" should report 3 messages. But it returns no messages. Seems like the result get's always AND'ED. I'm very sure that the search filter is syntactical correct, because i tested it against a cyrus imap server. Find the level 5 log below. Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Info:[imap] imap4.c,IMAPClientHandler(+200): COMMAND: [A0008 SEARCH OR FROM "alarm" SUBJECT "alarm"] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2132): arg[0]: 'OR' Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2132): arg[1]: 'FROM' Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2132): arg[2]: 'alarm' Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2132): arg[3]: 'SUBJECT' Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[imapsession] dbmail-imapsession.c,build_args_array_ext(+2132): arg[4]: 'alarm' Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Info:[imap] imap4.c,IMAPClientHandler(+313): Executing command search... Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[db] db.c,db_acl_has_right(+4222): checking ACL [read_flag] for user [4] on mailbox [6] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[db] db.c,db_acl_has_right(+4232): mailbox [6] is owned by user [4], is that also [4]? Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[db] db.c,db_acl_has_right(+4236): mailbox [6] is owned by user [4], giving all rights Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[sql] dbmysql.c,db_query(+286): query [SELECT message_idnr FROM dbmail_messages WHERE mailbox_idnr = 6 AND status IN (0,1) ORDER BY message_idnr] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,append_search(+521): [135756168] [1] type [2] field [] search [1:*] at depth [1] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,append_search(+521): [135760432] [1] type [15] field [] search [] at depth [2] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,append_search(+521): [135764696] [0] type [5] field [from] search [alarm] at depth [2] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,append_search(+521): [135768960] [0] type [5] field [subject] search [alarm] at depth [2] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,dbmail_mailbox_get_set(+1229): [1:*] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[misc] misc.c,g_tree_merge(+1206): a[0] [OR] b[11] -> a[11] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,_do_search(+1384): [135756168] depth [1] type [2] rows [11] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[sql] dbmysql.c,db_query(+286): query [SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE mailbox_idnr = 6 AND status IN (0,1) AND headername LIKE 'from' AND headervalue LIKE '%alarm%' ORDER BY message_idnr] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,_do_search(+1384): [135764696] depth [3] type [5] rows [3] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[sql] dbmysql.c,db_query(+286): query [SELECT message_idnr FROM dbmail_messages m JOIN dbmail_physmessage p ON m.physmessage_id=p.id JOIN dbmail_headervalue v ON v.physmessage_id=p.id JOIN dbmail_headername n ON v.headername_id=n.id WHERE mailbox_idnr = 6 AND status IN (0,1) AND headername LIKE 'subject' AND headervalue LIKE '%alarm%' ORDER BY message_idnr] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,_do_search(+1384): [135768960] depth [3] type [5] rows [0] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,_do_search(+1384): [135760432] depth [2] type [15] rows [0] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,_merge_search(+1409): [135756168] depth [1] type [2] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[misc] misc.c,g_tree_merge(+1206): a[11] [AND] b[11] -> a[11] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,_merge_search(+1409): [135760432] depth [2] type [15] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[misc] misc.c,g_tree_merge(+1206): a[3] [OR] b[0] -> a[3] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[misc] misc.c,g_tree_merge(+1206): a[11] [AND] b[3] -> a[3] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,_merge_search(+1409): [135764696] depth [3] type [5] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[misc] misc.c,g_tree_merge(+1206): a[3] [AND] b[3] -> a[3] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,_merge_search(+1409): [135768960] depth [3] type [5] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[misc] misc.c,g_tree_merge(+1206): a[3] [AND] b[0] -> a[0] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,dbmail_mailbox_search(+1477): found [0] ids Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[mailbox] dbmail-mailbox.c,dbmail_mailbox_ids_as_string(+442): no ids found Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[imapsession] dbmail-imapsession.c,dbmail_imap_session_printf(+1299): RESPONSE: [* SEARCH ^M ] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Debug:[imapsession] dbmail-imapsession.c,dbmail_imap_session_printf(+1299): RESPONSE: [A0008 OK SEARCH completed^M ] Dec 5 20:32:32 ubuntu dbmail/imap4d[22969]: Info:[imap] imap4.c,IMAPClientHandler(+341): Finished command search [0] ====================================================================== ---------------------------------------------------------------------- paul - 11-Dec-06 10:31 ---------------------------------------------------------------------- Lars, please test rev. 2393 ---------------------------------------------------------------------- lkneschke - 11-Dec-06 11:23 ---------------------------------------------------------------------- It is working now. ---------------------------------------------------------------------- paul - 16-Dec-06 19:55 ---------------------------------------------------------------------- closing then. Issue History Date Modified Username Field Change ====================================================================== 10-Dec-06 22:56 lkneschke New Issue 11-Dec-06 10:09 paul Status new => assigned 11-Dec-06 10:09 paul Assigned To => paul 11-Dec-06 10:31 paul Note Added: 0001668 11-Dec-06 11:23 lkneschke Note Added: 0001669 16-Dec-06 19:55 paul Status assigned => resolved 16-Dec-06 19:55 paul Fixed in Version => 2.2.2 16-Dec-06 19:55 paul Resolution open => fixed 16-Dec-06 19:55 paul Note Added: 0001693 ====================================================================== _______________________________________________ Dbmail-dev mailing list Dbmail-dev@dbmail.org http://twister.fastxs.net/mailman/listinfo/dbmail-dev