]
RH Bugzilla Integration commented on TEIID-3812:
------------------------------------------------
Jan Stastny <jstastny(a)redhat.com> changed the Status of [bug
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
Fix For: 8.12.2, 8.13
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.