Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-3043

'Schema <schemaname> does not exist' when constraint used in table definition

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.1.4
    • Fix Version/s: 10.4.2.1, 10.5.1.1
    • Component/s: SQL
    • Labels:
      None
    • Environment:
      Mac OS 10

      Description

      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_BLOGSUSERS(PK INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,username VARCHAR(16) NOT NULL CONSTRAINT BLOGSCOMBLOGSUSERS_UNIQUE_username UNIQUE CONSTRAINT BLOGSCOMBLOGS_USERS_PASSWORD_username CHECK(LENGTH(username)>7),password VARCHAR (32672) NOT NULL , PRIMARY KEY(PK));

        Attachments

        1. reorderWorkaroundTests.diff
          5 kB
          Bryan Pendleton
        2. setSchemaName.diff
          0.8 kB
          Bryan Pendleton
        3. tempTableTest.diff
          1 kB
          Bryan Pendleton
        4. withSimpleTest.diff
          5 kB
          Bryan Pendleton

          Issue Links

            Activity

              People

              • Assignee:
                bryanpendleton Bryan Pendleton
                Reporter:
                geoff_hendrey geoff hendrey
              • Votes:
                0 Vote for this issue
                Watchers:
                0 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: