[jira] [Assigned] (TRAFODION-1112) LP Bug: 1438888 - Error message incorrect when describing non existing procedure

["Suresh Subbiah (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/TRAFODION-1112?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Suresh Subbiah reassigned TRAFODION-1112:
-----------------------------------------

    Assignee: Suresh Subbiah

> LP Bug: 1438888 - Error message incorrect when describing non existing procedure
> --------------------------------------------------------------------------------
>
>                 Key: TRAFODION-1112
>                 URL: https://issues.apache.org/jira/browse/TRAFODION-1112
>             Project: Apache Trafodion
>          Issue Type: Bug
>          Components: sql-security
>            Reporter: Paul Low
>            Assignee: Suresh Subbiah
>            Priority: Minor
>             Fix For: 2.0-incubating
>
>
> Minor issue.
> Users may be confused by  the error message that returns when trying to execute 'showddl procedure T1' when T1 is not a procedure.
> T1 does not exist as a procedure, but T1 does exist as a table object.
> The text in the error message is technically incorrect because object T1 does exist, just not as a procedure.
> SQL>create schema schema1;
> --- SQL operation complete.
> SQL>set schema schema1;
> --- SQL operation complete.
> SQL>create table t1 (c1 int not null primary key, c2 int);
> --- SQL operation complete.
> SQL>grant select on table t1 to qauser_sqlqaa;
> --- SQL operation complete.
> SQL>showddl procedure t1;
> *** ERROR[1389] Object T1 does not exist in Trafodion. 
> *** ERROR[4082] Object TRAFODION.SCHEMA1.T1 does not exist or is inaccessible
> SQL>drop schema schema1 cascade;
> --- SQL operation complete.



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