Details
-
Bug
-
Resolution: Done
-
Major
-
8.12.11.6_4
-
None
Description
Osisoft PI does not support conversion from Boolean to Single or Double, however, query such as
select cast(booleanvalue as float) from Source.smalla
is pushed as
SELECT cast(g_0.BooleanValue AS Single) AS c_0 FROM dvqe..SmallA AS g_0
which results in
com.osisoft.rdsa.RdsaException: [PIOLEDBENT] [SQL Analyzer] [Line 1:14] Cannot cast 'Boolean' to 'Single'.