[teiid-issues] [JBoss JIRA] (TEIID-4278) MySQL 5 should support distinct aggregates

[Steven Hawkins (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-4278?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13554990#comment-13554990 ] 

Steven Hawkins commented on TEIID-4278:
---------------------------------------

1) regardless of the translator, the rewrite removes distinct from min/max as it has no effect on the results.

2) the mapping to group_concat has not been added regardless of distinct behavior.  One small consideration there is that Teiid supports blob/clob results, but group_concat returns strings.

> MySQL 5 should support distinct aggregates
> ------------------------------------------
>
>                 Key: TEIID-4278
>                 URL: https://issues.jboss.org/browse/TEIID-4278
>             Project: Teiid
>          Issue Type: Enhancement
>          Components: JDBC Connector
>            Reporter: Steven Hawkins
>            Assignee: Steven Hawkins
>             Fix For: 9.1, 8.7.8.6_2, 8.12.6.6_3
>
>
> Older versions of mysql only supported distinct count, but later versions supported distinct with all relevant aggregates.



--
This message was sent by Atlassian JIRA
(v7.5.0#75005)