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

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 Components: JDBC Connector Affects Versions: 8.12.3 Environment: driver - PostgreSQL 9.2 translator - postgresql Reporter: Juraj Duráni Assignee: Steven Hawkins Fix For: 8.13, 8.12.4 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.