Bug 1247976

Summary: MongoDB string functions - different handling of NULL values
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Jan Stastny <jstastny>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED CURRENTRELEASE QA Contact: Filip Elias <felias>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: atangrin, dlesage, vhalbert
Target Milestone: ER1   
Target Release: 6.3.0   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2016-08-24 11:42:39 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 Jan Stastny 2015-07-29 11:21:48 UTC 
Teiid doesn't handle NULL values right in UCASE,LCASE and SUBSTRING functions when working with mongodb. It preserves mongo's results, which are different from what is expected from SQL function.

Further description is in linked JIRA TEIID-3598.
Comment 1 JBoss JIRA Server 2015-07-31 18:05:09 UTC 
Ramesh Reddy <rareddy> updated the status of jira TEIID-3598 to Resolved
Comment 2 Van Halbert 2015-09-03 18:17:25 UTC 
This has been fixed upstream on the Teiid 8.12 branch.
Comment 3 JBoss JIRA Server 2016-01-26 18:00:55 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-3598 to Closed