[teiid-issues] [JBoss JIRA] (TEIID-5122) Osisoft Translator - Teiid pushes cast from Boolean to Single/Double
[
https://issues.jboss.org/browse/TEIID-5122?page=com.atlassian.jira.plugin...
]
Ramesh Reddy edited comment on TEIID-5122 at 10/25/17 11:40 AM:
----------------------------------------------------------------
[~asmigala] So boolean to "Int" type is there but not to "float" type,
we could do that.
was (Author: rareddy):
[~asmigala] Did you need the outer CAST? That makes me think, why it is not already
converting to native type names.
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: Ramesh Reddy
Fix For: 10.0
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)