Created attachment 235016 [details] patch Upgrade to new version 3.39.
Created attachment 235017 [details] poudriere log without flavors
Created attachment 235018 [details] poudriere log @icu
Created attachment 235019 [details] poudriere log @tcl
Created attachment 235020 [details] poudriere log tcl-sqlite3
Created attachment 235021 [details] portlint log
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(-)
Committed, Thanks!
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(-)