[jira] [Comment Edited] (SOLR-15463) Solr SQL predicate with wildcard doesn't match, needs the complex phrase query parser

[Aroop (Jira)]

    [ 
https://issues.apache.org/jira/browse/SOLR-15463?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17359549#comment-17359549
 ] 

Aroop edited comment on SOLR-15463 at 6/8/21, 8:08 PM:
-------------------------------------------------------

while we are at it, we should support the the SQL wildcard of % instead or in 
addition of * as well (or we can have a new Jira for it)


was (Author: aroopganguly):
while we are at it, we should support the the SQL wildcard of % instead or in 
addition of * as well 

> Solr SQL predicate with wildcard doesn't match, needs the complex phrase 
> query parser
> -------------------------------------------------------------------------------------
>
>                 Key: SOLR-15463
>                 URL: https://issues.apache.org/jira/browse/SOLR-15463
>             Project: Solr
>          Issue Type: Bug
>      Security Level: Public(Default Security Level. Issues are Public) 
>          Components: Parallel SQL
>            Reporter: Timothy Potter
>            Assignee: Timothy Potter
>            Priority: Major
>              Labels: RobustSQL
>
> I have a query:
> {code}
> SELECT a_s, count(*) as cnt FROM $ALIAS WHERE a_s='hello*' GROUP BY a_s ORDER 
> BY count(*) desc LIMIT 10
> {code}
> This fails to match documents that should match. The problem is the query 
> that gets generated is {{q=a_s:"hello*"}}. 
> Query should get generated like:
> {code}
> {!complexphrase}a_s:"hello*"
> {code}
> which matches ...



--
This message was sent by Atlassian Jira
(v8.3.4#803005)

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