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

[Ramesh Reddy (JIRA)]

     [ https://issues.jboss.org/browse/TEIID-5120?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Ramesh Reddy resolved TEIID-5120.
---------------------------------
    Resolution: Done
        Labels: CR2  (was: )


> 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
>
>
> 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)