[jira] [Created] (SOLR-16009) Solr SQL does not return documents for 'AND' operation on multi-valued field

["Kiran (Jira)" <ji...@apache.org>]

Kiran created SOLR-16009:
----------------------------

             Summary: Solr SQL does not return documents for 'AND' operation on multi-valued field
                 Key: SOLR-16009
                 URL: https://issues.apache.org/jira/browse/SOLR-16009
             Project: Solr
          Issue Type: Bug
      Security Level: Public (Default Security Level. Issues are Public)
          Components: Parallel SQL
    Affects Versions: 8.11.1
            Reporter: Kiran


SolrSQL fails if `AND` operation is performed on multi-valued field in Solr

Data

 
{code:java}
[{
        "name_s":"Foo",
        "cities_ss":["SFO",
          "NYC"],
        "userid_i":1,
        "id":"1"},
      {
        "name_s":"Bar",
        "cities_ss":["SEA",
          "LA"],
        "userid_i":2,
        "id":"2"}] {code}
Sql query

 
{code:java}
select name_s, cities_ss FROM sql_test WHERE cities_ss IN ('SFO') AND cities_ss IN ('NYC') {code}
The above query returns no documents even though a match exists in Solr

Similar query (below) returns no documents
{code:java}
select name_s, cities_ss FROM sql_test WHERE cities_ss='SFO' and cities_ss='NYC' {code}
Multi-valued support in SQL is messy but it would be good to get support for this as filtering on multi-valued fields are quite common in Solr

This is probably a bug in Calcite giving precedence to some default rules

 

 



--
This message was sent by Atlassian Jira
(v8.20.1#820001)

---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscribe@solr.apache.org
For additional commands, e-mail: issues-help@solr.apache.org