[
https://issues.apache.org/jira/browse/CALCITE-1918?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
sunjincheng updated CALCITE-1918:
---------------------------------
Description:
Currently Regular Expression Operators (RLIKE) are not supported. e.g.:
{code}
select * from emps name rlike '^(K|G|W)'
{code}
we'll get Error:
{code}
Error: Error while executing SQL "select * from emps name rlike '^(K|G|W)'":
parse failed: Encountered "rlike" at line 1, column 25.
{code}
So, in this JIRA. I want add RLIKE supported.
Reference:
MySql: https://dev.mysql.com/doc/refman/5.7/en/regexp.html#operator_regexp
was:
Currently Regular Expression Operators (RLIKE) are not supported. e.g.:
{code}
select * from emps name rlike '^(K|G|W)'
{code}
we'll get Error:
{code}
Error: Error while executing SQL "select * from emps name rlike '^(K|G|W)'":
parse failed: Encountered "rlike" at line 1, column 25.
{code}
So, in this JIRA. I want add RLIKE supported.
> Add support for Regular Expression Operators (RLIKE)
> -----------------------------------------------------
>
> Key: CALCITE-1918
> URL: https://issues.apache.org/jira/browse/CALCITE-1918
> Project: Calcite
> Issue Type: Bug
> Components: core
> Reporter: sunjincheng
> Assignee: sunjincheng
>
> Currently Regular Expression Operators (RLIKE) are not supported. e.g.:
> {code}
> select * from emps name rlike '^(K|G|W)'
> {code}
> we'll get Error:
> {code}
> Error: Error while executing SQL "select * from emps name rlike '^(K|G|W)'":
> parse failed: Encountered "rlike" at line 1, column 25.
> {code}
> So, in this JIRA. I want add RLIKE supported.
> Reference:
> MySql: https://dev.mysql.com/doc/refman/5.7/en/regexp.html#operator_regexp
--
This message was sent by Atlassian JIRA
(v6.4.14#64029)
