From patchwork Thu May 8 12:01:51 2025 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Adolf Belka X-Patchwork-Id: 8711 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 RSA-PSS (4096 bits)) (Client CN "mail01.haj.ipfire.org", Issuer "R10" (verified OK)) by web04.haj.ipfire.org (Postfix) with ESMTPS id 4ZtW2g3J0Gz3xDv for ; Thu, 8 May 2025 12:02:03 +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 RSA-PSS (4096 bits) client-signature ECDSA (secp384r1)) (Client CN "mail02.haj.ipfire.org", Issuer "E5" (verified OK)) by mail01.ipfire.org (Postfix) with ESMTPS id 4ZtW2d5tCjz6St for ; Thu, 8 May 2025 12:02:01 +0000 (UTC) Received: from mail02.haj.ipfire.org (localhost [127.0.0.1]) by mail02.haj.ipfire.org (Postfix) with ESMTP id 4ZtW2d55zVz33dC for ; Thu, 8 May 2025 12:02:01 +0000 (UTC) X-Original-To: development@lists.ipfire.org 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) server-digest SHA384 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mail01.haj.ipfire.org", Issuer "R10" (verified OK)) by mail02.haj.ipfire.org (Postfix) with ESMTPS id 4ZtW2Z5Mc4z2ybk for ; Thu, 8 May 2025 12:01:58 +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 RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mail01.ipfire.org (Postfix) with ESMTPSA id 4ZtW2Y2RYpzmP; Thu, 8 May 2025 12:01:57 +0000 (UTC) DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003ed25519; t=1746705717; 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=C+L/uJUvAB2tjub8NjrQGLD4QkoA1ShG1uRiltFBbss=; b=VFMZTJ0/B8BEnIU6qKYeXryeEr/Dzo9Xvonbm6rfkOpslr6Ens6qMY5fTVHsfFg1xhd3Pk Kz0Vq5x6oZ50TzCQ== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003rsa; t=1746705717; 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=C+L/uJUvAB2tjub8NjrQGLD4QkoA1ShG1uRiltFBbss=; b=aMXLqXRf8yC0zbRX7SbYsUYoglolJA9Yj73gMELyM9Kz67Buuu4hXK8xJIwpbqauRbh0A5 +zqU9HwHW4QU/syUqOT+9NNrnywYmNc7HeB8ptRwgflCX4nyR+iAgR9ivHxWodrYtOf3Co zf0Rn69AwDmNtg8B67uHPnCFyWYPVXCwWAr+l9nOsko1dCkiBc1fJKb4/G071ot14N9szM rOIMxCdfmB4n6X/jqWa/0s0C8FqQdoBTbJbeHAzweF8eE8r3veZtMmDYlnzFxNHbp1ZDWv n2XXywBfM41UK8pWd8EgqjVrftTU2olQZe2Gey5egpL49Cxp7DJMTCG++raaqA== From: Adolf Belka To: development@lists.ipfire.org Cc: Adolf Belka Subject: [PATCH 1/2] sqlite: Update to version 3.49.2 Date: Thu, 8 May 2025 14:01:51 +0200 Message-ID: <20250508120152.3246319-1-adolf.belka@ipfire.org> Precedence: list List-Id: List-Subscribe: , List-Unsubscribe: , List-Post: List-Help: Sender: Mail-Followup-To: MIME-Version: 1.0 - Update from version 3.49.1 to 3.49.2 - Update of rootfile - Changelog 3.49.2 Fix a bug in the NOT NULL optimization of version 3.40.0 (item 3c in the version 3.40.0 change log) that can lead to a memory error if abused. Fix the count-of-view optimization so that it does not give an incorrect answer for a DISTINCT query. Fix a possible incorrect answer that can result if a UNIQUE constraint of a table contains the PRIMARY KEY column and that UNIQUE constraint is used by an IN operator. Fix obscure problems with the generate_series() extension function. Incremental improvements to the configure/make. Signed-off-by: Adolf Belka --- config/rootfiles/common/sqlite | 2 +- lfs/sqlite | 4 ++-- 2 files changed, 3 insertions(+), 3 deletions(-) diff --git a/config/rootfiles/common/sqlite b/config/rootfiles/common/sqlite index 9e28c2d2b..1408c1879 100644 --- a/config/rootfiles/common/sqlite +++ b/config/rootfiles/common/sqlite @@ -3,6 +3,6 @@ usr/bin/sqlite3 #usr/include/sqlite3ext.h usr/lib/libsqlite3.so usr/lib/libsqlite3.so.0 -usr/lib/libsqlite3.so.3.49.1 +usr/lib/libsqlite3.so.3.49.2 #usr/lib/pkgconfig/sqlite3.pc #usr/share/man/man1/sqlite3.1 diff --git a/lfs/sqlite b/lfs/sqlite index ea3edcec2..ed23e9529 100644 --- a/lfs/sqlite +++ b/lfs/sqlite @@ -24,7 +24,7 @@ include Config -VER = 3490100 +VER = 3490200 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 = 08f9379977b9a7962de5283cb532ecdd500e6e9b00d5e64e14e323777b47ea90e15745528d441328b7907060b7f594dc5054b327b471189477e595c0575c43a0 +$(DL_FILE)_BLAKE2 = 588e881e986c618d7321546a5b236fe68371898295d80ff54f8d7037e5ae28d5384808f85e395e3467aa3494f84234709a1e9310277d6f0866e4c750f04c2fbb install : $(TARGET) From patchwork Thu May 8 12:01:52 2025 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Adolf Belka X-Patchwork-Id: 8710 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) server-digest SHA384 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mail01.haj.ipfire.org", Issuer "R10" (verified OK)) by web04.haj.ipfire.org (Postfix) with ESMTPS id 4ZtW2g2w8fz3x3j for ; Thu, 8 May 2025 12:02:03 +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 RSA-PSS (4096 bits) client-signature ECDSA (secp384r1)) (Client CN "mail02.haj.ipfire.org", Issuer "E5" (verified OK)) by mail01.ipfire.org (Postfix) with ESMTPS id 4ZtW2d6Blpz6Sy for ; Thu, 8 May 2025 12:02:01 +0000 (UTC) Received: from mail02.haj.ipfire.org (localhost [127.0.0.1]) by mail02.haj.ipfire.org (Postfix) with ESMTP id 4ZtW2d5T7Bz33B6 for ; Thu, 8 May 2025 12:02:01 +0000 (UTC) X-Original-To: development@lists.ipfire.org 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 RSA-PSS (4096 bits)) (Client CN "mail01.haj.ipfire.org", Issuer "R10" (verified OK)) by mail02.haj.ipfire.org (Postfix) with ESMTPS id 4ZtW2Z5pdzz335T for ; Thu, 8 May 2025 12:01:58 +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 RSA-PSS (4096 bits) server-digest SHA256) (No client certificate requested) by mail01.ipfire.org (Postfix) with ESMTPSA id 4ZtW2Z3Nkpz2fx; Thu, 8 May 2025 12:01:58 +0000 (UTC) DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003ed25519; t=1746705718; 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=ZOI8zLE0y0FT9IwLzznBIhA0nglbewyWxZKTV7kLh2I=; b=u6vtkokJ2tHLxcdjGDaNnr3v/54hRbwOOj4mjbN4S0inrE7hIdY3HVpaRY01DvKpjovvDe 58556olUE9HBKDCw== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003rsa; t=1746705718; 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=ZOI8zLE0y0FT9IwLzznBIhA0nglbewyWxZKTV7kLh2I=; b=LxxHE/nwUbhk2wrapIZaB+tS6niaCJizKxDr/vRhm58E0qAflPQTOqHVZo5kAqd1B3OJj9 VmGSo7Iya/45ahJ2JFrs+U59KGh7u40BbYybq5xtt7DPYrunV8/oSFQjEThPMj6lPYqNii PGsEME9Sc1rBdgA1Fcza8BnX2LOJtXtlTg1SbM5MBUdblUzYo2xOz1IDcA9DLm1j1RGQev 3eT9vfmdia3IIR6MbohRnoDwITDWV4bnONYuHPo4+9wVIsF1Jhk4IEdWT0iru+758ZkJLx J6Ggd0SefkHmC7L+rlYmf8Yb/eyLSNBDuwjJR1/dvGXQOQobXkWhavwxjGZwGw== From: Adolf Belka To: development@lists.ipfire.org Cc: Adolf Belka Subject: [PATCH 2/2] core195: Ship sqlite Date: Thu, 8 May 2025 14:01:52 +0200 Message-ID: <20250508120152.3246319-2-adolf.belka@ipfire.org> In-Reply-To: <20250508120152.3246319-1-adolf.belka@ipfire.org> References: <20250508120152.3246319-1-adolf.belka@ipfire.org> Precedence: list List-Id: List-Subscribe: , List-Unsubscribe: , List-Post: List-Help: Sender: Mail-Followup-To: MIME-Version: 1.0 Signed-off-by: Adolf Belka --- config/rootfiles/core/195/filelists/sqlite | 1 + 1 file changed, 1 insertion(+) create mode 120000 config/rootfiles/core/195/filelists/sqlite diff --git a/config/rootfiles/core/195/filelists/sqlite b/config/rootfiles/core/195/filelists/sqlite new file mode 120000 index 000000000..4ea569766 --- /dev/null +++ b/config/rootfiles/core/195/filelists/sqlite @@ -0,0 +1 @@ +../../../common/sqlite \ No newline at end of file