From patchwork Wed Dec 1 12:30:00 2021 Content-Type: text/plain; charset="utf-8" MIME-Version: 1.0 Content-Transfer-Encoding: 7bit X-Patchwork-Submitter: Adolf Belka X-Patchwork-Id: 4875 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) client-signature ECDSA (P-384)) (Client CN "mail01.haj.ipfire.org", Issuer "R3" (verified OK)) by web04.haj.ipfire.org (Postfix) with ESMTPS id 4J3z1r6Bp6z3wg9 for ; Wed, 1 Dec 2021 12:30:08 +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 4J3z1r3fCFz3ZZ; Wed, 1 Dec 2021 12:30:08 +0000 (UTC) Received: from mail02.haj.ipfire.org (localhost [127.0.0.1]) by mail02.haj.ipfire.org (Postfix) with ESMTP id 4J3z1r3FdZz2yrX; Wed, 1 Dec 2021 12:30:08 +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 4J3z1q63Bxz2yRb for ; Wed, 1 Dec 2021 12:30:07 +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 4J3z1q184lzsy; Wed, 1 Dec 2021 12:30:07 +0000 (UTC) DKIM-Signature: v=1; a=ed25519-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003ed25519; t=1638361807; 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=g6PszXpn+tNIDXudtcWnD7UoIYOow8M5qh950NCge9s=; b=tnJHryDpEM00oEcKEUkVIgNmuHFOx2O+T06J9lfhtlmMWcJ104or1ilFm8jiZFSu7tJs+g nelSth4Xb2ow9bCA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=ipfire.org; s=202003rsa; t=1638361807; 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=g6PszXpn+tNIDXudtcWnD7UoIYOow8M5qh950NCge9s=; b=Y+GOGaJ2q8km3fJcOyH8UTFQu6KZoFTbLWQH+cGsRFg/DnGf7I7TQ1tZ5wWX/gQnb9C1FF S+sLWxWCVNikkrFSsot7PCzjefpZ+R49L6GdeANQI49oWCR6C9sa4rZgzPTZOc0tqP1Itm jEBG0d3W0Fsjh8a0m5fPI9ki5HWshq9m6NtTFn6pWeG/IHPxUS+nD6v1aU7eRAg9RIsQwq Rz9BWOveCPht7v05HbTXDSjVZrMXYukzwhdjUmFDk22RrismpxV6zMfBN1drpqjLcEaQnf haRMz7RpWOtoF+Chkh6HOMOSF1osxK4F+oikrodsoq21m6t7CEa9iAdfXwgx/A== From: Adolf Belka To: development@lists.ipfire.org Subject: [PATCH] sqlite: Update to version 3.37.0 Date: Wed, 1 Dec 2021 13:30:00 +0100 Message-Id: <20211201123000.3436751-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 3.36.0 to 3.37.0 - Update of rootfile not required - Changelog Release 3.37.0 On 2021-11-27 STRICT tables provide a prescriptive style of data type management, for developers who prefer that kind of thing. When adding columns that contain a CHECK constraint or a generated column containing a NOT NULL constraint, the ALTER TABLE ADD COLUMN now checks new constraints against preexisting rows in the database and will only proceed if no constraints are violated. Added the PRAGMA table_list statement. CLI enhancements: Add the .connection command, allowing the CLI to keep multiple database connections open at the same time. Add the --safe command-line option that disables dot-commands and SQL statements that might cause side-effects that extend beyond the single database file named on the command-line. Performance improvements when reading SQL statements that span many lines. Added the sqlite3_autovacuum_pages() interface. The sqlite3_deserialize() does not and has never worked for the TEMP database. That limitation is now noted in the documentation. The query planner now omits ORDER BY clauses on subqueries and views if removing those clauses does not change the semantics of the query. The generate_series table-valued function extension is modified so that the first parameter ("START") is now required. This is done as a way to demonstrate how to write table-valued functions with required parameters. The legacy behavior is available using the -DZERO_ARGUMENT_GENERATE_SERIES compile-time option. Added new sqlite3_changes64() and sqlite3_total_changes64() interfaces. Added the SQLITE_OPEN_EXRESCODE flag option to sqlite3_open_v2(). Use less memory to hold the database schema. Signed-off-by: Adolf Belka Reviewed-by: Michael Tremer --- lfs/sqlite | 8 +++++--- 1 file changed, 5 insertions(+), 3 deletions(-) diff --git a/lfs/sqlite b/lfs/sqlite index 04eada9d8..84a04004a 100644 --- a/lfs/sqlite +++ b/lfs/sqlite @@ -24,7 +24,7 @@ include Config -VER = 3360000 +VER = 3370000 THISAPP = sqlite-autoconf-$(VER) DL_FILE = $(THISAPP).tar.gz @@ -40,7 +40,7 @@ objects = $(DL_FILE) $(DL_FILE) = $(DL_FROM)/$(DL_FILE) -$(DL_FILE)_MD5 = f5752052fc5b8e1b539af86a3671eac7 +$(DL_FILE)_MD5 = 021c1d936c157bb68d6d0b158636ac7a install : $(TARGET) @@ -70,7 +70,9 @@ $(subst %,%_MD5,$(objects)) : $(TARGET) : $(patsubst %,$(DIR_DL)/%,$(objects)) @$(PREBUILD) @rm -rf $(DIR_APP) && cd $(DIR_SRC) && tar zxf $(DIR_DL)/$(DL_FILE) - cd $(DIR_APP) && ./configure --prefix=/usr + cd $(DIR_APP) && ./configure \ + --prefix=/usr \ + --disable-static cd $(DIR_APP) && make $(MAKETUNING) cd $(DIR_APP) && make install @rm -rf $(DIR_APP)