We're updating the issue view to help you get more done. 

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