diff options
| author | adam <adam@pkgsrc.org> | 2022-07-01 17:49:39 +0000 |
|---|---|---|
| committer | adam <adam@pkgsrc.org> | 2022-07-01 17:49:39 +0000 |
| commit | ff04922bb8c7e4c6b3aed7e22dbbd604df3ae4eb (patch) | |
| tree | 27121bfd68c2f7230c26161631ec0cd1aad833c4 /databases/sqlite3-docs/PLIST | |
| parent | 19b889345c0381b44e9b78affa27a539a05adc47 (diff) | |
| download | pkgsrc-ff04922bb8c7e4c6b3aed7e22dbbd604df3ae4eb.tar.gz | |
sqlite3: updated to 3.39.0
SQLite Release 3.39.0 On 2022-06-25
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%.
Diffstat (limited to 'databases/sqlite3-docs/PLIST')
| -rw-r--r-- | databases/sqlite3-docs/PLIST | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/databases/sqlite3-docs/PLIST b/databases/sqlite3-docs/PLIST index 9bf09c64b94..37515b08089 100644 --- a/databases/sqlite3-docs/PLIST +++ b/databases/sqlite3-docs/PLIST @@ -1,4 +1,4 @@ -@comment $NetBSD: PLIST,v 1.113 2022/05/08 08:10:27 adam Exp $ +@comment $NetBSD: PLIST,v 1.114 2022/07/01 17:49:39 adam Exp $ share/doc/sqlite3/34to35.html share/doc/sqlite3/35to36.html share/doc/sqlite3/about.html @@ -102,6 +102,7 @@ share/doc/sqlite3/c3ref/db_config.html share/doc/sqlite3/c3ref/db_filename.html share/doc/sqlite3/c3ref/db_handle.html share/doc/sqlite3/c3ref/db_mutex.html +share/doc/sqlite3/c3ref/db_name.html share/doc/sqlite3/c3ref/db_readonly.html share/doc/sqlite3/c3ref/db_release_memory.html share/doc/sqlite3/c3ref/db_status.html @@ -387,7 +388,6 @@ share/doc/sqlite3/images/foreignlogos/dropbox.gif share/doc/sqlite3/images/foreignlogos/expensify.png share/doc/sqlite3/images/foreignlogos/fb.gif share/doc/sqlite3/images/foreignlogos/firefox.gif -share/doc/sqlite3/images/foreignlogos/flame.gif share/doc/sqlite3/images/foreignlogos/ge.gif share/doc/sqlite3/images/foreignlogos/google.gif share/doc/sqlite3/images/foreignlogos/intuit.gif @@ -647,6 +647,7 @@ share/doc/sqlite3/releaselog/3_38_2.html share/doc/sqlite3/releaselog/3_38_3.html share/doc/sqlite3/releaselog/3_38_4.html share/doc/sqlite3/releaselog/3_38_5.html +share/doc/sqlite3/releaselog/3_39_0.html share/doc/sqlite3/releaselog/3_3_0.html share/doc/sqlite3/releaselog/3_3_1.html share/doc/sqlite3/releaselog/3_3_10.html |