[hibernate-issues] [JIRA] (HHH-15527) Use SimpleInsertQueryPlan when query assigns id even if optimizer increment is bigger than 1

Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) *created* an issue Hibernate ORM ( https://hibernate.atlassian.net/browse/HHH?atlOrigin=eyJpIjoiYzRlNjI0MmIz... ) / Improvement ( https://hibernate.atlassian.net/browse/HHH-15527?atlOrigin=eyJpIjoiYzRlNj... ) HHH-15527 ( https://hibernate.atlassian.net/browse/HHH-15527?atlOrigin=eyJpIjoiYzRlNj... ) Use SimpleInsertQueryPlan when query assigns id even if optimizer increment is bigger than 1 ( https://hibernate.atlassian.net/browse/HHH-15527?atlOrigin=eyJpIjoiYzRlNj... ) Issue Type: Improvement Assignee: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) Components: hibernate-core Created: 19/Sep/2022 08:28 AM Priority: Major Reporter: Christian Beikov ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=557058%... ) The example in https://hibernate.atlassian.net/browse/HHH-15517 ( https://hibernate.atlassian.net/browse/HHH-15517 ) has shown that we currently create a multi-table insert plan because the sequence optimizer has an allocation size bigger than 1, although it wouldn’t be necessary because the statement assigns an id already. The improvement is to use the SimpleInsertQueryPlan to avoid creating a temporary table. ( https://hibernate.atlassian.net/browse/HHH-15527#add-comment?atlOrigin=ey... ) Add Comment ( https://hibernate.atlassian.net/browse/HHH-15527#add-comment?atlOrigin=ey... ) 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.... ) or iOS ( https://itunes.apple.com/app/apple-store/id1006972087?pt=696495&ct=Em... ) This message was sent by Atlassian Jira (v1001.0.0-SNAPSHOT#100207- sha1:7afd384 )