From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.io!.POSTED.blaine.gmane.org!not-for-mail From: Jonas Bernoulli Newsgroups: gmane.emacs.bugs Subject: bug#58363: 29.0.50; sqlite-select does not signal errors and errors should be improved Date: Fri, 07 Oct 2022 20:52:59 +0200 Message-ID: <87mta7lb3o.fsf@bernoul.li> Mime-Version: 1.0 Content-Type: text/plain Injection-Info: ciao.gmane.io; posting-host="blaine.gmane.org:116.202.254.214"; logging-data="10687"; mail-complaints-to="usenet@ciao.gmane.io" To: 58363@debbugs.gnu.org Original-X-From: bug-gnu-emacs-bounces+geb-bug-gnu-emacs=m.gmane-mx.org@gnu.org Fri Oct 07 20:54:21 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 1ogsUF-0002X2-MJ for geb-bug-gnu-emacs@m.gmane-mx.org; Fri, 07 Oct 2022 20:54:19 +0200 Original-Received: from localhost ([::1]:44950 helo=lists1p.gnu.org) by lists.gnu.org with esmtp (Exim 4.90_1) (envelope-from ) id 1ogsUE-000624-3L for geb-bug-gnu-emacs@m.gmane-mx.org; Fri, 07 Oct 2022 14:54:18 -0400 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:43180) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ogsTy-00061v-I5 for bug-gnu-emacs@gnu.org; Fri, 07 Oct 2022 14:54:02 -0400 Original-Received: from debbugs.gnu.org ([209.51.188.43]:38288) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.90_1) (envelope-from ) id 1ogsTy-0003sd-AE for bug-gnu-emacs@gnu.org; Fri, 07 Oct 2022 14:54:02 -0400 Original-Received: from Debian-debbugs by debbugs.gnu.org with local (Exim 4.84_2) (envelope-from ) id 1ogsTx-0002kB-Rm for bug-gnu-emacs@gnu.org; Fri, 07 Oct 2022 14:54:01 -0400 X-Loop: help-debbugs@gnu.org Resent-From: Jonas Bernoulli Original-Sender: "Debbugs-submit" Resent-CC: bug-gnu-emacs@gnu.org Resent-Date: Fri, 07 Oct 2022 18:54:01 +0000 Resent-Message-ID: Resent-Sender: help-debbugs@gnu.org X-GNU-PR-Message: report 58363 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.166516879110485 (code B ref -1); Fri, 07 Oct 2022 18:54:01 +0000 Original-Received: (at submit) by debbugs.gnu.org; 7 Oct 2022 18:53:11 +0000 Original-Received: from localhost ([127.0.0.1]:37366 helo=debbugs.gnu.org) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ogsT9-0002j3-B7 for submit@debbugs.gnu.org; Fri, 07 Oct 2022 14:53:11 -0400 Original-Received: from lists.gnu.org ([209.51.188.17]:59694) by debbugs.gnu.org with esmtp (Exim 4.84_2) (envelope-from ) id 1ogsT8-0002iw-3a for submit@debbugs.gnu.org; Fri, 07 Oct 2022 14:53:10 -0400 Original-Received: from eggs.gnu.org ([2001:470:142:3::10]:36056) by lists.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ogsT7-000600-UQ for bug-gnu-emacs@gnu.org; Fri, 07 Oct 2022 14:53:09 -0400 Original-Received: from mail.hostpark.net ([212.243.197.30]:47162) by eggs.gnu.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.90_1) (envelope-from ) id 1ogsT5-0003p5-VJ for bug-gnu-emacs@gnu.org; Fri, 07 Oct 2022 14:53:09 -0400 Original-Received: from localhost (localhost [127.0.0.1]) by mail.hostpark.net (Postfix) with ESMTP id 21E5A16916 for ; Fri, 7 Oct 2022 20:53:00 +0200 (CEST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=bernoul.li; h= content-type:content-type:mime-version:message-id:date:date :subject:subject:from:from:received:received; s=sel2011a; t= 1665168779; bh=8wq841dmX4bJ9VFK6CFSyYmsdqR0woMWEqAC4aOhpdg=; b=b DNIN+j8luXGUNOiEXRkc+oocDw3yzrR0yhdJ4qyBR/mf/D9Czrm5vwOfY6uEU4t6 f+X6idZMVPGHB/VG8YvUqXjjX87JXvGSl1CTWrZmSYs9WD/dVqFfBY+1lxEwhwV4 F2pQAGCUlI/Wi9LAGgQHk6KyQ16vKgTJm5XQMVA/IU= X-Virus-Scanned: by Hostpark/NetZone Mailprotection at hostpark.net Original-Received: from mail.hostpark.net ([127.0.0.1]) by localhost (mail1.hostpark.net [127.0.0.1]) (amavisd-new, port 10224) with ESMTP id qNWG_Vw7fYd3 for ; Fri, 7 Oct 2022 20:52:59 +0200 (CEST) Original-Received: from customer (localhost [127.0.0.1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange ECDHE (P-256) server-signature RSA-PSS (2048 bits) server-digest SHA256) (No client certificate requested) by mail.hostpark.net (Postfix) with ESMTPSA id E965216910 for ; Fri, 7 Oct 2022 20:52:59 +0200 (CEST) Received-SPF: none client-ip=212.243.197.30; envelope-from=jonas@bernoul.li; helo=mail.hostpark.net X-Spam_score_int: -27 X-Spam_score: -2.8 X-Spam_bar: -- X-Spam_report: (-2.8 / 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, RCVD_IN_DNSWL_LOW=-0.7, RCVD_IN_MSPIKE_H3=0.001, RCVD_IN_MSPIKE_WL=0.001, SPF_HELO_NONE=0.001, SPF_NONE=0.001 autolearn=ham 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:244839 Archived-At: sqlite-select does not signal any errors. This just returns nil for example: (sqlite-select (sqlite-open nil) "SELECT * FROM no_such_table") At least some of the other functions do signal errors when appropriate. (sqlite-execute db "bla") -error-> (error "near \"bla\": syntax error") It would be nice if a dedicated error type were used and if the error code was included in the error data. Maybe it would even make sense to use dedicated error types for all of the "primary result codes" as per https://sqlite.org/rescode.html. Thanks for considering, Jonas