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: