Uploaded image for project: 'Hibernate ORM'
  1. Hibernate ORM
  2. HHH-8401

Support fractional seconds on MySQL 5.7

    Details

    • Type: Improvement
    • Status: Closed
    • Priority: Minor
    • Resolution: Fixed
    • Affects Version/s: 4.3.0.Beta3
    • Fix Version/s: 4.2.17, 4.3.8, 5.0.0.Beta1
    • Component/s: None
    • Labels:
      None
    • Last commented by a user?:
      true

      Description

      New in MySQL 5.6 is support for fractional seconds. Hibernate should have a new dialect to support this:

      public class ImprovedMySQL56Dialect extends MySQL5InnoDBDialect {

    public ImprovedMySQL56Dialect() {
        super();
        // http://dev.mysql.com/doc/refman/5.6/en/fractional-seconds.html
        registerColumnType( Types.TIMESTAMP, "datetime(6)" );
    }
}

      This will most likely also fix HHH-3822 Open .

        Attachments

          Issue links

          is a fix for

          Bug - A problem which impairs or prevents the functions of the product. HHH-9444 Rounding of fractional seconds causes test failures on MySQL 5.6.4+

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. HHH-3822 mysql lack of timestamps with milliseconds breaks hibernate when used with versioning

          • Major - Major loss of function.
          • Open
          relates to

          Bug - A problem which impairs or prevents the functions of the product. HHH-9444 Rounding of fractional seconds causes test failures on MySQL 5.6.4+

          • Major - Major loss of function.
          • Closed
          links to

          Web Link BZ-1153069

          Web Link BZ-1173461

            Activity

              People

              • Votes:
                1 Vote for this issue
                Watchers:
                4 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: