db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew McIntyre (JIRA)" <derby-...@db.apache.org>
Subject [jira] Commented: (DERBY-1666) Show Views and Show Synonyms has confusing column names in results
Date Thu, 10 Aug 2006 19:55:14 GMT
    [ http://issues.apache.org/jira/browse/DERBY-1666?page=comments#action_12427333 ] 
            
Andrew McIntyre commented on DERBY-1666:
----------------------------------------

These are names of the columns in the result set returned from DatabaseMetaData.getTables.
Having just read through all of this code, the fix could be to pass the desired column names
to ijResultSetResult from the parser in ij.showTables and then JDBCDisplayUtil could check
for column name overrides when displaying an ijResultSetResult.

> Show Views and Show Synonyms has confusing column names in results
> ------------------------------------------------------------------
>
>                 Key: DERBY-1666
>                 URL: http://issues.apache.org/jira/browse/DERBY-1666
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions: 10.2.0.0
>            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.
-
If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

Mime
View raw message