Andrej Šmigala created TEIID-5122: ------------------------------------- Summary: Osisoft Translator - Teiid pushes cast from Boolean to Single/Double Key: TEIID-5122 URL: https://issues.jboss.org/browse/TEIID-5122 Project: Teiid Issue Type: Bug Components: JDBC Connector Affects Versions: 8.12.x-6.4 Reporter: Andrej Šmigala Assignee: Steven Hawkins Osisoft PI does not support conversion from Boolean to Single or Double, however, query such as {code:sql} select cast(booleanvalue as float) from Source.smalla {code} is pushed as {code:sql} SELECT cast(g_0.BooleanValue AS Single) AS c_0 FROM dvqe..SmallA AS g_0 {code} which results in {noformat} com.osisoft.rdsa.RdsaException: [PIOLEDBENT] [SQL Analyzer] [Line 1:14] Cannot cast 'Boolean' to 'Single'. {noformat} -- This message was sent by Atlassian JIRA (v7.5.0#75005)