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

xsi:nil is not honored by xmltable

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.4.1, 8.5
    • 7.7
    • Query Engine
    • None

    Description

      If an element is returnable by xmltable, but marked as nil more than likely an exception will be produced when attempting to convert the empty string value to a result.

      For example:

      select * from xmltable('/a/b' passing convert('<a xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"><b xsi:nil="true"/><b>1</b></a>', xml) columns val integer path '.') as x
      

      will error converting the first b element to an integer.

      Attachments

        Activity

          People

            rhn-engineering-shawkins Steven Hawkins
            rhn-engineering-shawkins Steven Hawkins
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: