Documentation Source Text

Check-in [77de487a96]
Login

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

Overview
Comment:Add the sha1sum and SQLITE_SOURCE_ID for version 3.8.11.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 77de487a960109aa29adabd7d1c570557624c816
User & Date: dan 2015-07-27 14:54:15.413
Context
2015-07-27
16:51
Version 3.8.11 (check-in: cae2f34af4 user: drh tags: trunk, release, version-3.8.11)
14:54
Add the sha1sum and SQLITE_SOURCE_ID for version 3.8.11. (check-in: 77de487a96 user: dan tags: trunk)
10:52
Add news for the 3.8.11 release. Tweaks to the testing document and to the change log. (check-in: 0b7f40e93e user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

chng {2015-07-28 (3.8.11)} {
<li>Added the experimental [RBU] extension.  Note that this extension is experimental
    and subject to change in incompatible ways.
<li>Added the experimental [FTS5] extension.  Note that this extension is experimental
    and subject to change in incompatible ways.
<li>Added the [sqlite3_value_dup()] and [sqlite3_value_free()] interfaces.
<li>Enhance the [spellfix1] extension to support [ON CONFLICT] clauses.
<li>The [IS operator] is now able to drive indexes.







|







14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

chng {2015-07-27 (3.8.11)} {
<li>Added the experimental [RBU] extension.  Note that this extension is experimental
    and subject to change in incompatible ways.
<li>Added the experimental [FTS5] extension.  Note that this extension is experimental
    and subject to change in incompatible ways.
<li>Added the [sqlite3_value_dup()] and [sqlite3_value_free()] interfaces.
<li>Enhance the [spellfix1] extension to support [ON CONFLICT] clauses.
<li>The [IS operator] is now able to drive indexes.
61
62
63
64
65
66
67



68
69
70
71
72
73
74
    aborts with an error.  Ticket
    [https://www.sqlite.org/src/info/873cae2b6e25b|873cae2b6e25b]
<li>Fix the [skip-scan optimization] so that it works correctly when
    the [OR optimization] is used on [WITHOUT ROWID] tables.  Ticket
    [https://www.sqlite.org/src/info/8fd39115d8f46|8fd39115d8f46]
<li>Fix the [sqlite3_memory_used()] and [sqlite3_memory_highwater()] interfaces
    so that they actually do provide a 64-bit answer.



}

chng {2015-05-20 (3.8.10.2)} {
<li>Fix an index corruption issue introduced by [version 3.8.7].  An index
    with a TEXT key can be corrupted by an [INSERT] into the corresponding 
    table if the table has two nested triggers that convert the key value to INTEGER
    and back to TEXT again.







>
>
>







61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
    aborts with an error.  Ticket
    [https://www.sqlite.org/src/info/873cae2b6e25b|873cae2b6e25b]
<li>Fix the [skip-scan optimization] so that it works correctly when
    the [OR optimization] is used on [WITHOUT ROWID] tables.  Ticket
    [https://www.sqlite.org/src/info/8fd39115d8f46|8fd39115d8f46]
<li>Fix the [sqlite3_memory_used()] and [sqlite3_memory_highwater()] interfaces
    so that they actually do provide a 64-bit answer.

<li>SQLITE_SOURCE_ID: "2015-07-27 13:49:41 b8e92227a469de677a66da62e4361f099c0b79d0"
<li>SHA1 for sqlite3.c: 719f6891abcd9c459b5460b191d731cd12a3643e
}

chng {2015-05-20 (3.8.10.2)} {
<li>Fix an index corruption issue introduced by [version 3.8.7].  An index
    with a TEXT key can be corrupted by an [INSERT] into the corresponding 
    table if the table has two nested triggers that convert the key value to INTEGER
    and back to TEXT again.
Changes to pages/news.in.
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  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 {2015-07-28} {Release 3.8.11} {
<p>SQLite version 3.8.10 is a regularly scheduled maintenance release.
   See the [version 3.8.11|change log] for details.
}

newsitem {2015-05-20} {Release 3.8.10.2} {
<p>Yikes!  Index corruption after a sequence of valid SQL statements!
<p>It has been many years since anything like 
   [https://www.sqlite.org/src/info/34cd55d6|this bug] has snuck into







|
|







15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
  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 {2015-07-27} {Release 3.8.11} {
<p>SQLite version 3.8.11 is a regularly scheduled maintenance release.
   See the [version 3.8.11|change log] for details.
}

newsitem {2015-05-20} {Release 3.8.10.2} {
<p>Yikes!  Index corruption after a sequence of valid SQL statements!
<p>It has been many years since anything like 
   [https://www.sqlite.org/src/info/34cd55d6|this bug] has snuck into