[
https://issues.apache.org/jira/browse/SQOOP-1823?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14232260#comment-14232260
]
Jarek Jarcec Cecho commented on SQOOP-1823:
-------------------------------------------
I've actually went through the exercise to get latest derby repository and
tried to see the table structure using {{ij}} utility, just to find out that
there is no way how to get the foreign key configuration from Derby back (or at
least I did not find that way :(). Based on the queries it seems that you are
correct and hence +1 n the patch.
> Sqoop2: Fix Derby schema documenation
> -------------------------------------
>
> Key: SQOOP-1823
> URL: https://issues.apache.org/jira/browse/SQOOP-1823
> Project: Sqoop
> Issue Type: Bug
> Components: sqoop2-derby-repository
> Affects Versions: 1.99.4
> Reporter: Abraham Elmahrek
> Assignee: Abraham Elmahrek
> Fix For: 1.99.5
>
> Attachments: SQOOP-1823.0.patch
>
>
> There are a few places where there foreign keys are inaccurately listed. For
> example:
> {noformat}
> * +------------------------------+
> * | SQ_CONNECTOR_DIRECTIONS |
> * +------------------------------+
> * | SQCD_ID: BIGINT PK AUTO-GEN |
> * | SQCD_CONNECTOR: BIGINT |FK SQCD_CONNECTOR(SQC_ID)
> * | SQCD_DIRECTION: BIGINT |FK SQCD_DIRECTION(SQD_ID)
> * +------------------------------+
> {noformat}
> In the above snippet, FK SQCD_CONNECTOR(SQC_ID) should be FK
> _SQ_CONFIGURABLE(SQC_ID).
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
