[jira] [Updated] (DRILL-1099) ltrim and rtrim functions fail with SchemaChangeException

["Cliff Buchanan (JIRA)" <ji...@apache.org>]

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

Cliff Buchanan updated DRILL-1099:
----------------------------------

    Attachment: 0001-DRILL-1099-Inject-as-the-default-second-argument-to-.patch

> ltrim and rtrim functions fail with SchemaChangeException  
> -----------------------------------------------------------
>
>                 Key: DRILL-1099
>                 URL: https://issues.apache.org/jira/browse/DRILL-1099
>             Project: Apache Drill
>          Issue Type: Bug
>          Components: Functions - Drill
>            Reporter: Krystal
>            Assignee: Cliff Buchanan
>         Attachments: 0001-DRILL-1099-Inject-as-the-default-second-argument-to-.patch
>
>
> git.commit.id.abbrev=a1a6144
> ltrim and rtrim functions fail with SchemaChangeException if trim characters are missing.
> 0: jdbc:drill:schema=dfs> select ltrim(name) from voter where voter_id=20;
> message: "Screen received stop request sent. < SchemaChangeException:[ Failure while trying to materialize incoming schema.  Errors:
>  
> Error in expression at index -1.  Error: Missing function implementation: [ltrim(VARBINARY-OPTIONAL)].  Full expression: --UNKNOWN EXPRESSION--.. ]"
> ]
> The default string should be spaces.
> The following query works;
> select ltrim(name,' ') from voter where voter_id=20;



--
This message was sent by Atlassian JIRA
(v6.2#6252)