[
https://issues.apache.org/jira/browse/DRILL-1098?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14050558#comment-14050558
]
Krystal commented on DRILL-1098:
--------------------------------
Additional trim queries that fail with the same error:
select trim(LEADING ' ' FROM name) from voter where voter_id=20;
select trim(' ' FROM name) from voter where voter_id=20;
select trim(LEADING FROM name) from voter where voter_id=20;
select trim(trailing FROM name) from voter where voter_id=20;
select trim(trailing 'n' from name) from voter where voter_id=46;
select trim(leading 'i' from name) from voter where voter_id=46;
select trim(both 'n' from name) from voter where voter_id=46;
In the above queries, if I replace the "name" column with a string, then the
queries run successfully.
> Trim function in Drill should default to 'space' when no trim characters are
> provided like Oracle and Postgres
> --------------------------------------------------------------------------------------------------------------
>
> Key: DRILL-1098
> URL: https://issues.apache.org/jira/browse/DRILL-1098
> Project: Apache Drill
> Issue Type: Bug
> Components: Functions - Drill
> Reporter: Rahul Challapalli
> Assignee: Mehant Baid
> Priority: Blocker
>
> git.commit.id.abbrev=a1a6144
> Build # 26266
> Any query where we use trim function without mentioning a 'trim character'
> fails
> select trim(pageURL) from rankings;
--
This message was sent by Atlassian JIRA
(v6.2#6252)
