[
https://issues.apache.org/jira/browse/TRAFODION-1793?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Work on TRAFODION-1793 started by Anoop Sharma.
-----------------------------------------------
> 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
> Assignee: Anoop Sharma
>
> 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)
