You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Knut Anders Hatlen (JIRA)" <ji...@apache.org> on 2011/03/17 09:33:29 UTC
[jira] Created: (DERBY-5139) User schema not auto-created on
creation of self-referencing table
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
[jira] Commented: (DERBY-5139) User schema not auto-created on
creation of self-referencing table
Posted by "Knut Anders Hatlen (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5139?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=13007852#comment-13007852 ]
Knut Anders Hatlen commented on DERBY-5139:
-------------------------------------------
DERBY-5101 added a workaround for this bug in TruncateTableTest (search for the string "DERBY-5139"). The workaround should be removed when the bug has been fixed.
> 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
[jira] [Updated] (DERBY-5139) User schema not auto-created on
creation of self-referencing table
Posted by "Mamta A. Satoor (Updated) (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-5139?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Mamta A. Satoor updated DERBY-5139:
-----------------------------------
Urgency: Normal
Labels: derby_triage10_9 (was: )
> 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
> Labels: derby_triage10_9
>
> 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.
If you think it was sent incorrectly, please contact your JIRA administrators: https://issues.apache.org/jira/secure/ContactAdministrators!default.jspa
For more information on JIRA, see: http://www.atlassian.com/software/jira