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

Posted to issues@ignite.apache.org by "Denis Magda (JIRA)" <ji...@apache.org> on 2017/06/29 20:47:00 UTC

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

Denis Magda created IGNITE-5624:
-----------------------------------

             Summary: 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)