François DAMBRINE ( https://hibernate.atlassian.net/secure/ViewProfile.jspa?accountId=5c07a50... ) *commented* on HHH-14153 ( https://hibernate.atlassian.net/browse/HHH-14153?atlOrigin=eyJpIjoiNDUzZj... ) Re: HQL update query with multiple condition generates temporary tables on SQLServer ( https://hibernate.atlassian.net/browse/HHH-14153?atlOrigin=eyJpIjoiNDUzZj... ) I don’t know how to extract a test case out of this. If you can provide some tips about it I will post one. Here is the minimal model to reproduce the issue @Entity(name = "abstracttaskentity" ) @Inheritance(strategy = InheritanceType.JOINED) public abstract class AbstractTaskEntity { @Id @Type(type = "uuid- char " ) @Column(name = "id" ) private UUID taskId; @NotNull private String name; private String description; private boolean locked; public UUID getTaskId() { return taskId; } public void setTaskId(UUID taskId) { this.taskId = taskId; } public boolean isLocked() { return locked; } /** * @param locked */ public void setLocked( boolean locked) { this.locked = locked; } public String getName() { return name; } /** * @param name */ public void setName( String name) { this.name = name; } public String getDescription() { return description; } /** * @param description */ public void setDescription( String description) { this.description = description; } } Then one implementing class @Entity(name = "webtaskentity" ) public class WebTaskEntity extends AbstractTaskEntity { private String sessionId; public String getSessionId() { return sessionId; } public void setSessionId( String sessionId) { this.sessionId = sessionId; } } To have more information : the entity is persisted through the entity manager by a web handler. Then a background-running thread find out the task and tries to lock it with the query I gave in the issue. ( 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 )