[jira] [Assigned] (PHOENIX-7201) Support LEFT, RIGHT operators as built in functions

["Nikita Pande (Jira)" <ji...@apache.org>]

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

Nikita Pande reassigned PHOENIX-7201:
-------------------------------------

    Assignee: Nikita Pande

> Support LEFT, RIGHT operators as built in functions
> ---------------------------------------------------
>
>                 Key: PHOENIX-7201
>                 URL: https://issues.apache.org/jira/browse/PHOENIX-7201
>             Project: Phoenix
>          Issue Type: Sub-task
>         Environment: strong text
>            Reporter: Nikita Pande
>            Assignee: Nikita Pande
>            Priority: Major
>
> When we are validating phoenix with existing databases in our organisation, there are few gaps identified wrt built in functions.
> 1. LEFT: [https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-left |http://example.com/]
> {*}Description{*}: The LEFT function returns a string that consists of the specified number of 
> leftmost bytes of the specified string units.
> {*}Example{*}: Assume that host variable ALPHA has a value of 'ABCDEF'. The following 
> statement returns '{*}ABC{*}'
> {code:java}
>      SELECT LEFT(:ALPHA,3) FROM SYSIBM.SYSDUMMY1;  {code}
> 2. RIGHT:[ [https://www.ibm.com/docs/en/db2-for-zos/12?topic=functions-right]|http://example.com]
> {*}Description{*}: The RIGHT function returns a string that consists of the specified number 
> of rightmost bytes or specified string unit from a string.
> {*}Example{*}: Assume that host variable ALPHA has a value of 'ABCDEF'. The following 
> statement returns the value '{*}DEF{*}', which are the three rightmost characters in ALPHA
> {code:java}
>      SELECT RIGHT(ALPHA,3) FROM SYSIBM.SYSDUMMY1;{code}



--
This message was sent by Atlassian Jira
(v8.20.10#820010)