[SOLR-16227] Solr SQL query parsing fails on multiple LIKE clauses and multiple terms

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 9.0, 8.11.1
• Fix Version/s: 8.11.2, 9.1
• Component/s: Parallel SQL
• Assignee: David Smiley
• Reporter: Kiran
• Created: 01/Jun/22 16:50
• Updated: 22/Jun/22 17:36
• Resolved: 09/Jun/22 19:48

Description

 

select count(*) as QUERY_COUNT from test_index WHERE (name LIKE 'Sample Temp*') AND (deploy_id LIKE 'aws*') HAVING count(*) >= 0

 

Above query fails with error 

    "msg":"org.apache.solr.search.SyntaxError: org.apache.lucene.queryparser.classic.ParseException: Cannot parse 'name:\"Sample': Lexical error at line 1, column 13.  Encountered: <EOF> after : \"\\\"Sample\"",

 

The bug is in SolrFilter which translates the query as 

({!complexphrase}name:"Sample Temp*" AND deploy_id:aws*)

which fails because of local params parsing I think

If Solr SQL rewrites the query as

({!complexphrase v="name:\"Sample Temp*\"" AND deploy_id:aws*) 

 

it works

 

Issue Links

• links to: GitHub Pull Request #887