[ 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-unsubscr...@lucene.apache.org For additional commands, e-mail: dev-h...@lucene.apache.org