apache / apache/beam

JdbcIO date conversion is sensitive to OS

Open
#21,115 3 comments 0 reactions 0 assignees View on GitHub
bug io java jdbc P2
Dominant language
Java
Stars
8.7k
Forks
4.7k
Avg merge
1d 20h
Merged PRs (30d)
196

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'

Imported from Jira [BEAM-12484](https://issues.apache.org/jira/browse/BEAM-12484). Original Jira may contain additional context.
Reported by: anant.damle.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.