[
https://issues.apache.org/jira/browse/SQOOP-2726?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15070744#comment-15070744
]
Jarek Jarcec Cecho commented on SQOOP-2726:
-------------------------------------------
Thanks for chiming in [~colin_mjj]. Agreed that we're expecting the SQL Mode
set to {{ANSI_QUOTES}} for Repository, but I believe that we're not expecting
it for the JDBC Connector. Whereas user can use it, they can also use the
[Dialect
configuration|https://github.com/apache/sqoop/blob/sqoop2/connector/connector-generic-jdbc/src/main/java/org/apache/sqoop/connector/jdbc/configuration/SqlDialect.java]
which I'm assuming will be a bit preferred. As the providers are more used for
the JDBC Connector testing then for the repository, it seems natural to test
without it.
> Sqoop2: Integration Tests: Do not use ansi_quotes mode for MySQL
> ----------------------------------------------------------------
>
> Key: SQOOP-2726
> URL: https://issues.apache.org/jira/browse/SQOOP-2726
> Project: Sqoop
> Issue Type: Bug
> Affects Versions: 1.99.6
> Reporter: Abraham Fine
> Assignee: Abraham Fine
> Fix For: 1.99.7
>
> Attachments: SQOOP-2726.patch
>
>
> Currently we are using sql_mode='ANSI_QUOTES' in the MySQL provider. This
> should be removed to better reflect real world usage.
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
