[teiid-issues] [JBoss JIRA] (TEIID-5120) Osisoft Translator - Wrong pushdown of LENGTH function
RH Bugzilla Integration (JIRA)
issues at jboss.org
Mon Jan 8 08:25:01 EST 2018
[ https://issues.jboss.org/browse/TEIID-5120?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13510810#comment-13510810 ]
RH Bugzilla Integration commented on TEIID-5120:
------------------------------------------------
Andrej Smigala <asmigala at redhat.com> changed the Status of [bug 1505870|https://bugzilla.redhat.com/show_bug.cgi?id=1505870] from ON_QA to VERIFIED
> 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.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list