Fix tests failing when switching to MySQL

Description

There are lots of tests failing on MySQL. We need to fix those so that we can identify if there is a real issue underneath.

hibernate-core:

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 org.hibernate.test.id.array.ByteArrayIdTest > testMultipleDeletions FAILED javax.persistence.PersistenceException at ByteArrayIdTest.java:54 Caused by: org.hibernate.exception.SQLGrammarException at ByteArrayIdTest.java:54 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException at ByteArrayIdTest.java:54 org.hibernate.exception.SQLGrammarException at ByteArrayIdTest.java:62 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException at ByteArrayIdTest.java:62 org.hibernate.test.id.array.ByteArrayIdTest > testMultipleUpdates FAILED javax.persistence.PersistenceException at ByteArrayIdTest.java:54 Caused by: org.hibernate.exception.SQLGrammarException at ByteArrayIdTest.java:54 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException at ByteArrayIdTest.java:54 org.hibernate.exception.SQLGrammarException at ByteArrayIdTest.java:62 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException at ByteArrayIdTest.java:62 org.hibernate.test.id.array.PrimitiveByteArrayIdTest > testMultipleDeletions FAILED javax.persistence.PersistenceException at PrimitiveByteArrayIdTest.java:54 Caused by: org.hibernate.exception.SQLGrammarException at PrimitiveByteArrayIdTest.java:54 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException at PrimitiveByteArrayIdTest.java:54 org.hibernate.exception.SQLGrammarException at PrimitiveByteArrayIdTest.java:62 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException at PrimitiveByteArrayIdTest.java:62 org.hibernate.test.id.array.PrimitiveByteArrayIdTest > testMultipleUpdates FAILED javax.persistence.PersistenceException at PrimitiveByteArrayIdTest.java:54 Caused by: org.hibernate.exception.SQLGrammarException at PrimitiveByteArrayIdTest.java:54 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException at PrimitiveByteArrayIdTest.java:54 org.hibernate.exception.SQLGrammarException at PrimitiveByteArrayIdTest.java:62 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException at PrimitiveByteArrayIdTest.java:62 org.hibernate.test.schemaupdate.QuotedTableNameSchemaUpdateTest > testSchemaUpdateWithQuotedTableName FAILED java.lang.AssertionError at QuotedTableNameSchemaUpdateTest.java:80 org.hibernate.test.schemaupdate.idbag.IdBagSequenceTest > testIdBagSequenceGeneratorIsCreated FAILED java.lang.AssertionError at IdBagSequenceTest.java:56 org.hibernate.test.sorted.SortTest > testOrderBy FAILED javax.persistence.PersistenceException at SortTest.java:113 Caused by: org.hibernate.exception.SQLGrammarException at SortTest.java:113 Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException at SortTest.java:113

Environment

None

Status

Assignee

Vlad Mihalcea

Reporter

Vlad Mihalcea

Fix versions

Labels

None

backPortable

None

Suitable for new contributors

None

Requires Release Note

None

backportDecision

None

Priority

Major