Mercurial > hg > orthanc-databases
diff MySQL/Plugins/DeleteResources.sql @ 455:d0dd95ff0662 improve-delete
move temp table creation out of the procedure
| author | Alain Mazy <am@osimis.io> |
|---|---|
| date | Mon, 22 Jan 2024 12:27:42 +0100 |
| parents | 95c413106a66 |
| children |
line wrap: on
line diff
--- a/MySQL/Plugins/DeleteResources.sql Mon Jan 22 10:00:28 2024 +0100 +++ b/MySQL/Plugins/DeleteResources.sql Mon Jan 22 12:27:42 2024 +0100 @@ -10,16 +10,6 @@ SELECT internalId FROM DeletedResources@ DECLARE CONTINUE HANDLER FOR SQLSTATE '02000' SET done = TRUE@ set done=FALSE@ - -- Create a CTE to hold the temporary data ??? - -- WITH DeletedResources AS ( - -- SELECT internalId, resourceType, publicId - -- FROM Resources - -- ) - - CREATE TEMPORARY TABLE DeletedResources SELECT * FROM ( - SELECT internalId, resourceType, publicId FROM Resources WHERE internalId=p_id OR parentId=p_id - OR parentId IN (SELECT internalId FROM Resources WHERE parentId=p_id) - OR parentId IN (SELECT internalId FROM Resources WHERE parentId IN (SELECT internalId FROM Resources WHERE parentId=p_id))) AS t@ OPEN cur1@ REPEAT