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

HANA SUBSTRING function inconsistent with teiid behaviour

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Resolved (View Workflow)
    • Priority: Major
    • Resolution: Deferred
    • Affects Version/s: 8.7.1.6_2
    • Fix Version/s: None
    • Component/s: Misc. Connectors
    • Labels:
      None

      Description

      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.

        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: