[
https://issues.apache.org/jira/browse/TRAFODION-1112?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Selvaganesan Govindarajan updated TRAFODION-1112:
-------------------------------------------------
Fix Version/s: (was: 2.3)
2.4
> 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.4
>
>
> 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
(v8.3.4#803005)
