[
https://issues.apache.org/jira/browse/SOLR-16009?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Timothy Potter resolved SOLR-16009.
-----------------------------------
Fix Version/s: 9.0
8.11.2
Resolution: Fixed
> 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
> Assignee: Timothy Potter
> Priority: Major
> Fix For: 9.0, 8.11.2
>
> Time Spent: 1h 40m
> Remaining Estimate: 0h
>
> 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: [email protected]
For additional commands, e-mail: [email protected]
