Bug 1505870 - Osisoft Translator - Wrong pushdown of LENGTH function
Summary: Osisoft Translator - Wrong pushdown of LENGTH function
Keywords:
Status: CLOSED CURRENTRELEASE
Alias: None
Product: JBoss Data Virtualization 6
Classification: JBoss
Component: Teiid
Version: 6.4.0
Hardware: Unspecified
OS: Unspecified
high
high
Target Milestone: CR2
: 6.4.0
Assignee: Van Halbert
QA Contact: Andrej Smigala
URL:
Whiteboard:
Depends On:
Blocks:
TreeView+ depends on / blocked
 
Reported: 2017-10-24 12:46 UTC by Andrej Smigala
Modified: 2018-02-13 17:35 UTC (History)
8 users (show)

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.
Clone Of:
Environment:
Last Closed: 2018-02-13 17:35:43 UTC
Type: Bug
Embargoed:

Attachments (Terms of Use)


Links
System ID Private Priority Status Summary Last Updated
Red Hat Issue Tracker TEIID-5120 0 Major Resolved Osisoft Translator - Wrong pushdown of LENGTH function 2018-02-01 00:16:55 UTC

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.
Note You need to log in before you can comment on or make changes to this bug.