Sandhya Sundaresan created TRAFODION-3267:
---------------------------------------------
Summary: Create procedure|function no longer verify that the
library exists
Key: TRAFODION-3267
URL: https://issues.apache.org/jira/browse/TRAFODION-3267
Project: Apache Trafodion
Issue Type: Bug
Components: sql-general
Affects Versions: 2.4
Reporter: Sandhya Sundaresan
Assignee: Sandhya Sundaresan
Fix For: 2.4
In the latest version , create procedure, create table_mapping function, and
create function now all fail to verify that the library actually exists. As
shown below, the create statements now allow the operation to complete even
with a non-existing library 'doesntexist'. This appears to be a regression
introduced in a recent version, as they all still return a proper 1389 error in
earlier version
>>drop schema if exists mytest cascade;
--- SQL operation complete.
>>create schema mytest;
--- SQL operation complete.
>>set schema mytest;
--- SQL operation complete.
>>
>>create procedure myspj()
+>external name 'abcd.myspj'
+>library doesntexist
+>language java
+>parameter style java;
--- SQL operation complete.
>>
>>create table_mapping function mytmudf
+>(test_what char(100),
+>test_parm char(100))
+>external name 'mytmudf'
+>language cpp
+>library doesnotexist;
--- SQL operation complete.
>>
>>create function myudf
+>(INVAL char(50))
+>returns (c_char char(50))
+>language c
+>parameter style sql
+>external name 'myudf'
+>library doesntexist
+>deterministic
+>state area size 1024
+>allow any parallelism
+>no sql;
--- SQL operation complete.
>>
>>drop schema mytest cascade;
--- SQL operation complete.
--
This message was sent by Atlassian JIRA
(v7.6.3#76005)
