db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Created: (DERBY-5139) User schema not auto-created on creation of self-referencing table
Date Thu, 17 Mar 2011 08:33:29 GMT
User schema not auto-created on creation of self-referencing table
------------------------------------------------------------------

                 Key: DERBY-5139
                 URL: https://issues.apache.org/jira/browse/DERBY-5139
             Project: Derby
          Issue Type: Bug
          Components: SQL
    Affects Versions: 10.7.1.1
            Reporter: Knut Anders Hatlen


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

--
This message is automatically generated by JIRA.
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message