]
Steven Hawkins resolved TEIID-3812.
-----------------------------------
Fix Version/s: 8.12.2
8.13
Resolution: Done
Changed to compute the min/max by casting to tinyint and then converting the expression
back to boolean.
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.