---
- branch: MAIN
  date: Fri Aug 25 06:48:00 UTC 2023
  files:
  - new: '1.102'
    old: '1.101'
    path: pkgsrc/databases/sqlite3/Makefile.common
    pathrev: pkgsrc/databases/sqlite3/Makefile.common@1.102
    type: modified
  - new: '1.195'
    old: '1.194'
    path: pkgsrc/databases/sqlite3/distinfo
    pathrev: pkgsrc/databases/sqlite3/distinfo@1.195
    type: modified
  - new: '1.125'
    old: '1.124'
    path: pkgsrc/databases/sqlite3-docs/PLIST
    pathrev: pkgsrc/databases/sqlite3-docs/PLIST@1.125
    type: modified
  - new: '1.128'
    old: '1.127'
    path: pkgsrc/databases/sqlite3-docs/distinfo
    pathrev: pkgsrc/databases/sqlite3-docs/distinfo@1.128
    type: modified
  - new: '1.140'
    old: '1.139'
    path: pkgsrc/databases/sqlite3-tcl/distinfo
    pathrev: pkgsrc/databases/sqlite3-tcl/distinfo@1.140
    type: modified
  - new: '1.69'
    old: '1.68'
    path: pkgsrc/devel/lemon/distinfo
    pathrev: pkgsrc/devel/lemon/distinfo@1.69
    type: modified
  id: 20230825T064800Z.4a6b798f5fbd9d851f14df8d1b7a6c323436812c
  log: "databases/sqlite3* devel/lemon: updated to 2.43.0\n\nSQLite Release 3.43.0
    On 2023-08-24\n\nAdd 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.\nEnhancements to the date and time
    functions:\nAdded new time shift modifiers of the form è³\x8AYYYY-MM-DD HH:MM:SS.SSS.\nAdded
    the timediff() SQL function.\nAdded the octet_length(X) SQL function.\nAdded the
    sqlite3_stmt_explain() API.\nQuery planner enhancements:\nGeneralize the LEFT
    JOIN strength reduction optimization so that it works for RIGHT and FULL JOINs
    as well. Rename it to OUTER JOIN strength reduction.\nEnhance the theorem prover
    in the OUTER JOIN strength reduction optimization so that it returns fewer false-negatives.\nEnhancements
    to the decimal extension:\nNew function decimal_pow2(N) returns the N-th power
    of 2 for integer N between -20000 and +20000.\nNew function decimal_exp(X) works
    like decimal(X) except that it returns the result in exponential notation - with
    a \"e+NN\" at the end.\nIf X is a floating-point value, then the decimal(X) function
    now does a full expansion of that value into its exact decimal equivalent.\nPerformance
    enhancements to JSON processing results in a 2x performance improvement for some
    kinds of processing on large JSON strings.\nNew 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.)\nAdded
    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.\nThe
    VFS for unix now assumes that the nanosleep() system call is available unless
    compiled with -DHAVE_NANOSLEEP=0.\n"
  module: pkgsrc
  subject: 'CVS commit: pkgsrc'
  unixtime: '1692946080'
  user: adam