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

HANA SUBSTRING function inconsistent with teiid behaviour

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Won't Do
    • Icon: Major Major
    • None
    • 8.7.1.6_2
    • Misc. Connectors
    • None

      When querying HANA using hana translator, there is an inconsistency in handling SUBSTRING with similar parameters:

      SELECT SUBSTRING('sth',20,1) FROM tablename

      That is, when the starting offset supplied to SUBSTRING function is greater than the length of the string value, Teiid returns NULL in this case.
      But when I run:

      SELECT SUBSTRING(STRINGNUM,20,1) FROM bqt1.smalla

      (it is pushed to HANA and STRINGNUM column contains strings of length <=2)
      I get empty strings instead of NULL values, which is default in Teiid.

      This inconsistency is caused by different handling of such situation on HANA's side.

            [TEIID-3805] HANA SUBSTRING function inconsistent with teiid behaviour

            RH Bugzilla Integration added a comment -

            Debi Rieden <drieden@redhat.com> changed the Status of bug 1278464 from NEW to CLOSED

            RH Bugzilla Integration added a comment - Debi Rieden <drieden@redhat.com> changed the Status of bug 1278464 from NEW to CLOSED

            Steven Hawkins added a comment -

            Added a release note and updated the docs, will mark the issue as deferred until it's needed to be addressed by a customer case.

            Steven Hawkins added a comment - Added a release note and updated the docs, will mark the issue as deferred until it's needed to be addressed by a customer case.

              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: