[CALCITE-1918] Add support for Regular Expression Operators (RLIKE)

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Won't Fix
• Component/s: core
• Assignee: sunjincheng
• Reporter: sunjincheng
• Created: 02/Aug/17 03:03
• Updated: 11/Feb/21 00:46
• Resolved: 11/Aug/17 07:46

Description

Currently Regular Expression Operators (RLIKE) are not supported. e.g.:

select * from emps name rlike '^(K|G|W)' 

we'll get Error:

Error: Error while executing SQL "select * from emps name rlike '^(K|G|W)'": parse failed: Encountered "rlike" at line 1, column 25.

So, in this JIRA. I want add RLIKE supported.

Reference:
MySql: https://dev.mysql.com/doc/refman/5.7/en/regexp.html#operator_regexp

Issue Links

• duplicates: CALCITE-3574 Add RLIKE operator (similar to LIKE, but Hive- and Spark-specific)