[ http://issues.apache.org/jira/browse/DERBY-2030?page=all ]
Andrew McIntyre updated DERBY-2030:
-----------------------------------
Attachment: derby-2030-v1.diff
Thanks for the review Bryan, I was just capturing the little patch that I
posted for Oystein on the list in this JIRA.
Attaching a complete patch that updates ij7.sql to include a testcase for this
issue. I'll commit this shortly if there are no further comments.
Just a note, in the future, it might be nice to have the syntax:
SHOW [ SYSTEM ] TABLES
and then take the system tables out of the results returned by default for SHOW
TABLES, but that enhancement should be handled in a different JIRA.
> 'set schema sys' followed by 'show tables' does not show tables in sys schema
> -----------------------------------------------------------------------------
>
> Key: DERBY-2030
> URL: http://issues.apache.org/jira/browse/DERBY-2030
> Project: Derby
> Issue Type: Bug
> Components: Tools
> Affects Versions: 10.2.1.6, 10.3.0.0
> Reporter: Andrew McIntyre
> Assigned To: Andrew McIntyre
> Priority: Minor
> Attachments: derby-2030-v1.diff, ij_showalltables.diff
>
>
> If you create a new database in IJ, followed by 'set schema sys' and then
> 'show tables', ij shows no tables in the schema. This is because ij's show
> tables command only shows system tables if a schema is provided.
--
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
