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

JdbcIO date conversion is sensitive to OS

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Open
    • Priority: P1
    • Resolution: Unresolved
    • Affects Version/s: 2.30.0
    • Fix Version/s: None
    • Component/s: io-java-jdbc
    • Labels:
      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

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                anant.damle Anant Damle
              • Votes:
                0 Vote for this issue
                Watchers:
                3 Start watching this issue

                Dates

                • Created:
                  Updated: