db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Andrew McIntyre (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2030) 'set schema sys' followed by 'show tables' does not show tables in sys schema
Date Mon, 13 Nov 2006 23:25:38 GMT
     [ 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

        

Mime
View raw message