[hibernate-issues] [JIRA] (HHH-14114) Duplicate order column

[Alex CD (JIRA)]

Alex CD ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A9b0f6d49-bc76-4aca-875b-c8525b2f039d ) *created* an issue

Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiY2NjODAxNmU3MWFiNGM3NGIzODFkZThkZDEwYWRjNjUiLCJwIjoiaiJ9 ) / Bug ( https://hibernate.atlassian.net/browse/HHH-14114?atlOrigin=eyJpIjoiY2NjODAxNmU3MWFiNGM3NGIzODFkZThkZDEwYWRjNjUiLCJwIjoiaiJ9 ) HHH-14114 ( https://hibernate.atlassian.net/browse/HHH-14114?atlOrigin=eyJpIjoiY2NjODAxNmU3MWFiNGM3NGIzODFkZThkZDEwYWRjNjUiLCJwIjoiaiJ9 ) Duplicate order column ( https://hibernate.atlassian.net/browse/HHH-14114?atlOrigin=eyJpIjoiY2NjODAxNmU3MWFiNGM3NGIzODFkZThkZDEwYWRjNjUiLCJwIjoiaiJ9 )

Issue Type: Bug Affects Versions: 5.4.17 Assignee: Unassigned Created: 22/Jul/2020 10:06 AM Priority: Major Reporter: Alex CD ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3A9b0f6d49-bc76-4aca-875b-c8525b2f039d )

Current behavior when retrieving children ordered by column with a duplicate order column is to skip the duplicate child.
This leads to *silent errors*.

This could be resolved by:

* Throw an error when duplicate order column is found
* Or better yet, a duplicate order column value means that order of those duplicate elements is not important and thus should be added to collection in undefined order and continue where it left with next order column value.

Workaround:
Database constraint to not allow duplicate parent/order pairs.

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

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#100133- sha1:ead1094 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200722/1956a9e2/attachment-0001.html