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:17:49 UTC
[jira] [Updated] (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:all-tabpanel ]
Bill Bell updated SOLR-8478:
----------------------------
Description:
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.
was:
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.
> {!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