[teiid-issues] [JBoss JIRA] (TEIID-3812) HANA MIN and MAX functions not applicable on boolean

[Jan Stastny (JIRA)]

Jan Stastny created TEIID-3812:
----------------------------------

             Summary: 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.




--
This message was sent by Atlassian JIRA
(v6.4.11#64026)