Uploaded image for project: 'Teiid'
  1. Teiid
  2. TEIID-3817

HANA FLOOR and CELING functions not applicable to boolean

    Details

      Description

      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:

      SELECT CEILING(BooleanValue) FROM BQT1.SmallA
      

      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)

        Gliffy Diagrams

          Attachments

            Activity

              People

              • Assignee:
                shawkins Steven Hawkins
                Reporter:
                jstastny Jan Stastny
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: