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

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

Wouldn't be easier to issue {{SET sql_mode = ANSI_QUOTES}} then refactoring 
entire infrastructure ([more in 
documentation|https://dev.mysql.com/doc/refman/5.0/en/sql-mode.html#sqlmode_ansi_quotes])?
 For repository we own the database, so I think that it's reasonable to request 
on user side to allow us using double quotes.


> Refactor repository-common to make sqoop2 easy to use external DB as 
> repository 
> --------------------------------------------------------------------------------
>
>                 Key: SQOOP-2460
>                 URL: https://issues.apache.org/jira/browse/SQOOP-2460
>             Project: Sqoop
>          Issue Type: Sub-task
>          Components: sqoop2-server
>            Reporter: Colin Ma
>             Fix For: 1.99.7
>
>         Attachments: SQOOP-2460.001.patch, SQOOP-2460.002.patch
>
>
> Currently, in the class CommonRepositoryInsertUpdateDeleteSelectQuery, the 
> tableName and columnName are wrapped with quotation, like 
> "tableName"."columnName". But some db doesn't support this format, like MySql.
> Refactor the code in repository-common to fix this problem.



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

Reply via email to