[teiid-issues] [JBoss JIRA] (TEIID-1953) Greenplum DB - BQT correlated subquery failures

[Steven Hawkins (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-1953?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins updated TEIID-1953:
----------------------------------

    Fix Version/s: 7.7.1

    
> Greenplum DB - BQT correlated subquery failures
> -----------------------------------------------
>
>                 Key: TEIID-1953
>                 URL: https://issues.jboss.org/browse/TEIID-1953
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 7.6
>            Reporter: Warren Gibson
>            Assignee: Steven Hawkins
>             Fix For: 7.7.1
>
>
> Testing Greenplum DB against Teiid 7.6.0 Final.  Greenplum DB is returning the following on 59 BQT queries:  Remote org.postgresql.util.PSQLException: ERROR: Greenplum Database does not yet support that query.  Detail: The query contains a correlated subquery.  I am using the postgresql Translator. 
> A couple example queries are listed below:
> SELECT INTKEY, STRINGNUM FROM BQT1.SmallA AS A WHERE NOT (EXISTS (SELECT STRINGNUM FROM BQT1.SmallA AS B WHERE B.INTKEY = A.INTKEY))
> SELECT INTKEY, STRINGKEY FROM BQT1.SMALLA AS A WHERE STRINGKEY = (SELECT MASTRINGKEY) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) ORDER BY INTKEY, STRINGKEY

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.jboss.org/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira