[teiid-issues] [JBoss JIRA] (TEIID-5122) Osisoft Translator - Teiid pushes cast from Boolean to Single/Double

[Ramesh Reddy (JIRA)]

    [ https://issues.jboss.org/browse/TEIID-5122?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13481789#comment-13481789 ] 

Ramesh Reddy commented on TEIID-5122:
-------------------------------------

All conversions from Boolean to any other type will be not pushed with the fix.

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