JdbcIO date conversion is sensitive to OS
Open
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
Assessment
This issue has not been assessed yet.