You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@beam.apache.org by "Beam JIRA Bot (Jira)" <ji...@apache.org> on 2021/07/16 17:21:01 UTC
[jira] [Updated] (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 ]
Beam JIRA Bot updated BEAM-12484:
---------------------------------
Labels: stale-assigned (was: )
> 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
> Labels: stale-assigned
>
> 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)