From nobody Mon Mar 13 23:07:19 2023 X-Original-To: dev-commits-ports-all@mlmmj.nyi.freebsd.org Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2610:1c1:1:606c::19:1]) by mlmmj.nyi.freebsd.org (Postfix) with ESMTP id 4PbC3W6kS4z3yKgW; Mon, 13 Mar 2023 23:07:19 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from mxrelay.nyi.freebsd.org (mxrelay.nyi.freebsd.org [IPv6:2610:1c1:1:606c::19:3]) (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 client-signature RSA-PSS (4096 bits) client-digest SHA256) (Client CN "mxrelay.nyi.freebsd.org", Issuer "R3" (verified OK)) by mx1.freebsd.org (Postfix) with ESMTPS id 4PbC3W4KYHz3PK5; Mon, 13 Mar 2023 23:07:19 +0000 (UTC) (envelope-from git@FreeBSD.org) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1678748839; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=z2BWA+TCVcRx8JtH7gwhd213MdZOcRlKPB+u1LxFdH0=; b=sDrVRcDO/eecEXuo2BlOGo1cOSzbHS8ukpmgAuaYplN936fEaBiN6hL+Ym36nvkeHGi+is q3etboPGj1JDA0Fdr03cvj/9N8za12aq9ou8k/OkBlyo3IoOqLyS2ltqARYU6+B2Zr0WiC RSMyDG4xlsdtZdf5Y9so8Dslqyc5CNMYmNIrfyqNk8n7yyd9xqTVuT6C/lcWqHRdIbirBg qRCZTqH3/R+LP4R1o4X5nZfJmmWrToAJyh431cRDvvWCV3ItW19qT3PVSkDMy1rQAiQUA1 zPCP02wz51Xcp1FOA0JppHDvFnd6rwq59PTu6SIXKx0uYJI2ImcjEC/pj+nYHg== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1678748839; h=from:from:reply-to:subject:subject:date:date:message-id:message-id: to:to:cc:mime-version:mime-version:content-type:content-type: content-transfer-encoding:content-transfer-encoding; bh=z2BWA+TCVcRx8JtH7gwhd213MdZOcRlKPB+u1LxFdH0=; b=oG1rh2A6Fe0JhLAk8Yvod3tXHOZoRLIA8gj6E/7yc4NUY7dAzJQHsx11nf+YRML6pKi6sg 9a92ynsyvuZyIRdnadC7b4atXXgZnH596Yt8e2Pdtt7pp4t1miFLeOqMAuGowmbqdRtggp IWVbG3GgUZbKN9jyZJWQrleoaLfiAsJtHlQ3vSWBimnmVIc+zaN01vaEyW2Llsb/esCp2p Z7m+2ZVMzitmYHXTnCSk6nQhY8Xm9Y/8fUwoQV7J03NcoAk6Q2wAxdq9q7ihdeg+6mbWzG t3nOyKer2nsVUHqyj1wkeWzOkIOAf57dyWWt1k4gwgW1rupA/j9QW5pvLaI5uQ== ARC-Authentication-Results: i=1; mx1.freebsd.org; none ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1678748839; a=rsa-sha256; cv=none; b=QYDgT9eJShIx3VfV5QYa4F2F5+K6/M9barna87XGuzQthLPCgEVm7ciIn5M5b4QdYDkdmY 9zX7bzCPyE0F/1owndHJZzuXkk3JMZffkJUerKwKOYwCOqMwHMhFQb8oFp2CMqhFt8Kyti 9CmKw1b2Qz2NyhWE9RmlnHhYGTRM44tZh5WNE0x3YkmGAVIX8R7ojzZVBEZ/ODKrMs2byk WruqWaA7yg9IRyzwxAJlcANd0dKXBJgXMp/7JptIqndtWn7l+SoYhqc9tP1Z19C24HN0HT Bq74nMzhkNRLLbT67RkkrqoVRwOUp+diYMojfMhOf6U3G1h4oszStSYVoSXq0A== Received: from gitrepo.freebsd.org (gitrepo.freebsd.org [IPv6:2610:1c1:1:6068::e6a:5]) (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) (Client did not present a certificate) by mxrelay.nyi.freebsd.org (Postfix) with ESMTPS id 4PbC3W2TJDz1BT0; Mon, 13 Mar 2023 23:07:19 +0000 (UTC) (envelope-from git@FreeBSD.org) Received: from gitrepo.freebsd.org ([127.0.1.44]) by gitrepo.freebsd.org (8.16.1/8.16.1) with ESMTP id 32DN7J06048613; Mon, 13 Mar 2023 23:07:19 GMT (envelope-from git@gitrepo.freebsd.org) Received: (from git@localhost) by gitrepo.freebsd.org (8.16.1/8.16.1/Submit) id 32DN7JaV048612; Mon, 13 Mar 2023 23:07:19 GMT (envelope-from git) Date: Mon, 13 Mar 2023 23:07:19 GMT Message-Id: <202303132307.32DN7JaV048612@gitrepo.freebsd.org> To: ports-committers@FreeBSD.org, dev-commits-ports-all@FreeBSD.org, dev-commits-ports-main@FreeBSD.org From: Robert Clausecker Subject: git: 5fd5f3398b66 - main - databases/sqlite3: reenable the DQS option List-Id: Commit messages for all branches of the ports repository List-Archive: https://lists.freebsd.org/archives/dev-commits-ports-all List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-dev-commits-ports-all@freebsd.org X-BeenThere: dev-commits-ports-all@freebsd.org MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Git-Committer: fuz X-Git-Repository: ports X-Git-Refname: refs/heads/main X-Git-Reftype: branch X-Git-Commit: 5fd5f3398b665540ed77893b792e7372f8087f2f Auto-Submitted: auto-generated X-ThisMailContainsUnwantedMimeParts: N The branch main has been updated by fuz: URL: https://cgit.FreeBSD.org/ports/commit/?id=5fd5f3398b665540ed77893b792e7372f8087f2f commit 5fd5f3398b665540ed77893b792e7372f8087f2f Author: Pavel Volkov AuthorDate: 2023-03-13 09:46:16 +0000 Commit: Robert Clausecker CommitDate: 2023-03-13 23:06:38 +0000 databases/sqlite3: reenable the DQS option Due to various ports not being prepared for this change (see 20230227 entry), the DQS option of databases/sqlite3 has been reenabled as a stop gap measure. It is scheduled to be disabled again for good no earlier than 20240101, giving downstream software authors more time to fix their queries. PR: 270064 Fixes: 47912ce2e613211aecf6ecdfc58681b7aca0df33 See also: PR 269889, 269966, 269950 --- UPDATING | 12 ++++++++++++ databases/sqlite3/Makefile | 4 +++- 2 files changed, 15 insertions(+), 1 deletion(-) diff --git a/UPDATING b/UPDATING index 6d648be11f16..2def2788a33b 100644 --- a/UPDATING +++ b/UPDATING @@ -5,6 +5,18 @@ they are unavoidable. You should get into the habit of checking this file for changes each time you update your ports collection, before attempting any port upgrades. +20230313: + AFFECTS: users of databases/sqlite3 + AUTHOR: fuz@FreeBSD.org + + Due to various ports not being prepared for this change (see 20230227 + entry), the DQS option of databases/sqlite3 has been reenabled as a + stop gap measure. It is scheduled to be disabled again for good no + earlier than 20240101, giving downstream software authors more time + to fix their queries. + + See also: https://sqlite.org/quirks.html#dblquote + 20230311: AFFECTS: users of net/dshell AUTHOR: nobutaka@FreeBSD.org diff --git a/databases/sqlite3/Makefile b/databases/sqlite3/Makefile index 993737673af6..a0ffcd221d5c 100644 --- a/databases/sqlite3/Makefile +++ b/databases/sqlite3/Makefile @@ -1,5 +1,6 @@ PORTNAME= sqlite3 DISTVERSION= 3.41.0 +PORTREVISION= 1 PORTEPOCH= 1 CATEGORIES= databases MASTER_SITES= https://www.sqlite.org/${_YEAR}/ https://www2.sqlite.org/${_YEAR}/ https://www3.sqlite.org/${_YEAR}/ @@ -74,7 +75,7 @@ OPTIONS_DEFINE+= ARMOR DBPAGE DBSTAT DIRECT_READ DQS EXTENSION FTS3_TOKEN \ SORT_REF STATIC STMT TRUSTED_SCHEMA UNKNOWN_SQL UNLOCK_NOTIFY \ UPDATE_LIMIT URI URI_AUTHORITY .endif -OPTIONS_DEFAULT= DBPAGE DBSTAT EXTENSION FTS3_TOKEN FTS4 FTS5 LIBEDIT METADATA \ +OPTIONS_DEFAULT= DBPAGE DBSTAT DQS EXTENSION FTS3_TOKEN FTS4 FTS5 LIBEDIT METADATA \ RTREE SECURE_DELETE STRIP THREADS TS1 UNICODE61 UNLOCK_NOTIFY URI # SECURE_DELETE, UNLOCK_NOTIFY, DBSTAT (since 41.0) used by www/firefox et al. # RTREE used by graphics/mapnik, databases/spatialite @@ -82,6 +83,7 @@ OPTIONS_DEFAULT= DBPAGE DBSTAT EXTENSION FTS3_TOKEN FTS4 FTS5 LIBEDIT METADATA \ # FTS5 used by sysutils/tracker # JSON1 used by net-im/py-matrix-synapse # DBPAGE used by audio/audacity (since 3.0.0) +# DQS used by multimedia/emby-server, multimedia/tautulli, net/vnstat, www/qutebrowser # .if !defined(TEA) OPTIONS_GROUP= OPT_EXT OPT_FUNC RTREEG UNICODE