Bug 1278464

Summary: HANA SUBSTRING function inconsistent with Teiid's behaviour
Product: [JBoss] JBoss Data Virtualization 6 Reporter: Jan Stastny <jstastny>
Component: TeiidAssignee: Van Halbert <vhalbert>
Status: CLOSED WONTFIX QA Contact: Jan Stastny <jstastny>
Severity: unspecified Docs Contact:
Priority: unspecified    
Version: 6.2.0CC: drieden, vhalbert
Target Milestone: ---   
Target Release: ---   
Hardware: Unspecified   
OS: Unspecified   
Whiteboard:
Fixed In Version: Doc Type: Bug Fix
Doc Text:
Story Points: ---
Clone Of: Environment:
Last Closed: 2015-11-23 16:04:33 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-11-05 14:41:57 UTC 
Description of problem:
When trying to get a substring starting on a position which is after the end of the string, default behaviour for Teiid is to return NULL. But HANA returns empty string, which is then returned by Teiid. This introduces an inconsistency in handling such situation.

See the linked JIRA.
Comment 1 JBoss JIRA Server 2015-11-09 20:35:47 UTC 
Steven Hawkins <shawkins> updated the status of jira TEIID-3805 to Resolved