[hibernate-issues] [JIRA] (HHH-14097) Versions 5.4.11.Final+ produce too many sql queries

[Nathan Xu (JIRA)]

Nathan Xu ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%3Af1c90216-c2ff-4df7-8e20-9d0e140d7f64 ) *commented* on HHH-14097 ( https://hibernate.atlassian.net/browse/HHH-14097?atlOrigin=eyJpIjoiZDA0OGJhZTdiZTJkNGFmNDg4YjhmNDlhZjk1OTIyYjUiLCJwIjoiaiJ9 )

Re: Versions 5.4.11.Final+ produce too many sql queries ( https://hibernate.atlassian.net/browse/HHH-14097?atlOrigin=eyJpIjoiZDA0OGJhZTdiZTJkNGFmNDg4YjhmNDlhZjk1OTIyYjUiLCJwIjoiaiJ9 )

i found the third SQL is identical with the second one, which is weird. Could you double check whether two identical SQLs were generated?

Actually, the entity graph implementation has a well-known bug before (see https://docs.jboss.org/hibernate/orm/5.3/userguide/html_single/Hibernate_User_Guide.html#fetching-strategies-dynamic-fetching-entity-graph for instance). As you can see, the second SQL corresponds to the entity graph attribute of dList `, so it seems to correct the previous bug. However, not sure why the third SQL is duplicated.

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

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#100131- sha1:aac02e2 )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200703/751bb6b3/attachment.html