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

Driver fails to retrieve timestamps with partial zeros

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Major
    • Resolution: Duplicate
    • 3.5.2
    • 3.5.3
    • 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

        Issue Links

          duplicates

          Bug - A problem which impairs or prevents the functions of the product. CONJ-1226 Dates conatining zero day or month resutl into DateTimeException

          • Major - Major loss of function.
          • Closed

          Activity

            People

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

              Dates

                Created:
                Updated:
                Resolved:

                Git Integration

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