I added a test case that runs with the latest MySQL Driver (6.0.5) and the issue cannot be replicated.

You can run this test as follows:

> cd hibernate-core
> gradle clean test -Pdb=mysql --tests org.hibernate.test.annotations.uniqueconstraint.UniqueConstraintThrowsConstraintViolationExceptionTest

Check out target/reports/tests/index.html