[DERBY-5139] User schema not auto-created on creation of self-referencing table

• Type: Bug
• Status: Open
• Priority: Major
• Resolution: Unresolved
• Affects Version/s: 10.7.1.1
• Component/s: SQL
• Labels: derby_triage10_9
• Urgency: Normal
• Issue & fix info: Repro attached
• Assignee: Unassigned
• Reporter: Knut Anders Hatlen
• Created: 17/Mar/11 08:33
• Updated: 06/Mar/14 00:05

Description

The schema for the current user is usually auto-created on the first DDL operation if it doesn't already exist. If the DDL is a CREATE TABLE statement that creates a self-referencing table, however, the schema is not created, and the CREATE TABLE statement fails:

ij version 10.7
ij> connect 'jdbc:derby:testdb;create=true;user=alice';
ij> create table self_referencing_t1(x int primary key, y int references self_referencing_t1);
ERROR 42Y07: Schema 'ALICE' does not exist

Issue Links

• Is contained by: DERBY-6498 Derby does not always automatically create a user's schema
• is related to: DERBY-5101 TruncateTableTest depends on implicit ordering of test cases
• is related to: DERBY-6361 Valid statements rejected if Derby has not implicitly created the current user's schema.