From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Jean Louis Newsgroups: gmane.emacs.bugs Subject: bug#58390: 29.0.50; sqlite: on INSERT RETURNING id does not return value 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 Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="29746"; mail-complaints-to="usenet@ciao.gmane.io" To: 58390@debbugs.gnu.org Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Sun Oct 09 09:23:20 2022 Return-path: Envelope-to: geb-bug-gnu-emacs@m.gmane-mx.org Original-Received: from lists.gnu.org ([209.51.188.17]) by ciao.gmane.io with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ohQed-0007ah-DW for geb-bug-gnu-emacs@m.gmane-mx.org; Sun, 09 Oct 2022 09:23:19 +0200 Original-Received: from localhost ([::1]:54856 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1ohQec-0001Eg-HV for geb-bug-gnu-emacs@m.gmane-mx.org; Sun, 09 Oct 2022 03:23:18 -0400 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:32992) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ohQeN-0001EX-0B for bug-gnu-emacs@gnu.org; Sun, 09 Oct 2022 03:23:03 -0400 Original-Received: from debbugs.gnu.org ([209.51.188.43]:42798) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1ohQeM-0002vC-NT for bug-gnu-emacs@gnu.org; Sun, 09 Oct 2022 03:23:02 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1ohQeM-0001Nu-BH for bug-gnu-emacs@gnu.org; Sun, 09 Oct 2022 03:23:02 -0400 X-Loop: help-debbugs@gnu.org 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-Debbugs-Original-To: bug-gnu-emacs@gnu.org Original-Received: via spool by submit@debbugs.gnu.org id=B.16653001705284 (code B ref -1); Sun, 09 Oct 2022 07:23:02 +0000 Original-Received: (at submit) by debbugs.gnu.org; 9 Oct 2022 07:22:50 +0000 Original-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 Original-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 Original-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 Original-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 Original-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 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-BeenThere: debbugs-submit@debbugs.gnu.org X-Mailman-Version: 2.1.18 Precedence: list X-BeenThere: bug-gnu-emacs@gnu.org List-Id: "Bug reports for GNU Emacs, the Swiss army knife of text editors" List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Original-Sender: "bug-gnu-emacs" Xref: news.gmane.io gmane.emacs.bugs:244946 Archived-At: 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/