[BEAM-12484] JdbcIO date conversion is sensitive to OS

• Type: Bug
• Status: Triage Needed
• Priority: P1
• Resolution: Unresolved
• Affects Version/s: 2.30.0
• Component/s: io-java-jdbc
• Assignee: Unassigned
• Reporter: Anant Damle
• Created: 14/Jun/21 06:45
• Updated: 23/Nov/24 09:37

Description

Time handling varies between OSes:

for e.g.

// 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');

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'

Issue Links

• is part of: BEAM-5530 Migrate to java.time lib instead of joda-time