You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@beam.apache.org by "Chamikara Madhusanka Jayalath (Jira)" <ji...@apache.org> on 2021/10/09 00:18:00 UTC
[jira] [Assigned] (BEAM-12484) JdbcIO date conversion is sensitive
to OS
[ https://issues.apache.org/jira/browse/BEAM-12484?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Chamikara Madhusanka Jayalath reassigned BEAM-12484:
----------------------------------------------------
Assignee: Pablo Estrada
> 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: Pablo Estrada
> 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)