[jira] [Updated] (TAJO-147) Implement trim(text), ltrim(text), and rtrim(text) function

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

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

Hyunsik Choi updated TAJO-147:
------------------------------

    Attachment: TAJO-147.patch

I've attached the trim string function.

In order to support SQL standard built-in string function, this patch improves and refactors SQLParser.g. As a result, this implementation well follows SQL standard as follows:
{code}
trim([leading | trailing | both] [characters] from string)
{code}
For PostgreSQL compatibility, It also adds btim, ltrim, and rtrim function and some synonym function 'trim' of btrim.

Besides, this patch also removes the legacy license from NOTICE.txt and LICENSE.txt for sql-frontend that was removed few month ago.

> Implement trim(text), ltrim(text), and rtrim(text) function
> -----------------------------------------------------------
>
>                 Key: TAJO-147
>                 URL: https://issues.apache.org/jira/browse/TAJO-147
>             Project: Tajo
>          Issue Type: Sub-task
>          Components: operator/function/udf
>            Reporter: Hyunsik Choi
>            Assignee: Hyunsik Choi
>            Priority: Minor
>              Labels: newbie
>             Fix For: 0.2-incubating
>
>         Attachments: TAJO-147.patch
>
>
> We need to implement the below trim functions:
> * trim() function removes whitespaces in both sides
> * ltrim() function removes whitespaces in left side.
> * rtrim() function removes whitespaces in right side.



--
This message was sent by Atlassian JIRA
(v6.1#6144)