new definition of udf not being picked up after drop/recreate

[Aruna Sadashiva]

When a function is dropped and new one with the same name but different defn. is created it is not picked by.
This is from trafci:

SQL>cqd allow_udf 'on';
--- SQL operation complete.

SQL>create function ADD2(int, char) returns (ADD2 int)
language c parameter style sql external name 'add2'
library TEST107;
--- SQL operation complete.

SQL>values(add2(1,'a'));
ADD2
-----------
         98
--- 1 row(s) selected.

SQL>values(add2(2,'abc'));
*** ERROR[8402] A string overflow occurred during the evaluation of a character expression. Conversion of Source Type:CHAR(REC_BYTE_F_ASCII) Source Value:abc to Target Type:CHAR(REC_BYTE_F_ASCII). [2014-05-30 07:16:41]

SQL>values(add2(3,40));
*** ERROR[4455] The supplied type for input value 2 of user-defined function TRAFODION.UDF_FUNCTIONS.ADD2 was NUMERIC(2) SIGNED which is not compatible with the expected type CHAR(1) CHARACTER SET ISO88591. [2014-05-30 07:16:41]

SQL>drop function add2;
--- SQL operation complete.
SQL>control query default query_cache '0';
--- SQL operation complete.
SQL>control query default query_cache reset;
--- SQL operation complete.
SQL>control query default COMP_BOOL_215 reset;
--- SQL operation complete.
SQL>control query default ROUTINE_CACHE_SIZE reset;
--- SQL operation complete.
SQL>create function ADD2(int,int) returns (ADD2 int)
language c parameter style sql external name 'add2'
library TEST107;
--- SQL operation complete.

SQL>values(add2(-1,NULL));
ADD2
-----------
       NULL
--- 1 row(s) selected.

SQL>values(add2(2,3.9997));
*** ERROR[4455] The supplied type for input value 2 of user-defined function TRAFODION.UDF_FUNCTIONS.ADD2 was NUMERIC(5,4) SIGNED which is not compatible with the expected type CHAR(1) CHARACTER SET ISO88591. [2014-05-30 07:16:42]

SQL>values(add2(3,'x'));
ADD2
-----------
        123
--- 1 row(s) selected.

SQL>drop function add2;
--- SQL operation complete.

[Cliff Gray (cliff-gray)]

Fixed as of change 1296.