[
https://issues.apache.org/jira/browse/SOLR-16009?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17500455#comment-17500455
]
ASF subversion and git services commented on SOLR-16009:
--------------------------------------------------------
Commit 07816fcbb93bbb276787b403a2f3b1fb86a6a67b in lucene-solr's branch
refs/heads/branch_8_11 from Kiran Chitturi
[ https://gitbox.apache.org/repos/asf?p=lucene-solr.git;h=07816fc ]
SOLR-16009: Disable Calcite simplify config setting
Co-authored-by: kiran chitturi <kchitt...@apple.com>
> 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: issues-unsubscr...@solr.apache.org
For additional commands, e-mail: issues-h...@solr.apache.org
