[jira] [Closed] (TRAFODION-774) LP Bug: 1393988 - Missing UDF return values should have been caught at the create function time

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-774?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah closed TRAFODION-774.
------------------------------------
    Resolution: Fixed

Close issues in JIRA to reflect status in LaunchPad

> LP Bug: 1393988 - Missing UDF return values should have been caught at the create function time
> -----------------------------------------------------------------------------------------------
>
>                 Key: TRAFODION-774
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-774
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-exe
>            Reporter: Weishiun Tsai
>            Assignee: Hans Zeller
>
> Currently, if a user does not specify the required ‘returns (<values>)’ option for ‘create function’, the create statement does not catch this error.  However, error 4457 is returned when the UDF is used in a statement.  This error should have been caught earlier at the create function time.
> This is seen on the v1115_0830 build installed on a workstation.
> To reproduce this problem, you need to install UDF first by following the instructions bellow:
> (1) Download the attached tar file and untar it to get the 4 files in there. Put the 4 files in any directory <mydir>
> (2) Run build.sh from <mydir> to build the UDF so file.
> (3) Change the line ‘create library myudflib file '<mydir>'; in mytest.sql and fill in <mydir>
> (4) From sqlci, obey mytest.sql
> ------------------------------------------------------------------------------------------------------------------
> Here is the execution output of mytset.sql
> >>obey mytest.sql;
> >>set schema MYUDFTEST;
> --- SQL operation complete.
> >>
> >>create table mytab (a int);
> --- SQL operation complete.
> >>insert into mytab values (1),(2),(3);
> --- 3 row(s) inserted.
> >>
> >>create library myudflib file '<mydir>’;
> --- SQL operation complete.
> >>
> >>create function ENCRYPT_I
> +>(INVAL INT)
> +>-- returns (OUTVAL INT)
> +>language c
> +>parameter style sql
> +>external name 'encrypt_i'
> +>library myudflib
> +>deterministic
> +>state area size 1024
> +>allow any parallelism
> +>no sql;
> --- SQL operation complete.
> >>
> >>select encrypt_i(a) from mytab;
> *** ERROR[4457] An error was encountered processing metadata for user-defined function TRAFODION.MYUDFTEST.ENCRYPT_I.  Details: User-defined functions must have at least one registered output value.
> *** ERROR[8822] The statement was not prepared.
> >>
> >>drop function ENCRYPT_I cascade;
> --- SQL operation complete.
> >>drop library myudflib cascade;
> --- SQL operation complete.
> >>drop schema MYUDFTEST cascade;
> --- SQL operation complete.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)