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

[Vlad Mihalcea]

Thanks, Martin,

I'll use that dialect then.

Vlad

On Thu, Mar 17, 2016 at 12:08 PM, Martin Simka <msimka at redhat.com> wrote:

> 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
> >
>