verifications will not be processed until their topic is active

[websub-hub] / src / db / postgres / sql / schema / 1.0.0 / apply.sql

diff --git a/src/db/postgres/sql/schema/1.0.0/apply.sql b/src/db/postgres/sql/schema/1.0.0/apply.sql
index 2665882108cef64db73e9293442edac259020cff..24e955dbfc0c26423e998eff3870067164cecf89 100644 (file)
--- a/src/db/postgres/sql/schema/1.0.0/apply.sql
+++ b/src/db/postgres/sql/schema/1.0.0/apply.sql
@@ -174,7 +174,7 @@ BEGIN;
                SELECT *
                FROM verification
                WHERE
-                       (topic_id, callback, created) IN (SELECT topic_id, callback, max(created) AS created FROM verification GROUP BY (topic_id, callback))
+                       (topic_id, callback, created) IN (SELECT topic_id, callback, max(created) AS created FROM verification GROUP BY topic_id, callback)
                AND
                        (topic_id, callback) NOT IN (SELECT topic_id, callback FROM verification_in_progress_active)
                AND