[teiid-issues] [JBoss JIRA] (TEIID-4199) Redshift fails locate pushdown
RH Bugzilla Integration (JIRA)
issues at jboss.org
Fri Jun 3 17:31:00 EDT 2016
[ https://issues.jboss.org/browse/TEIID-4199?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13247926#comment-13247926 ]
RH Bugzilla Integration commented on TEIID-4199:
------------------------------------------------
Van Halbert <vhalbert at redhat.com> changed the Status of [bug 1296599|https://bugzilla.redhat.com/show_bug.cgi?id=1296599] from MODIFIED to ON_QA
> 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)
More information about the teiid-issues
mailing list