[teiid-issues] [JBoss JIRA] (TEIID-5123) Osisoft translator - Cannot cast String to Float if value is negative
Andrej Šmigala (JIRA)
issues at jboss.org
Wed Oct 25 07:46:00 EDT 2017
Andrej Šmigala created TEIID-5123:
-------------------------------------
Summary: 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: Steven Hawkins
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