TimePropertyTest fails on MySQL 8.0 with a ComparisonFailure
Description
Running org.hibernate.test.temporal.TimePropertyTest.testTimeAsDate from Hibernate ORM test suite of version 5.3.20 on MySQL 8.0 database results in a ComparisonFailure:
junit.framework.ComparisonFailure: expected:<08:55:5[1]> but was:<08:55:5[2]>
at junit.framework.Assert.assertEquals(Assert.java:100)
at junit.framework.Assert.assertEquals(Assert.java:107)
at org.hibernate.test.temporal.TimePropertyTest.testTimeAsDate(TimePropertyTest.java:59)
Note: From my tiny experience with DBs I would say it could possibly caused by rounding milliseconds value. The issue is not present in the latest ORM version (5.5.0) Given that, I'm filing this JIRA as a known issue for QE Hibernate ORM 5.3.20 testing.
Web links
Activity
Show:
Former user July 9, 2021 at 6:19 PM
Fixed in 5.3 branch.
This has already been fixed in main and 5.4 branches by HHH-14031. That issue involved upgrading H2, which was not done here.
Running org.hibernate.test.temporal.TimePropertyTest.testTimeAsDate from Hibernate ORM test suite of version 5.3.20 on MySQL 8.0 database results in a ComparisonFailure:
junit.framework.ComparisonFailure: expected:<08:55:5[1]> but was:<08:55:5[2]> at junit.framework.Assert.assertEquals(Assert.java:100) at junit.framework.Assert.assertEquals(Assert.java:107) at org.hibernate.test.temporal.TimePropertyTest.testTimeAsDate(TimePropertyTest.java:59)Note: From my tiny experience with DBs I would say it could possibly caused by rounding milliseconds value. The issue is not present in the latest ORM version (5.5.0)
Given that, I'm filing this JIRA as a known issue for QE Hibernate ORM 5.3.20 testing.