Note: This bug is displayed in read-only format because the product is no longer active in Red Hat Bugzilla.

Bug 1505693

Summary:	Osisoft Translator - NULL values in numeric columns returned as zeroes
Product:	[JBoss] JBoss Data Virtualization 6	Reporter:	Andrej Smigala <asmigala>
Component:	Teiid	Assignee:	Van Halbert <vhalbert>
Status:	CLOSED CURRENTRELEASE	QA Contact:	Andrej Smigala <asmigala>
Severity:	high	Docs Contact:
Priority:	high
Version:	6.4.0	CC:	blafond, dlesage, drieden, gjospin, jolee, jschatte, thauser, vhalbert
Target Milestone:	CR2
Target Release:	6.4.0
Hardware:	Unspecified
OS:	Unspecified
Whiteboard:
Fixed In Version:		Doc Type:	If docs needed, set a value
Doc Text:	Null values in columns with a numeric type are returned as 0. This is due to a bug in the Osisoft PI JDBC driver, which is hard-coded to return false from the wasNull method.	Story Points:	---
Clone Of:		Environment:
Last Closed:	2018-02-13 17:42:06 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 2017-10-24 06:55:11 UTC

NULL values in columns with a numeric type (all of int8, int16 etc, single, double) are returned as 0.
This is due to a bug/quirk of the Osisoft PI JDBC driver, which is hard-coded to return false from the wasNull method.

See JIRA for details