Osisoft translator - correlated subquery on HAVING clause fails --------------------------------------------------------------- Key: TEIID-5193 URL: https://issues.jboss.org/browse/TEIID-5193 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 8.12.11.6_4 Reporter: Andrej Šmigala Assignee: Steven Hawkins Fix For: 10.1, 8.12.13.6_4 Running a query with a correlated subquery in a HAVING clause, such as {code:sql} 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) {code} fails on the datasource with bq. 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.