View Issue Details

IDProjectCategoryView StatusLast Update
0004116SymmetricDSBugpublic2020-05-26 12:27
Reporterhanes Assigned To 
Status confirmedResolutionopen 
Product Version3.11.0 
Target Version3.13.0 
Summary0004116: Syncing from Time to Timestamp (or vice versa) in Postgres produced inaccurate values
DescriptionFor Postgres, when syncing from a Time column to a Timestamp column (or vice versa), the time amount is not the correct value. Perhaps it's an incorrect interpretation of the microseconds when doing the conversion? Time to Time, and Timestamp to Timestamp seem to work okay.
Tagsdialect: postgresql



2019-10-18 14:38

developer   ~0001617

Note that the CSV being sent seems to be correct. For example:
insert,"foo6","2019-10-18 10:29:32.307966"
for the timestamp on the source case, and
for the time on the source case.

FYI, for the Time to Timestamp case, the date portion of the timestamp defaults to 1/1/1970, which seems reasonable (since the time is unknown)


2019-10-18 14:39

developer   ~0001618

Issues appears to occur with initial load, as well.


2019-10-18 15:03

developer   ~0001619

This scenario with an H2 source and target works just fine. In fact, H2 as a source and Postgres as a target works as well. However, Postgres as a source and H2 as a target doesn't work. My guess is it has something to do with the six digit "microsecond" value postgres seems to use.

Issue History

Date Modified Username Field Change
2019-10-18 14:36 hanes New Issue
2019-10-18 14:36 hanes Tag Attached: dialect: postgresql
2019-10-18 14:36 hanes Status new => confirmed
2019-10-18 14:38 hanes Note Added: 0001617
2019-10-18 14:39 hanes Note Added: 0001618
2019-10-18 15:03 hanes Note Added: 0001619
2019-11-14 19:49 elong Target Version 3.11.0 => 3.12.0
2020-05-26 12:27 elong Target Version 3.12.0 => 3.13.0