[hibernate-issues] [Hibernate-JIRA] Closed: (HHH-5324) Tests fail on mysql

Tests fail on mysql ------------------- Key: HHH-5324 URL: http://opensource.atlassian.com/projects/hibernate/browse/HHH-5324 Project: Hibernate Core Issue Type: Bug Components: testsuite Affects Versions: 3.5.4, 3.6 Reporter: Strong Liu Assignee: Strong Liu Fix For: 3.5.4, 3.6 1. org.hibernate.test.criteria.CriteriaQueryTest.testProjectedCompositeId() line 1283, the Criteria.list return type is List, in the following assert, it converted to Long, then CCE. this has not been found till now is because of the default test db (hsqldb) does not support Tuple Distinct Counts 2. org.hibernate.test.sql.hand.quotedidentifiers.NativeSqlAndQuotedIdentifiersTest in this test class, it overrides the prepareTest method, and calls sfi() to get a sessionfactory, but this test also has an applyTo method to determine if the dialect.openQuote() is quote ("), when the open quote is not quote ("), the sfi() return null 3. org.hibernate.test.schemaupdate.MigrationTest does not clean the DB when it finished 4. org.hibernate.test.component.basic.ComponentTest.testComponentFormulaQuery() parameters does not match 5. org.hibernate.test.annotations.quote.resultsetmappings.ExplicitSqlResultSetMappingTest uses quote(") as the Quote character in the query string, this fails on Mysql