[teiid-issues] [JBoss JIRA] (TEIID-5120) Osisoft Translator - Wrong pushdown of LENGTH function

Osisoft Translator - Wrong pushdown of LENGTH function ------------------------------------------------------ Key: TEIID-5120 URL: https://issues.jboss.org/browse/TEIID-5120 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 8.12.x-6.4 Reporter: Andrej Šmigala Assignee: Ramesh Reddy Labels: CR2 Fix For: 10.0, 8.12.x-6.4 The LENGTH function is pushed down to Osisoft PI as-is, but fails on the datasource with {noformat} com.osisoft.rdsa.RdsaException: [PIOLEDBENT] [SQL Analyzer] [Line 0:4294967295] Function name 'length' is invalid. {noformat} 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.