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

HANA FLOOR and CELING functions not applicable to boolean

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.12.2, 8.13
    • 8.7.1.6_2
    • Misc. Connectors
    • None

    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)

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            jstastny@redhat.com Jan Stastny
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: