[jira] [Created] (TRAFODION-1007) LP Bug: 1421438 - UDF: showddl does not work for UDFs

["Alice Chen (JIRA)" <ji...@apache.org>]

Alice Chen created TRAFODION-1007:
-------------------------------------

             Summary: LP Bug: 1421438 - UDF: showddl does not work for UDFs
                 Key: TRAFODION-1007
                 URL: https://issues.apache.org/jira/browse/TRAFODION-1007
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-cmu
            Reporter: Weishiun Tsai
            Assignee: Suresh Subbiah
             Fix For: 1.1 (pre-incubation)


Showddl is supposed to be enhanced for supporting UDF.  But it does not work right now, as shown below.  This is seen on the v0210
build installed on a workstation.

To reproduce this problem:

(1) Download the attached tar file and untar it to get the 4 files in there. Put the 4 files in any directory <mydir>
(2) Run build.sh from <mydir> to build the UDF so file.
(3) Change the line ‘create library qa_udf_lib file '<mydir>/myudf.so'; in mytest.sql and fill in <mydir>
(4) From sqlci, obey mytest.sql

-------------------------------------------

>>obey mytest.sql;
>>create schema mytest;

--- SQL operation complete.
>>set schema mytest;

--- SQL operation complete.
>>
>>create library qa_udf_lib file '<mydir>/myudf.so';

--- SQL operation complete.
>>
>>create function MYUDF
+>(INVAL int)
+>returns (OUTVAL int)
+>language c
+>parameter style sql
+>external name 'myudf'
+>library qa_udf_lib
+>deterministic
+>state area size 1024
+>allow any parallelism
+>no sql;

--- SQL operation complete.
>>
>>create table mytable (a int, b int);

--- SQL operation complete.
>>insert into mytable values (1,1);

--- 1 row(s) inserted.
>>
>>select myudf(a) from mytable;

OUTVAL
-----------

          1

--- 1 row(s) selected.
>>
>>showddl function myudf;

*** ERROR[1389] Object MYUDF does not exist in Trafodion.

*** ERROR[4082] Object TRAFODION.MYTEST.MYUDF does not exist or is inaccessible.

--- SQL operation failed with errors.
>>showddl myudf;

*** ERROR[1389] Object MYUDF does not exist in Trafodion.

*** ERROR[4082] Object TRAFODION.MYTEST.MYUDF does not exist or is inaccessible.

--- SQL operation failed with errors.
>>showddl schema mytest;

CREATE PRIVATE SCHEMA "TRAFODION"."MYTEST" AUTHORIZATION "DB__ROOT";

--- SQL operation complete.
>>get functions;

Functions in Schema TRAFODION.MYTEST
====================================

MYUDF

--- SQL operation complete.
>>
>>drop schema mytest cascade;

--- SQL operation complete.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)