db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Rick Hillegas (JIRA)" <j...@apache.org>
Subject [jira] [Updated] (DERBY-6661) dblook does not recognize the deferrability of deferrable constraints
Date Tue, 15 Jul 2014 19:15:06 GMT

     [ https://issues.apache.org/jira/browse/DERBY-6661?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel

Rick Hillegas updated DERBY-6661:

    Attachment: derby-6661-01-aa-recreateDeferrableConstraints.diff

Attaching derby-6661-01-aa-recreateDeferrableConstraints.diff. This patch adds dblook support
for deferrable constraints. I will run tests.

Touches the following files:


M       java/tools/org/apache/derby/impl/tools/dblook/DB_Check.java
M       java/tools/org/apache/derby/impl/tools/dblook/DB_Key.java
M       java/engine/org/apache/derby/impl/sql/catalog/SYSCONSTRAINTSRowFactory.java

Adds code to dblook to handle deferrable constraints. I had to clone some code in the DataDictionary
because the code can't be shared today due to the way we factor Derby into jar files. We expect
that dblook can be run client-side without an engine jar file.


A       java/testing/org/apache/derbyTesting/functionTests/tests/tools/Test_6661.java
M       java/testing/org/apache/derbyTesting/functionTests/tests/tools/dblook_test.java
M       java/testing/org/apache/derbyTesting/functionTests/tests/tools/_Suite.java

Adds a test to verify that dblook correctly recreates deferrable primary, unique, foreign,
and check constraints.

> dblook does not recognize the deferrability of deferrable constraints
> ---------------------------------------------------------------------
>                 Key: DERBY-6661
>                 URL: https://issues.apache.org/jira/browse/DERBY-6661
>             Project: Derby
>          Issue Type: Bug
>          Components: Tools
>    Affects Versions:
>            Reporter: Rick Hillegas
>            Assignee: Rick Hillegas
>         Attachments: derby-6661-01-aa-recreateDeferrableConstraints.diff
> If you create a table with a deferrable primary key constraint and then run dblook, the
recreation ddl does not flag the primary key as deferrable. I suspect that this applies to
other kinds of constraints as well.

This message was sent by Atlassian JIRA

View raw message