[teiid-issues] [JBoss JIRA] Updated: (TEIID-24) Correlated reference in aggregate function of subquery not supported by all data sources

Correlated reference in aggregate function of subquery not supported by all data sources ---------------------------------------------------------------------------------------- Key: TEIID-24 URL: https://jira.jboss.org/jira/browse/TEIID-24 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 6.x Reporter: Steven Hawkins Priority: Optional Fix For: 6.x Defect Tracker #10437: The below BQT query fails for Sybase or SQL Server because of the correlated reference inside the aggregate function, but works in Oracle or if processed by our own system. Seems like connector capabilities need to handle this but they aren't fine-grained enough currently. SELECT sa.intkey, sa.stringkey, sa.datevalue, sa.floatnum, sa.doublenum, sa.datevalue, sa.charvalue, sa.shortvalue, sa.objectvalue FROM bqt1.smalla AS sa WHERE sa.datevalue = (SELECT MAX(sb.datevalue) FROM bqt1.smalla AS sb WHERE (sb.intkey = sa.intkey) AND (sa.stringkey = sb.stringkey) )