[teiid-issues] [JBoss JIRA] (TEIID-5123) Osisoft translator - Cannot cast String to Float if value is negative
RH Bugzilla Integration (JIRA)
issues at jboss.org
Thu Feb 1 14:40:00 EST 2018
[ https://issues.jboss.org/browse/TEIID-5123?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13527486#comment-13527486 ]
RH Bugzilla Integration commented on TEIID-5123:
------------------------------------------------
Jan Stastny <jstastny at redhat.com> changed the Status of [bug 1506201|https://bugzilla.redhat.com/show_bug.cgi?id=1506201] from ON_QA to CLOSED
> Osisoft translator - Cannot cast String to Float if value is negative
> ---------------------------------------------------------------------
>
> Key: TEIID-5123
> URL: https://issues.jboss.org/browse/TEIID-5123
> Project: Teiid
> Issue Type: Bug
> Components: JDBC Connector
> Affects Versions: 8.12.x-6.4
> Reporter: Andrej Šmigala
> Assignee: Ramesh Reddy
> Fix For: 10.1
>
>
> Casting a string containing a negative value (e.g. '-24') to float fails with
> {noformat}com.osisoft.rdsa.RdsaException: [PIOLEDBENT] Cannot convert -24 from String to Single.{noformat}
> This seems to be a bug in Osisoft PI SQL DAS (server-side not the JDBC driver), as connecting to the PI server using Osisoft's SQL Commander and running
> {code:sql}select cast(N'-24' as single){code}
> results in the same error.
> I think the best course of action would be to document this behaviour of the PI server as known issue and NOT work around it.
--
This message was sent by Atlassian JIRA
(v7.5.0#75005)
More information about the teiid-issues
mailing list