You are viewing a plain text version of this content. The canonical link for it is here.

Posted to issues@ignite.apache.org by "Valentin Kulichenko (JIRA)" <ji...@apache.org> on 2017/06/29 22:01:01 UTC

[jira] [Closed] (IGNITE-5624) SQL: LTRIM/RTRIM not working with multiple character

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

Valentin Kulichenko closed IGNITE-5624.
---------------------------------------

> SQL: LTRIM/RTRIM not working with multiple character
> ----------------------------------------------------
>
>                 Key: IGNITE-5624
>                 URL: https://issues.apache.org/jira/browse/IGNITE-5624
>             Project: Ignite
>          Issue Type: Task
>            Reporter: Denis Magda
>
>  LTRIM/RTRIM is working only for one char and not for a word (Multiple Character). For instance, the example below doesn't work for Ignite:
> {code}
> SELECT product_name, LTRIM(product_name, 'Monitor ') "Short Name"
>    FROM products
>    WHERE product_name LIKE 'Monitor%';
> {code}



--
This message was sent by Atlassian JIRA
(v6.4.14#64029)