Re: [AMaViS-user] MySQL changes in amavisd-new from 2.2.0 to 2.3.3

Dale,

> In 2.3.3 the changes are different as shown from the original 2.2.0
> 'SELECT wb FROM wblist,mailaddr ... WHERE (wblist.sid=3Dmailaddr.id)
> 'SELECT wb FROM wblist LEFT JOIN mailaddr ON wblist.sid=3Dmailaddr.id

The change from WHERE to LEFT JOIN ON is mostly cosmetic,
it should work one way or another. SQL clause from 2.2.0
should be able to work just fine in 2.3.3.

=46rom 2.3.0 release notes:
=2D change the default $sql_select_policy and $sql_select_white_black_list =
to
use the LEFT JOIN ... ON instead of WHERE for the 'join' relation; should
be functionally equivalent, but makes the join operation explicit;

Mark


-------------------------------------------------------
This SF.net email is sponsored by: Splunk Inc. Do you grep through log files
for problems? Stop! Download the new AJAX search engine that makes
searching your log files as easy as surfing the web. DOWNLOAD SPLUNK!
http://sel.as-us.falkag.net/sel?cmd=...486&dat=121642
_______________________________________________
AMaViS-user mailing list
AMaViS-user@lists.sourceforge.net
https://lists.sourceforge.net/lists/...fo/amavis-user
AMaViS-FAQ:http://www.amavis.org/amavis-faq.php3
AMaViS-HowTos:http://www.amavis.org/howto/