Next | Query returned 157 messages, browsing 1 to 10 | Previous

History of commit frequency

CVS Commit History:


   2021-06-25 23:21:31 by Adam Ciarcinski | Files touched by this commit (8) | Package updated
Log message:
sqlite3: updated to 3.36.0

SQLite Release 3.36.0 On 2021-06-18

Improvement to the EXPLAIN QUERY PLAN output to make it easier to understand.
Byte-order marks at the start of a token are skipped as if they were whitespace.
An error is raised on any attempt to access the rowid of a VIEW or subquery. \ 
Formerly, the rowid of a VIEW would be indeterminate and often would be NULL. \ 
The -DSQLITE_ALLOW_ROWID_IN_VIEW compile-time option is available to restore the \ 
legacy behavior for applications that need it.
The sqlite3_deserialize() and sqlite3_serialize() interfaces are now enabled by \ 
default. The -DSQLITE_ENABLE_DESERIALIZE compile-time option is no longer \ 
required. Instead, there is is a new -DSQLITE_OMIT_DESERIALIZE compile-time \ 
option to omit those interfaces.
The "memdb" VFS now allows the same in-memory database to be shared \ 
among multiple database connections in the same process as long as the database \ 
name begins with "/".
Back out the EXISTS-to-IN optimization (item 8b in the SQLite 3.35.0 change log) \ 
as it was found to slow down queries more often than speed them up.
Improve the constant-propagation optimization so that it works on non-join queries.
The REGEXP extension is now included in CLI builds.
   2021-04-21 13:43:04 by Adam Ciarcinski | Files touched by this commit (1822)
Log message:
revbump for textproc/icu
   2021-04-20 08:30:07 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.35.5

version 3.35.5:

Fix defects in the new ALTER TABLE DROP COLUMN feature that could corrupt the \ 
database file.
Fix an obscure query optimizer problem that might cause an incorrect query result.
   2021-04-03 08:25:30 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.35.4

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.
   2021-03-30 09:51:16 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.35.3

changes in version 3.35.3

Enhance the OP_OpenDup opcode of the bytecode engine so that it works even if \ 
the cursor being duplicated itself came from OP_OpenDup. Fix for ticket \ 
bb8a9fd4a9b7fce5. This problem only came to light due to the recent MATERIALIZED \ 
hint enhancement.
When materializing correlated common table expressions, do so separately for \ 
each use case, as that is required for correctness. This fixes a problem that \ 
was introduced by the MATERIALIZED hint enhancement.
Fix a problem in the filename normalizer of the unix VFS.
Fix the "box" output mode in the CLI so that it works with statements \ 
that returns one or more rows of zero columns (such as PRAGMA \ 
incremental_vacuum). Forum post afbbcb5b72.
Improvements to error messages generated by faulty common table expressions. \ 
Forum post aa5a0431c99e.
Fix some incorrect assert() statements.
Fix to the SELECT statement syntax diagram so that the FROM clause syntax is \ 
shown correctly. Forum post 9ed02582fe.
Fix the EBCDIC character classifier so that it understands newlines as \ 
whitespace. Forum post 58540ce22dcd.
Improvements the xBestIndex method in the implementation of the (unsupported) \ 
wholenumber virtual table extension so that it does a better job of convincing \ 
the query planner to avoid trying to materialize a table with an infinite number \ 
of rows.
   2021-03-19 07:29:04 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.35.2

Changes in version 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. Ticket \ 
2c6c8689fb5f3d2f
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. See forum thread \ 
140a67d3d2 for details.
   2021-03-17 07:24:43 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.35.1

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.
   2021-03-15 15:51:01 by Adam Ciarcinski | Files touched by this commit (7) | Package updated
Log message:
sqlite3: updated to 3.35.0

