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

Osisoft translator - correlated subquery on HAVING clause fails

XMLWordPrintable

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

      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.

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

                Created:
                Updated:
                Resolved: