Documentation Source Text

Check-in [0ed8a559a1]
Login

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

Overview
Comment:The change of removing deprecated PRAGMAs with SQLITE_OMIT_DEPRECATED was backed out, so remove it from the change log.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 0ed8a559a1a20af7f451f0aedc218d8f297acc0ab4a8747bba37ab93d75a2d9f
User & Date: drh 2019-02-08 16:06:26.752
Context
2019-02-11
13:21
Add documentation for the fts3/4/5 remove_diacritic options. (check-in: 34f973966a user: dan tags: trunk)
2019-02-08
16:06
The change of removing deprecated PRAGMAs with SQLITE_OMIT_DEPRECATED was backed out, so remove it from the change log. (check-in: 0ed8a559a1 user: drh tags: trunk)
13:54
Improved text for the 3.27.1 news article. (check-in: b5727d3e83 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
     [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].







<







72
73
74
75
76
77
78

79
80
81
82
83
84
85
     [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> 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].