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

HANA FLOOR and CELING functions not applicable to boolean

XMLWordPrintable

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

      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)

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

                Created:
                Updated:
                Resolved: