search

TampaDevs / jobsyn

Syndication for posts on https://jobs.tampa.dev/
3 stars 0 forks source link

Bump sqlite3 from 1.6.3 to 1.6.4 #19

Closed dependabot[bot] closed 1 year ago

dependabot[bot] commented 1 year ago

Bumps sqlite3 from 1.6.3 to 1.6.4.

Release notes

Sourced from sqlite3's releases.

1.6.4 / 2023-08-26

Dependencies

Vendored sqlite is updated to v3.43.0.

Upstream release notes:

SQLite Release 3.43.0 On 2023-08-24

  • Add support for Contentless-Delete FTS5 Indexes. This is a variety of FTS5 full-text search index that omits storing the content that is being indexed while also allowing records to be deleted.
  • Enhancements to the date and time functions:
    • Added new time shift modifiers of the form ±YYYY-MM-DD HH:MM:SS.SSS.
    • Added the timediff() SQL function.
  • Added the octet_length(X) SQL function.
  • Added the sqlite3_stmt_explain() API.
  • Query planner enhancements:
    • Generalize the LEFT JOIN strength reduction optimization so that it works for RIGHT and FULL JOINs as well. Rename it to OUTER JOIN strength reduction.
    • Enhance the theorem prover in the OUTER JOIN strength reduction optimization so that it returns fewer false-negatives.
  • Enhancements to the decimal extension:
    • New function decimal_pow2(N) returns the N-th power of 2 for integer N between -20000 and +20000.
    • New function decimal_exp(X) works like decimal(X) except that it returns the result in exponential notation - with a "e+NN" at the end.
    • If X is a floating-point value, then the decimal(X) function now does a full expansion of that value into its exact decimal equivalent.
  • Performance enhancements to JSON processing results in a 2x performance improvement for some kinds of processing on large JSON strings.
  • New makefile target "verify-source" checks to ensure that there are no unintentional changes in the source tree. (Works for canonical source code only - not for precompiled amalgamation tarballs.)
  • Added the SQLITE_USE_SEH compile-time option that enables Structured Exception Handling on Windows while working with the memory-mapped shm file that is part of WAL mode processing. This option is enabled by default when building on Windows using Makefile.msc.
  • The VFS for unix now assumes that the nanosleep() system call is available unless compiled with -DHAVE_NANOSLEEP=0.

sha256 checksums:

612cffeb329d282226fe56c160ec3a98e2ee6a1a39020f18bf5db7c3cf3108f3  sqlite3-1.6.4-aarch64-linux.gem
60803013a225021574a8b11485fb98f56b0f0c6723a8a85813f24b8828361a4a  sqlite3-1.6.4-arm-linux.gem
4e3faaf9707284d0835944dd444105a6eaa441cfdd12514aa38e61bea79dd7f4  sqlite3-1.6.4-arm64-darwin.gem
4e269ff73b126e98bf9674f1e9f7ee7fd1d3b62cc61f680beeb832c782ca2a4b  sqlite3-1.6.4-x64-mingw-ucrt.gem
715e3e9acc253441a51593f508ddfb11c6ac325037c0183ccc550a9858c50a65  sqlite3-1.6.4-x64-mingw32.gem
4062f32f3506cb8215df8328ad5ca38dd4a9c2c76683d165753da916a14bc0fb  sqlite3-1.6.4-x86-linux.gem
2d17a20990d2a5b451470e26064600d58501ad73a62874dad1a3adce5d760943  sqlite3-1.6.4-x86_64-darwin.gem
0fb593369047f70016afc9ab79ce4ffa0a8976d0ba3a470f9fc7a4702dc11655  sqlite3-1.6.4-x86_64-linux.gem
f908a60df7bf19cf559ba7a5da369e5eb19d48fad639225037c70b26d66af635  sqlite3-1.6.4.gem
Changelog

Sourced from sqlite3's changelog.

1.6.4 / 2023-08-26

Dependencies

Vendored sqlite is updated to v3.43.0.

Upstream release notes:

SQLite Release 3.43.0 On 2023-08-24

  • Add support for Contentless-Delete FTS5 Indexes. This is a variety of FTS5 full-text search index that omits storing the content that is being indexed while also allowing records to be deleted.
  • Enhancements to the date and time functions:
    • Added new time shift modifiers of the form ±YYYY-MM-DD HH:MM:SS.SSS.
    • Added the timediff() SQL function.
  • Added the octet_length(X) SQL function.
  • Added the sqlite3_stmt_explain() API.
  • Query planner enhancements:
    • Generalize the LEFT JOIN strength reduction optimization so that it works for RIGHT and FULL JOINs as well. Rename it to OUTER JOIN strength reduction.
    • Enhance the theorem prover in the OUTER JOIN strength reduction optimization so that it returns fewer false-negatives.
  • Enhancements to the decimal extension:
    • New function decimal_pow2(N) returns the N-th power of 2 for integer N between -20000 and +20000.
    • New function decimal_exp(X) works like decimal(X) except that it returns the result in exponential notation - with a "e+NN" at the end.
    • If X is a floating-point value, then the decimal(X) function now does a full expansion of that value into its exact decimal equivalent.
  • Performance enhancements to JSON processing results in a 2x performance improvement for some kinds of processing on large JSON strings.
  • New makefile target "verify-source" checks to ensure that there are no unintentional changes in the source tree. (Works for canonical source code only - not for precompiled amalgamation tarballs.)
  • Added the SQLITE_USE_SEH compile-time option that enables Structured Exception Handling on Windows while working with the memory-mapped shm file that is part of WAL mode processing. This option is enabled by default when building on Windows using Makefile.msc.
  • The VFS for unix now assumes that the nanosleep() system call is available unless compiled with -DHAVE_NANOSLEEP=0.
Commits
  • d28600e version bump to v1.6.4
  • 662d731 Merge pull request #395 from sparklemotion/flavorjones-update-sqlite-3.43.0
  • 5c67d56 test: avoid using floats whose rounding is affected by valgrind
  • 7569b46 dep: update sqlite3 to v3.43.0
  • 676b1a7 Merge pull request #390 from sparklemotion/flavorjones-doc-improvements-2023-05
  • a2aa21a doc: create .rdoc_options with good defaults
  • 2dc58b7 doc: extract install docs to INSTALLATION.md
  • 56869e2 doc: promote the FAQ to the root directory
  • See full diff in compare view


Dependabot compatibility score

Dependabot will resolve any conflicts with this PR as long as you don't alter it yourself. You can also trigger a rebase manually by commenting @dependabot rebase.

Dependabot commands and options
You can trigger Dependabot actions by commenting on this PR: - `@dependabot rebase` will rebase this PR - `@dependabot recreate` will recreate this PR, overwriting any edits that have been made to it - `@dependabot merge` will merge this PR after your CI passes on it - `@dependabot squash and merge` will squash and merge this PR after your CI passes on it - `@dependabot cancel merge` will cancel a previously requested merge and block automerging - `@dependabot reopen` will reopen this PR if it is closed - `@dependabot close` will close this PR and stop Dependabot recreating it. You can achieve the same result by closing it manually - `@dependabot show ignore conditions` will show all of the ignore conditions of the specified dependency - `@dependabot ignore this major version` will close this PR and stop Dependabot creating any more for this major version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this minor version` will close this PR and stop Dependabot creating any more for this minor version (unless you reopen the PR or upgrade to it yourself) - `@dependabot ignore this dependency` will close this PR and stop Dependabot creating any more for this dependency (unless you reopen the PR or upgrade to it yourself)
dependabot[bot] commented 1 year ago

Superseded by #20.