[teiid-issues] [JBoss JIRA] (TEIID-5191) Osisoft translator - AVG on integral column returns NULL
[
https://issues.jboss.org/browse/TEIID-5191?page=com.atlassian.jira.plugin...
]
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)