[hibernate-issues] [JIRA] (HHH-14153) HQL update query with multiple condition generates temporary tables on SQLServer

[François DAMBRINE (JIRA)]

François DAMBRINE ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c07a505d3af3b1ccfec791d ) *commented* on HHH-14153 ( https://hibernate.atlassian.net/browse/HHH-14153?atlOrigin=eyJpIjoiOGQ3ODU3M2M3NWJkNGViYjhjMzE1M2ExYWJhOTQ1YmQiLCJwIjoiaiJ9 )

Re: HQL update query with multiple condition generates temporary tables on SQLServer ( https://hibernate.atlassian.net/browse/HHH-14153?atlOrigin=eyJpIjoiOGQ3ODU3M2M3NWJkNGViYjhjMzE1M2ExYWJhOTQ1YmQiLCJwIjoiaiJ9 )

For me they are strongly related but not duplicated

The ancient ticket just talks about the collation of temp table. Of my understanding it affects the queries we could run by ourselves that use temp tables.

My ticket talks about a specific query that ends up having temp table created where it is not needed.

While https://hibernate.atlassian.net/browse/HHH-3326 is open this ticket generates a blocking error and the query cannot be processed. But the temp table query is still overkill for such update query.

At the beginning I thought it was because of the presence of UUID identifier but if I use only one condition in the query there are no temp table created.

I found your test template, I will try to provide you a test case.

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

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#100144- sha1:b6d623e )
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.jboss.org/pipermail/hibernate-issues/attachments/20200813/a4f08a1c/attachment.html