Uploaded image for project: 'OFBiz'
  1. OFBiz
  2. OFBIZ-9337

Update msyql sql-type for datetime field-type to support Fractional Seconds in Time Values

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Major
    • Resolution: Done
    • Affects Version/s: Trunk
    • Fix Version/s: Upcoming Release
    • Component/s: ALL APPLICATIONS
    • Labels:
      None

      Description

      Mysql 5.6.4 added support to store microseconds in datetime/time field.
      Here is the link for discussion on dev list:
      https://s.apache.org/ytBk

      Need to update fieldtypemysql.xml and update the following field-type

      • date-time : use DATETIME (3)
      • time : use TIME (3)

        Issue Links

          Activity

          Hide
          jacques.le.roux Jacques Le Roux added a comment -

          Deepak rightly mentioned that [...] we need to create an entry in "data migration" wiki page

          Show
          jacques.le.roux Jacques Le Roux added a comment - Deepak rightly mentioned that [...] we need to create an entry in "data migration" wiki page
          Hide
          deepak.dixit Deepak Dixit added a comment - - edited

          This has been done at r#1793300

          Added generateMySqlFileWithAlterTableForTimestamps service to generate sql alter statement for date-time and time filed.
          groupName is required field for this service ,it will generate sql file at location ofbiz.home/runtime/tempfiles/<groupName>.sql

          User can use mysql batch command to execute sql statement from text file.

          Also update Data Migration wiki page with revision and migration service detail.

          Show
          deepak.dixit Deepak Dixit added a comment - - edited This has been done at r#1793300 Added generateMySqlFileWithAlterTableForTimestamps service to generate sql alter statement for date-time and time filed. groupName is required field for this service ,it will generate sql file at location ofbiz.home/runtime/tempfiles/<groupName>.sql User can use mysql batch command to execute sql statement from text file. Also update Data Migration wiki page with revision and migration service detail.

            People

            • Assignee:
              deepak.dixit Deepak Dixit
              Reporter:
              deepak.dixit Deepak Dixit
            • Votes:
              0 Vote for this issue
              Watchers:
              3 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development