× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
tariqrahiman reported 2014-02-04T21:05:15Z  · last modified 2014-02-05T20:52:04Z

Oracle Batch import with Date Column is slower and inserts incorrect 1/1/1970 for all date rows


customer request
Dev
Jenny Nishimura
JennyNishimura
QA
Tariq Rahiman
tariqrahiman
Priority Major
Complexity Unknown
Component Tools - Import Tool
Version 14.0

 

Version: 14.0.3-15
Build #: 34659
Build Date: 2013-Oct-31 03:50:25 PM

 

Oracle Batch import with Date Column is slower and inserts incorrect 1/1/1970 for all date rows

To reproduce the issue with Batch Import

1. Create the below table with the SQL

 

CREATE TABLE DATEIMP  (
        A   NUMBER(*, 0) NOT NULL,
        B   NUMBER(*, 0) NOT NULL,
        C   VARCHAR2(30) NULL,
        D   CHAR(1) NULL,
        iDATE DATE NULL
        )

2. Do a batch import with the attached file with Batch Size = 1000 and Transaction Type = Batch

3. The Import is slow with Batch involving DATE data type. 

4. You can see that an incorrect date 1/1/1970 is being inserted instead of the correct date

See below for reference

1 attachment

Issue #11639

Closed
Fixed
Resolved 2014-02-05T19:01:34Z
 
 
Completion
No due date
Fixed Build ADS 14.0.8-5
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017