[jira] [Created] (TRAFODION-773) LP Bug: 1393950 - Error message for a nonexistent UDF refers to the NEO catalog

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

Alice Chen created TRAFODION-773:
------------------------------------

             Summary: LP Bug: 1393950 - Error message for a nonexistent UDF refers to the NEO catalog
                 Key: TRAFODION-773
                 URL: https://issues.apache.org/jira/browse/TRAFODION-773
             Project: Apache Trafodion
          Issue Type: Bug
          Components: sql-exe
            Reporter: Weishiun Tsai
            Assignee: Cliff Gray


When referencing a UDF that does not exist, SQL would try to search for a ‘global one’ beyond the default schema.  The error message refers to the NEO catalog in this case.

This is seen on the v1115_0830 build installed on a workstation.

--------------------------------------------------------------------------------------------------------------------
Here is the entire script to reproduce it (there is no need to install UDF to reproduce this problem):

set schema mytest;
create table t (a int);
insert into t values (1);
select ABCD(a) from t;
drop schema mytest cascade;

--------------------------------------------------------------------------------------------------------------------
Here is the execution output:

>>set schema mytest;

--- SQL operation complete.
>>create table t (a int);

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

--- 1 row(s) inserted.
>>select ABCD(a) from t;

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

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

*** ERROR[4450] Function TRAFODION.MYTEST.ABCD is not a built-in function or registered user-defined function.

*** ERROR[4450] Function NEO.UDF.ABCD is not a built-in function or registered user-defined function.

*** ERROR[8822] The statement was not prepared.

>>drop schema mytest cascade;

--- SQL operation complete.



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