-
Bug
-
Resolution: Done
-
Major
-
8.12.11.6_4
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.