[teiid-issues] [JBoss JIRA] (TEIID-3888) Redshift - there is not function SUBSTR (RS uses SUBSTRING)

[Juraj Duráni (JIRA)]

Juraj Duráni created TEIID-3888:
-----------------------------------

             Summary: Redshift - there is not function SUBSTR (RS uses SUBSTRING)
                 Key: TEIID-3888
                 URL: https://issues.jboss.org/browse/TEIID-3888
             Project: Teiid
          Issue Type: Bug
    Affects Versions: 8.12.3
         Environment: driver - PostgreSQL 9.2
translator - postgresql
            Reporter: Juraj Duráni
            Assignee: Steven Hawkins


Postgresql translator uses SUBSTR function to get substring of string (e.g. function LEFT(x,y)), but Redshift does not support function SUBSTR. It support SUBSTRING function instead.



--
This message was sent by Atlassian JIRA
(v6.4.11#64026)