Documentation Source Text

Check-in [2482a30724]
Login

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

Overview
Comment:Version 3.8.4.3
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk | release | version-3.8.4.3
Files: files | file ages | folders
SHA1: 2482a30724433d91b593012c5dcd6e40c71c6f52
User & Date: drh 2014-04-03 17:07:38.788
Context
2014-04-05
12:04
Fix a typo on the 3.8.4.3 news page. (check-in: 7401266cf0 user: drh tags: trunk)
2014-04-03
17:07
Version 3.8.4.3 (check-in: 2482a30724 user: drh tags: trunk, release, version-3.8.4.3)
2014-04-01
17:19
Tweaks and maintenance on the various documentation pages. Improvements to wording. Updated hyperlinks. (check-in: c08c92bf98 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
︙︙
13
14
15
16
17
18
19










20
21
22
23
24
25
26

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











chng {2014-03-26 (3.8.4.2)} {
<li>Fix a potential buffer overread that could result when trying to search a
    corrupt database file.
<li>SQLITE_SOURCE_ID: "2014-03-26 18:51:19 02ea166372bdb2ef9d8dfbb05e78a97609673a8e"
<li>SHA1 for sqlite3.c: 4685ca86c2ea0649ed9f59a500013e90b3fe6d03
}








>
>
>
>
>
>
>
>
>
>








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

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

chng {2014-04-03 (3.8.4.3)} {
<li>Add a 
    [http://www.sqlite.org/src/fdiff?sbs=1&v1=7d539cedb1c&v2=ebad891b7494d&smhdr|one-character fix]
    for a problem that might cause incorrect query results on a query that mixes
    DISTINCT, GROUP BY in a subquery, and ORDER BY.
    [http://www.sqlite.org/src/info/98825a79ce1456863|Ticket 98825a79ce14].
<li>SQLITE_SOURCE_ID: "2014-04-03 16:53:12 a611fa96c4a848614efe899130359c9f6fb889c3"
<li>SHA1 for sqlite3.c: 310a1faeb9332a3cd8d1f53b4a2e055abf537bdc
}

chng {2014-03-26 (3.8.4.2)} {
<li>Fix a potential buffer overread that could result when trying to search a
    corrupt database file.
<li>SQLITE_SOURCE_ID: "2014-03-26 18:51:19 02ea166372bdb2ef9d8dfbb05e78a97609673a8e"
<li>SHA1 for sqlite3.c: 4685ca86c2ea0649ed9f59a500013e90b3fe6d03
}
︙︙
Changes to pages/index.in.
︙︙
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105


</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_8_4_2.html">Version 3.8.4.2</a>
of SQLite is recommended for all new development.
Upgrading from all other versions of SQLite
is recommended.</li>
</ul></p>

<h3>Common Links</h3>









|








91
92
93
94
95
96
97
98
99
100
101
102
103
104
105


</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_8_4_3.html">Version 3.8.4.3</a>
of SQLite is recommended for all new development.
Upgrading from all other versions of SQLite
is recommended.</li>
</ul></p>

<h3>Common Links</h3>
︙︙
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 {2014-03-26} {Release 3.8.4.2} {
<p>The code changes that resulted in the performance improvements
   in [version 3.8.4] missed a single buffer overflow test, which could
   result in a read past the end of a buffer while searching a database
   that is corrupted in a particular way.  [Version 3.8.4.2] fixes that
   problem using a








>
>
>
>
>
>
>
>
>
>
>








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

  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 {2014-04-03} {Release 3.8.4.3} {
<p>The optimizations added in [version 3.8.4] caused some queries that involve
   subqueries in the FROM clause, DISTINCT, and ORDER BY clauess, to give an incorrect
   result.  See
   [http://www.sqlite.org/src/info/98825a79ce145686392d8074032ae54863aa21a3| ticket 98825a79ce145]
   for details.
   This release adds a 
   [http://www.sqlite.org/src/fdiff?sbs=1&v1=7d539cedb1c&v2=ebad891b7494d&smhdr|one-character change]
   to a single line of code to fix the problem.
}

newsitem {2014-03-26} {Release 3.8.4.2} {
<p>The code changes that resulted in the performance improvements
   in [version 3.8.4] missed a single buffer overflow test, which could
   result in a read past the end of a buffer while searching a database
   that is corrupted in a particular way.  [Version 3.8.4.2] fixes that
   problem using a
︙︙