[ https://issues.apache.org/jira/browse/IGNITE-5624?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Vladimir Ozerov resolved 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)