[#DERBY-2030] 'set schema sys' followed by 'show tables' does not show tables in sys schema

Derby

'set schema sys' followed by 'show tables' does not show tables in sys schema

Created: 02/Nov/06 05:52 AM Updated: 14/Nov/06 02:36 AM

Return to search

Component/s:

Tools

Affects Version/s:

10.2.1.6, 10.3.1.4

Fix Version/s:

10.2.2.0, 10.3.1.4

Time Tracking:

Not Specified

File Attachments:

File Name	Date Attached	Attached By	Size
derby-2030-v1.diff	2006-11-13 11:23 PM	Andrew McIntyre	6 kB
ij_showalltables.diff	2006-11-02 05:53 AM	Andrew McIntyre	0.7 kB

Resolution Date:

14/Nov/06 02:36 AM

Description

« Hide

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.

All

Comments

Work Log

Change History

Subversion Commits

Sort Order:

No work has yet been logged on this issue.