[SOLR-15460] Solr SQL doesn't support LIKE operator

• Type: Improvement
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Fix Version/s: 9.0, 8.10
• Component/s: Parallel SQL
• Labels: RobustSQL
• Assignee: Timothy Potter
• Reporter: Timothy Potter
• Created: 08/Jun/21 14:52
• Updated: 28/Sep/21 20:22
• Resolved: 16/Jun/21 19:55

Description

Using the LIKE operator returns results that don't match the expected criteria, i.e. the operator is just ignored, resulting in the wrong results. Solr can do fuzzy matching so seems like we can support the LIKE operator but I need to dig into the code a bit to see why it's not currently supported.

Issue Links

• fixes: SOLR-15459 Solr SQL doesn't support IS NULL / IS NOT NULL operators
• fixes: SOLR-15463 Solr SQL predicate with wildcard doesn't match, needs the complex phrase query parser
• links to: GitHub Pull Request #173
• links to: GitHub Pull Request #2522