[
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)
