Re: [hibernate-dev] Tests fail on MySQL due to timestamp precision issues

From: "Vlad Mihalcea" <mihalcea.vlad(a)gmail.com&gt; To: "hibernate-dev" <hibernate-dev(a)lists.jboss.org&gt; Sent: Thursday, 17 March, 2016 9:05:44 AM Subject: [hibernate-dev] Tests fail on MySQL due to timestamp precision issues Hi, While running the test suite on MySQL, I noticed that some of those fail because of DATETIME/TIMESTAMP precision. Prior to MySQL 5.6.4, these types didn't have microsecond precision at all. Using a newer MySQL version, these tests will work like on other DBs but it will require changing the column definitions to DATETIME(6), TIMESTAMP(6). To avoid breaking backward compatibility, what do you think of adding a new Configuration Property: "hibernate.mysql.fractional.seconds" (or a MySQLDialect method) which gives the default fractional second precision used when creating these column types. This way we can have all these tests work with just a single Hibernate configuration property. Vlad _______________________________________________ hibernate-dev mailing list hibernate-dev(a)lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev