Documentation Source Text

     source tree.
<li> Add support for the "--maxsize N" option on ".open --deserialize".
<li> Add the "--memtrace" command-line option, to show all memory allocations
     and deallocations.
<li> Add the ".eqp trace" option on builds with SQLITE_DEBUG, to enable
     bytecode program listing with indentation and 
     [PRAGMA vdbe_trace] all in one step.


<li> Add the "--async" option to the ".backup" command.
<li> Add options "--expanded", "--normalized", "--plain", "--profile", "--row",
     "--stmt", and "--close" to the ".trace" command.
</ol>
<li> Omit deprecated PRAGMA statements when compiling with [SQLITE_OMIT_DEPRECATED].


 <p><b>Bug fixes:</b>
<li>Do not use a partial index to do a table scan on an IN operator.
Ticket [https://www.sqlite.org/src/info/1d958d90596593a774|1d958d90596593a774].
<li>Fix the [query flattener] so that it works on queries that contain
subqueries that use [window functions].
Ticket [https://www.sqlite.org/src/info/f09fcd17810f65f717|709fcd17810f65f717]
<li>Ensure that ALTER TABLE modifies table and column names embedded in WITH
clauses that are part of views and triggers.
<li>Fix a parser bug that prevented the use of parentheses around table-valued
functions.



















}

chng {2018-12-01 (3.26.0)} {
<li>Optimization: When doing an [UPDATE] on a table with [indexes on expressions],
    do not update the expression indexes if they do not refer to any of the columns
    of the table being updated.
<li>Allow the [xBestIndex()] method of [virtual table] implementations to return

     source tree.
<li> Add support for the "--maxsize N" option on ".open --deserialize".
<li> Add the "--memtrace" command-line option, to show all memory allocations
     and deallocations.
<li> Add the ".eqp trace" option on builds with SQLITE_DEBUG, to enable
     bytecode program listing with indentation and 
     [PRAGMA vdbe_trace] all in one step.
<li> Add the ".progress" command for accessing
     the [sqlite3_progress_handler()] interface.
<li> Add the "--async" option to the ".backup" command.
<li> Add options "--expanded", "--normalized", "--plain", "--profile", "--row",
     "--stmt", and "--close" to the ".trace" command.
</ol>
<li> Omit deprecated PRAGMA statements when compiling with [SQLITE_OMIT_DEPRECATED].
<li> Increased robustness against malicious SQL that is run against a 
     maliciously corrupted database.
 <p><b>Bug fixes:</b>
<li>Do not use a partial index to do a table scan on an IN operator.
Ticket [https://www.sqlite.org/src/info/1d958d90596593a774|1d958d90596593a774].
<li>Fix the [query flattener] so that it works on queries that contain
subqueries that use [window functions].
Ticket [https://www.sqlite.org/src/info/f09fcd17810f65f717|709fcd17810f65f717]
<li>Ensure that ALTER TABLE modifies table and column names embedded in WITH
clauses that are part of views and triggers.
<li>Fix a parser bug that prevented the use of parentheses around table-valued
functions.
<li>Fix a problem with the [OR optimization] on [indexes on expressions].
Ticket [https://www.sqlite.org/src/info/d96eba87698a428c1d|d96eba87698a428c1d].
<li>Fix a problem with the
[LEFT JOIN strength reduction optimization] in which the optimization
was being applied inappropriately due to an IS NOT NULL operator.
Ticket [https://www.sqlite.org/src/info/5948e09b8c415bc45d|5948e09b8c415bc45d].
<li>Fix the [REPLACE] command so that it is no longer able to sneak a
NULL value into a NOT NULL column even if the NOT NULL column has a default
value of NULL.
Ticket [https://www.sqlite.org/src/info/e6f1f2e34dceeb1ed6|e6f1f2e34dceeb1ed6]
<li>Fix a problem with the use of [window functions] used within 
[correlated subqueries].
Ticket [https://www.sqlite.org/src/info/d0866b26f83e9c55e3|d0866b26f83e9c55e3]
<li>Fix the [ALTER TABLE RENAME COLUMN] command so that it works for tables
that have redundant UNIQUE constraints.
Ticket [https://www.sqlite.org/src/info/bc8d94f0fbd633fd9a|bc8d94f0fbd633fd9a]
<li>Fix a bug that caused [zeroblob] values to be truncated when inserted into
a table that uses an [expression index].
Ticket [https://www.sqlite.org/src/info/bb4bdb9f7f654b0bb9|bb4bdb9f7f654b0bb9]
}

chng {2018-12-01 (3.26.0)} {
<li>Optimization: When doing an [UPDATE] on a table with [indexes on expressions],
    do not update the expression indexes if they do not refer to any of the columns
    of the table being updated.
<li>Allow the [xBestIndex()] method of [virtual table] implementations to return