[hibernate-issues] [JIRA] (HHH-14147) Entities containing field "rank" cannot be updated

[Sergiu Hlihor (JIRA)]

Sergiu Hlihor ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Aeb8226b5-bd0f-4caa-b6a4-8a027bdf1eaf ) *updated* an issue

Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiNTM1NmNjYjg0MDBlNDU0M2FhYmQ3ZTYxMjRhNWY5MDAiLCJwIjoiaiJ9 ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14147?atlOrigin=eyJpIjoiNTM1NmNjYjg0MDBlNDU0M2FhYmQ3ZTYxMjRhNWY5MDAiLCJwIjoiaiJ9 ) HHH-14147 ( https://hibernate.atlassian.net/browse/HHH-14147?atlOrigin=eyJpIjoiNTM1NmNjYjg0MDBlNDU0M2FhYmQ3ZTYxMjRhNWY5MDAiLCJwIjoiaiJ9 ) Entities containing field "rank" cannot be updated ( https://hibernate.atlassian.net/browse/HHH-14147?atlOrigin=eyJpIjoiNTM1NmNjYjg0MDBlNDU0M2FhYmQ3ZTYxMjRhNWY5MDAiLCJwIjoiaiJ9 )

Change By: Sergiu Hlihor ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Aeb8226b5-bd0f-4caa-b6a4-8a027bdf1eaf )

I have a an entity containing a field called “rank“ . This worked perfectly fine with MySQL 5.6. Now in MySQL 8, since this is a keyword, it fails to update the field.

Tested configurations were:

<property name="hibernate.dialect" value="org.hibernate.dialect.MySQLInnoDBDialect" />

<property name="hibernate.dialect" value="org.hibernate.dialect.MySQL8Dialect" />

or no dialect whatsoever.

Database is MySQL 8.0.20, Percona flavor + HikariCP

Would have expected that by choosing the correct dialect, the fields are escaped automatically.

( https://hibernate.atlassian.net/browse/HHH-14147#add-comment?atlOrigin=eyJpIjoiNTM1NmNjYjg0MDBlNDU0M2FhYmQ3ZTYxMjRhNWY5MDAiLCJwIjoiaiJ9 ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-14147#add-comment?atlOrigin=eyJpIjoiNTM1NmNjYjg0MDBlNDU0M2FhYmQ3ZTYxMjRhNWY5MDAiLCJwIjoiaiJ9 )

Get Jira notifications on your phone! Download the Jira Cloud app for Android ( https://play.google.com/store/apps/details?id=com.atlassian.android.jira.core&referrer=utm_source%3DNotificationLink%26utm_medium%3DEmail ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=EmailNotificationLink&mt=8 ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100142- sha1:98e8dd4 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200811/0702ccf5/attachment.html