Bug 264974 - databases/sqlite3: Update to 3.39
Summary: databases/sqlite3: Update to 3.39
Status: Closed FIXED
Alias: None
Product: Ports & Packages
Classification: Unclassified
Component: Individual Port(s) (show other bugs)
Version: Latest
Hardware: Any Any
: --- Affects Only Me
Assignee: Fernando Apesteguía
URL: https://www.sqlite.org/releaselog/3_3...
Keywords:
Depends on:
Blocks:
 
Reported: 2022-07-01 11:00 UTC by Pavel Volkov
Modified: 2022-08-30 23:17 UTC (History)
2 users (show)

See Also:


Attachments
patch (1.68 KB, patch)
2022-07-01 11:00 UTC, Pavel Volkov
pavelivolkov: maintainer-approval+
Details | Diff
poudriere log without flavors (59.81 KB, text/plain)
2022-07-01 11:01 UTC, Pavel Volkov
no flags Details
poudriere log @icu (63.76 KB, text/plain)
2022-07-01 11:02 UTC, Pavel Volkov
no flags Details
poudriere log @tcl (72.34 KB, text/plain)
2022-07-01 11:02 UTC, Pavel Volkov
no flags Details
poudriere log tcl-sqlite3 (57.43 KB, text/plain)
2022-07-01 11:03 UTC, Pavel Volkov
no flags Details
portlint log (12 bytes, text/plain)
2022-07-01 11:03 UTC, Pavel Volkov
no flags Details

Note You need to log in before you can comment on or make changes to this bug.
Description Pavel Volkov 2022-07-01 11:00:13 UTC
Created attachment 235016 [details]
patch

Upgrade to new version 3.39.
Comment 1 Pavel Volkov 2022-07-01 11:01:55 UTC
Created attachment 235017 [details]
poudriere log without flavors
Comment 2 Pavel Volkov 2022-07-01 11:02:24 UTC
Created attachment 235018 [details]
poudriere log @icu
Comment 3 Pavel Volkov 2022-07-01 11:02:43 UTC
Created attachment 235019 [details]
poudriere log @tcl
Comment 4 Pavel Volkov 2022-07-01 11:03:15 UTC
Created attachment 235020 [details]
poudriere log tcl-sqlite3
Comment 5 Pavel Volkov 2022-07-01 11:03:35 UTC
Created attachment 235021 [details]
portlint log
Comment 6 commit-hook freebsd_committer freebsd_triage 2022-07-07 05:35:51 UTC
A commit in branch main references this bug:

URL: https://cgit.FreeBSD.org/ports/commit/?id=5bf2947fce86388fd612492f980540c07d41f0b2

commit 5bf2947fce86388fd612492f980540c07d41f0b2
Author:     Pavel Volkov <pavelivolkov@gmail.com>
AuthorDate: 2022-07-05 05:52:02 +0000
Commit:     Fernando Apesteguía <fernape@FreeBSD.org>
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 DISTINCT 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 filenames to
       create a canonical name for the database before the file is opened.
     * Defer materializing views until the materialization is actually needed, 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 aggregate
       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(-)
Comment 7 Fernando Apesteguía freebsd_committer freebsd_triage 2022-07-07 05:36:30 UTC
Committed,

Thanks!
Comment 8 commit-hook freebsd_committer freebsd_triage 2022-08-30 23:17:11 UTC
A commit in branch 2022Q3 references this bug:

URL: https://cgit.FreeBSD.org/ports/commit/?id=5b8f768c5f76dfc97084a5a0cbe0075fdd3a6bbc

commit 5b8f768c5f76dfc97084a5a0cbe0075fdd3a6bbc
Author:     Pavel Volkov <pavelivolkov@gmail.com>
AuthorDate: 2022-07-05 05:52:02 +0000
Commit:     Cy Schubert <cy@FreeBSD.org>
CommitDate: 2022-08-30 23:15:42 +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 DISTINCT 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 filenames to
       create a canonical name for the database before the file is opened.
     * Defer materializing views until the materialization is actually needed, 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 aggregate
       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)

    (cherry picked from commit 5bf2947fce86388fd612492f980540c07d41f0b2)

 databases/sqlite3/Makefile | 6 +++---
 databases/sqlite3/distinfo | 6 +++---
 2 files changed, 6 insertions(+), 6 deletions(-)