metadata: Fix prepared statements joining on XEP status default tip

Mon, 07 Aug 2023 12:47:52 +0100

author
Matthew Wild <mwild1@gmail.com>
date
Mon, 07 Aug 2023 12:47:52 +0100
changeset 7
bfc568736c13
parent 6
266242703b38

metadata: Fix prepared statements joining on XEP status

metadata.yml file | annotate | diff | comparison | revisions
--- a/metadata.yml	Mon Mar 20 11:49:20 2023 +0000
+++ b/metadata.yml	Mon Aug 07 12:47:52 2023 +0100
@@ -90,7 +90,7 @@
             xeps
             join implementations on implementations.xep_id = xeps.id
           where
-            status = "Deferred"
+            xeps.status = "Deferred"
           group by
             xeps.id
           order by
@@ -108,7 +108,7 @@
             xeps
             join implementations on implementations.xep_id = xeps.id
           where
-            status = "Experimental"
+            xeps.status = "Experimental"
           group by
             xeps.id
           order by
@@ -124,7 +124,7 @@
           from
             xeps
           where
-            status = "Proposed"
+            xeps.status = "Proposed"
           order by
             last_updated desc;
       inbox:

mercurial