[
https://issues.jboss.org/browse/TEIID-1953?page=com.atlassian.jira.plugin...
]
Steven Hawkins resolved TEIID-1953.
-----------------------------------
Resolution: Done
Added a Greenplum translator as a subclass of the postgresexecutionfactory and added an
override for correlated subquery support. Any additional tweaks can be added to the new
translator.
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