-
Bug
-
Resolution: Done
-
Major
-
8.7.1.6_2
-
None
SAP HANA doesn't support FLOOR and CEILING functions for BOOLEAN type.
Compared to postgresql, which also has BOOLEAN data type, it seems inconsistent.
When querying postgres directly:
SELECT CEILING(BooleanValue) FROM BQT1.SmallA
is not valid query.
But through Teiid, it returns double values corresponding to the boolean value provided:
0.0 for CEILING(false)
1.0 for CELING(true)