coder
diff --git a/‎coderd/database/queries.sql.go
Lines changed: 4 additions & 6 deletions b/‎coderd/database/queries.sql.go
Lines changed: 4 additions & 6 deletions
diff --git a/‎coderd/database/queries/notifications.sql
Lines changed: 4 additions & 6 deletions b/‎coderd/database/queries/notifications.sql
Lines changed: 4 additions & 6 deletions
@@ -86,10 +86,6 @@ FROM acquired nm
          JOIN notification_templates nt ON nm.notification_template_id = nt.id;
 
 -- name: BulkMarkNotificationMessagesFailed :execrows
-WITH new_values AS (SELECT UNNEST(@ids::uuid[])                             AS id,
-                           UNNEST(@failed_ats::timestamptz[])               AS failed_at,
-                           UNNEST(@statuses::notification_message_status[]) AS status,
-                           UNNEST(@status_reasons::text[])                  AS status_reason)
 UPDATE notification_messages
 SET updated_at       = subquery.failed_at,
     attempt_count    = attempt_count + 1,
@@ -101,8 +97,10 @@ SET updated_at       = subquery.failed_at,
     next_retry_after = CASE
                            WHEN (attempt_count + 1 < @max_attempts::int)
                                THEN NOW() + CONCAT(@retry_interval::int, ' seconds')::interval END
-FROM (SELECT id, status, status_reason, failed_at
-      FROM new_values) AS subquery
+FROM (SELECT UNNEST(@ids::uuid[])                             AS id,
+             UNNEST(@failed_ats::timestamptz[])               AS failed_at,
+             UNNEST(@statuses::notification_message_status[]) AS status,
+             UNNEST(@status_reasons::text[])                  AS status_reason) AS subquery
 WHERE notification_messages.id = subquery.id;
 
 -- name: BulkMarkNotificationMessagesSent :execrows