Uploaded image for project: 'MariaDB Connector/C'
  1. MariaDB Connector/C
  2. CONC-168

string conversion of timestamps is broken

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: 3.0.0, 2.2.0
    • Fix Version/s: 2.2.3, 3.0.1
    • Component/s: None
    • Labels:
      None
    • Environment:
      All OSes

      Description

      ps_fetch_datetime() does not work for DATETIME( n ) fields where n is between 1 and 5.

      for example, when DATETIME(3) is used for millisecond resolution, the current version sprintf()s the first 3 digits of the microsecond field, but this yields a wrong output, when there are leading zeroes (see examples below).

      Test values, type DATETIME(3):
      2016-03-09 07:51:49.000
      2016-03-09 07:51:49.001
      2016-03-09 07:51:49.010

      ps_fetch_datetime() output:
      2016-03-09 07:51:49
      2016-03-09 07:51:49.1000
      2016-03-09 07:51:49.10000

      See github pull requests for fixes:
      master: https://github.com/MariaDB/mariadb-connector-c/pull/17
      2.2.x: https://github.com/MariaDB/mariadb-connector-c/pull/16

        Attachments

          Activity

            People

            Assignee:
            georg Georg Richter
            Reporter:
            patrickh Patrick Huesmann
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: