[ 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)