From nobody Thu Jul 07 05:35:51 2022 X-Original-To: ports-bugs@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 D38461D029FF for ; Thu, 7 Jul 2022 05:35:51 +0000 (UTC) (envelope-from bugzilla-noreply@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 4LdlWC3sBrz3MwF for ; Thu, 7 Jul 2022 05:35:51 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org (kenobi.freebsd.org [IPv6:2610:1c1:1:606c::50:1d]) (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 4LdlWC2wh0zWyN for ; Thu, 7 Jul 2022 05:35:51 +0000 (UTC) (envelope-from bugzilla-noreply@freebsd.org) Received: from kenobi.freebsd.org ([127.0.1.5]) by kenobi.freebsd.org (8.15.2/8.15.2) with ESMTP id 2675Zpbh063563 for ; Thu, 7 Jul 2022 05:35:51 GMT (envelope-from bugzilla-noreply@freebsd.org) Received: (from bugzilla@localhost) by kenobi.freebsd.org (8.15.2/8.15.2/Submit) id 2675ZpLQ063562 for ports-bugs@FreeBSD.org; Thu, 7 Jul 2022 05:35:51 GMT (envelope-from bugzilla-noreply@freebsd.org) X-Authentication-Warning: kenobi.freebsd.org: bugzilla set sender to bugzilla-noreply@freebsd.org using -f From: bugzilla-noreply@freebsd.org To: ports-bugs@FreeBSD.org Subject: [Bug 264974] databases/sqlite3: Update to 3.39 Date: Thu, 07 Jul 2022 05:35:51 +0000 X-Bugzilla-Reason: AssignedTo X-Bugzilla-Type: changed X-Bugzilla-Watch-Reason: None X-Bugzilla-Product: Ports & Packages X-Bugzilla-Component: Individual Port(s) X-Bugzilla-Version: Latest X-Bugzilla-Keywords: X-Bugzilla-Severity: Affects Only Me X-Bugzilla-Who: commit-hook@FreeBSD.org X-Bugzilla-Status: New X-Bugzilla-Resolution: X-Bugzilla-Priority: --- X-Bugzilla-Assigned-To: ports-bugs@FreeBSD.org X-Bugzilla-Flags: X-Bugzilla-Changed-Fields: Message-ID: In-Reply-To: References: Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable X-Bugzilla-URL: https://bugs.freebsd.org/bugzilla/ Auto-Submitted: auto-generated List-Id: Ports bug reports List-Archive: https://lists.freebsd.org/archives/freebsd-ports-bugs List-Help: List-Post: List-Subscribe: List-Unsubscribe: Sender: owner-freebsd-ports-bugs@freebsd.org X-BeenThere: freebsd-ports-bugs@freebsd.org MIME-Version: 1.0 ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=freebsd.org; s=dkim; t=1657172151; 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: in-reply-to:in-reply-to:references:references; bh=9rUg8aQobyirL37rQIQ1n12uAfwXDsNDZP/Zz5Uzycw=; b=wJMXgbMaIE3jCKAx3sQl5PG24aKHgqFhj/Zc/3YyD7A4fYk1z5MyW4lmJibD0GCGSRSb4/ 81uwFngT8c+2WwPqqhTCN7sze7mBzpxnnaaOEQtHPOMfPftEa4HRmf07L+GVjcFPFENDku PYV+WWHAcEoApFPbBW2AtCBRFQActinsz1zvnE8jRG+MK7fJN3oI9ZYXgNIK8dNm7WFr78 pes94z6eDTQ/5vLD8Tx1W8L1bJNI3FX4Y1ge0yE7TM0gp7yvl2FUM4QNSW7w1AqSq/FnI5 hutVlwmylyQFspEFHR93SMr9THDMPIPvIC0K4t7618AD7nmOZV8Mo4QKRvRNDg== ARC-Seal: i=1; s=dkim; d=freebsd.org; t=1657172151; a=rsa-sha256; cv=none; b=xOXyYL4Gf8MTaegHgGumJ3d8a5sPtNm+/U/gtESZ2wTCJtLYE63FGCAhkiH5rM80Td02ds T1GdJ1bKrjunGaHenyxLWX2p/0ScVffPgl9a+/xNx6yOBZEQnsvFHp4c4smiOybUTpvYCJ vQh04zJGJr9AX7LmiAR9nnCxxoMziOOtTTTsMlWuQw2mWfNfvDyhJ6gFrrQ0Onf/I0bMWu LLibabFvva6n18Xhao4HTxVINf+B/d5AKSFPG6TtE5FZk9KphkJNUVtEAbxPYsSSYgJEN4 vG7QHV/4rNl9N063AynbczO3ccnA1X2omRaKij1FsYfoJG43JRny/ldlnaUMGA== ARC-Authentication-Results: i=1; mx1.freebsd.org; none X-ThisMailContainsUnwantedMimeParts: N https://bugs.freebsd.org/bugzilla/show_bug.cgi?id=3D264974 --- Comment #6 from commit-hook@FreeBSD.org --- A commit in branch main references this bug: URL: https://cgit.FreeBSD.org/ports/commit/?id=3D5bf2947fce86388fd612492f980540c= 07d41f0b2 commit 5bf2947fce86388fd612492f980540c07d41f0b2 Author: Pavel Volkov AuthorDate: 2022-07-05 05:52:02 +0000 Commit: Fernando Apestegu=C3=ADa CommitDate: 2022-07-07 05:32:47 +0000 databases/sqlite3: Update to 3.39 ChangeLog: https://www.sqlite.org/releaselog/3_39_0.html * Add (long overdue) support for RIGHT and FULL OUTER JOIN. * Add new binary comparison operators IS NOT DISTINCT FROM and IS DIST= INCT 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 filena= mes to create a canonical name for the database before the file is opened. * Defer materializing views until the materialization is actually need= ed, 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 aggreg= ate query, even queries that do not have a GROUP BY clause. * Many microoptimizations collectively reduce CPU cycles by about 2.3%. PR: 264974 Reported by: pavelivolkov@gmail.com (maintainer) databases/sqlite3/Makefile | 6 +++--- databases/sqlite3/distinfo | 6 +++--- 2 files changed, 6 insertions(+), 6 deletions(-) --=20 You are receiving this mail because: You are the assignee for the bug.=