François DAMBRINE (
https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c07a50...
) *commented* on HHH-14153 (
https://hibernate.atlassian.net/browse/HHH-14153?atlOrigin=eyJpIjoiOGQ3OD...
)
Re: HQL update query with multiple condition generates temporary tables on SQLServer (
https://hibernate.atlassian.net/browse/HHH-14153?atlOrigin=eyJpIjoiOGQ3OD...
)
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=ey...
) Add Comment (
https://hibernate.atlassian.net/browse/HHH-14153#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#100144- sha1:b6d623e )