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-unsubscr...@solr.apache.org
For additional commands, e-mail: issues-h...@solr.apache.org
