Krystal created DRILL-1099:
------------------------------
Summary: 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
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)
