]
Jan Stastny commented on TEIID-3812:
------------------------------------
Based on Steven's comment I created
HANA MIN and MAX functions not applicable on boolean
----------------------------------------------------
Key: TEIID-3812
URL:
https://issues.jboss.org/browse/TEIID-3812
Project: Teiid
Issue Type: Bug
Components: Misc. Connectors
Affects Versions: 8.7.1.6_2
Reporter: Jan Stastny
Assignee: Steven Hawkins
SAP HANA doesn't support MIN and MAX functions for BOOLEAN type.
Compared to postgresql, which also has BOOLEAN data type, it seems inconsistent, as
postgresql translator mimics MIN and MAX functions by translating them using PostgreSQL
specific constructs:
min(BooleanValue) as bool_and(BooleanValue)
max(BooleanValue) as bool_or(BooleanValue)
Similar issue is with CEILING and FLOOR functions.