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

Bug 1505870

Summary: Osisoft Translator - Wrong pushdown of LENGTH function
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, 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:
The length function is pushed down to Osisoft PI but fails on the datasource with an exception. This seems to be due to an Osisoft bug.
 Story Points: ---
Clone Of: Environment:
Last Closed: 2018-02-13 17:35:43 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 12:46:46 UTC 
The LENGTH function is pushed down to Osisoft PI as-is, but fails on the datasource with

com.osisoft.rdsa.RdsaException: [PIOLEDBENT] [SQL Analyzer] [Line 0:4294967295] Function name 'length' is invalid.

This seems to be a mistake in PI OLEDB Enterprise 2016 User Guide, as this document mentions on page 32 that LENGTH is an alias for LEN.

However, since LEN actually works, I suggest changing the pushdown in teiid as a workaround.