[
https://issues.apache.org/jira/browse/SQOOP-2767?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15103469#comment-15103469
]
ASF subversion and git services commented on SQOOP-2767:
--------------------------------------------------------
Commit 55d8b4a7b0dc1a1e0c93fce0ded37481710cd8da in sqoop's branch
refs/heads/trunk from [~kathleen]
[ https://git-wip-us.apache.org/repos/asf?p=sqoop.git;h=55d8b4a ]
SQOOP-2767: Test is failing SystemImportTest
(Jarek Jarcec Cecho via Kate Ting)
> Test is failing SystemImportTest
> --------------------------------
>
> Key: SQOOP-2767
> URL: https://issues.apache.org/jira/browse/SQOOP-2767
> Project: Sqoop
> Issue Type: Bug
> Affects Versions: 1.4.6
> Reporter: Jarek Jarcec Cecho
> Assignee: Jarek Jarcec Cecho
> Fix For: 1.4.7
>
> Attachments: SQOOP-2767.patch
>
>
> I've noticed that {{SystemImportTest}} is constantly failing in my
> environment. I've dig into the problem and I've noticed that we're no longer
> able to import {{URITYPE}} from Oracle (it's always imported as {{NULL}}.
> The test started failing after we made changes back in SQOOP-2723 - the
> generated select queries has changed from:
> {code}
> SELECT /*+ NO_INDEX(t) */
> ID,BD,BF,B,C,CL,D,F,L,NC,NCL,N,NVC,R,uritype.geturl(U),IYM,IDS,T,TZ,TLTZ,RAWCOL,'6_2'
> data_chunk_id FROM oraoop_test t WHERE
> {code}
> To something like:
> {code}
> SELECT /*+ NO_INDEX(t) */
> "ID","BD","BF","B","C","CL","D","F","L","NC","NCL","N","NVC","R","U","IYM","IDS","T","TZ","TLTZ","RAWCOL",'6_1'
> data_chunk_id FROM oraoop_test t WHERE
> {code}
> Notice how the column {{U}} is selected as {{uritype.getUrl()}} in first
> example and as simple {{U}} in the second one. The problem is that we're
> doing [special
> magic|https://github.com/apache/sqoop/blob/trunk/src/java/org/apache/sqoop/manager/oracle/OraOopDBRecordReader.java#L285]
> based on type in {{OraOopDBRecordReader}}. The reason why this magic got
> broken is that we're building a list of all columns with types from the
> database and then searching for each individual column during select query
> generation. However the list contains unescaped columns whereas the "work
> column" is escaped. Hence the [find
> here|https://github.com/apache/sqoop/blob/trunk/src/java/org/apache/sqoop/manager/oracle/OraOopDBRecordReader.java#L283]
> always fails.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
