Error message incorrect when describing non existing procedure

Bug #1438888 reported by Paul Low
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Trafodion
New
Low
Unassigned

Bug 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.

Tags: sql-security
Paul Low (paul-low-x)
Changed in trafodion:
milestone: none → r1.2
To post a comment you must log in.
This report contains Public information  
Everyone can see this information.

Other bug subscribers

Remote bug watches

Bug watches keep track of this bug in other bug trackers.