[JBoss JIRA] Updated: (TEIID-24) Correlated reference in aggregate function of subquery not supported by all data sources
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/jira/browse/TEIID-24?page=com.atlassian.jira.plugi... ]
Ramesh Reddy updated TEIID-24:
------------------------------
Component/s: JDBC Connector
Fix Version/s: 6.x
Affects Version/s: 6.x
> 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
15 years, 10 months
[JBoss JIRA] Updated: (TEIID-18) Confusing dialog about missing extension module when importing connector binding
by Ramesh Reddy (JIRA)
[ https://jira.jboss.org/jira/browse/TEIID-18?page=com.atlassian.jira.plugi... ]
Ramesh Reddy updated TEIID-18:
------------------------------
Component/s: Console
Fix Version/s: 6.x
Affects Version/s: 6.1.0
> Confusing dialog about missing extension module when importing connector binding
> --------------------------------------------------------------------------------
>
> Key: TEIID-18
> URL: https://jira.jboss.org/jira/browse/TEIID-18
> Project: Teiid
> Issue Type: Bug
> Components: Console
> Affects Versions: 6.1.0
> Reporter: Steven Hawkins
> Priority: Optional
> Fix For: 6.x
>
>
> Defect Tracker #24362: When importing a connector binding that was exported from another server, an error dailog appears indicating the "connector_patch.jar" extension module is missing. However, there is no "Cancel" option in the dialog, and when you hit "OK", the wizard ends anyway. The specified module is not listed in either the source or target server's extension modules. Ramesh indicated everything will work despite the dialog, and this jar only exists for quick fixes, debugging, and testing, and should not cause this dialog to show up.
> RReddy - Also while exporting the Connector Type using the console, since this file is not available the CAF file creation fails with a exception
--
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
15 years, 10 months