[jira] [Updated] (DERBY-6661) dblook does not recognize the deferrability of deferrable constraints

["Rick Hillegas (JIRA)" <ji...@apache.org>]

     [ 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: 10.11.0.0
>            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
(v6.2#6252)