[jira] [Created] (SOLR-8478) {!join} does not work when outside is multiValue

["Bill Bell (JIRA)" <ji...@apache.org>]

Bill Bell created SOLR-8478:
-------------------------------

             Summary: {!join} does not work when outside is multiValue
                 Key: SOLR-8478
                 URL: https://issues.apache.org/jira/browse/SOLR-8478
             Project: Solr
          Issue Type: Bug
    Affects Versions: 5.3.1
            Reporter: Bill Bell


I have having issues with {!join}. If the core have multiValued field and the inner join does not have a multiValued field it does not find the ones... 

Solr 5.3.1... <luceneMatchVersion>5.3.1</luceneMatchVersion>

Example.

PS1226 is in practicing_specialties_codes in providersearch core. This field is multiValued.

in the autosuggest core there is NOT a field for PS1226 in there. This field is called prac_spec_code and is single values.


http://localhost:8983/solr/providersearch/select?q=*%3A*&wt=json&indent=true&fq=practicing_specialties_codes:PS1226&fl=practicing_specialties_codes

I get:

{{{
docs: 
[
{
practicing_specialties_codes: 
[
"PS1010",
"PS282",
"PS1226"
]
}
]
}}}

In autosuggest there is nothing:

http://localhost:8983/solr/autosuggest/select?q=*%3A*&wt=json&indent=true&fq=prac_spec_code:PS1226&fl=prac_spec_code

Nothing.

Then a join should find what is in providersearch but missing in autosuggest.

{{{
http://localhost:8983/solr/providersearch/select?debugQuery=true&wt=json&q=*:*&rows=10&fq=practicing_specialties_codes:PS1226&fl=practicing_specialties_codes&fq=NOT%20{!join%20from=prac_spec_code%20to=practicing_specialties_codes%20fromIndex=autosuggest}auto_type:PRACSPEC
}}}

or

{{{
http://localhost:8983/solr/providersearch/select?debugQuery=true&wt=json&q=*:*&rows=10&fl=practicing_specialties_codes&fq=NOT%20{!join%20from=prac_spec_code%20to=practicing_specialties_codes%20fromIndex=autosuggest}auto_type:PRACSPEC
}}}

or

{{{
http://localhost:8983/solr/providersearch/select?debugQuery=true&wt=json&q=*:*&rows=10&fl=practicing_specialties_codes&fq=NOT%20{!join%20from=prac_spec_code%20to=practicing_specialties_codes%20fromIndex=autosuggest}*:*
}}}

I also tried *:* AND NOT {!join}

I get 0 results. This seems to be a bug when using MultiValued fields with join.





--
This message was sent by Atlassian JIRA
(v6.3.4#6332)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org