[teiid-issues] [JBoss JIRA] (TEIID-5191) Osisoft translator - AVG on integral column returns NULL

[Andrej Šmigala (JIRA)]

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

Andrej Šmigala edited comment on TEIID-5191 at 1/2/18 4:17 AM:
---------------------------------------------------------------

Same issue when the AVG is on an integral expression such as AVG(LEN(g_0.StringNum)).


was (Author: asmigala):
Same issue when the AVG is on an integral expression such as ``AVG(LEN(g_0.StringNum))``.

> Osisoft translator - AVG on integral column returns NULL
> --------------------------------------------------------
>
>                 Key: TEIID-5191
>                 URL: https://issues.jboss.org/browse/TEIID-5191
>             Project: Teiid
>          Issue Type: Bug
>          Components: JDBC Connector
>    Affects Versions: 8.12.x-6.4
>            Reporter: Andrej Šmigala
>            Assignee: Steven Hawkins
>
> Running a query such as 
> {code:sql}
> SELECT AVG(intnum) FROM BQT1.SmallA
> {code}
> returns just a NULL value. 
> Running an equivalent query directly against the PI datasource returns the correct result. 
> This happens for any column type except for single and double.



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