Anton Nekhoroshikh wrote:
Добрый день Paul,
Tuesday, October 19, 2004, 1:21:30 PM, you wrote:
Paul J Stevens> Anton Nekhoroshikh wrote:
Paul J Stevens> Oct 18 16:58:20 com0
Paul J Stevens> dbmail/smtp[19957]: dboracle.c,db_query: [SELECT
Paul J Stevens> deliver_to
Paul J Stevens> FROM dbmail_aliases
Paul J Stevens> WHERE lower(alias) = lower('[EMAIL PROTECTED]')]
Paul J Stevens> Oct 18 16:58:20 com0
Paul J Stevens> dbmail/smtp[19957]: dboracle.c,db_num_rows: cannot
Paul J Stevens> fetch result
Paul J Stevens> this query shouldn't fail.
SELECT deliver_to FROM dbmail_aliases WHERE lower(alias) = lower('[EMAIL
PROTECTED]')
[EMAIL PROTECTED] alias to [EMAIL PROTECTED]
Paul J Stevens> ergo, a bug in the oracle driver.
Nonsense full;) the everything else works truly!!!
The old version works truly!!!
SELECT deliver_to
FROM dbmail_aliases
WHERE lower(alias) = lower('[EMAIL PROTECTED]')
Cannot return anything as in base is alias for [EMAIL PROTECTED], instead
of for [EMAIL PROTECTED] !
Well, if you have,
ALIAS | DELIVER_TO
----------------------------------------------------
[EMAIL PROTECTED] | [EMAIL PROTECTED]
than to what deliver_to points [EMAIL PROTECTED] ???
As I understand the delivery chain, the alias [EMAIL PROTECTED] *should* exist in
the aliases table if that address should be delivered locally.
--
________________________________________________________________
Paul Stevens [EMAIL PROTECTED]
NET FACILITIES GROUP GPG/PGP: 1024D/11F8CD31
The Netherlands_______________________________________www.nfg.nl
