Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <1604244997.1223870864739.JavaMail.jira@brutus>
Date: Sun, 12 Oct 2008 21:07:44 -0700 (PDT)
From: "Bryan Pendleton (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Commented: (DERBY-3043) 'Schema <schemaname> does not exist'
 when constraint used in table definition
In-Reply-To: <15248416.1188842475792.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit


    [ https://issues.apache.org/jira/browse/DERBY-3043?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12638939#action_12638939 ] 

Bryan Pendleton commented on DERBY-3043:
----------------------------------------

Here's the stack trace I get with the current trunk:

ERROR 42Y07: Schema 'BRY' does not exist
    at org.apache.derby.iapi.error.StandardException.newException(StandardException.java:286)
    at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(DataDictionaryImpl.java:1487)
    at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(QueryTreeNode.java:1329)
    at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(QueryTreeNode.java:1262)
    at org.apache.derby.impl.sql.compile.TableName.bind(TableName.java:238)
    at org.apache.derby.impl.sql.compile.FromBaseTable.getMatchingColumn(FromBaseTable.java:2533)
    at org.apache.derby.impl.sql.compile.FromList.bindColumnReference(FromList.java:602)
    at org.apache.derby.impl.sql.compile.ColumnReference.bindExpression(ColumnReference.java:349)
    at org.apache.derby.impl.sql.compile.UnaryOperatorNode.bindOperand(UnaryOperatorNode.java:333)
    at org.apache.derby.impl.sql.compile.DB2LengthOperatorNode.bindExpression(DB2LengthOperatorNode.java:84)
    at org.apache.derby.impl.sql.compile.BinaryOperatorNode.bindExpression(BinaryOperatorNode.java:298)
    at org.apache.derby.impl.sql.compile.BinaryComparisonOperatorNode.bindExpression(BinaryComparisonOperatorNode.java:133)
    at org.apache.derby.impl.sql.compile.TableElementList.bindAndValidateCheckConstraints(TableElementList.java:556)
    at org.apache.derby.impl.sql.compile.CreateTableNode.bindStatement(CreateTableNode.java:448)
    at org.apache.derby.impl.sql.GenericStatement.prepMinion(GenericStatement.java:314)
    at org.apache.derby.impl.sql.GenericStatement.prepare(GenericStatement.java:88)
    at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(GenericLanguageConnectionContext.java:796)
    at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:606)
    at org.apache.derby.impl.jdbc.EmbedStatement.execute(EmbedStatement.java:555)
    at org.apache.derby.impl.tools.ij.ij.executeImmediate(ij.java:329)
    at org.apache.derby.impl.tools.ij.utilMain.doCatch(utilMain.java:508)
    at org.apache.derby.impl.tools.ij.utilMain.runScriptGuts(utilMain.java:350)
    at org.apache.derby.impl.tools.ij.utilMain.go(utilMain.java:248)
    at org.apache.derby.impl.tools.ij.Main.go(Main.java:215)
    at org.apache.derby.impl.tools.ij.Main.mainCore(Main.java:181)
    at org.apache.derby.impl.tools.ij.Main.main(Main.java:73)
    at org.apache.derby.tools.ij.main(ij.java:59)


> 'Schema <schemaname> does not exist' when constraint used in table definition
> -----------------------------------------------------------------------------
>
>                 Key: DERBY-3043
>                 URL: https://issues.apache.org/jira/browse/DERBY-3043
>             Project: Derby
>          Issue Type: Bug
>          Components: SQL
>    Affects Versions: 10.3.1.4
>         Environment: Mac OS 10
>            Reporter: geoff hendrey
>            Assignee: Bryan Pendleton
>
> https://issues.apache.org/jira/browse/DERBY-568#action_12524420
> In the response to my original comment post, which you can find via the permalink above, I was encouraged to file this as a new issue.
> verified this back to 10.1.2.1 with the following ij script.
> connect 'jdbc:derby:wombat;create=true;user=blogs';
> CREATE TABLE BLOGSCOM__BLOGS__USERS(PK INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,username VARCHAR(16) NOT NULL CONSTRAINT BLOGSCOM__BLOGS__USERS_UNIQUE_username UNIQUE CONSTRAINT BLOGSCOM__BLOGS__USERS_PASSWORD_username CHECK(LENGTH(username)>7),password VARCHAR (32672) NOT NULL , PRIMARY KEY(PK));

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.