[teiid-issues] [JBoss JIRA] (TEIID-4199) Redshift fails locate pushdown

[Steven Hawkins (JIRA)]

Steven Hawkins created TEIID-4199:
-------------------------------------

             Summary: Redshift fails locate pushdown
                 Key: TEIID-4199
                 URL: https://issues.jboss.org/browse/TEIID-4199
             Project: Teiid
          Issue Type: Bug
          Components: JDBC Connector
    Affects Versions: 8.12
            Reporter: Steven Hawkins
            Assignee: Steven Hawkins
             Fix For: 9.0, 8.12.5


The LOCATE(x,y,z) function translates incorrectly:
Query: SELECT INTKEY, STRINGKEY FROM Source.SmallA WHERE LOCATE('1', STRINGKEY, 2) IN (1, 2)
Source-specific command: SELECT g_0.intkey, g_0.stringkey FROM smalla AS g_0 WHERE (position('1' in substr(g_0.stringkey, 2)) + 1) IN (1, 2)
Root exception message: Caused by: org.postgresql.util.PSQLException: ERROR: function SUBSTR does not exist (Hint: use SUBSTRING instead)



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