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

[Martin Simka]

MySQL57InnoDBDialect supports fractional seconds (HHH-8401). 

Martin

----- Original Message -----
> From: "Vlad Mihalcea" <mihalcea.vlad at gmail.com>
> To: "hibernate-dev" <hibernate-dev at lists.jboss.org>
> 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 at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/hibernate-dev
>