Bug 1530184

Summary: Osisoft Translator - AVG on integral column returns NULL
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Andrej Smigala <asmigala>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact: Andrej Smigala <asmigala>
Severity: high Docs Contact:
Priority: high    
Version: 6.4.0CC: blafond, drieden, gjospin, jolee, jschatte, thauser, vhalbert
Target Milestone: CR5   
Target Release: 6.4.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: If docs needed, set a value
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2018-02-13 17:37:34 UTC Type: Bug
Regression: --- Mount Type: ---
Documentation: --- CRM:
Verified Versions: Category: ---
oVirt Team: --- RHEL 7.3 requirements from Atomic Host:
Cloudforms Team: --- Target Upstream Version:
Embargoed:

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)