Merge branch '21030-update-perm-cte' refs #21030

Arvados-DCO-1.1-Signed-off-by: Peter Amstutz <peter.amstutz@curii.com>

diff --cc services/api/db/structure.sql
index a26db2e5dbd659b73ee414aaf7768f4fb4a8e983,28259a08f29f191315f7e1dc81078e2188bfbf9f..c0d4263d97aa6bdde258688d091b5cf69fdd47af
--- 1/services/api/db/structure.sql
--- 2/services/api/db/structure.sql
+++ b/services/api/db/structure.sql
@@@ -62,10 -62,10 +62,10 @@@ wit
       permission (permission origin is self).
    */
    perm_from_start(perm_origin_uuid, target_uuid, val, traverse_owned) as (
--    
++
  WITH RECURSIVE
          traverse_graph(origin_uuid, target_uuid, val, traverse_owned, starting_set) as (
--            
++
               values (perm_origin_uuid, starting_uuid, starting_perm,
                      should_traverse_owned(starting_uuid, starting_perm),
                      (perm_origin_uuid = starting_uuid or starting_uuid not like '_____-tpzed-_______________'))
@@@ -107,10 -107,10 +107,10 @@@ case (edges.edge_id = perm_edge_id
         can_manage permission granted by ownership.
    */
    additional_perms(perm_origin_uuid, target_uuid, val, traverse_owned) as (
--    
++
  WITH RECURSIVE
          traverse_graph(origin_uuid, target_uuid, val, traverse_owned, starting_set) as (
--            
++
      select edges.tail_uuid as origin_uuid, edges.head_uuid as target_uuid, edges.val,
             should_traverse_owned(edges.head_uuid, edges.val),
             edges.head_uuid like '_____-j7d0g-_______________'
@@@ -3308,6 -3301,6 +3315,5 @@@ INSERT INTO "schema_migrations" (versio
  ('20230503224107'),
  ('20230815160000'),
  ('20230821000000'),
- ('20230922000000');
- 
- 
++('20230922000000'),
+ ('20231013000000');
 -
 -