LuKreme:
> virtual_alias_maps = 
>     hash:$config_directory/virtual
>     pcre:$config_directory/virtual.pcre,
>     pcre:$config_directory/virtual_sql.pcre,
>     proxy:mysql:$config_directory/mysql_virtual_alias_maps.cf
> 
> I want to be sure that the ORDER of declarations in virtual_alias_maps
> is significant. For example, if something matches in virtual it
> will always match and not be overridden by a match in virtual.pcre.

Quote from virtual(5):

    "Specify zero or more "type:name" lookup tables, separated by
    whitespace of comma. Tables will be searched in the specified
    order until a  match is found.  Note: these lookups are recursive."

Thus, with "virtual_alias_maps = A, B, C", a match in B terminates
the search, meaning that B has precedence over C.

However, lookup is recursive. The above result from B will be used
for a subsequent query. That may still query A and B and C, finding
a result in C.

        Wietse

Reply via email to