[teiid-issues] [JBoss JIRA] (TEIID-5123) Osisoft translator - Cannot cast String to Float if value is negative

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