GitHub user mimcdevitt added a comment to the discussion: Unable to delete Zone

Thanks,  I can try with a single record but I have hundreds to do;  I think I 
am running into an issue  where MySQL doesn't allow updates to a table when the 
update involves a subquery that selects from a view that references the same 
table. This creates a situation where the update operation could potentially 
create inconsistent or unexpected results.   So I am going to try storing the 
results of the select in a temp table and run the update from the data in that 
table.

GitHub link: 
https://github.com/apache/cloudstack/discussions/9532#discussioncomment-10341919

----
This is an automatically sent email for [email protected].
To unsubscribe, please send an email to: [email protected]

Reply via email to