[
https://issues.apache.org/jira/browse/SOLR-16250?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Kiran updated SOLR-16250:
-------------------------
Description:
Solr SQL currently translates the following like term to
{code:java}
stringfield LIKE 'task% failed' {code}
to
{code:java}
stringfield:(task* failed){code}
which does not return any results
Instead, it should be translated to
{code:java}
stringfield:(task*\ failed){code}
Solr SQL should distinguish the translation for string and text fields when
multiple terms are present in LIKE
was:
Solr SQL currently translates the following like term to
{code:java}
stringfield LIKE 'task* failed' {code}
to
{code:java}
stringfield:(task* failed){code}
which does not return any results
Instead, it should be translated to
{code:java}
stringfield:(task*\ failed){code}
Solr SQL should distinguish the translation for string and text fields when
multiple terms are present in LIKE
> Solr SQL returns no results for multiple terms in LIKE operator on string
> fields
> --------------------------------------------------------------------------------
>
> Key: SOLR-16250
> URL: https://issues.apache.org/jira/browse/SOLR-16250
> Project: Solr
> Issue Type: Bug
> Security Level: Public(Default Security Level. Issues are Public)
> Components: Parallel SQL
> Affects Versions: 9.0, 8.11.1
> Reporter: Kiran
> Priority: Minor
>
> Solr SQL currently translates the following like term to
> {code:java}
> stringfield LIKE 'task% failed' {code}
> to
>
>
> {code:java}
> stringfield:(task* failed){code}
> which does not return any results
>
> Instead, it should be translated to
> {code:java}
> stringfield:(task*\ failed){code}
> Solr SQL should distinguish the translation for string and text fields when
> multiple terms are present in LIKE
--
This message was sent by Atlassian Jira
(v8.20.7#820007)
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
