Documentation Source Text

Check-in [13e71499bd]
Login

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

Overview
Comment:Add the new sqlite3_stmt_isexplain() interface to the change log.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 13e71499bd03eb6edb4bff9e28a836337b2e97c85f669f505ae04e4912eaec7d
User & Date: drh 2019-03-06 15:16:28
Context
2019-03-07
00:26
Fix typos in the changelog for 3.28.0. check-in: 6bd3d16e85 user: drh tags: trunk
2019-03-06
15:16
Add the new sqlite3_stmt_isexplain() interface to the change log. check-in: 13e71499bd user: drh tags: trunk
15:03
Merge changes from the 3.27 branch. check-in: 00f74a59cd user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

18
19
20
21
22
23
24


25
26
27
28
29
30
31
  global nChng aChng xrefChng
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}

chng {2019-04-00 (3.28.0)} {


<li> New query optimizations:
<ol type="a">
<li> Enable the [LIKE optimization] for cases when the ESCAPE keyword
     is present and [PRAGMA case_sensitive_like] is on.
<li> In queries that are driven by a [partial index], avoid unnecessary
     tests of the constraint named in the WHERE clause of the partial
     index, since we know that constraint must always be true.







>
>







18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
  global nChng aChng xrefChng
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}

chng {2019-04-00 (3.28.0)} {
<li> Added the new [sqlite3_stmt_isexplain(S)] interface for determining
     whether or not a [prepared statement] is an [EXPLAIN].
<li> New query optimizations:
<ol type="a">
<li> Enable the [LIKE optimization] for cases when the ESCAPE keyword
     is present and [PRAGMA case_sensitive_like] is on.
<li> In queries that are driven by a [partial index], avoid unnecessary
     tests of the constraint named in the WHERE clause of the partial
     index, since we know that constraint must always be true.