feat: support like operator
Summarize the changes
- feat: support like operator
- Support like operator with signature:
expr1 LIKE expr2 [ESCAPE expr3]
which returns TRUE only if expr1 matches the string specified by expr2 (pattern). '_' in pattern matches any single character, '%' matches any character 0 or more times. All other characters match itself according to case.
- Optional escape clause specifies character to use for escaping '_' and '%'
Ensure that
-
New code is covered by unit and integration tests. -
Related issues would be automatically closed with gitlab's closing pattern ( Closes #1, #2). -
Public modules are documented (check the rendered version with cargo doc --open). -
(if PEST grammar is changed) EBNF grammar reflects these changes (check the result with railroad diagram generator.
Next steps
- Cherry-pick to: none / 24.2 / 24.3
- Update sbroad submodule in picodata/picodata.
- (if EBNF grammar is changed) create a follow-up issue in picodata/docs — document like operator (docs#347 - closed)
Edited by Artur Sabirov