Uploaded image for project: 'Beam'
  1. Beam
  2. BEAM-12484

JdbcIO date conversion is sensitive to OS

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • P1
    • Resolution: Unresolved
    • 2.30.0
    • None
    • io-java-jdbc
    • None

    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'

      Attachments

        Issue Links

          is part of

          Improvement - An improvement or enhancement to an existing feature or task. BEAM-5530 Migrate to java.time lib instead of joda-time

          • P3 - Non-urgent bugs, features, and improvements
          • Open

          Activity

            People

              Unassigned Unassigned
              anant.damle Anant Damle
              Votes:
              0 Vote for this issue
              Watchers:
              6 Start watching this issue

              Dates

                Created:
                Updated: