Documentation Source Text

Check-in [19c959312d]
Login

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

Overview
Comment:Adjust the website for the 3.10.2 patch release.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | branch-3.10
Files: files | file ages | folders
SHA1: 19c959312d6707ca62019f1bcd1fd6ce9439993e
User & Date: drh 2016-01-20 14:50:00.168
Context
2016-01-20
15:35
Include the minor bug fixes in the 3.10.2 patch release. (check-in: 1f9040ed82 user: drh tags: branch-3.10)
14:50
Adjust the website for the 3.10.2 patch release. (check-in: 19c959312d user: drh tags: branch-3.10)
2016-01-19
17:10
Fix to the download.in script to not disable individual shell downloads if the tool bundle is missing. (check-in: 2dcd192c8b user: drh tags: branch-3.10)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
︙︙
16
17
18
19
20
21
22










23
24
25
26
27
28
29

set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}











chng {2016-01-14 (3.10.1)} {
<p><b>New feature:</b>
<li>Add the [SQLITE_FCNTL_JOURNAL_POINTER] file control.
<p><b>Bug fix:</b>
<li>Fix a 16-month-old bug in the query planner that could generate incorrect results
    when a scalar subquery attempts to use the [block sorting] optimization.  Ticket
    [https://www.sqlite.org/src/info/cb3aa0641d9a4|cb3aa0641d9a4].








>
>
>
>
>
>
>
>
>
>








16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39

set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

chng {2016-01-20 (3.10.2)} {
<p><b>Bug fix:</b>
<li>Version 3.10.0 introduced a case-folding bug in the [LIKE] operator which is fixed
    by this patch release.  Ticket 
    [https://www.sqlite.org/src/info/80369eddd5c94 | 80369eddd5c94].
<p><b>Hashes:</b>
<li>SQLITE_SOURCE_ID: "2016-01-20 14:32:43 c1f918dcc15e3bd440435df4c7939bb2ee49b693"
<li>SHA1 for sqlite3.c: fda268ecda8162063bf913e90ea3350d1c4cbbc9
} {patchagainst 1 patchagainst 2}

chng {2016-01-14 (3.10.1)} {
<p><b>New feature:</b>
<li>Add the [SQLITE_FCNTL_JOURNAL_POINTER] file control.
<p><b>Bug fix:</b>
<li>Fix a 16-month-old bug in the query planner that could generate incorrect results
    when a scalar subquery attempts to use the [block sorting] optimization.  Ticket
    [https://www.sqlite.org/src/info/cb3aa0641d9a4|cb3aa0641d9a4].
︙︙
Changes to pages/index.in.
︙︙
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120


</td>
<td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td>
<td valign="top">
<h3>Current Status</h3>

<p><ul>
<li><a href="releaselog/3_10_1.html">Version 3.10.1</a>
of SQLite is recommended for all new development.
</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>








|








106
107
108
109
110
111
112
113
114
115
116
117
118
119
120


</td>
<td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td>
<td valign="top">
<h3>Current Status</h3>

<p><ul>
<li><a href="releaselog/3_10_2.html">Version 3.10.2</a>
of SQLite is recommended for all new development.
</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>
︙︙
Changes to pages/news.in.
︙︙
14
15
16
17
18
19
20






21
22
23
24
25
26
27

  hd_puts "<h3>$date - $title</h3>"
  regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
  regsub -all {[Tt]icket #(\d+)} $txt \
      {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
  hd_resolve "<blockquote>$txt</blockquote>"
  hd_puts "<hr width=\"50%\">"
}







newsitem {2016-01-14} {Release 3.10.1} {
<p>SQLite [version 3.10.1] is a bug-fix release primarily targeting the
fix for the query planner bug
[https://www.sqlite.org/src/info/cb3aa0641d9a4|cb3aa0641d9a4] discovered by
Mapscape.  Also included is a minor API enhancement requested by
the Firefox developers at Mozilla.  The differences from version 








>
>
>
>
>
>








14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33

  hd_puts "<h3>$date - $title</h3>"
  regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
  regsub -all {[Tt]icket #(\d+)} $txt \
      {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
  hd_resolve "<blockquote>$txt</blockquote>"
  hd_puts "<hr width=\"50%\">"
}

newsitem {2016-01-20} {Release 3.10.2} {
<p>Yikes!  An optimization attempt gone bad resulted in a 
[https://www.sqlite.org/src/info/80369eddd5c94 | bug in the LIKE operator]
which is fixed by this patch release.
}

newsitem {2016-01-14} {Release 3.10.1} {
<p>SQLite [version 3.10.1] is a bug-fix release primarily targeting the
fix for the query planner bug
[https://www.sqlite.org/src/info/cb3aa0641d9a4|cb3aa0641d9a4] discovered by
Mapscape.  Also included is a minor API enhancement requested by
the Firefox developers at Mozilla.  The differences from version
︙︙