From patchwork Tue May 28 15:41:44 2024 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Adolf Belka X-Patchwork-Id: 7828 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 (secp384r1) client-signature ECDSA (secp384r1)) (Client CN "mail01.haj.ipfire.org", Issuer "R3" (verified OK)) by web04.haj.ipfire.org (Postfix) with ESMTPS id 4VpcFh1HfBz3wxV for ; Tue, 28 May 2024 15:42:00 +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 (secp384r1) client-signature ECDSA (secp384r1)) (Client CN "mail02.haj.ipfire.org", Issuer "R3" (verified OK)) by mail01.ipfire.org (Postfix) with ESMTPS id 4VpcFb6jtgz5j2; Tue, 28 May 2024 15:41:55 +0000 (UTC) Received: from mail02.haj.ipfire.org (localhost [127.0.0.1]) by mail02.haj.ipfire.org (Postfix) with ESMTP id 4VpcFb2TpXz33CH; Tue, 28 May 2024 15:41:55 +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 (secp384r1) client-signature ECDSA (secp384r1)) (Client CN "mail01.haj.ipfire.org", Issuer "R3" (verified OK)) by mail02.haj.ipfire.org (Postfix) with ESMTPS id 4VpcFX3R0Bz2xxl for ; Tue, 28 May 2024 15:41:52 +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 (secp384r1) server-digest SHA384) (No client certificate requested) by mail01.ipfire.org (Postfix) with ESMTPSA id 4VpcFX0kD4z1T1; Tue, 28 May 2024 15:41:52 +0000 (UTC) DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003ed25519; t=1716910912; 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: in-reply-to:in-reply-to:references:references; bh=Z8ziwGBIy5HQpy8n87SCZsQWT35GykCbxUl4uHCLDaE=; b=XQEDoMUdzPeBT+WM+ff7dAPwICMpQVciDoavhs5Sec1U8368b02MsvXN+RNjh4sfY3vDzU PPN+cgv97mtyfhDQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003rsa; t=1716910912; 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: in-reply-to:in-reply-to:references:references; bh=Z8ziwGBIy5HQpy8n87SCZsQWT35GykCbxUl4uHCLDaE=; b=reBlSQykWfg2b8god/GvyBAceOP6Hoa1R5z6siA1NjblcKV5aH/XMgXvsVtufGwoAvMXo3 8Zv6dSbhF8qCnQ5Y6WNTtSlZ5crxR8KKT1zCtab+r2u+mykGGIOUVfPJJHxNjaOTGUDRk8 K+yGoHkeGpFmsoTku659E6aDSOW/xtxpoJKi6a8XIy+O+1+c7gXcTJ9qAxLLbjL3o+cWVr SlK87fNf+BjaDMyrZ2C+FsMa7xG902yGL9QJlgif7dIgcG1YhFGKZKenK1phGOgKs8r8fK XcegWv+X5DYIV2YHUIXfmK+1MKTHY5TulQI/ykRg2DyS4Icc5Qk7G4V5xXoIkQ== From: Adolf Belka To: development@lists.ipfire.org Subject: [PATCH] sqlite: Update to version 3.46.0 Date: Tue, 28 May 2024 17:41:44 +0200 Message-ID: <20240528154144.3777068-2-adolf.belka@ipfire.org> In-Reply-To: <20240528154144.3777068-1-adolf.belka@ipfire.org> References: <20240528154144.3777068-1-adolf.belka@ipfire.org> MIME-Version: 1.0 Message-ID-Hash: J52C3SKFSLUPY4NJE4LBIWJL6QMDXFXT X-Message-ID-Hash: J52C3SKFSLUPY4NJE4LBIWJL6QMDXFXT X-MailFrom: adolf.belka@ipfire.org X-Mailman-Rule-Misses: dmarc-mitigation; no-senders; approved; emergency; loop; banned-address; member-moderation; nonmember-moderation; administrivia; implicit-dest; max-recipients; max-size; news-moderation; no-subject; digests; suspicious-header X-Mailman-Version: 3.3.8 Precedence: list List-Id: IPFire development talk Archived-At: <> List-Archive: <> List-Help: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: - Update from version 3.45.3 to 3.46.0 - Update of rootfile not required - Changelog 3.46.0 Enhance PRAGMA optimize in multiple ways, to make it simpler to use: PRAGMA optimize automatically implements a temporary analysis limit to prevent excess runtime on large databases. Added the new 0x10000 bitmask option to check for updates on all tables. Automatically re-analyze tables that do not have sqlite_stat1 entries. Enhancements to the date and time functions: The strftime() SQL function now supports %G, %g, %U, and %V. New modifiers 'ceiling' and 'floor' control the algorithm used to resolve ambiguous dates when shifting a date by an integer number of months and/or years. The 'utc' and 'localtime' modifiers are now no-ops if SQLite knows that the time is already in UTC or in the localtime, respectively. Add support for underscore ("_") characters between digits in numeric literals. Add the json_pretty() SQL function. Query planner improvements: The "VALUES-as-coroutine" optimization enables INSERT statements with thousands of rows in the VALUES clause to parse and run in about half the time and using about half as much memory. Allow the use of an index for queries like "SELECT count(DISTINCT col) FROM ...", even if the index records are not smaller than the table records. Improved recognition of cases where the value of an SQL function is constant because all its arguments are constant. Enhance the WHERE-clause push-down optimization so that it is able to push down WHERE clause terms containing uncorrelated subqueries. Allocate additional memory from the heap for the SQL parser stack if that stack overflows, rather than reporting a "parser stack overflow" error. JSON changes: Allow ASCII control characters within JSON5 string literals. Fix the -> and ->> operators so that when the right-hand side operand is a string that looks like an integer it is still treated as a string, because that is what PostgreSQL does. Allow large hexadecimal literals to be used as the DEFAULT value to a table column. Signed-off-by: Adolf Belka Reviewed-by: Michael Tremer --- lfs/sqlite | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/lfs/sqlite b/lfs/sqlite index 421e32dd2..d001a5f49 100644 --- a/lfs/sqlite +++ b/lfs/sqlite @@ -24,7 +24,7 @@ include Config -VER = 3450300 +VER = 3460000 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 = 24e47dcfb8fb1dbd0055d48cfc540884439e9443b1b79700e867326feb60b340a9b5d5bdb83eeca210b47251e61b706ec67eb1b84e59b11bae6c76271b1030bf +$(DL_FILE)_BLAKE2 = 2f484823b84ab758e21960ac6b730cefa62c26f7ccf5344299a26e6f559d0e02cfd4cff5f5921effdee6e2e49d2ab36b1f91cffdd8599bc2189efab44bf4b197 install : $(TARGET)