summaryrefslogtreecommitdiff
path: root/lib
diff options
context:
space:
mode:
authorfeld <feld@feld.me>2024-02-12 19:37:17 +0000
committerfeld <feld@feld.me>2024-02-12 19:37:17 +0000
commit769e02d0de48484d9396fadb030bf5f708f4fd84 (patch)
treee338311cdb2a4764704dd91bac78fb8f55ce665a /lib
parent991807080bfb35caf32f2403d61dd6ced66a9a50 (diff)
parentcb4d3db8c69104960f18be740cb7253add8c00e4 (diff)
downloadpleroma-769e02d0de48484d9396fadb030bf5f708f4fd84.tar.gz
pleroma-769e02d0de48484d9396fadb030bf5f708f4fd84.zip
Merge branch 'notifications-query' into 'develop'
Fix notifications query to use the index See merge request pleroma/pleroma!4058
Diffstat (limited to 'lib')
-rw-r--r--lib/pleroma/notification.ex2
1 files changed, 1 insertions, 1 deletions
diff --git a/lib/pleroma/notification.ex b/lib/pleroma/notification.ex
index 48d467c59..368e609d2 100644
--- a/lib/pleroma/notification.ex
+++ b/lib/pleroma/notification.ex
@@ -88,7 +88,7 @@ defmodule Pleroma.Notification do
where: q.seen == true,
select: type(q.id, :string),
limit: 1,
- order_by: [desc: :id]
+ order_by: fragment("? desc nulls last", q.id)
)
end