[
https://issues.apache.org/jira/browse/SOLR-11788?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Cassandra Targett resolved SOLR-11788.
--------------------------------------
Resolution: Incomplete
Reporter is suggested to use the Solr-User mailing list first and only file an
issue if a bug has been determined. Information on our mailing lists is at
https://lucene.apache.org/solr/community.html#mailing-lists-irc.
> conjunction of filterQueries not working properly
> -------------------------------------------------
>
> Key: SOLR-11788
> URL: https://issues.apache.org/jira/browse/SOLR-11788
> Project: Solr
> Issue Type: Bug
> Security Level: Public(Default Security Level. Issues are Public)
> Components: search
> Affects Versions: 6.4.1
> Reporter: Patrick Klampfl
> Priority: Major
>
> those two filter queries work fine individually and lead to the same result:
> 1. all brands of products with application 50
> http://localhost:8983/solr/master_wac_WacBrandClassificationClass_flop/select?q=*:*&fq={!join%20from=brands_string_mv%20to=code_string%20fromIndex=master_wac_Product_flop}applications_string_mv:50
> 2. all brands of products with category 100
> http://localhost:8983/solr/master_wac_WacBrandClassificationClass_flop/select?q=*:*&fq={!join%20from=brands_string_mv%20to=code_string%20fromIndex=master_wac_Product_flop}category_string_mv:100
> although 1 and 2 have the exact same result set, the conjunction of both does
> not work
> 3. combination:
> http://localhost:8983/solr/master_wac_WacBrandClassificationClass_flop/select?q=*:*&fq={!join%20from=brands_string_mv%20to=code_string%20fromIndex=master_wac_Product_flop}applications_string_mv:50,{!join%20from=brands_string_mv%20to=code_string%20fromIndex=master_wac_Product_flop}category_string_mv:100
> Result for 1:
> {code:java}
> <?xml version="1.0" encoding="UTF-8"?>
> <response>
> <lst name="responseHeader"><int name="status">0</int><int
> name="QTime">0</int><lst name="params"><str name="q">*:*</str><str
> name="fq">{!join from=brands_string_mv to=code_string
> fromIndex=master_wac_Product_flop}applications_string_mv:50</str></lst></lst><result
> name="response" numFound="1" start="0"><doc><long
> name="indexOperationId">99207272441184304</long><str
> name="id">wackerMarketingClassificationCatalog/Default/36</str><long
> name="pk">8796094169230</long><str
> name="catalogId">wackerMarketingClassificationCatalog</str><str
> name="catalogVersion">Default</str><str
> name="itemtype_string">WacBrandClassificationClass</str><str
> name="code_string">36</str><arr name="autosuggest_fr"><str>ELASTOSIL ®
> WT</str></arr><str name="name_sortable_fr_sortabletext">ELASTOSIL ®
> WT</str><str name="name_text_fr">ELASTOSIL ® WT</str><arr
> name="spellcheck_fr"><str>ELASTOSIL ® WT</str></arr><str
> name="name_text_en">ELASTOSIL ® WT</str><str
> name="name_sortable_en_sortabletext">ELASTOSIL ® WT</str><arr
> name="autosuggest_en"><str>ELASTOSIL ® WT</str></arr><arr
> name="spellcheck_en"><str>ELASTOSIL ® WT</str></arr><str
> name="name_text_de">ELASTOSIL ® WT</str><str
> name="name_sortable_de_sortabletext">ELASTOSIL ® WT</str><arr
> name="autosuggest_de"><str>ELASTOSIL ® WT</str></arr><arr
> name="spellcheck_de"><str>ELASTOSIL ® WT</str></arr><str
> name="indexedType_string">WacBrandClassificationClass</str><long
> name="_version_">1587316359348355073</long></doc></result>
> </response>
> {code}
> Result for 2:
> {code:java}
> <?xml version="1.0" encoding="UTF-8"?>
> <response>
> <lst name="responseHeader"><int name="status">0</int><int
> name="QTime">0</int><lst name="params"><str name="q">*:*</str><str
> name="fq">{!join from=brands_string_mv to=code_string
> fromIndex=master_wac_Product_flop}category_string_mv:100</str></lst></lst><result
> name="response" numFound="1" start="0"><doc><long
> name="indexOperationId">99207272441184304</long><str
> name="id">wackerMarketingClassificationCatalog/Default/36</str><long
> name="pk">8796094169230</long><str
> name="catalogId">wackerMarketingClassificationCatalog</str><str
> name="catalogVersion">Default</str><str
> name="itemtype_string">WacBrandClassificationClass</str><str
> name="code_string">36</str><arr name="autosuggest_fr"><str>ELASTOSIL ®
> WT</str></arr><str name="name_sortable_fr_sortabletext">ELASTOSIL ®
> WT</str><str name="name_text_fr">ELASTOSIL ® WT</str><arr
> name="spellcheck_fr"><str>ELASTOSIL ® WT</str></arr><str
> name="name_text_en">ELASTOSIL ® WT</str><str
> name="name_sortable_en_sortabletext">ELASTOSIL ® WT</str><arr
> name="autosuggest_en"><str>ELASTOSIL ® WT</str></arr><arr
> name="spellcheck_en"><str>ELASTOSIL ® WT</str></arr><str
> name="name_text_de">ELASTOSIL ® WT</str><str
> name="name_sortable_de_sortabletext">ELASTOSIL ® WT</str><arr
> name="autosuggest_de"><str>ELASTOSIL ® WT</str></arr><arr
> name="spellcheck_de"><str>ELASTOSIL ® WT</str></arr><str
> name="indexedType_string">WacBrandClassificationClass</str><long
> name="_version_">1587316359348355073</long></doc></result>
> </response>
> {code}
> Result for 3 (combination of fq 1 and 2):
> {code:java}
> <?xml version="1.0" encoding="UTF-8"?>
> <response>
> <lst name="responseHeader"><int name="status">0</int><int
> name="QTime">0</int><lst name="params"><str name="q">*:*</str><str
> name="fq">{!join from=brands_string_mv to=code_string
> fromIndex=master_wac_Product_flop}applications_string_mv:50,{!join
> from=brands_string_mv to=code_string
> fromIndex=master_wac_Product_flop}category_string_mv:100</str></lst></lst><result
> name="response" numFound="0" start="0"></result>
> </response>
> {code}
> this filterquery however works (and leads to the same result as 1 and 2):
> http://localhost:8983/solr/master_wac_WacBrandClassificationClass_flop/select?q=*:*&fq={!join%20from=brands_string_mv%20to=code_string%20fromIndex=master_wac_Product_flop}category_string_mv:100
> AND applications_string_mv:50
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscr...@lucene.apache.org
For additional commands, e-mail: dev-h...@lucene.apache.org
