[ 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)