[SOLR-16250] Solr SQL returns no results for multiple terms in LIKE operator on string fields

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Affects Version/s: 9.0, 8.11.1
• Component/s: Parallel SQL
• Assignee: Unassigned
• Reporter: Kiran
• Created: 14/Jun/22 18:01
• Updated: 22/Jun/22 17:36

Description

Solr SQL currently does not any results for below query

stringfield LIKE 'task% failed' 

 

Instead, it should be translated to and not use complex phrase parser

stringfield:(task*\ failed)

Solr SQL should distinguish the translation for string and text fields when multiple terms are present in LIKE

 

Also, Solr SQL translates this to a complex

Issue Links

• links to: GitHub Pull Request #905