[DERBY-4101] Further improvements to schema <schemaname> does not exist fix - DERBY-3043

• Type: Improvement
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.5.1.1
• Component/s: SQL
• Labels: derby_triage10_10
• Urgency: Normal
• Assignee: Unassigned
• Reporter: Myrna van Lunteren
• Created: 18/Mar/09 03:51
• Updated: 30/Sep/12 01:36

Description

DERBY-3043 was fixed, but a number of comments were raised, specifically because of meshing code from the fix of DERBY-3266, that warrant follow-up:

instead of current code, make another overload of getSchemaDescriptor(<int:tabletype>) and use that
consistently in CreateTableNode and DropTableNode.

Issue Links

• relates to: DERBY-3043 'Schema <schemaname> does not exist' when constraint used in table definition
• relates to: DERBY-3266 Not possible for non-db-owner to create a temporary table. "Get ERROR 42507: User 'USERB' can not perform the operation in schema 'SESSION'."