sqlite: Update to version 3390000

Message ID 20220710131036.3611221-1-adolf.belka@ipfire.org
State Accepted
Commit 5a2bd6d7399b3eb65f6bae3fac2588cf769133c3
Headers
Series sqlite: Update to version 3390000 |

Commit Message

Adolf Belka July 10, 2022, 1:10 p.m. UTC
  - Update from version 3380500 to 3890000
- Update of rootfile not required
- Changelog
   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%.

Signed-off-by: Adolf Belka <adolf.belka@ipfire.org>
---
 lfs/sqlite | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)
  

Comments

Peter Müller July 11, 2022, 10:16 a.m. UTC | #1
Reviewed-by: Peter Müller <peter.mueller@ipfire.org>

> - Update from version 3380500 to 3890000
> - Update of rootfile not required
> - Changelog
>    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%.
> 
> Signed-off-by: Adolf Belka <adolf.belka@ipfire.org>
> ---
>  lfs/sqlite | 4 ++--
>  1 file changed, 2 insertions(+), 2 deletions(-)
> 
> diff --git a/lfs/sqlite b/lfs/sqlite
> index 4f6d5ad06..a7aa0b499 100644
> --- a/lfs/sqlite
> +++ b/lfs/sqlite
> @@ -24,7 +24,7 @@
>  
>  include Config
>  
> -VER        = 3380500
> +VER        = 3390000
>  
>  THISAPP    = sqlite-autoconf-$(VER)
>  DL_FILE    = $(THISAPP).tar.gz
> @@ -40,7 +40,7 @@ objects = $(DL_FILE)
>  
>  $(DL_FILE) = $(DL_FROM)/$(DL_FILE)
>  
> -$(DL_FILE)_BLAKE2 = 546db2fddfc065ddb5d0f232456a79d6a582cd98acfe7c1c8e0f53311906f70d47d89dfabfdb52c9c261202931b97d84b5fd238f70e6539522e56a57c03036b3
> +$(DL_FILE)_BLAKE2 = 5621aee0468184599f5fea172699ce4db969edb794704c6038009c6fe9fda3613f53de5307e1a5077ca790640f0d7fe82fd7f110c7e1acb0553490da5a5c13f6
>  
>  install : $(TARGET)
>
  

Patch

diff --git a/lfs/sqlite b/lfs/sqlite
index 4f6d5ad06..a7aa0b499 100644
--- a/lfs/sqlite
+++ b/lfs/sqlite
@@ -24,7 +24,7 @@ 
 
 include Config
 
-VER        = 3380500
+VER        = 3390000
 
 THISAPP    = sqlite-autoconf-$(VER)
 DL_FILE    = $(THISAPP).tar.gz
@@ -40,7 +40,7 @@  objects = $(DL_FILE)
 
 $(DL_FILE) = $(DL_FROM)/$(DL_FILE)
 
-$(DL_FILE)_BLAKE2 = 546db2fddfc065ddb5d0f232456a79d6a582cd98acfe7c1c8e0f53311906f70d47d89dfabfdb52c9c261202931b97d84b5fd238f70e6539522e56a57c03036b3
+$(DL_FILE)_BLAKE2 = 5621aee0468184599f5fea172699ce4db969edb794704c6038009c6fe9fda3613f53de5307e1a5077ca790640f0d7fe82fd7f110c7e1acb0553490da5a5c13f6
 
 install : $(TARGET)