Documentation Source Text

Check-in [f9f945c599]
Login

Many hyperlinks are disabled.
Use anonymous login to enable hyperlinks.

Overview
Comment:Update to the change log.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: f9f945c599f732c40485349527e4fb0a22dd1dd46415ad3120539e313ee9a166
User & Date: drh 2019-02-05 16:45:35.629
Context
2019-02-07
13:42
Add news for 3.27.0 (check-in: 7a25788e4c user: drh tags: trunk)
2019-02-05
16:45
Update to the change log. (check-in: f9f945c599 user: drh tags: trunk)
12:58
Clarification to the VACUUM INTO documentation. (check-in: c7001012e1 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
55
56
57
58
59
60
61


62
63
64
65
66


67
68
69
70
71
72
73
74
75
76



















77
78
79
80
81
82
83
     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







>
>





>
>










>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
     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