[ic] [query] causes [more] to generate non-unique mv_cache_key

Sandy Thomson sandy at scotwebshops.com
Mon Nov 15 07:13:55 EST 2004

On Tue, 2004-10-26 at 18:59 -0700, Daniel Browning wrote:
> This bug has subtle but important effects for anyone using [query] & [more].

Thanks for this, I have noticed this niggling problem for a while here
and wasn't sure how to solve it.

> - $obj->{mv_cache_key} = generate_key(substr($page,0,100));
> + $obj->{mv_cache_key} = generate_key(substr($opt->{query} || $page,0,100));

This is ok in most cases, but I have some very large queries, sometimes
with the uniqueness towards the end of the query (and was getting the
same problem again). So I changed the above line to:

$obj->{mv_cache_key} = generate_key($opt->{query});

I understand why the values are truncated but when you have queries with
large numbers of sub-selects the above might be better. I certainly
haven't had any problems with it since the change.

Sandy Thomson <sandy at scotwebshops.com>

More information about the interchange-users mailing list