SQLite Release 3.35.0 On 2021-03-12

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:
Enhancements to the min/max optimization so that it works better with the IN \ 
operator and the OP_SeekScan optimization of the previous release.
Attempt to process EXISTS operators in the WHERE clause as if they were IN \ 
operators, in cases where this is a valid transformation and seems likely to \ 
improve performance.
Allow UNION ALL sub-queries to be flattened even if the parent query is a join.
Use an index, if appropriate, on IS NOT NULL expressions in the WHERE clause, \ 
even if STAT4 is disabled.
Expressions of the form "x IS NULL" or "x IS NOT NULL" might \ 
be converted to simply FALSE or TRUE, if "x" is a column that has a \ 
"NOT NULL" constraint and is not involved in an outer join.
Avoid checking foreign key constraints on an UPDATE statement if the UPDATE does \ 
not modify any columns associated with the foreign key.
Allow WHERE terms to be pushed down into sub-queries that contain window \ 
functions, as long as the WHERE term is made up of entirely of constants and \ 
copies of expressions found in the PARTITION BY clauses of all window functions \ 
in the sub-query.
CLI enhancements:
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.
Bug fixes:
Fix a potential NULL pointer dereference when processing a syntactically \ 
incorrect SELECT statement with a correlated WHERE clause and a "HAVING \ 
0" clause. (Also fixed in the 3.34.1 patch release.)
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 \ 
"%" and there is an "ESCAPE '_'" clause.
   2021-01-20 21:34:37 by Adam Ciarcinski | Files touched by this commit (6) | Package updated
Log message:
sqlite3: updated to 3.34.1

Changes in version 3.34.1:

Fix a potential use-after-free bug when processing a a subquery with both a \ 
correlated WHERE clause and a "HAVING 0" clause and where the parent \ 
query is an aggregate.
Fix documentation typos
Fix minor problems in extensions.
   2020-12-02 08:57:19 by Adam Ciarcinski | Files touched by this commit (8) | Package updated
Log message:
sqlite3: updated to 3.34.0

SQLite Release 3.34.0

Added the sqlite3_txn_state() interface for reporting on the current transaction \ 
state of the database connection.
Enhance recursive common table expressions to support two or more recursive \ 
terms as is done by SQL Server, since this helps make queries against graphs \ 
easier to write and faster to execute.
Improved error messages on CHECK constraint failures.
CLI enhancements:
The .read dot-command now accepts a pipeline in addition to a filename.
Added options --data-only and --nosys to the .dump dot-command.
Added the --nosys option to the .schema dot-command.
Table name quoting works correctly for the .import dot-command.
The generate_series(START,END,STEP) table-valued function extension is now built \ 
into the CLI.
The .databases dot-command now show the status of each database file as \ 
determined by sqlite3_db_readonly() and sqlite3_txn_state().
Added the --tabs command-line option that sets .mode tabs.
The --init option reports an error if the file named as its argument cannot be \ 
opened. The --init option also now honors the --bail option.
Query planner improvements:
Improved estimates for the cost of running a DISTINCT operator.
When doing an UPDATE or DELETE using a multi-column index where only a few of \ 
the earlier columns of the index are useful for the index lookup, postpone doing \ 
the main table seek until after all WHERE clause constraints have been \ 
evaluated, in case those constraints can be covered by unused later terms of the \ 
index, thus avoiding unnecessary main table seeks.
The new OP_SeekScan opcode is used to improve performance of multi-column index \ 
look-ups when later columns are constrained by an IN operator.
The BEGIN IMMEDIATE and BEGIN EXCLUSIVE commands now work even if one or more \ 
attached database files are read-only.
Enhanced FTS5 to support trigram indexes.
Improved performance of WAL mode locking primitives in cases where there are \ 
hundreds of connections all accessing the same database file at once.
Enhanced the carray() table-valued function to include a single-argument form \ 
that is bound using the auxiliary sqlite3_carray_bind() interface.
The substr() SQL function can now also be called "substring()" for \ 
compatibility with SQL Server.
The syntax diagrams are now implemented as Pikchr scripts and rendered as SVG \ 
for improved legibility and ease of maintenance.

Next | Query returned 157 messages, browsing 1 to 10 | Previous