[jira] [Created] (SOLR-11788) conjunction of filterQueries not working properly

["Patrick Klampfl (JIRA)" <ji...@apache.org>]

Patrick Klampfl created SOLR-11788:
--------------------------------------

             Summary: 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)
    Affects Versions: 6.4.1
            Reporter: Patrick Klampfl


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 message was sent by Atlassian JIRA
(v6.4.14#64029)

---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@lucene.apache.org
For additional commands, e-mail: dev-help@lucene.apache.org