[teiid-issues] [JBoss JIRA] (TEIID-5120) Osisoft Translator - Wrong pushdown of LENGTH function
Andrej Šmigala (JIRA)
issues at jboss.org
Tue Oct 24 08:46:02 EDT 2017
Andrej Šmigala created TEIID-5120:
-------------------------------------
Summary: 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: Steven Hawkins
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.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list