[jira] [Created] (TAJO-958) LIKE, REGEXP, and SIMILAR TO should support escape character.

["Hyunsik Choi (JIRA)" <ji...@apache.org>]

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)