Venkat Muthuswamy created TRAFODION-1793:
--------------------------------------------
Summary: GET commands that report usage information should return
3 or 2 part ansi object names
Key: TRAFODION-1793
URL: https://issues.apache.org/jira/browse/TRAFODION-1793
Project: Apache Trafodion
Issue Type: Bug
Reporter: Venkat Muthuswamy
Let's see we create a view that joins 2 tables from different schemas.
CREATE VIEW TRAFODION.SCH.V1 AS
SELECT 1 AS Z FROM TRAFODION.SCH.T, TRAFODION.SEABASE.T ;
Now if we try to get the tables used by V1 using this command, it just returns
the object names and it is difficult to say which object is which since the
schema information is missing.
get tables in view v1;
It returns :
>>get tables in view v1;
Tables in View SCH.V1
=====================
T
T
It would be good if the GET commands can return the 3 or 2 part ansi name of
the object.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
