From patchwork Sun Jul 10 13:10:36 2022 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 8bit X-Patchwork-Submitter: Adolf Belka X-Patchwork-Id: 5740 Return-Path: Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) server-digest SHA384 client-signature ECDSA (P-384) client-digest SHA384) (Client CN "mail01.haj.ipfire.org", Issuer "R3" (verified OK)) by web04.haj.ipfire.org (Postfix) with ESMTPS id 4LgnSq2SRGz40TZ for ; Sun, 10 Jul 2022 13:10:51 +0000 (UTC) Received: from mail02.haj.ipfire.org (mail02.haj.ipfire.org [172.28.1.201]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail02.haj.ipfire.org", Issuer "R3" (verified OK)) by mail01.ipfire.org (Postfix) with ESMTPS id 4LgnSm56FCzlC; Sun, 10 Jul 2022 13:10:48 +0000 (UTC) Received: from mail02.haj.ipfire.org (localhost [127.0.0.1]) by mail02.haj.ipfire.org (Postfix) with ESMTP id 4LgnSm4SvNz2ySh; Sun, 10 Jul 2022 13:10:48 +0000 (UTC) Received: from mail01.ipfire.org (mail01.haj.ipfire.org [172.28.1.202]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "R3" (verified OK)) by mail02.haj.ipfire.org (Postfix) with ESMTPS id 4LgnSk6nKYz2xK9 for ; Sun, 10 Jul 2022 13:10:46 +0000 (UTC) Received: from [127.0.0.1] (localhost [127.0.0.1]) (using TLSv1.3 with cipher TLS_AES_256_GCM_SHA384 (256/256 bits) key-exchange X25519 server-signature ECDSA (P-384) server-digest SHA384) (No client certificate requested) by mail01.ipfire.org (Postfix) with ESMTPSA id 4LgnSk3LcFzN7; Sun, 10 Jul 2022 13:10:46 +0000 (UTC) DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003ed25519; t=1657458646; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version: content-transfer-encoding:content-transfer-encoding; bh=uT2WF3kTe2ObPdBm1dC1i8oEICKAvlKOIaT9FRjQt+M=; b=molhCipLnmW/cTR/IXxeSlOmdfL+J7KAjEvxztRBfembxXQLxsCJSrO9DvujuC5xvmbXGJ Xsv9LQnFkNCydXAA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003rsa; t=1657458646; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:cc:mime-version:mime-version: content-transfer-encoding:content-transfer-encoding; bh=uT2WF3kTe2ObPdBm1dC1i8oEICKAvlKOIaT9FRjQt+M=; b=idXXEEBpe2QYNBvk/N5O1svVmyU2Jq3mXiN0sA7nOzNO+4lCs9iWy6/Ry/+ZBoaD1zSSLA A6Th+HjOVyeLY58gDBysVNw3FwsejpOCfjpBaN2AKFbJUt1CSP4nFpnCr1GYd9Dr2EE4iI c63ZcCO7JT51P+OrXuypq6IbPC+1z/1GKGNz9ABAHBW8nvA3XFwhh9JthC4U0zct87ZNtm 5xo/xwD1TJUU7E6AqNdjdCss9G9zEOP+ltV/6Ei8EJor5mC1XvmnTc3MkTJGtGaeHb0y5J 0hlJePctiYPZojfbtMxpml91WWH68bhFirf6n8djHTyjoNazE96XacklbxIGow== From: Adolf Belka To: development@lists.ipfire.org Subject: [PATCH] sqlite: Update to version 3390000 Date: Sun, 10 Jul 2022 15:10:36 +0200 Message-Id: <20220710131036.3611221-1-adolf.belka@ipfire.org> MIME-Version: 1.0 X-BeenThere: development@lists.ipfire.org X-Mailman-Version: 2.1.29 Precedence: list List-Id: IPFire development talk List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: development-bounces@lists.ipfire.org Sender: "Development" - Update from version 3380500 to 3890000 - Update of rootfile not required - Changelog Release 3.39.0 On 2022-06-25 Add (long overdue) support for RIGHT and FULL OUTER JOIN. Add new binary comparison operators IS NOT DISTINCT FROM and IS DISTINCT FROM that are equivalent to IS and IS NOT, respective, for compatibility with PostgreSQL and SQL standards. Add a new return code (value "3") from the sqlite3_vtab_distinct() interface that indicates a query that has both DISTINCT and ORDER BY clauses. Added the sqlite3_db_name() interface. The unix os interface resolves all symbolic links in database filenames to create a canonical name for the database before the file is opened. Defer materializing views until the materialization is actually needed, thus avoiding unnecessary work if the materialization turns out to never be used. The HAVING clause of a SELECT statement is now allowed on any aggregate query, even queries that do not have a GROUP BY clause. Many microoptimizations collectively reduce CPU cycles by about 2.3%. Signed-off-by: Adolf Belka Reviewed-by: Peter Müller --- lfs/sqlite | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lfs/sqlite b/lfs/sqlite index 4f6d5ad06..a7aa0b499 100644 --- a/lfs/sqlite +++ b/lfs/sqlite @@ -24,7 +24,7 @@ include Config -VER = 3380500 +VER = 3390000 THISAPP = sqlite-autoconf-$(VER) DL_FILE = $(THISAPP).tar.gz @@ -40,7 +40,7 @@ objects = $(DL_FILE) $(DL_FILE) = $(DL_FROM)/$(DL_FILE) -$(DL_FILE)_BLAKE2 = 546db2fddfc065ddb5d0f232456a79d6a582cd98acfe7c1c8e0f53311906f70d47d89dfabfdb52c9c261202931b97d84b5fd238f70e6539522e56a57c03036b3 +$(DL_FILE)_BLAKE2 = 5621aee0468184599f5fea172699ce4db969edb794704c6038009c6fe9fda3613f53de5307e1a5077ca790640f0d7fe82fd7f110c7e1acb0553490da5a5c13f6 install : $(TARGET)