[hibernate-issues] [Hibernate-JIRA] Commented: (HHH-2221) MySQL temp table DDL and isolation

[ http://opensource.atlassian.com/projects/hibernate/browse/HHH-2221?page=c... ] Milosz Tylenda commented on HHH-2221: ------------------------------------- Steve, these 2 failures are MySQL "features". Section "DELETE syntax" in their manual says: "Currently, you cannot delete from a table and select from the same table in a subquery." The similar restriction applies to UPDATE with subquery syntax: "Incorrectly used table in subquery: Error 1093 (ER_UPDATE_TABLE_USED) SQLSTATE = HY000 Message = "You can't specify target table 'x' for update in FROM clause" This error occurs in cases such as the following: UPDATE t1 SET column2 = (SELECT MAX(column1) FROM t1); You can use a subquery for assignment within an UPDATE statement because subqueries are legal in UPDATE and DELETE statements as well as in SELECT statements. However, you cannot use the same table (in this case, table t1) for both the subquery's FROM clause and the update target." -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://opensource.atlassian.com/projects/hibernate/secure/Administrators.... - For more information on JIRA, see: http://www.atlassian.com/software/jira