Join Query Behavior

[Andy Pickler <an...@gmail.com>]

We're attempting to upgrade from Solr 4.2 to 4.5 but are finding that 4.5
is not "honoring" this join query:

<first part of query>...
&
fq={!join from=project_id_i to=project_id_im}user_id_i:65615 -role_id_i:18
type:UserRole
&
<last part of query>

On our Solr 4.2 instance adding/removing that query gives us different (and
expected) results, while the query doesn't affect the results at all in
4.5.  Is there any known join query behavior differences/fixes between 4.2
and 4.5 that might explain this, or should I be looking at other factors?

Thanks,
Andy Pickler

Re: Join Query Behavior

[Andy Pickler <an...@gmail.com>]

If it helps to clarify any, here's the full query:

/select
?
q=*:*
&
fq=type:ProjectGroup
&
fq={!join from=project_id_i to=project_id_im}user_id_i:65615 -role_id_i:18
type:UserRole

We have two Solr servers that were indexed from the same database.  One of
the servers is running Solr 4.2, while the other (test server) is running
4.5.

Solr 4.2:
<result name="response" numFound="64" start="0">

Solr 4.5.1:
<result name="response" numFound="2642" start="0">

Solr 4.2 returns the expected result with the project IDs "filtered" out
from the join query, while the 4.5 query shows *all* results (2642
records).  I can leave off the join query in 4.5 and get the same results,
which tells me obviously it is having no effect.

Is there a change to the join query behavior between these releases, or
could I have configured something differently in my 4.5.1 install?

Thanks,
Andy Pickler

On Thu, Oct 24, 2013 at 2:42 PM, Andy Pickler <an...@gmail.com>wrote:

> We're attempting to upgrade from Solr 4.2 to 4.5 but are finding that 4.5
> is not "honoring" this join query:
>
> <first part of query>...
> &
> fq={!join from=project_id_i to=project_id_im}user_id_i:65615 -role_id_i:18
> type:UserRole
> &
> <last part of query>
>
> On our Solr 4.2 instance adding/removing that query gives us different
> (and expected) results, while the query doesn't affect the results at all
> in 4.5.  Is there any known join query behavior differences/fixes between
> 4.2 and 4.5 that might explain this, or should I be looking at other
> factors?
>
> Thanks,
> Andy Pickler
>
>