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/02 06:54:16 UTC
[jira] Created: (DERBY-2030) 'set schema sys' followed by 'show
tables' does not show tables in sys schema
'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: 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
[jira] Resolved: (DERBY-2030) 'set schema sys' followed by 'show
tables' does not show tables in sys schema
Posted by "Andrew McIntyre (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2030?page=all ]
Andrew McIntyre resolved DERBY-2030.
------------------------------------
Fix Version/s: 10.2.1.8
10.3.0.0
Resolution: Fixed
Derby Info: (was: [Patch Available])
Committed to trunk with revision 474628 and 10.2 with revision 474630.
> '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
[jira] Updated: (DERBY-2030) 'set schema sys' followed by 'show
tables' does not show tables in sys schema
Posted by "Andrew McIntyre (JIRA)" <ji...@apache.org>.
[ 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
[jira] Commented: (DERBY-2030) 'set schema sys' followed by 'show
tables' does not show tables in sys schema
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2030?page=comments#action_12449527 ]
Bryan Pendleton commented on DERBY-2030:
----------------------------------------
Hi Andrew, the new patch looks great to me. I was able to run the new test both with and without your code change and got the expected results. +1 to your patch, and +1 to your idea about an alternate syntax to let the user control the system table behavior, too.
> '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
[jira] Closed: (DERBY-2030) 'set schema sys' followed by 'show
tables' does not show tables in sys schema
Posted by "Andrew McIntyre (JIRA)" <ji...@apache.org>.
[ 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
[jira] Commented: (DERBY-2030) 'set schema sys' followed by 'show
tables' does not show tables in sys schema
Posted by "Bryan Pendleton (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2030?page=comments#action_12447157 ]
Bryan Pendleton commented on DERBY-2030:
----------------------------------------
Hi Andrew, I applied the patch and it seems to work fine for me. I can see the behavior changes and they are as I expected. I think the new behavior is reasonable.
Are there no tests for this feature in our test suite? I was a little bit surprised that there were no test changes in this patch.
> '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: 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
[jira] Updated: (DERBY-2030) 'set schema sys' followed by 'show
tables' does not show tables in sys schema
Posted by "Andrew McIntyre (JIRA)" <ji...@apache.org>.
[ http://issues.apache.org/jira/browse/DERBY-2030?page=all ]
Andrew McIntyre updated DERBY-2030:
-----------------------------------
Attachment: ij_showalltables.diff
Attaching simple patch to take care of this issue. Need to also investigate whether we should show other table types if no schema is provided.
> '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: 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