Documentation Source Text

Check-in [cc1675f94a]
Login

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

Overview
Comment:Add a change log entry for the query planner enhancement backport to 3.9.3.
Timelines: family | ancestors | descendants | both | branch-3.12
Files: files | file ages | folders
SHA1: cc1675f94adf87fedfc6a80f10103411d37037fc
User & Date: drh 2016-04-01 01:05:52
Context
2016-04-04
12:21
Typo fixes from Johannes Laire. check-in: 16f159820b user: drh tags: branch-3.12
2016-04-01
14:57
Merge changes from the 3.12.0 branch. Add the "rowidtable.html" page. Add documentation for SQLITE_ENABLE_PREUPDATE_HOOK. check-in: 74e8dbd8bf user: drh tags: trunk
01:05
Add a change log entry for the query planner enhancement backport to 3.9.3. check-in: cc1675f94a user: drh tags: branch-3.12
2016-03-29
22:30
On second thought, remove the information disclosure clean-up policy. check-in: f343e93d94 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in.

15
16
17
18
19
20
21






22
23
24
25
26
27
28
<tcl>
set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}







chng {2016-03-29 (3.12.0)} {
<p><b>Potentially Disruptive Change:</b>
<li>The [SQLITE_DEFAULT_PAGE_SIZE] is increased from 1024 to 4096.  
    The [SQLITE_DEFAULT_CACHE_SIZE] is changed from 2000 to -2000 so 
    the same amount of cache memory is used by default.
    See the application note on the







>
>
>
>
>
>







15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
<tcl>
set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

chng {2016-04-01 (3.9.3)} {
<li>Backport a simple query planner optimization that allows the IS operator
    to drive an index on a LEFT OUTER JOIN.  No other changes from the
    [version 3.9.2] baseline.
}

chng {2016-03-29 (3.12.0)} {
<p><b>Potentially Disruptive Change:</b>
<li>The [SQLITE_DEFAULT_PAGE_SIZE] is increased from 1024 to 4096.  
    The [SQLITE_DEFAULT_CACHE_SIZE] is changed from 2000 to -2000 so 
    the same amount of cache memory is used by default.
    See the application note on the