[teiid-issues] [JBoss JIRA] (TEIID-3888) Redshift - there is not function SUBSTR (RS uses SUBSTRING)
[
https://issues.jboss.org/browse/TEIID-3888?page=com.atlassian.jira.plugin...
]
Juraj Duráni reopened TEIID-3888:
---------------------------------
This still does not work for function LOCATION(x,y,z).
*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)
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.
--
This message was sent by Atlassian JIRA
(v6.4.11#64026)