[ 
https://issues.apache.org/jira/browse/SQOOP-2725?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
 ]

Abraham Fine updated SQOOP-2725:
--------------------------------
    Description: 
MySQL, PostgreSQL, and Oracle have slightly different syntaxes for inserting 
dates that PreparedStatements deal with for us. We should use them when 
inserting our test data.

In addition, each database seems to have different ways of printing dates, 
timestamps seemed to provide the greatest amount of consistency. 

  was:MySQL, PostgreSQL, and Oracle have slightly different syntaxes for 
inserting dates that PreparedStatements deal with for us. We should use them 
when inserting our test data.


> Sqoop2: Integration Tests: Prefer using Timestamp types and 
> PreparedStatements for inserting rows into test databases
> ---------------------------------------------------------------------------------------------------------------------
>
>                 Key: SQOOP-2725
>                 URL: https://issues.apache.org/jira/browse/SQOOP-2725
>             Project: Sqoop
>          Issue Type: Bug
>    Affects Versions: 1.99.6
>            Reporter: Abraham Fine
>            Assignee: Abraham Fine
>
> MySQL, PostgreSQL, and Oracle have slightly different syntaxes for inserting 
> dates that PreparedStatements deal with for us. We should use them when 
> inserting our test data.
> In addition, each database seems to have different ways of printing dates, 
> timestamps seemed to provide the greatest amount of consistency. 



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

Reply via email to