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

DDL for UDF in exported dynamic VDB contains RETURN parameter

    XMLWordPrintable

Details

    Description

      When exporting VDB with a UDF, the resulting DDL contains the RETURN parameter in the parameters list. According to the Teiid docs, the return parameter should not be specified.

      Generated DDL:

      CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000), result string(4000)) RETURNS string
) OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')

      Expected DDL:

      CREATE VIRTUAL FUNCTION concatNull (stringLeft string(4000), stringRight string(4000)) RETURNS string
 OPTIONS("FUNCTION-CATEGORY" 'MY_TESTING_FUNCTION_CATEGORY', JAVA_CLASS 'userdefinedfunctions.MyConcatNull', JAVA_METHOD 'myConcatNull')

      (note that the generated DDL also contains an unrelated syntax error due to TEIIDDES-2697)

      Attachments

        Issue Links

          is incorporated by

          Task - Represents a small unit of work that is not end-user facing. TEIIDDES-2699 Issues with Dynamic VDB import/export

          • Blocker - To be worked above all other priorities. This term is chosen when the severity of the issue is very high, has no workaround, or the effort for the change is comparatively low. Issues that may be very publicly visible and could generate significant media attention may also drive a higher priority.
          • Closed

          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: