Uploaded image for project: 'Teiid Designer'
  1. Teiid Designer
  2. TEIIDDES-2198

Virtual procedure transformation not revalidated after changing parameter datatype

    XMLWordPrintable

Details

    • Hide
      1. Create new virtual procedure
      2. Add a parameter p1 with datatype 'string'
      3. Set the following transformation:
        CREATE VIRTUAL PROCEDURE BEGIN DECLARE xml VARIABLES.IN_P1 = p1; END
      4. Save the model, an error is shown as expected (TEIID30082 Expected value of type 'xml' but 'p1' is of type 'string' and no implicit conversion is available.)
      5. Change the datatype of the paramter to XMLLiteral
      6. Validate the SQL, save the model, the error does not go away
      7. Change the procedure to force revalidation (e.g. by adding DECLARE string VARIABLES.S = ''; to the procedure body)
      8. Validate and save, the error disappears.
      9. Change the datatype of the parameter back to string
      10. Validate and save, no error appears
      11. Change the procedure again, validate and save, the error appears again
      Show
      Create new virtual procedure Add a parameter p1 with datatype 'string' Set the following transformation: CREATE VIRTUAL PROCEDURE BEGIN DECLARE xml VARIABLES.IN_P1 = p1; END Save the model, an error is shown as expected (TEIID30082 Expected value of type 'xml' but 'p1' is of type 'string' and no implicit conversion is available.) Change the datatype of the paramter to XMLLiteral Validate the SQL, save the model, the error does not go away Change the procedure to force revalidation (e.g. by adding DECLARE string VARIABLES.S = ''; to the procedure body) Validate and save, the error disappears. Change the datatype of the parameter back to string Validate and save, no error appears Change the procedure again, validate and save, the error appears again

    Description

      Changing the datatype of a virtual procedure parameter does not trigger revalidation. This means that errors caused by trying to convert the parameter to an incompatible datatype in the transformation do not disappear after fixing the datatype, and conversely, changing the datatype does not trigger validation errors when the new datatype is incompatible.

      Attachments

        Activity

          People

            blafond Barry LaFond
            asmigala@redhat.com Andrej Smigala
            Votes:
            0 Vote for this issue
            Watchers:
            3 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: