Bug 911247
| Summary: | [HHH-8006] BadMergeHandlingTest and MergeCollectionEventTest fails on mysql55 due to MySQLSyntaxErrorException | ||
|---|---|---|---|
| Product: | [JBoss] JBoss Enterprise Application Platform 6 | Reporter: | Madhumita Sadhukhan <msadhukh> |
| Component: | Hibernate | Assignee: | Brett Meyer <brmeyer> |
| Status: | CLOSED CURRENTRELEASE | QA Contact: | |
| Severity: | high | Docs Contact: | |
| Priority: | unspecified | ||
| Version: | 6.1.0 | CC: | msimka, pslavice, rsvoboda, theute, zroubali |
| Target Milestone: | ER3 | ||
| Target Release: | EAP 6.1.0 | ||
| Hardware: | Unspecified | ||
| OS: | Unspecified | ||
| Whiteboard: | |||
| Fixed In Version: | Doc Type: | Bug Fix | |
| Doc Text: | Story Points: | --- | |
| Clone Of: | Environment: | ||
| Last Closed: | Type: | Bug | |
| Regression: | --- | Mount Type: | --- |
| Documentation: | --- | CRM: | |
| Verified Versions: | Category: | --- | |
| oVirt Team: | --- | RHEL 7.3 requirements from Atomic Host: | |
| Cloudforms Team: | --- | Target Upstream Version: | |
| Embargoed: | |||
Fixed upstream and pushed to prod branch eap61-cp verified 6.1.0.ER3 |
Description of problem: BadMergeHandlingTest and MergeCollectionEventTest fails on mysql55 due to MySQLSyntaxErrorException failing query: 12:02:24,566 DEBUG SQL:104 - alter table CHARACTER_ALIAS add index FKBFBA17A55528DA3 (characters_id), add constraint FKBFBA17A55528DA3 foreign key (characters_id) references Character (id) 12:02:24,567 ERROR SchemaExport:425 - HHH000389: Unsuccessful: alter table CHARACTER_ALIAS add index FKBFBA17A55528DA3 (characters_id), add constraint FKBFBA17A55528DA3 foreign key (characters_id) references Character (id) 12:02:24,567 ERROR SchemaExport:426 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Character (id)' at line 1 12:02:24,567 DEBUG SQL:104 - alter table CHARACTER_ALIAS add index FKBFBA17AA869D0B6 (aliases_id), add constraint FKBFBA17AA869D0B6 foreign key (aliases_id) references Alias (id) Cause: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Character (name, id) values ('Paul Atreides', 1)' at line 1 at sun.reflect.GeneratedConstructorAccessor26.newInstance(Unknown Source) at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45) at java.lang.reflect.Constructor.newInstance(Constructor.java:525) at com.mysql.jdbc.Util.handleNewInstance(Util.java:411) at com.mysql.jdbc.Util.getInstance(Util.java:386) at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1053) at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:4096) Version-Release number of selected component (if applicable): EAP 6.1.0.DR4