Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-1953

Greenplum DB - BQT correlated subquery failures

    XMLWordPrintable

Details

    Description

      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

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            wgibson_jira Warren Gibson (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: