[teiid-issues] [JBoss JIRA] (TEIID-3817) HANA FLOOR and CELING functions not applicable to boolean

HANA FLOOR and CELING functions not applicable to boolean --------------------------------------------------------- Key: TEIID-3817 URL: https://issues.jboss.org/browse/TEIID-3817 Project: Teiid Issue Type: Bug Components: Misc. Connectors Affects Versions: 8.7.1.6_2 Reporter: Jan Stastny Assignee: Steven Hawkins Fix For: 8.12.2, 8.13 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: {code:sql} SELECT CEILING(BooleanValue) FROM BQT1.SmallA {code} 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)