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

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