Uploaded image for project: 'MariaDB Connector/J'
  1. MariaDB Connector/J
  2. CONJ-1242

Driver fails to retrieve timestamps with partial zeros

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.5.2
    • None
    • datetime
    • None

    Description

      When the table contains timestamp like 0000-00-00 01:00:00.000 then an error is throw similar to

      2025-03-06T04:58:18.6523831Z Caused by: java.time.DateTimeException: Invalid value for MonthOfYear (valid values 1 - 12): 0
      2025-03-06T04:58:18.6524811Z 	at java.base/java.time.temporal.ValueRange.checkValidValue(ValueRange.java:319)
      2025-03-06T04:58:18.6525746Z 	at java.base/java.time.temporal.ChronoField.checkValidValue(ChronoField.java:718)
      2025-03-06T04:58:18.6526523Z 	at java.base/java.time.LocalDate.of(LocalDate.java:273)
      2025-03-06T04:58:18.6527290Z 	at java.base/java.time.LocalDateTime.of(LocalDateTime.java:338)
      2025-03-06T04:58:18.6528130Z 	at org.mariadb.jdbc.client.column.TimestampColumn.parseText(TimestampColumn.java:337)
      2025-03-06T04:58:18.6529177Z 	at org.mariadb.jdbc.client.column.TimestampColumn.decodeTimestampText(TimestampColumn.java:313)
      2025-03-06T04:58:18.6530437Z 	at org.mariadb.jdbc.client.column.TimestampColumn.getDefaultText(TimestampColumn.java:97)
      2025-03-06T04:58:18.6531658Z 	at org.mariadb.jdbc.client.result.rowdecoder.TextRowDecoder.defaultDecode(TextRowDecoder.java:43)
      2025-03-06T04:58:18.6532610Z 	at org.mariadb.jdbc.client.result.Result.getObject(Result.java:802)
      

      The issue was not present in 3.5.0. Issue is visible in Debezium.

      Attachments

        Activity

          There are no comments yet on this issue.

          People

            diego dupin Diego Dupin
            Pechanec Jiri
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:

              Git Integration

                Error rendering 'com.xiplink.jira.git.jira_git_plugin:git-issue-webpanel'. Please contact your Jira administrators.