[#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:

Andrew McIntyre made changes - 02/Nov/06 05:53 AM

Field	Original Value	New Value
Attachment		ij_showalltables.diff [ 12344153 ]

Andrew McIntyre made changes - 13/Nov/06 11:23 PM

Attachment

derby-2030-v1.diff [ 12344928 ]

Andrew McIntyre made changes - 14/Nov/06 02:36 AM

Fix Version/s		10.2.1.8 [ 12312096 ]
Resolution		Fixed [ 1 ]
Fix Version/s		10.3.0.0 [ 12310800 ]
Derby Info	[Patch Available]
Status	Open [ 1 ]	Resolved [ 5 ]

Andrew McIntyre made changes - 14/Nov/06 02:36 AM

Status

Resolved [ 5 ]

Closed [ 6 ]