baserev update by copy to link target

• Files Changed
• Browse Source

- use https urls

• Files Changed
• Browse Source

- update to 3.35.4:
  * Fix a defect in the query planner optimization identified by item 8b above.
  * Fix a defect in the new RETURNING syntax.
  * Fix the new RETURNING feature so that it raises an error if one of the
    terms in the RETURNING clause references a unknown table, instead of
    silently ignoring that error.
  * Fix an assertion associated with aggregate function processing that was
    incorrectly triggered by the push-down optimization.

• Files Changed
• Browse Source

• Files Changed
• Browse Source

- Fix typo in macro definition.

- SQLite 3.35.2:
  * Fix a problem in the appendvfs.c extension that was introduced
    into version 3.35.0.
  * Ensure that date/time functions with no arguments (which
    generate responses that depend on the current time) are treated
    as non-deterministic functions.
  * Fix a problem in the sqldiff utility program having to do with
    unusual whitespace characters in a virtual table definition.
  * Limit the new UNION ALL optimization described by item 8c in
    the 3.35.0 release so that it does not try to make too many
    new subqueries.
- include changes from 3.35.1:
  * Fix a bug in the new DROP COLUMN feature when used on columns
    that are indexed and that are quoted in the index definition.
  * Improve the built-in documentation for the .dump command in the
    CLI.

• Files Changed
• Browse Source

- update to 3.35.1:
  * Fix a bug in the new DROP COLUMN feature when used on columns that are
    indexed and that are quoted in the index definition.
  * Documentation improvements

• Files Changed
• Browse Source

baserev update by copy to link target

• Files Changed
• Browse Source

- update to 3.35.0:
  * Added built-in SQL math functions().
    (Requires the -DSQLITE_ENABLE_MATH_FUNCTIONS compile-time option.)
  * Added support for ALTER TABLE DROP COLUMN.
  * Generalize UPSERT:
      * Allow multiple ON CONFLICT clauses that are evaluated in order,
      * The final ON CONFLICT clause may omit the conflict target and yet still use DO UPDATE.
  * Add support for the RETURNING clause on DELETE, INSERT, and UPDATE statements.
  * Use less memory when running VACUUM on databases containing very large TEXT
    or BLOB values. It is no longer necessary to hold the entire TEXT or BLOB
    in memory all at once.
  * Add support for the MATERIALIZED and NOT MATERIALIZED hints when specifying
    common table expressions. The default behavior was formerly NOT
    MATERIALIZED, but is now changed to MATERIALIZED for CTEs that are used
    more than once.
  * The SQLITE_DBCONFIG_ENABLE_TRIGGER and SQLITE_DBCONFIG_ENABLE_VIEW settings
    are modified so that they only control triggers and views in the main
    database schema or in attached database schemas and not in the TEMP schema.
    TEMP triggers and views are always allowed.
  * Query planner/optimizer improvements
  * Enhance the ".stats" command to accept new arguments "stmt" and "vmstep",
    causing prepare statement statistics and only the virtual-machine step
    count to be shown, respectively.
  * Add the ".filectrl data_version" command.
  * Enhance the ".once" and ".output" commands so that if the destination
    argument begins with "|" (indicating that output is redirected into a pipe)
    then the argument does not need to be quoted.
  * Fix a bug in the IN-operator optimization of version 3.33.0 that can cause
    an incorrect answer.
  * Fix incorrect answers from the LIKE operator if the pattern ends with "%"

• Files Changed
• Browse Source

• Browse Source