You are viewing a plain text version of this content. The canonical link for it is here.

Posted to commits@spamassassin.apache.org by he...@apache.org on 2022/04/11 11:41:02 UTC

svn commit: r1899745 - /spamassassin/branches/3.4/sql/txrep_sqlite.sql

Author: hege
Date: Mon Apr 11 11:41:02 2022
New Revision: 1899745

URL: http://svn.apache.org/viewvc?rev=1899745&view=rev
Log:
Fix typo

Modified:
    spamassassin/branches/3.4/sql/txrep_sqlite.sql

Modified: spamassassin/branches/3.4/sql/txrep_sqlite.sql
URL: http://svn.apache.org/viewvc/spamassassin/branches/3.4/sql/txrep_sqlite.sql?rev=1899745&r1=1899744&r2=1899745&view=diff
==============================================================================
--- spamassassin/branches/3.4/sql/txrep_sqlite.sql (original)
+++ spamassassin/branches/3.4/sql/txrep_sqlite.sql Mon Apr 11 11:41:02 2022
@@ -15,7 +15,7 @@ CREATE TRIGGER [UpdateLastHit]
     AFTER UPDATE
     ON txrep
     FOR EACH ROW
-    WHEN NEW.last_hot < OLD.last_hit
+    WHEN NEW.last_hit < OLD.last_hit
 BEGIN
     UPDATE txrep SET last_hit=CURRENT_TIMESTAMP 
     WHERE (username=OLD.username AND email=OLD.email AND signedby=OLD.signedby AND ip=OLD.ip);