[
https://issues.apache.org/jira/browse/DERBY-1666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Jazarine Jamal reassigned DERBY-1666:
-------------------------------------
Assignee: Jazarine Jamal
i JUST STARTED WORKING ON THE BUG..
> Show Views and Show Synonyms has confusing column names in results
> ------------------------------------------------------------------
>
> Key: DERBY-1666
> URL: https://issues.apache.org/jira/browse/DERBY-1666
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.2.1.6
> Reporter: David Van Couvering
> Assignee: Jazarine Jamal
> Priority: Minor
>
> When you run SHOW VIEWS and SHOW SYNONYMS, the column names are confusing.
> They use TABLE_SCHEM and TABLE_NAME instead of VIEW_SCHEM/VIEW_NAME and
> SYNONYM_SCHEM/SYONYM_NAME
> === Examples ===
> ij> show views;
> TABLE_SCHEM |TABLE_NAME |REMARKS
> ------------------------------------------------------------------------
> APP |AA_FLIGHTS |
> ij> show synonyms;
> TABLE_SCHEM |TABLE_NAME |REMARKS
> ------------------------------------------------------------------------
> APP |COLUMNS |
> APP |TRIGGERS |
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
