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

[Steven Hawkins (JIRA)]

     [ https://jira.jboss.org/jira/browse/TEIID-24?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Steven Hawkins resolved TEIID-24.
---------------------------------

    Resolution: Out of Date


The rewriter will now catch situations where expressions that will become constants are used in aggregates.  If a source has a problem with a correlated reference as part of a non-constant expression in an aggregate, then we'll open a new issue for that.

> 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) )

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: https://jira.jboss.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira