[
https://issues.apache.org/jira/browse/TRAFODION-1902?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Weishiun Tsai closed TRAFODION-1902.
------------------------------------
Resolution: Fixed
This problem has been fixed:
>>create schema mytest200;
--- SQL operation complete.
>>set schema mytest200;
--- SQL operation complete.
>>create library MYLIB file '/home/trafodion/QALibs/UDF/qaUdfTest.so';
--- SQL operation complete.
>>create function MYFUNC
+>(INVAL integer)
+>returns (c_integer integer)
+>language c
+>parameter style sql
+>external name 'qa_func_int32'
+>library MYLIB
+>deterministic
+>state area size 1024
+>allow any parallelism
+>no sql;
--- SQL operation complete.
>>showddl function MYFUNC;
CREATE FUNCTION TRAFODION.MYTEST200.MYFUNC
(
IN INVAL INTEGER SIGNED
)
RETURNS
(
OUT C_INTEGER INTEGER SIGNED
)
EXTERNAL NAME 'qa_func_int32'
LIBRARY TRAFODION.MYTEST200.MYLIB
LANGUAGE C
PARAMETER STYLE SQL
NO SQL
NO FINAL CALL
STATE AREA SIZE 1024
ALLOW ANY PARALLELISM
DETERMINISTIC
SAFE EXECUTION MODE
;
--- SQL operation complete.
>>drop library MYLIB cascade;
--- SQL operation complete.
>>showddl function MYFUNC;
*** ERROR[1389] Object MYFUNC does not exist in Trafodion.
*** ERROR[4082] Object TRAFODION.MYTEST200.MYFUNC does not exist or is
inaccessible.
--- SQL operation failed with errors.
>>drop schema mytest200 cascade;
--- SQL operation complete.
>>showddl function MYFUNC;
*** ERROR[1389] Object MYFUNC does not exist in Trafodion.
*** ERROR[4082] Object TRAFODION.MYTEST200.MYFUNC does not exist or is
inaccessible.
--- SQL operation failed with errors.
>>drop function MYFUNC;
*** ERROR[1389] Object TRAFODION.MYTEST200.MYFUNC does not exist in Trafodion.
--- SQL operation failed with errors.
>>showddl function MYFUNC;
*** ERROR[1389] Object MYFUNC does not exist in Trafodion.
*** ERROR[4082] Object TRAFODION.MYTEST200.MYFUNC does not exist or is
inaccessible.
--- SQL operation failed with errors.
> Showddl continues to show function after it's dropped
> -----------------------------------------------------
>
> Key: TRAFODION-1902
> URL: https://issues.apache.org/jira/browse/TRAFODION-1902
> Project: Apache Trafodion
> Issue Type: Bug
> Components: sql-cmu
> Affects Versions: 2.0-incubating
> Reporter: Weishiun Tsai
> Assignee: Roberta Marton
>
> As shown in the following execution output, showddl continues to show the
> function even after 'drop library cascade', 'drop schema cascade', or even
> 'drop function' itself. Any of the 3 statements should have dropped the
> function.
> >>create schema mytest200;
>
> --- SQL operation complete.
> >>set schema mytest200;
>
> --- SQL operation complete.
> >>
> >>create library MYLIB file '/home/trafodion/QALibs/UDF/qaUdfTest.so';
>
> --- SQL operation complete.
> >>
> >>create function MYFUNC
> +>(INVAL integer)
> +>returns (c_integer integer)
> +>language c
> +>parameter style sql
> +>external name 'qa_func_int32'
> +>library MYLIB
> +>deterministic
> +>state area size 1024
> +>allow any parallelism
> +>no sql;
>
> --- SQL operation complete.
> >>
> >>showddl function MYFUNC;
>
> CREATE FUNCTION TRAFODION.MYTEST200.MYFUNC
> (
> IN INVAL INTEGER SIGNED
> )
> RETURNS
> (
> OUT C_INTEGER INTEGER SIGNED
> )
> EXTERNAL NAME 'qa_func_int32'
> LIBRARY TRAFODION.MYTEST200.MYLIB
> LANGUAGE C
> PARAMETER STYLE SQL
> NO SQL
> NO FINAL CALL
> STATE AREA SIZE 1024
> ALLOW ANY PARALLELISM
> DETERMINISTIC
> SAFE EXECUTION MODE
> ;
>
> --- SQL operation complete.
> >>
> >>drop library MYLIB cascade;
>
> --- SQL operation complete.
> >>showddl function MYFUNC;
>
> CREATE FUNCTION TRAFODION.MYTEST200.MYFUNC
> (
> IN INVAL INTEGER SIGNED
> )
> RETURNS
> (
> OUT C_INTEGER INTEGER SIGNED
> )
> EXTERNAL NAME 'qa_func_int32'
> LIBRARY TRAFODION.MYTEST200.MYLIB
> LANGUAGE C
> PARAMETER STYLE SQL
> NO SQL
> NO FINAL CALL
> STATE AREA SIZE 1024
> ALLOW ANY PARALLELISM
> DETERMINISTIC
> SAFE EXECUTION MODE
> ;
>
> --- SQL operation complete.
> >>
> >>drop schema mytest200 cascade;
>
> --- SQL operation complete.
> >>showddl function MYFUNC;
>
> CREATE FUNCTION TRAFODION.MYTEST200.MYFUNC
> (
> IN INVAL INTEGER SIGNED
> )
> RETURNS
> (
> OUT C_INTEGER INTEGER SIGNED
> )
> EXTERNAL NAME 'qa_func_int32'
> LIBRARY TRAFODION.MYTEST200.MYLIB
> LANGUAGE C
> PARAMETER STYLE SQL
> NO SQL
> NO FINAL CALL
> STATE AREA SIZE 1024
> ALLOW ANY PARALLELISM
> DETERMINISTIC
> SAFE EXECUTION MODE
> ;
>
> --- SQL operation complete.
> >>
> >>drop function MYFUNC;
>
> *** ERROR[1389] Object TRAFODION.MYTEST200.MYFUNC does not exist in Trafodion.
>
> --- SQL operation failed with errors.
> >>showddl function MYFUNC;
>
> CREATE FUNCTION TRAFODION.MYTEST200.MYFUNC
> (
> IN INVAL INTEGER SIGNED
> )
> RETURNS
> (
> OUT C_INTEGER INTEGER SIGNED
> )
> EXTERNAL NAME 'qa_func_int32'
> LIBRARY TRAFODION.MYTEST200.MYLIB
> LANGUAGE C
> PARAMETER STYLE SQL
> NO SQL
> NO FINAL CALL
> STATE AREA SIZE 1024
> ALLOW ANY PARALLELISM
> DETERMINISTIC
> SAFE EXECUTION MODE
> ;
>
> --- SQL operation complete.
> =========================================================
> Here is the entire script tor reproduce this problem:
> log mytest.log clear;
> create schema mytest200;
> set schema mytest200;
> create library MYLIB file '/home/trafodion/QALibs/UDF/qaUdfTest.so';
> create function MYFUNC
> (INVAL integer)
> returns (c_integer integer)
> language c
> parameter style sql
> external name 'qa_func_int32'
> library MYLIB
> deterministic
> state area size 1024
> allow any parallelism
> no sql;
> showddl function MYFUNC;
> drop library MYLIB cascade;
> showddl function MYFUNC;
> drop schema mytest200 cascade;
> showddl function MYFUNC;
> drop function MYFUNC;
> showddl function MYFUNC;
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
