From unknown Tue Jul 15 20:09:49 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--