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

• Type: Bug
• Status: Open
• Priority: Minor
• Resolution: Unresolved
• Fix Version/s: 2.4
• Component/s: sql-security
• External issue URL: https://bugs.launchpad.net/bugs/1438888
• Assignee: Suresh Subbiah
• Reporter: Paul Low
• Created: 22/Jul/15 18:19
• Updated: 16/Apr/20 02:20

Description

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.