[ASTERIXDB-2633] Error matching patterns that follow the LIKE syntax

• Type: Bug
• Status: Resolved
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 0.9.4.1
• Fix Version/s: 0.9.6
• Component/s: FUN - Functions
• Assignee: Till Westmann
• Reporter: Till Westmann
• Created: 12/Sep/19 03:39
• Updated: 14/Sep/19 04:16
• Resolved: 14/Sep/19 04:16

Description

'+0300' like "+03%"

fails with

ASX1001: Syntax error: In line 1 >>'+0300' like "+03%"<< Encountered  at column 19.  [CompilationException]

and

'?0300' like "?03%"

fails with

ASX1001: Syntax error: In line 1 >>'?0300' like "?03%"<< Encountered  at column 19.  [CompilationException]

as the characters '+' and '?' are not escaped when translating the LIKE syntax to Java's regex syntax.