db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-1666) Show Views and Show Synonyms has confusing column names in results
Date Thu, 09 Jul 2009 11:03:16 GMT

     [ https://issues.apache.org/jira/browse/DERBY-1666?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

Knut Anders Hatlen updated DERBY-1666:
--------------------------------------

    Issue & fix info: [Known fix, Newcomer, Repro attached]
             Urgency: Normal
          Issue Type: Improvement  (was: Bug)

Triaged for 10.5.2. Reclassifying from bug to improvement.

> 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: Improvement
>          Components: Tools
>    Affects Versions: 10.2.1.6
>            Reporter: David Van Couvering
>            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.


Mime
View raw message