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)

Reply via email to