Issue with Join

[William 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://hgsolr2sl1: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://hgsolr2sl1: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.

{

   - responseHeader:
   {
      - status: 0,
      - QTime: 178,
      - params:
      {
         - q: "*:*",
         - fl: "practicing_specialties_codes",
         - fq: "NOT {!join from=prac_spec_code
         to=practicing_specialties_codes fromIndex=autosuggest}*:*",
         - rows: "10",
         - wt: "json",
         - debugQuery: "true"
         }
      },
   - response:
   {
      - numFound: 0,
      - start: 0,
      - docs: [ ]
      },
   - debug:
   {
      - rawquerystring: "*:*",
      - querystring: "*:*",
      - parsedquery: "MatchAllDocsQuery(*:*)",
      - parsedquery_toString: "*:*",
      - explain: { },
      - QParser: "LuceneQParser",
      - filter_queries:
      [
         - "NOT {!join from=prac_spec_code to=practicing_specialties_codes
         fromIndex=autosuggest}*:*"
         ],
      - parsed_filter_queries:
      [
         - "-JoinQuery({!join from=prac_spec_code
         to=practicing_specialties_codes fromIndex=autosuggest}*:*)"
         ],
      - timing:
      {
         - time: 177,
         - prepare:
         {
            - time: 0,
            - query:
            {
               - time: 0
               },
            - facet:
            {
               - time: 0
               },
            - facet_module:
            {
               - time: 0
               },
            - mlt:
            {
               - time: 0
               },
            - highlight:
            {
               - time: 0
               },
            - stats:
            {
               - time: 0
               },
            - expand:
            {
               - time: 0
               },
            - debug:
            {
               - time: 0
               }
            },
         - process:
         {
            - time: 177,
            - query:
            {
               - time: 177
               },
            - facet:
            {
               - time: 0
               },
            - facet_module:
            {
               - time: 0
               },
            - mlt:
            {
               - time: 0
               },
            - highlight:
            {
               - time: 0
               },
            - stats:
            {
               - time: 0
               },
            - expand:
            {
               - time: 0
               },
            - debug:
            {
               - time: 0
               }
            }
         }
      }

}




-- 
Bill Bell
billnb...@gmail.com
cell 720-256-8076