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

Validate that result sets returned from a procedure match the expected metadata

    XMLWordPrintable

Details

    • Bug
    • Resolution: Done
    • Major
    • 8.2
    • None
    • Query Engine
    • None

    Description

      Very little validation is performed to ensure that the proper resultset is returned from a procedure.

      for example:

      create virtual procedure vproc (x integer) returns table (y integer) as begin if (x = 1) select 1; else select 1, 2; end;

      will return an incorrect result if anything but 1 is passed in, which will cause downstream errors, such as exceptions during serialization (if mismatched types) or npes if too few columns.

      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: