From b400772bf3801cb29949cf2ae5021e8e3a8e2d94 Mon Sep 17 00:00:00 2001
From: Jonathan Corbet <corbet@pi.lwn.net>
Date: Thu, 22 Feb 2018 23:05:46 +0000
Subject: Don't use LIMIT in UPDATE statements

...not all distributions build SQLite with that enabled.

[ew: LIMIT shouldn't be necessary because `key' is primary]
---
 lib/PublicInbox/Msgmap.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'lib')

diff --git a/lib/PublicInbox/Msgmap.pm b/lib/PublicInbox/Msgmap.pm
index a147b9f3..6b6d1c6e 100644
--- a/lib/PublicInbox/Msgmap.pm
+++ b/lib/PublicInbox/Msgmap.pm
@@ -57,7 +57,7 @@ sub meta_accessor {
 	$prev = $dbh->selectrow_array($sql, undef, $key);
 
 	if (defined $prev) {
-		$sql = 'UPDATE meta SET val = ? WHERE key = ? LIMIT 1';
+		$sql = 'UPDATE meta SET val = ? WHERE key = ?';
 		$dbh->do($sql, undef, $value, $key);
 	} else {
 		$sql = 'INSERT INTO meta (key,val) VALUES (?,?)';
-- 
cgit v1.2.3-24-ge0c7