Hyunsik Choi created TAJO-958:
---------------------------------
Summary: LIKE, REGEXP, and SIMILAR TO should support escape
character.
Key: TAJO-958
URL: https://issues.apache.org/jira/browse/TAJO-958
Project: Tajo
Issue Type: Bug
Components: parser, planner/optimizer
Reporter: Hyunsik Choi
Fix For: 0.9.0
LIKE, REGEXP, and SIMILAR TO predicates use special characters to present
pattern matching. But, in some cases, we want to use the special characters as
just characters. For it, we need some escape feature for them.
In SQL standards, ESCAPE is supported as the following syntax.
http://savage.net.au/SQL/sql-2003-2.bnf.html#character%20like%20predicate%20part%202
{noformat}
expression LIKE pattern [ ESCAPE 'escape_character' ]
{noformat}
We need to support it.
--
This message was sent by Atlassian JIRA
(v6.2#6252)