Details
Description
This is possibly related to Bug https://issues.apache.org/jira/browse/DERBY-1304.
Use ij to execute the following statements:
CREATE SCHEMA datamgmt;
CREATE PROCEDURE datamgmt.exit ( IN value INTEGER )
MODIFIES SQL DATA
PARAMETER STYLE JAVA
LANGUAGE JAVA
EXTERNAL NAME 'java.lang.System.exit'
;
DROP PROCEDURE datamgmt.exit;
DROP SCHEMA datamgmt RESTRICT;
Then execute exactly the same lines once again. Then statement "DROP PROCEDURE datamgmt.exit" yields:
ERROR 42X94: PROCEDURE 'EXIT' does not exist.
However, if the DROP works if a default schema (SET SCHEMA) is used instead of the prefixed schemaName. That is, the following lines can be executed more than once in a row:
CREATE SCHEMA datamgmt;
CREATE PROCEDURE datamgmt.exit ( IN value INTEGER )
MODIFIES SQL DATA
PARAMETER STYLE JAVA
LANGUAGE JAVA
EXTERNAL NAME 'java.lang.System.exit'
;
SET SCHEMA datamgmt;
DROP PROCEDURE exit;
DROP SCHEMA datamgmt RESTRICT;
Therefore, SET SCHEMA can be used as a workaround, hence minor importance.