From unknown Sun Sep 07 16:50:20 2025 X-Loop: help-debbugs@gnu.org Subject: bug#79011: sqlite-mode-delete does not work correctly when field value is NULL Resent-From: "Yue Yi" Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Mon, 14 Jul 2025 06:06:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 79011 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: 79011@debbugs.gnu.org X-Debbugs-Original-To: "bug-gnu-emacs" Received: via spool by submit@debbugs.gnu.org id=B.175247310828305 (code B ref -1); Mon, 14 Jul 2025 06:06:01 +0000 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: "Yue Yi" 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-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 unknown Sun Sep 07 16:50:20 2025 MIME-Version: 1.0 X-Mailer: MIME-tools 5.505 (Entity 5.505) X-Loop: help-debbugs@gnu.org From: help-debbugs@gnu.org (GNU bug Tracking System) To: "Yue Yi" Subject: bug#79011: closed (Re: bug#79011: sqlite-mode-delete does not work correctly when field value is NULL) Message-ID: References: <86tt2z1gjv.fsf@gnu.org> X-Gnu-PR-Message: they-closed 79011 X-Gnu-PR-Package: emacs Reply-To: 79011@debbugs.gnu.org Date: Sat, 26 Jul 2025 08:52:02 +0000 Content-Type: multipart/mixed; boundary="----------=_1753519922-4340-1" This is a multi-part message in MIME format... ------------=_1753519922-4340-1 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset="utf-8" Your bug report #79011: sqlite-mode-delete does not work correctly when field value is NULL which was filed against the emacs package, has been closed. The explanation is attached below, along with your original report. If you require more details, please reply to 79011@debbugs.gnu.org. --=20 79011: https://debbugs.gnu.org/cgi/bugreport.cgi?bug=3D79011 GNU Bug Tracking System Contact help-debbugs@gnu.org with problems ------------=_1753519922-4340-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit 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. ------------=_1753519922-4340-1 Content-Type: message/rfc822 Content-Disposition: inline Content-Transfer-Encoding: 7bit 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-- ------------=_1753519922-4340-1--