sqoop-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Jarek Jarcec Cecho (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (SQOOP-597) PostgreSQL Manager is incorrectly escaping table names
Date Tue, 11 Sep 2012 11:54:10 GMT

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

Jarek Jarcec Cecho commented on SQOOP-597:
------------------------------------------

There is small "hack"  for bypassing this issue. User might specify following parameter on
the command line:

{code}
--table 'schema"."table'
{code}

The entire table name is enclosed in single quotes to prevent the shell from any other escape
resolution as there are two double quotes inside. Sqoop should escape this term correctly
to "schema"."table" - single quotes will be removed by the shell and double quotes will be
added around the entire expression by Sqoop.
                
> PostgreSQL Manager is incorrectly escaping table names
> ------------------------------------------------------
>
>                 Key: SQOOP-597
>                 URL: https://issues.apache.org/jira/browse/SQOOP-597
>             Project: Sqoop
>          Issue Type: Bug
>    Affects Versions: 1.4.2
>            Reporter: Jarek Jarcec Cecho
>            Assignee: Jarek Jarcec Cecho
>             Fix For: 1.4.3
>
>
> PostgreSQL Manager is incorrectly escaping entire table name argument into double quotes
like on following example:
> {code}
> schema.table => "schema.table"
> {code}
> However this escaping is not valid as it should be one of following possibilities:
> {code}
> schema.table => schema."table"
> schema.table => "schema"."table"
> {code}

--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira

Mime
View raw message