You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@trafodion.apache.org by "Suresh Subbiah (JIRA)" <ji...@apache.org> on 2015/08/31 07:37:01 UTC
[jira] [Closed] (TRAFODION-773) LP Bug: 1393950 - Error message for
a nonexistent UDF refers to the NEO catalog
[ https://issues.apache.org/jira/browse/TRAFODION-773?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Suresh Subbiah closed TRAFODION-773.
------------------------------------
Resolution: Fixed
Close issues in JIRA to reflect status in LaunchPad
> 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)