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)