[
https://issues.apache.org/jira/browse/SOLR-16009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17500274#comment-17500274
]
ASF subversion and git services commented on SOLR-16009:
--------------------------------------------------------
Commit b7424bd1b33848b6732dd194607644f6baf1c90b in solr's branch
refs/heads/main from Timothy Potter
[ https://gitbox.apache.org/repos/asf?p=solr.git;h=b7424bd ]
SOLR-16009: Disable Calcite simplify config setting (#715)
Co-authored-by: Kiran Chitturi
> 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
> Time Spent: 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: issues-unsubscr...@solr.apache.org
For additional commands, e-mail: issues-h...@solr.apache.org
