[jira] [Updated] (DRILL-1544) Support the escape clause for like and similar to

["Jinfeng Ni (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DRILL-1544?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Jinfeng Ni updated DRILL-1544:
------------------------------
    Attachment: 0001-DRILL-1544-Support-escape-character-in-like-or-simil.patch

> Support the escape clause for like and similar to
> -------------------------------------------------
>
>                 Key: DRILL-1544
>                 URL: https://issues.apache.org/jira/browse/DRILL-1544
>             Project: Apache Drill
>          Issue Type: Improvement
>          Components: Functions - Drill
>            Reporter: Norris Lee
>            Assignee: Jinfeng Ni
>         Attachments: 0001-DRILL-1544-Support-escape-character-in-like-or-simil.patch
>
>
> {code}
> 0: jdbc:drill:zk=localhost:5181> Select * from INFORMATION_SCHEMA.`TABLES` where TABLE_NAME LIKE 'bit\_table' ESCAPE '\';
> Query failed: Screen received stop request sent. Failure while trying to materialize incoming schema.  Errors:
> Error in expression at index -1.  Error: Missing function implementation: [like(VARCHAR-OPTIONAL, VARCHAR-REQUIRED, VARCHAR-REQUIRED)].  Full expression: --UNKNOWN EXPRESSION--.. [b65e023d-ed41-4779-8fb9-946cd66b2190]
> Error: exception while executing query: Failure while trying to get next result batch. (state=,code=0)
> {code}



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)