Uploaded image for project: 'Nuxeo Platform'
  1. Nuxeo Platform
  2. NXP-21338

Use millisecond precision on MySQL/MariaDB

    XMLWordPrintable

    Details

    • Type: Improvement
    • Status: Resolved
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 9.1
    • Component/s: Core, Core VCS
    • Tags:
    • Impact type:
      Configuration Change
    • Upgrade notes:
      Hide

      Require MySQL >= 5.6.4

      Show
      Require MySQL >= 5.6.4
    • Sprint:
      nxFG 9.1.2
    • Story Points:
      2

      Description

      Since MySQL 5.6.4 timestamps can now have millisecond precision (https://dev.mysql.com/doc/relnotes/mysql/5.6/en/news-5-6-4.html#mysqld-5-6-4-fractional-seconds).

      Use this feature, and require MySQL >= 5.6.4.

      In addition to the added precision, this allows us to simplify some special cases in a number of unit tests.

        Attachments

          Issue Links

          depends on

          Task - A task that needs to be done. NXBT-1465 Upgrade to MySQL 5.7 and MariaDB 10.1

          • Critical - Crashes, loss of data, severe memory leak.
          • Resolved

          Task - A task that needs to be done. NXP-21350 Use specific template and JDBC driver for MariaDB

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is duplicated by

          Improvement - An improvement or enhancement to an existing feature or task. NXP-21221 Use DATETIME2 for SQL Server date storage

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is related to

          Bug - A problem which impairs or prevents the functions of the product. NXP-20468 Drive: random failures on versioning tests

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved
          is required by

          Bug - A problem which impairs or prevents the functions of the product. NXP-20311 Fix random test failure on TestRenditionService.doZipTreeExportRendition on mssql and mysql

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-21299 Fix randomly-failing CMIS test testSetContentStreamWithDigestHeader

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-21325 Fix randomly-failing CMIS test testDeleteContentStreamPWC

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

          Bug - A problem which impairs or prevents the functions of the product. NXP-23025 Fix failure on TestDublinCoreStorage.testCopyDocument on MariaDB

          • Minor - Minor loss of function, or other problem where easy workaround is present.
          • Resolved

            Activity

              People

              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: