12032: Add test fixtures

[arvados.git] / services / api / lib / create_permission_view.sql

diff --git a/services/api/lib/create_permission_view.sql b/services/api/lib/create_permission_view.sql
index e6195d7911f43667d885ba3f626a683da945e0f0..639610ac2a6efd53a7be2cbaf9b29a0608e805e6 100644 (file)
--- a/services/api/lib/create_permission_view.sql
+++ b/services/api/lib/create_permission_view.sql
@@ -37,7 +37,10 @@ perm_edges (tail_uuid, head_uuid, val, follow, trashed) AS (
               LEFT JOIN groups ON pv.val<3 AND groups.uuid = links.head_uuid
               WHERE links.link_class = 'permission'
        UNION ALL
-       SELECT owner_uuid, uuid, 3, true, CASE is_trashed WHEN true THEN 1 ELSE 0 END FROM groups
+       SELECT owner_uuid, uuid, 3, true, CASE
+              WHEN trash_at IS NOT NULL and trash_at < clock_timestamp() THEN 1
+              ELSE 0 END
+              FROM groups
        ),
 perm (val, follow, user_uuid, target_uuid, trashed, startnode) AS (
      SELECT 3::smallint             AS val,