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

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

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

Krystal closed DRILL-1099.
--------------------------

Verified that bug is fixed.  Automated tests are at:
/private-sql-hadoop-test/framework/resources/Functional/Passing/p1tests/ltrim.q
/private-sql-hadoop-test/framework/resources/Functional/Passing/p1tests/rtrim.q

> 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: DrillCommitter
>             Fix For: 0.4.0
>
>         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.3.4#6332)