[ 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
