From unknown Sun Jun 22 04:18:11 2025 X-Loop: help-debbugs@gnu.org Subject: bug#58390: 29.0.50; sqlite: on INSERT RETURNING id does not return value Resent-From: Jean Louis Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Sun, 09 Oct 2022 07:23:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 58390 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: 58390@debbugs.gnu.org X-Debbugs-Original-To: bug-gnu-emacs@gnu.org Received: via spool by submit@debbugs.gnu.org id=B.16653001705284 (code B ref -1); Sun, 09 Oct 2022 07:23:02 +0000 Received: (at submit) by debbugs.gnu.org; 9 Oct 2022 07:22:50 +0000 Received: from localhost ([127.0.0.1]:41875 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ohQe9-0001N9-Su for submit@debbugs.gnu.org; Sun, 09 Oct 2022 03:22:50 -0400 Received: from lists.gnu.org ([209.51.188.17]:58584) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ohQe6-0001N0-Lf for submit@debbugs.gnu.org; Sun, 09 Oct 2022 03:22:48 -0400 Received: from eggs.gnu.org ([2001:470:142:3::10]:48810) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ohQe6-0001DS-Gn for bug-gnu-emacs@gnu.org; Sun, 09 Oct 2022 03:22:46 -0400 Received: from stw1.rcdrun.com ([217.170.207.13]:40779) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ohQe4-0002sF-H1 for bug-gnu-emacs@gnu.org; Sun, 09 Oct 2022 03:22:46 -0400 Received: from localhost ([::ffff:197.239.7.157]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 00000000000BBD14.00000000634276C2.000077CE; Sun, 09 Oct 2022 00:22:42 -0700 From: Jean Louis Date: Sun, 09 Oct 2022 10:19:16 +0300 Message-ID: <86pmf1o45n.fsf@protected.rcdrun.com> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Received-SPF: pass client-ip=217.170.207.13; envelope-from=admin@protected.rcdrun.com; helo=stw1.rcdrun.com X-Spam_score_int: -14 X-Spam_score: -1.5 X-Spam_bar: - X-Spam_report: (-1.5 / 5.0 requ) BAYES_00=-1.9, HEADER_FROM_DIFFERENT_DOMAINS=0.249, RCVD_IN_SBL=0.141, SPF_HELO_PASS=-0.001, SPF_PASS=-0.001 autolearn=no autolearn_force=no X-Spam_action: no action X-Spam-Score: 1.5 (+) X-Spam-Report: Spam detection software, running on the system "debbugs.gnu.org", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see the administrator of that system for details. Content preview: Here I see not acceptable behavior with sqlite- functions, as INSERT statement does not return the value. (setq my-db (sqlite-open "~/my-org-properties")) my-db =?UTF-8?Q?=E2=87=92?= # Content analysis details: (1.5 points, 10.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -2.3 RCVD_IN_DNSWL_MED RBL: Sender listed at https://www.dnswl.org/, medium trust [209.51.188.17 listed in list.dnswl.org] 2.6 RCVD_IN_SBL RBL: Received via a relay in Spamhaus SBL [197.239.7.157 listed in zen.spamhaus.org] 0.2 HEADER_FROM_DIFFERENT_DOMAINS From and EnvelopeFrom 2nd level mail domains are different -0.0 SPF_HELO_PASS SPF: HELO matches SPF record 0.9 SPF_FAIL SPF: sender does not match SPF record (fail) [SPF failed: Please see http://www.openspf.org/Why?s=mfrom;id=admin%40protected.rcdrun.com;ip=209.51.188.17;r=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: 0.5 (/) Here I see not acceptable behavior with sqlite- functions, as INSERT statement does not return the value. (setq my-db (sqlite-open "~/my-org-properties")) my-db =E2=87=92 # (sqlite-execute my-db "CREATE TABLE people1 (people_id INTEGER PRIMARY KEY, people_firstname TEXT, people_middlenames TEXT, people_name TEXT NOT NULL DEFAUL= T '>>>UNKNOWN<<<', people_email TEXT, people_description TEXT)") (sqlite-select my-db "SELECT * FROM people") =E2=87=92 nil (sqlite-execute my-db "INSERT INTO people (people_firstname, people_name, p= eople_email) VALUES (?, ?, ?) RETURNING people_id"=20 '("Joe" "Doe" "joedoe@example.com")) and after that function I get message "not an error". That is not proper. What I actually expect is to get the `people_id' but function does not return it. Returning the values is very important for future work with SQLite in Emacs. I can expect it, I see it worked well: (sqlite-select my-db "SELECT * FROM people") =E2=87=92 ((1 "Joe" nil "Doe" = "joedoe@example.com" nil)) This one is returning well the value of deleted people: (sqlite-execute my-db "DELETE FROM people") =E2=87=92 1 Let me confirm it: (sqlite-select my-db "SELECT * FROM people") =E2=87=92 nil Let me try to delete it again: (sqlite-execute my-db "DELETE FROM people") =E2=87=92 0 I will keep testing it. In GNU Emacs 29.0.50 (build 4, x86_64-pc-linux-gnu, X toolkit, cairo version 1.17.6, Xaw3d scroll bars) of 2022-10-05 built on protected.rcdrun.com Repository revision: 9449e0740cd97bbcdbaeb4713dc2dd51e65994fd Repository branch: master Windowing system distributor 'The X.Org Foundation', version 11.0.12101004 System Description: Parabola GNU/Linux-libre Configured using: 'configure --with-x-toolkit=3Dlucid' Configured features: ACL CAIRO DBUS FREETYPE GIF GLIB GMP GNUTLS GPM GSETTINGS HARFBUZZ JPEG JSON LCMS2 LIBOTF LIBSYSTEMD LIBXML2 M17N_FLT MODULES NOTIFY INOTIFY PDUMPER PNG RSVG SECCOMP SOUND SQLITE3 THREADS TIFF TOOLKIT_SCROLL_BARS WEBP X11 XAW3D XDBE XIM XINPUT2 XPM LUCID ZLIB Important settings: value of $LC_ALL: en_US.UTF-8 value of $LANG: de_DE.UTF-8 value of $XMODIFIERS: @im=3Dexwm-xim locale-coding-system: utf-8-unix Major mode: ELisp/d Minor modes in effect: tooltip-mode: t global-eldoc-mode: t eldoc-mode: t show-paren-mode: t electric-indent-mode: t mouse-wheel-mode: t tool-bar-mode: t menu-bar-mode: t file-name-shadow-mode: t global-font-lock-mode: t font-lock-mode: t blink-cursor-mode: t line-number-mode: t indent-tabs-mode: t transient-mark-mode: t auto-composition-mode: t auto-encryption-mode: t auto-compression-mode: t Load-path shadows: None found. Features: (shadow sort mail-extr emacsbug message mailcap yank-media puny dired dired-loaddefs rfc822 mml mml-sec epa derived epg rfc6068 epg-config gnus-util text-property-search time-date mm-decode mm-bodies mm-encode mail-parse rfc2231 mailabbrev gmm-utils mailheader sendmail rfc2047 rfc2045 ietf-drums mm-util mail-prsvr mail-utils sql auth-source cl-seq eieio eieio-core cl-macs password-cache json subr-x map byte-opt gv bytecomp byte-compile cconv view thingatpt comint ansi-osc ansi-color ring cl-loaddefs cl-lib display-line-numbers rmc iso-transl tooltip eldoc paren electric uniquify ediff-hook vc-hooks lisp-float-type elisp-mode mwheel term/x-win x-win term/common-win x-dnd tool-bar dnd fontset image regexp-opt fringe tabulated-list replace newcomment text-mode lisp-mode prog-mode register page tab-bar menu-bar rfn-eshadow isearch easymenu timer select scroll-bar mouse jit-lock font-lock syntax font-core term/tty-colors frame minibuffer nadvice seq simple cl-generic indonesian philippine cham georgian utf-8-lang misc-lang vietnamese tibetan thai tai-viet lao korean japanese eucjp-ms cp51932 hebrew greek romanian slovak czech european ethiopic indian cyrillic chinese composite emoji-zwj charscript charprop case-table epa-hook jka-cmpr-hook help abbrev obarray oclosure cl-preloaded button loaddefs faces cus-face macroexp files window text-properties overlay sha1 md5 base64 format env code-pages mule custom widget keymap hashtable-print-readable backquote threads dbusbind inotify lcms2 dynamic-setting system-font-setting font-render-setting cairo x-toolkit xinput2 x multi-tty make-network-process emacs) Memory information: ((conses 16 61937 9937) (symbols 48 7314 2) (strings 32 21536 2117) (string-bytes 1 684680) (vectors 16 14306) (vector-slots 8 201108 13531) (floats 8 30 73) (intervals 56 879 50) (buffers 1000 14)) --=20 Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/ From unknown Sun Jun 22 04:18:11 2025 X-Loop: help-debbugs@gnu.org Subject: bug#58390: 29.0.50; sqlite: on INSERT RETURNING id does not return value Resent-From: Lars Ingebrigtsen Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Mon, 10 Oct 2022 09:00:02 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 58390 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: Jean Louis Cc: 58390@debbugs.gnu.org Received: via spool by 58390-submit@debbugs.gnu.org id=B58390.16653923465169 (code B ref 58390); Mon, 10 Oct 2022 09:00:02 +0000 Received: (at 58390) by debbugs.gnu.org; 10 Oct 2022 08:59:06 +0000 Received: from localhost ([127.0.0.1]:45998 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ohocr-0001LJ-Vg for submit@debbugs.gnu.org; Mon, 10 Oct 2022 04:59:06 -0400 Received: from quimby.gnus.org ([95.216.78.240]:53082) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ohocp-0001Kd-4S for 58390@debbugs.gnu.org; Mon, 10 Oct 2022 04:59:04 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Content-Type:MIME-Version:Message-ID:Date:References: In-Reply-To:Subject:Cc:To:From:Sender:Reply-To:Content-Transfer-Encoding: Content-ID:Content-Description:Resent-Date:Resent-From:Resent-Sender: Resent-To:Resent-Cc:Resent-Message-ID:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=Jfrx5bvucMr2eOw0SHR+hDbUrzNt58jONW+xfRaAZmA=; b=dwQTzAKwlSJs/iEwNgh04rG2wd Vj7qJfE3MVAHKWMPQVZ0m79r8ox/ThMuWWEFUErZ+/bPVLuI2LDfN3Rkhc9SsrxgY/GHjDflx29Vk Ymq1PevcB3E3Y8sJG93YQJqSal2iysRpuUw1Zj06kxXZ2/FE6guN8JaOKP9OlGMzYRvE=; Received: from [84.212.220.105] (helo=downe) by quimby.gnus.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ohocf-0006qx-Q8; Mon, 10 Oct 2022 10:58:56 +0200 From: Lars Ingebrigtsen In-Reply-To: <86pmf1o45n.fsf@protected.rcdrun.com> (Jean Louis's message of "Sun, 09 Oct 2022 10:19:16 +0300") References: <86pmf1o45n.fsf@protected.rcdrun.com> X-Now-Playing: Everything But The Girl's _Amplified Heart_: "Get Me" Date: Mon, 10 Oct 2022 10:58:53 +0200 Message-ID: <87bkqknjg2.fsf@gnus.org> User-Agent: Gnus/5.13 (Gnus v5.13) MIME-Version: 1.0 Content-Type: text/plain X-Spam-Report: Spam detection software, running on the system "quimby.gnus.org", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see @@CONTACT_ADDRESS@@ for details. Content preview: Jean Louis writes: > (sqlite-execute my-db "INSERT INTO people (people_firstname, people_name, people_email) > VALUES (?, ?, ?) > RETURNING people_id" > '("Joe" "Doe" "joedoe@example.com")) > and after that function I g [...] Content analysis details: (-2.9 points, 5.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -1.0 ALL_TRUSTED Passed through trusted hosts only via SMTP -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] X-Spam-Score: -2.3 (--) 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 (---) Jean Louis writes: > (sqlite-execute my-db "INSERT INTO people (people_firstname, people_name, people_email) > VALUES (?, ?, ?) > RETURNING people_id" > '("Joe" "Doe" "joedoe@example.com")) > and after that function I get message "not an error". That is not proper. I've now fixed this in Emacs 29. From debbugs-submit-bounces@debbugs.gnu.org Mon Oct 10 04:59:08 2022 Received: (at control) by debbugs.gnu.org; 10 Oct 2022 08:59:08 +0000 Received: from localhost ([127.0.0.1]:46001 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ohocu-0001LX-8g for submit@debbugs.gnu.org; Mon, 10 Oct 2022 04:59:08 -0400 Received: from quimby.gnus.org ([95.216.78.240]:53098) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ohocs-0001Kn-TZ for control@debbugs.gnu.org; Mon, 10 Oct 2022 04:59:07 -0400 DKIM-Signature: v=1; a=rsa-sha256; q=dns/txt; c=relaxed/relaxed; d=gnus.org; s=20200322; h=Subject:From:To:Message-Id:Date:Sender:Reply-To:Cc: MIME-Version:Content-Type:Content-Transfer-Encoding:Content-ID: Content-Description:Resent-Date:Resent-From:Resent-Sender:Resent-To:Resent-Cc :Resent-Message-ID:In-Reply-To:References:List-Id:List-Help:List-Unsubscribe: List-Subscribe:List-Post:List-Owner:List-Archive; bh=rq9BZp3smK4DR456U+hdXVhAj0Aq8k1IVLu94rWiWZU=; b=mi/gZmStltu6AfRUtbiwmjR0Tb vHhkXXTYZ8PMNBj/F9m/2C/dIT/wcRrNM9SgfwkIwmxgV1eA4G8d7xyZWhywtFlEn7XBvbqMF0E2Q eImnS2vmsbnLBLYV92mVszbvcRb9KFi2TBsqGhYJE6yXPZtxDWG2zML5wNHf0BbzhnEI=; Received: from [84.212.220.105] (helo=downe) by quimby.gnus.org with esmtpsa (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ohock-0006r4-QO for control@debbugs.gnu.org; Mon, 10 Oct 2022 10:59:01 +0200 Date: Mon, 10 Oct 2022 10:58:58 +0200 Message-Id: <87a664njfx.fsf@gnus.org> To: control@debbugs.gnu.org From: Lars Ingebrigtsen Subject: control message for bug #58390 X-Spam-Report: Spam detection software, running on the system "quimby.gnus.org", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see @@CONTACT_ADDRESS@@ for details. Content preview: close 58390 29.1 quit Content analysis details: (-2.9 points, 5.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- -1.0 ALL_TRUSTED Passed through trusted hosts only via SMTP -1.9 BAYES_00 BODY: Bayes spam probability is 0 to 1% [score: 0.0000] X-Spam-Score: -2.3 (--) X-Debbugs-Envelope-To: control 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 (---) close 58390 29.1 quit From unknown Sun Jun 22 04:18:11 2025 X-Loop: help-debbugs@gnu.org Subject: bug#58390: 29.0.50; sqlite: on INSERT RETURNING id does not return value Resent-From: Jean Louis Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Mon, 10 Oct 2022 10:07:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: followup 58390 X-GNU-PR-Package: emacs X-GNU-PR-Keywords: To: 58390@debbugs.gnu.org Received: via spool by 58390-submit@debbugs.gnu.org id=B58390.166539636520396 (code B ref 58390); Mon, 10 Oct 2022 10:07:01 +0000 Received: (at 58390) by debbugs.gnu.org; 10 Oct 2022 10:06:05 +0000 Received: from localhost ([127.0.0.1]:46170 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ohpfd-0005Ig-Tq for submit@debbugs.gnu.org; Mon, 10 Oct 2022 06:06:05 -0400 Received: from stw1.rcdrun.com ([217.170.207.13]:42621) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ohpfb-0005IF-La for 58390@debbugs.gnu.org; Mon, 10 Oct 2022 06:06:00 -0400 Received: from localhost ([::ffff:197.239.4.3]) (AUTH: PLAIN admin, TLS: TLS1.3,256bits,ECDHE_RSA_AES_256_GCM_SHA384) by stw1.rcdrun.com with ESMTPSA id 00000000000BBD19.000000006343EE82.0000112E; Mon, 10 Oct 2022 03:05:53 -0700 Date: Mon, 10 Oct 2022 11:43:31 +0300 From: Jean Louis Message-ID: References: <86pmf1o45n.fsf@protected.rcdrun.com> Mime-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline In-Reply-To: <86pmf1o45n.fsf@protected.rcdrun.com> User-Agent: Mutt/2.2.7+37 (a90f69b) (2022-09-02) X-Spam-Score: 2.6 (++) X-Spam-Report: Spam detection software, running on the system "debbugs.gnu.org", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see the administrator of that system for details. Content preview: One can see on command line that RETURNING works well in SQLite: sqlite> insert into people default values returning people_id; 5 That is necessary to have in Emacs functions to get the return value from `sqlite-execute' as well. Content analysis details: (2.6 points, 10.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- 2.6 RCVD_IN_SBL RBL: Received via a relay in Spamhaus SBL [197.239.4.3 listed in zen.spamhaus.org] -0.0 SPF_PASS SPF: sender matches SPF record -0.0 SPF_HELO_PASS SPF: HELO matches SPF record 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: 1.6 (+) X-Spam-Report: Spam detection software, running on the system "debbugs.gnu.org", has NOT identified this incoming email as spam. The original message has been attached to this so you can view it or label similar future email. If you have any questions, see the administrator of that system for details. Content preview: One can see on command line that RETURNING works well in SQLite: sqlite> insert into people default values returning people_id; 5 That is necessary to have in Emacs functions to get the return value from `sqlite-execute' as well. Content analysis details: (1.6 points, 10.0 required) pts rule name description ---- ---------------------- -------------------------------------------------- 2.6 RCVD_IN_SBL RBL: Received via a relay in Spamhaus SBL [197.239.4.3 listed in zen.spamhaus.org] 0.0 T_SPF_TEMPERROR SPF: test of record failed (temperror) -0.0 SPF_HELO_PASS SPF: HELO matches SPF record -1.0 MAILING_LIST_MULTI Multiple indicators imply a widely-seen list manager One can see on command line that RETURNING works well in SQLite: sqlite> insert into people default values returning people_id; 5 That is necessary to have in Emacs functions to get the return value from `sqlite-execute' as well. -- Jean Take action in Free Software Foundation campaigns: https://www.fsf.org/campaigns In support of Richard M. Stallman https://stallmansupport.org/