From unknown Sun Sep 07 16:50:59 2025 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable MIME-Version: 1.0 X-Mailer: MIME-tools 5.509 (Entity 5.509) Content-Type: text/plain; charset=utf-8 From: bug#79011 <79011@debbugs.gnu.org> To: bug#79011 <79011@debbugs.gnu.org> Subject: Status: sqlite-mode-delete does not work correctly when field value is NULL Reply-To: bug#79011 <79011@debbugs.gnu.org> Date: Sun, 07 Sep 2025 23:50:59 +0000 retitle 79011 sqlite-mode-delete does not work correctly when field value i= s NULL reassign 79011 emacs submitter 79011 "Yue Yi" severity 79011 normal thanks From debbugs-submit-bounces@debbugs.gnu.org Mon Jul 14 02:05:08 2025 Received: (at submit) by debbugs.gnu.org; 14 Jul 2025 06:05:08 +0000 Received: from localhost ([127.0.0.1]:58839 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ubCJH-0007MT-S1 for submit@debbugs.gnu.org; Mon, 14 Jul 2025 02:05:08 -0400 Received: from lists.gnu.org ([2001:470:142::17]:48676) by debbugs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ubCJD-0007Lb-4T for submit@debbugs.gnu.org; Mon, 14 Jul 2025 02:05:05 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ubCJ2-0005cc-Mh for bug-gnu-emacs@gnu.org; Mon, 14 Jul 2025 02:04:52 -0400 Received: from xmbghk7.mail.qq.com ([43.163.128.48]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ubCIz-0007OI-0L for bug-gnu-emacs@gnu.org; Mon, 14 Jul 2025 02:04:52 -0400 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=qq.com; s=s201512; t=1752473080; bh=eFt7bVUN/fVxK4lov4hKc2dU/5lyJOfd7vxK1ycGCXQ=; h=From:To:Subject:Date; b=BkpSlleQxx3vPeQMBt/OnaBem2m2b379NYmOpHw4RRwMZe0mZiDwEd6tHEG4/qByE 49PM/V/YL2n5I62lEvDG6522elI54MiW/R32JJZrP40viAEybehFB4Zkfcitu4RQO7 cOyOMjqxv4QCLYE5D0+vbQHOOmJsDMYbkH53eaSA= X-QQ-FEAT: oHWrrGTW1dCi2Uhv/TjzETR5+gOBkNuu X-QQ-SSF: 00000000000000F0000000000000 X-QQ-XMRINFO: MSVp+SPm3vtS1Vd6Y4Mggwc= X-QQ-XMAILINFO: M7dxyDFn9MPmHOPjrXvL52O57lowAZpHSWl1di9lXGCIA7v+Uuaxe0QnQ7k7ry 2U0QVQ4l8AjUVMSnk8WPnA01ef7KcyO2+FfRzPI87BiEC/VAikUIEslXpTe+bkT+AU9RUL37X0/xG ORJJNZbcdt9mam5PKVyaUv7RRQS7FmPEyahtr051CnMMYJy6PprQIAM1LPNNczPuzSCzssPTkQ1mf 0yBmwAn6ooYbwkOBTm/u0nEwZ41jPLpb843UHeqD9NuJzOfcCVoKSpkAFeG9o8/r8B99kJCsupNd4 r9XK3fKDyS58RAEQkVKJevBBLvUDVYfDV5siuGosujVenDfepLoP0Le8KhOdav/k3iBW4mCZxwlnq tRrH3SpsCOsXFdpa5FFm7GsKOXbBLdSzMOAyZ7CtmNSc5x+qs2uEfjAFPNwy5V22XrwCa7S8i5LjJ CcZ10TSfQKae7wuDHHw72mlLAJ51A+t53f03B52HMCr6VKgNaHD2aLViphILnVXmxCfUXmH4z27Ig MZhipzP8BpD5hm7w5W2T9/VgIZBgRgJ2Paun/1QjVxhmptzrhW15aOuM4KafVc43lMynAmv55gPNH hGTki3gsRJJSDzFe6TF+YHsLjIf+LnWWcD0Om7yoIJk4kY61Kh8TvYn1NZcMiEFfedFz+A1MAXOaK rNqwgTC2qTjUh8fG6CpDWf02W5UL4DpzIFmz4HXxZZvwJ0LczEABK4uhk36KyThYQoXh/exRJ1y8h 10pCOLIFvWKtrtv7JFWXCpHsluBcGqUXGcXGvfVVJtRzGXw4WAD+u7a0kOhE8D6ZmZqUdMeP2MMH7 Ecp+6oB/FFEtiSu9PeyEsXqZNmvzhYJsnrgHZLnJL2SdWjyE5jmhBAl+dZ90CIeiaYIEl0FikmW8m 4a6JHu0B6X2NuHWxXcJHjjcAdAwgiigivc0XwpclrfvpNq0HLvfiRjl96vxY1E7AinYdG2FvEjacA 6nO46M2pAdv+5aCd5994I4dFJWerOR9myJDAXsrCMCI/ZDReRbts1lO9d95OSBKA0ECs0obg== X-HAS-ATTACH: no X-QQ-BUSINESS-ORIGIN: 2 X-Originating-IP: 223.104.194.6 X-QQ-STYLE: X-QQ-mid: webmail739t1752472639t7951827 From: "=?ISO-8859-1?B?WXVlIFlp?=" To: "=?ISO-8859-1?B?YnVnLWdudS1lbWFjcw==?=" Subject: sqlite-mode-delete does not work correctly when field value is NULL Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_68749C3F_450A23A8_63D2A860" Content-Transfer-Encoding: 8Bit Date: Mon, 14 Jul 2025 13:57:19 +0800 X-Priority: 3 Message-ID: X-QQ-MIME: TCMime 1.0 by Tencent X-Mailer: QQMail 2.x X-QQ-Mailer: QQMail 2.x Received-SPF: pass client-ip=43.163.128.48; envelope-from=include_yy@qq.com; helo=xmbghk7.mail.qq.com X-Spam_score_int: -20 X-Spam_score: -2.1 X-Spam_bar: -- X-Spam_report: (-2.1 / 5.0 requ) BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, FREEMAIL_FROM=0.001, FROM_EXCESS_BASE64=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RCVD_IN_MSPIKE_H4=-0.01, RCVD_IN_MSPIKE_WL=-0.01, RCVD_IN_VALIDITY_RPBL_BLOCKED=0.001, RCVD_IN_VALIDITY_SAFE_BLOCKED=0.001, SPF_HELO_NONE=0.001, SPF_PASS=-0.001 autolearn=ham autolearn_force=no X-Spam_action: no action X-Spam-Score: 0.9 (/) X-Debbugs-Envelope-To: submit X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -0.1 (/) This is a multi-part message in MIME format. ------=_NextPart_68749C3F_450A23A8_63D2A860 Content-Type: text/plain; charset="ISO-8859-1" Content-Transfer-Encoding: base64 SGVsbG8gRW1hY3MgbWFpbnRhaW5lcnMsIFBsZWFzZSBjb25zaWRlciB0aGUgZGF0YWJhc2Ug dGFibGUgY3JlYXRlZCBieSB0aGUgZm9sbG93aW5nIGNvZGU6IC0tLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tJmd0Ozg8LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0g KGxldCAoKGRiIChzcWxpdGUtb3BlbiAidGVzdC5zcWxpdGUzIikpKSAgICh3aXRoLXNxbGl0 ZS10cmFuc2FjdGlvbiBkYiAgICAgKHNxbGl0ZS1leGVjdXRlIGRiICJDUkVBVEUgVEFCTEUg dG1wIChpZCwgdHh0KSIpICAgICAoc3FsaXRlLWV4ZWN1dGUgZGIgIklOU0VSVCBJTlRPIHRt cCBWQUxVRVMgKDEsIG51bGwpIikgICAgIChzcWxpdGUtZXhlY3V0ZSBkYiAiSU5TRVJUIElO VE8gdG1wIHZhbHVlcyAoMiwgJycpIikpKSAtLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0t LS0tLSZndDs4PC0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tIFRoZW4sIG9wZW4g dGVzdC5zcWxpdGUzIHdpdGggYHNxbGl0ZS1tb2RlLW9wZW4tZmlsZScgYW5kIGV4cGFuZCB0 aGUgZGF0YWJhc2UgY29udGVudHMuIFVzZSBERUwgKHNxbGl0ZS1tb2RlLWRlbGV0ZSkgdG8g dHJ5IGRlbGV0aW5nIHRoZSBmaXJzdCBhbmQgc2Vjb25kIHJvd3MuIEFmdGVyIHByZXNzaW5n IGcgKHNxbGl0ZS1tb2RlLWxpc3QtdGFibGVzKSwgeW91J2xsIGZpbmQgdGhhdCB0aGUgZmly c3Qgcm93IHN0aWxsIGV4aXN0cyBhbmQgaGFzbid0IGJlZW4gZGVsZXRlZCBhcyBleHBlY3Rl ZC4gVGhlIHJlYXNvbiBmb3IgdGhpcyBpc3N1ZSBpcyB0aGF0IHdoZW4gYHNxbGl0ZS1tb2Rl LWRlbGV0ZScgY29uc3RydWN0cyB0aGUgU1FMIHN0YXRlbWVudCwgaXQgY29uY2F0ZW5hdGVz IGNvbmRpdGlvbnMgbGlrZSAoRklFTEQgPSA/KSBldmVuIHdoZW4gYSBmaWVsZCdzIHZhbHVl IGlzIE5VTEwsIGluc3RlYWQgb2YgdXNpbmcgKEZJRUxEIElTID8pLiBUbyBjaGVjayB3aGV0 aGVyIGEgZmllbGQgaXMgTlVMTCwgdGhlIGNvcnJlY3Qgc3ludGF4IGlzIElTIE5VTEwgb3Ig SVMgTk9UIE5VTEwuIEhlcmUgaXMgb25lIHBvc3NpYmxlIGZpeDogZGlmZiAtLWdpdCBhL2xp c3Avc3FsaXRlLW1vZGUuZWwgYi9saXNwL3NxbGl0ZS1tb2RlLmVsIGluZGV4IGE0Yjk2YjAy YjQ4Li44MmQ1Y2M4MGEyYyAxMDA2NDQgLS0tIGEvbGlzcC9zcWxpdGUtbW9kZS5lbCArKysg Yi9saXNwL3NxbGl0ZS1tb2RlLmVsIEBAIC0yMDQsOSArMjA0LDEyIEBAIHNxbGl0ZS1tb2Rl LWRlbGV0ZSAgICAgICAoZm9ybWF0ICJkZWxldGUgZnJvbSBcIiVzXCIgd2hlcmUgJXMiICAg ICAgICAgICAgICAgKGNkciB0YWJsZSkgICAgICAgICAgICAgICAoc3RyaW5nLWpvaW4gLSAg ICAgICAgICAgICAgKG1hcGNhciAobGFtYmRhIChjb2x1bW4pIC0gICAgICAgICAgICAgICAg ICAgICAgICAoZm9ybWF0ICJcIiVzXCIgPSA/IiAoY2FyIChzcGxpdC1zdHJpbmcgY29sdW1u ICIgIikpKSkgLSAgICAgICAgICAgICAgICAgICAgICAoY29ucyAicm93aWQiIChzcWxpdGUt bW9kZS0tY29sdW1uLW5hbWVzIChjZHIgdGFibGUpKSkpICsgICAgICAgICAgICAgIChjbC1t YXBjYXIgKGxhbWJkYSAoY29sdW1uIHZhbHVlKSArICAgICAgICAgICAgICAgICAgICAgICAg ICAgKGZvcm1hdCAiXCIlc1wiICVzID8iICsgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgIChjYXIgKHNwbGl0LXN0cmluZyBjb2x1bW4gIiAiKSkgKyAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgKGlmIHZhbHVlICI9IiAiaXMiKSkpICsgICAgICAgICAg ICAgICAgICAgICAgICAgKGNvbnMgInJvd2lkIiAoc3FsaXRlLW1vZGUtLWNvbHVtbi1uYW1l cyAoY2RyIHRhYmxlKSkpICsgICAgICAgICAgICAgICAgICAgICAgICAgcm93KSAgICAgICAg ICAgICAgICAiIGFuZCAiKSkgICAgICAgcm93KSAgICAgIChkZWxldGUtcmVnaW9uIChsaW5l LWJlZ2lubmluZy1wb3NpdGlvbikgKHByb2duIChmb3J3YXJkLWxpbmUgMSkgKHBvaW50KSkp KSkgUmVnYXJkcy4= ------=_NextPart_68749C3F_450A23A8_63D2A860 Content-Type: text/html; charset="ISO-8859-1" Content-Transfer-Encoding: base64 PG1ldGEgaHR0cC1lcXVpdj0iQ29udGVudC1UeXBlIiBjb250ZW50PSJ0ZXh0L2h0bWw7IGNo YXJzZXQ9R0IxODAzMCI+PHByZT5IZWxsbyBFbWFjcyBtYWludGFpbmVycywKClBsZWFzZSBj b25zaWRlciB0aGUgZGF0YWJhc2UgdGFibGUgY3JlYXRlZCBieSB0aGUgZm9sbG93aW5nIGNv ZGU6CgotLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLSZndDs4Jmx0Oy0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tCihsZXQgKChkYiAoc3FsaXRlLW9wZW4gInRlc3Qu c3FsaXRlMyIpKSkKICAod2l0aC1zcWxpdGUtdHJhbnNhY3Rpb24gZGIKICAgIChzcWxpdGUt ZXhlY3V0ZSBkYiAiQ1JFQVRFIFRBQkxFIHRtcCAoaWQsIHR4dCkiKQogICAgKHNxbGl0ZS1l eGVjdXRlIGRiICJJTlNFUlQgSU5UTyB0bXAgVkFMVUVTICgxLCBudWxsKSIpCiAgICAoc3Fs aXRlLWV4ZWN1dGUgZGIgIklOU0VSVCBJTlRPIHRtcCB2YWx1ZXMgKDIsICcnKSIpKSkKLS0t LS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0tLS0mZ3Q7OCZsdDstLS0tLS0tLS0tLS0tLS0t LS0tLS0tLS0tLS0tLS0tLQoKVGhlbiwgb3BlbiB0ZXN0LnNxbGl0ZTMgd2l0aCBgc3FsaXRl LW1vZGUtb3Blbi1maWxlJyBhbmQgZXhwYW5kIHRoZQpkYXRhYmFzZSBjb250ZW50cy4gVXNl IERFTCAoc3FsaXRlLW1vZGUtZGVsZXRlKSB0byB0cnkgZGVsZXRpbmcgdGhlCmZpcnN0IGFu ZCBzZWNvbmQgcm93cy4gQWZ0ZXIgcHJlc3NpbmcgZyAoc3FsaXRlLW1vZGUtbGlzdC10YWJs ZXMpLAp5b3UnbGwgZmluZCB0aGF0IHRoZSBmaXJzdCByb3cgc3RpbGwgZXhpc3RzIGFuZCBo YXNuJ3QgYmVlbiBkZWxldGVkIGFzCmV4cGVjdGVkLgoKVGhlIHJlYXNvbiBmb3IgdGhpcyBp c3N1ZSBpcyB0aGF0IHdoZW4gYHNxbGl0ZS1tb2RlLWRlbGV0ZScgY29uc3RydWN0cwp0aGUg U1FMIHN0YXRlbWVudCwgaXQgY29uY2F0ZW5hdGVzIGNvbmRpdGlvbnMgbGlrZSAoRklFTEQg PSA/KSBldmVuIHdoZW4KYSBmaWVsZCdzIHZhbHVlIGlzIE5VTEwsIGluc3RlYWQgb2YgdXNp bmcgKEZJRUxEIElTID8pLiBUbyBjaGVjayB3aGV0aGVyCmEgZmllbGQgaXMgTlVMTCwgdGhl IGNvcnJlY3Qgc3ludGF4IGlzIElTIE5VTEwgb3IgSVMgTk9UIE5VTEwuCgpIZXJlIGlzIG9u ZSBwb3NzaWJsZSBmaXg6CgpkaWZmIC0tZ2l0IGEvbGlzcC9zcWxpdGUtbW9kZS5lbCBiL2xp c3Avc3FsaXRlLW1vZGUuZWwKaW5kZXggYTRiOTZiMDJiNDguLjgyZDVjYzgwYTJjIDEwMDY0 NAotLS0gYS9saXNwL3NxbGl0ZS1tb2RlLmVsCisrKyBiL2xpc3Avc3FsaXRlLW1vZGUuZWwK QEAgLTIwNCw5ICsyMDQsMTIgQEAgc3FsaXRlLW1vZGUtZGVsZXRlCiAgICAgIChmb3JtYXQg ImRlbGV0ZSBmcm9tIFwiJXNcIiB3aGVyZSAlcyIKICAgICAgICAgICAgICAoY2RyIHRhYmxl KQogICAgICAgICAgICAgIChzdHJpbmctam9pbgotICAgICAgICAgICAgICAobWFwY2FyIChs YW1iZGEgKGNvbHVtbikKLSAgICAgICAgICAgICAgICAgICAgICAgIChmb3JtYXQgIlwiJXNc IiA9ID8iIChjYXIgKHNwbGl0LXN0cmluZyBjb2x1bW4gIiAiKSkpKQotICAgICAgICAgICAg ICAgICAgICAgIChjb25zICJyb3dpZCIgKHNxbGl0ZS1tb2RlLS1jb2x1bW4tbmFtZXMgKGNk ciB0YWJsZSkpKSkKKyAgICAgICAgICAgICAgKGNsLW1hcGNhciAobGFtYmRhIChjb2x1bW4g dmFsdWUpCisgICAgICAgICAgICAgICAgICAgICAgICAgICAoZm9ybWF0ICJcIiVzXCIgJXMg PyIKKyAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgKGNhciAoc3BsaXQtc3Ry aW5nIGNvbHVtbiAiICIpKQorICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAo aWYgdmFsdWUgIj0iICJpcyIpKSkKKyAgICAgICAgICAgICAgICAgICAgICAgICAoY29ucyAi cm93aWQiIChzcWxpdGUtbW9kZS0tY29sdW1uLW5hbWVzIChjZHIgdGFibGUpKSkKKyAgICAg ICAgICAgICAgICAgICAgICAgICByb3cpCiAgICAgICAgICAgICAgICIgYW5kICIpKQogICAg ICByb3cpCiAgICAgKGRlbGV0ZS1yZWdpb24gKGxpbmUtYmVnaW5uaW5nLXBvc2l0aW9uKSAo cHJvZ24gKGZvcndhcmQtbGluZSAxKSAocG9pbnQpKSkpKQoKUmVnYXJkcy4KPC9wcmU+ ------=_NextPart_68749C3F_450A23A8_63D2A860-- From debbugs-submit-bounces@debbugs.gnu.org Sat Jul 26 04:51:13 2025 Received: (at 79011-done) by debbugs.gnu.org; 26 Jul 2025 08:51:13 +0000 Received: from localhost ([127.0.0.1]:39779 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ufacb-00014k-E4 for submit@debbugs.gnu.org; Sat, 26 Jul 2025 04:51:13 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:37156) by debbugs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1ufacX-000141-G0 for 79011-done@debbugs.gnu.org; Sat, 26 Jul 2025 04:51:11 -0400 Received: from fencepost.gnu.org ([2001:470:142:3::e]) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ufacR-0006tD-Nl; Sat, 26 Jul 2025 04:51:03 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnu.org; s=fencepost-gnu-org; h=References:Subject:In-Reply-To:To:From:Date: mime-version; bh=dvgO2sU+RGZQqlSmb5gsZfVK2CETH5dLif/AcUQiUuc=; b=rPbKAWBLzi3M CMKvtry7ZSgrT+tEy5KlecipL6oQtkPyIxqL7zjCcjrjGfxQZ3xz9T1SaXeCvYwHC/gzSaEwWXMTh ai4QDNAK6scFCHVay5cFTWgfR6cRN5MH2C+FA7tYNwPrV39vs9SznyILPCi+6ynwVep1WSvUWWnn0 JX6oJhD0FHnWXyyaDFil++nAbCDrbGJGKMWnVGNIcqHYg7UURg5JBkFC5bMQcgpigVzRE4BCc4EYr 2y8QbrqcFAUuMyIXyX+cmq2bkisNiuac1lmimW1MpbpN0LIkOO1ogalnOQp35ibvXcR29EbwtU2hE rsuPJ6TTwUse0UT7lW4CDg==; Date: Sat, 26 Jul 2025 11:51:00 +0300 Message-Id: <86tt2z1gjv.fsf@gnu.org> From: Eli Zaretskii To: "Yue Yi" In-Reply-To: (bug-gnu-emacs@gnu.org) Subject: Re: bug#79011: sqlite-mode-delete does not work correctly when field value is NULL References: X-Spam-Score: -2.3 (--) X-Debbugs-Envelope-To: 79011-done Cc: 79011-done@debbugs.gnu.org X-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list List-Id: List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: debbugs-submit-bounces@debbugs.gnu.org Sender: "Debbugs-submit" X-Spam-Score: -3.3 (---) > Date: Mon, 14 Jul 2025 13:57:19 +0800 > From: "Yue Yi" via "Bug reports for GNU Emacs, > the Swiss army knife of text editors" > > Please consider the database table created by the following code: > > -------------------------------->8<-------------------------------- > (let ((db (sqlite-open "test.sqlite3"))) > (with-sqlite-transaction db > (sqlite-execute db "CREATE TABLE tmp (id, txt)") > (sqlite-execute db "INSERT INTO tmp VALUES (1, null)") > (sqlite-execute db "INSERT INTO tmp values (2, '')"))) > -------------------------------->8<-------------------------------- > > Then, open test.sqlite3 with `sqlite-mode-open-file' and expand the > database contents. Use DEL (sqlite-mode-delete) to try deleting the > first and second rows. After pressing g (sqlite-mode-list-tables), > you'll find that the first row still exists and hasn't been deleted as > expected. > > The reason for this issue is that when `sqlite-mode-delete' constructs > the SQL statement, it concatenates conditions like (FIELD = ?) even when > a field's value is NULL, instead of using (FIELD IS ?). To check whether > a field is NULL, the correct syntax is IS NULL or IS NOT NULL. > > Here is one possible fix: Thanks, installed on the master branch, and closing the bug. From unknown Sun Sep 07 16:50:59 2025 Received: (at fakecontrol) by fakecontrolmessage; To: internal_control@debbugs.gnu.org From: Debbugs Internal Request Subject: Internal Control Message-Id: bug archived. Date: Sat, 23 Aug 2025 11:24:05 +0000 User-Agent: Fakemail v42.6.9 # This is a fake control message. # # The action: # bug archived. thanks # This fakemail brought to you by your local debbugs # administrator