Hi again :)
I would like to propose a fix to problem with search-date test.
In dbmail-mailbox.c function mailbox_search() there is date buf which is
defined as char dateold[SQL_INTERNALDATE_LEN]; where SQL_INTERNALDATE_LEN == 32.
The problem is that it is not date itself that is stored in "date" buf, rather
it is an sql statement, which becomes truncated as follows:
Debug:[mailbox] mailbox_search(+1211): date: TO_DATE('2007-03-24 00:00:00':
A quick fix would be to change the length of this buffer to something like 256,
then the output will be:
Debug:[mailbox] mailbox_search(+1211): date: TO_DATE('2007-03-24
00:00:00'::text,'YYYY-MM-DD')
and all search-date test will pass successfully.
I hope this helps.
_______________________________________________
Dbmail-dev mailing list
Dbmail-dev@dbmail.org
http://mailman.fastxs.nl/cgi-bin/mailman/listinfo/dbmail-dev
