ignite-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Denis Magda (JIRA)" <j...@apache.org>
Subject [jira] [Created] (IGNITE-5624) SQL: LTRIM/RTRIM not working with multiple character
Date Thu, 29 Jun 2017 20:47:00 GMT
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)

Mime
View raw message