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

DDL for UDF in exported dynamic VDB contains RETURN parameter

    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)

        Gliffy Diagrams

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  blafond Barry LaFond
                  Reporter:
                  asmigala Andrej Smigala
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  3 Start watching this issue

                  Dates

                  • Created:
                    Updated:
                    Resolved: