You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Andrew McIntyre (JIRA)" <ji...@apache.org> on 2006/11/14 03:37:39 UTC

[jira] Closed: (DERBY-2030) 'set schema sys' followed by 'show tables' does not show tables in sys schema

     [ http://issues.apache.org/jira/browse/DERBY-2030?page=all ]

Andrew McIntyre closed DERBY-2030.
----------------------------------


> '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
>             Fix For: 10.2.1.8, 10.3.0.0
>
>         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