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

After getTimestamp with 0000-00-00 00:00:00 all other values return NULL

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Blocker
    • Resolution: Cannot Reproduce
    • Affects Version/s: 2.1.0, 2.4.0
    • Fix Version/s: N/A
    • Component/s: Other
    • Labels:
    • Environment:
      MariaDB 10.4/10.2; Windows

      Description

      Hello,
      there is a bug with ResultSet.wasNull after getting a timestamp column with the value '0000-00-00 00:00:00'.
      All subsequent calls to ResultSet.wasNull will always return true.
      This is a problem because we can't check if a ResultSet.getInt that returns 0 has the database value 0 or NULL.

      In the attechment is a small use case test.

        Attachments

          Activity

            People

            Assignee:
            diego dupin Diego Dupin
            Reporter:
            fahrenholz sfahren
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: