[
https://issues.apache.org/jira/browse/BEAM-12484?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17363879#comment-17363879
]
Kenneth Knowles commented on BEAM-12484:
----------------------------------------
As a data corruption issue, I am marking this P1. It has probably been there
the whole time, so it isn't necessarily a release blocker. The JdbcIO component
doesn't get that many changes. Would you be interested in trying for a fix?
> JdbcIO date conversion is sensitive to OS
> -----------------------------------------
>
> Key: BEAM-12484
> URL: https://issues.apache.org/jira/browse/BEAM-12484
> Project: Beam
> Issue Type: Bug
> Components: io-java-jdbc
> Affects Versions: 2.30.0
> Reporter: Anant Damle
> Assignee: Anant Damle
> Priority: P1
>
> Time handling varies between OSes:
> for e.g.
> {code:java}
> // DB Init script
> CREATE TABLE SimpleFlatRecords
> (
> id INTEGER AUTO_INCREMENT PRIMARY KEY,
> birth_date DATE
> );
> INSERT INTO SimpleFlatRecords(id, birth_date)
> VALUES (1, '2000-05-11'),
> (2, '2001-06-12'),
> (3, '2002-07-13');{code}
> The Beam Row contains different dates based on OS:
> MacOS:
> 1: '2000-05-10'
> 2: '2001-06-11'
> 3: '2002-07-12'
> Linux:
> 1: '2000-05-11'
> 2: '2001-06-12'
> 3: '2002-07-13'
--
This message was sent by Atlassian Jira
(v8.3.4#803005)
