Bug 1530184 - Osisoft Translator - AVG on integral column returns NULL
Summary: Osisoft Translator - AVG on integral column returns NULL
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.4.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: CR5
: 6.4.0
Assignee: Van Halbert
QA Contact: Andrej Smigala
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2018-01-02 08:37 UTC by Andrej Smigala
Modified: 2018-02-13 17:37 UTC (History)
7 users (show)

Fixed In Version:
Doc Type: If docs needed, set a value
Doc Text:
Clone Of:
Environment:
Last Closed: 2018-02-13 17:37:34 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-5191 0 Major Resolved Osisoft translator - AVG on integral column returns NULL 2018-01-23 11:49:04 UTC

Description Andrej Smigala 2018-01-02 08:37:37 UTC 
Running a query such as

SELECT AVG(intnum) FROM BQT1.SmallA

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.
Comment 1 Andrej Smigala 2018-01-15 11:30:29 UTC 
This issue is resolved in upstream (commit 01b968a2)
Note You need to log in before you can comment on or make changes to this bug.