Uploaded image for project: 'Tajo'
  1. Tajo
  2. TAJO-958

LIKE, REGEXP, and SIMILAR TO should support escape character.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Labels:
      None

      Description

      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

      expression LIKE pattern [ ESCAPE 'escape_character' ]
      

      We need to support it.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              hyunsik Hyunsik Choi
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated: