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

Osisoft translator - correlated subquery on HAVING clause fails

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 10.1, 8.12.13.6_4
    • 8.12.11.6_4
    • JDBC Connector
    • None

    Description

      Running a query with a correlated subquery in a HAVING clause, such as

      SELECT INTKEY, STRINGKEY 
        FROM BQT1.SMALLA AS A 
        WHERE NOT (INTKEY IN (10)) 
        GROUP BY INTKEY, STRINGKEY 
        HAVING INTKEY = (SELECT MIN(STRINGKEY) FROM BQT1.SMALLA AS B WHERE A.INTKEY = B.INTKEY) 
      

      fails on the datasource with

      com.osisoft.rdsa.RdsaException: [PIOLEDBENT] HAVING condition cannot be nonaggregate.

      This seems to be an issue on the Osisoft PI datasource side, as running the query directly against the datasource produces the same failure.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            asmigala@redhat.com Andrej Smigala
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: