Uploaded image for project: 'Apache Drill'
  1. Apache Drill
  2. DRILL-3301

ILIKE does not support escape characters.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Major
    • Resolution: Unresolved
    • None
    • Future
    • SQL Parser
    • None

    Description

      The like operator properly supports escaping characters. Because the ILIKE is implemented as a function, it does not support escaping.

      The grammar needs to be updated to accept ILIKE in the same locations as LIKE.

      Attachments

        Issue Links

          is related to

          New Feature - A new feature of the product, which has yet to be developed. DRILL-2658 Add ilike and regex substring functions

          • Major - Major loss of function.
          • Resolved

          Activity

            People

              Unassigned Unassigned
              ptoole Patrick Toole
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: