You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@lucene.apache.org by "Bill Bell (JIRA)" <ji...@apache.org> on 2015/12/31 05:21:49 UTC

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

    [ https://issues.apache.org/jira/browse/SOLR-8478?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15075703#comment-15075703 ] 

Bill Bell edited comment on SOLR-8478 at 12/31/15 4:21 AM:
-----------------------------------------------------------

providersearch core:
<field name="practicing_specialties_codes" type="string" indexed="true" stored="true" multiValued="true" omitNorms="true" omitTermFreqAndPositions="true" />

and

autosuggest core:
<field name="prac_spec_code" type="string" indexed="true" stored="true" />


was (Author: billnbell):
<field name="practicing_specialties_codes" type="string" indexed="true" stored="true" multiValued="true" omitNorms="true" omitTermFreqAndPositions="true" />

and

<field name="prac_spec_code" type="string" indexed="true" stored="true" />

> {!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