You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@sqoop.apache.org by "Veena Basavaraj (JIRA)" <ji...@apache.org> on 2015/03/31 01:06:53 UTC

[jira] [Comment Edited] (SQOOP-2250) Sqoop2: SQ_LINK_INPUT is missing a foreign key constraint

    [ https://issues.apache.org/jira/browse/SQOOP-2250?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14387441#comment-14387441 ] 

Veena Basavaraj edited comment on SQOOP-2250 at 3/30/15 11:06 PM:
------------------------------------------------------------------

I am no expert, but as per the comment I swapped the AND, did not get time to look at it since i figured its a trivial swap, does not look like, I am busy otherwise, I will try to look at it. b/w patch-1 and patch-2, I am not sure if it makes much of difference in performance ( or rather was it merely stylistic, readability improvement?), again I am no sql expert.


was (Author: vybs):
I am no expert, but as per the comment I swapped the AND, did not get time to look at it since i figured its a trivial swap, does not look like, I am busy otherwise, I will try to look at it. b/w patch-1 and patch-2, I am not sure if it makes much of difference, again I am no sql expert.

> Sqoop2: SQ_LINK_INPUT is missing a foreign key constraint
> ---------------------------------------------------------
>
>                 Key: SQOOP-2250
>                 URL: https://issues.apache.org/jira/browse/SQOOP-2250
>             Project: Sqoop
>          Issue Type: Improvement
>          Components: sqoop2-derby-repository
>    Affects Versions: 1.99.4
>            Reporter: Veena Basavaraj
>            Assignee: Veena Basavaraj
>             Fix For: 1.99.6
>
>         Attachments: SQOOP-2250-1.patch, SQOOP-2250-2.patch, SQOOP-2250.patch, Screen Shot 2015-03-20 at 11.11.56 AM.png, Screen Shot 2015-03-20 at 11.12.09 AM.png
>
>
> While working on 2113 tests, I figured there is a missing constraint on the SQ_LINK_INPUT table.
> the FK to the INPUT table is missing post the upgrade changes in 1.99.4 release.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)