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

• Type: Bug
• Status: Closed
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 10.2.1.6, 10.3.1.4
• Fix Version/s: 10.2.2.0, 10.3.1.4
• Component/s: Tools
• Assignee: Samuel Andrew McIntyre
• Reporter: Samuel Andrew McIntyre
• Created: 02/Nov/06 05:52
• Updated: 14/Nov/06 02:36
• Resolved: 14/Nov/06 02:36

Description

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.