Documentation Source Text
Check-in [9ac72e3702]
Not logged in

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

Overview
SHA1 Hash:9ac72e3702c2e9f266a33dab3163364d73137b37
Date: 2014-03-10 12:23:40
User: drh
Comment:The 3.8.4 release.
Tags And Properties
Changes
Hide Diffs Unified Diffs Ignore Whitespace Patch

Changes to pages/changes.in

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
39
..
49
50
51
52
53
54
55


56
57
58
59
60
61
62
set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

chng {2014-03-08 (3.8.4)} {
<li>Code optimization and refactoring for improved performance.
<li>Add the ".clone" and ".save" commands to the command-line shell.
<li>Update the banner on the command-line shell to alert novice users when they
    are using an ephemeral in-memory database.
<li>Fix editline support in the command-line shell.
<li>Add support for coverage testing of VDBE programs using the
    [SQLITE_TESTCTRL_VDBE_COVERAGE] verb of [sqlite3_test_control()].
<li>Update the _FILE_OFFSET_BITS macro so that builds work again on QNX.
<li>Change the datatype of SrcList.nSrc from type u8 to type int to work around 
    an issue in the C compiler on AIX.
<li>Get extension loading working on Cygwin.


<li>Bug fix: DISTINCT now recognizes that a [zeroblob] and a blob of all
    0x00 bytes are the same thing. 
    [http://www.sqlite.org/src/info/fccbde530a | Ticket &#91;fccbde530a&#93]
<li>Bug fix: Compute the correct answer for queries that contain an IS NOT NULL
    term in the WHERE clause and also contain an OR term in the WHERE clause and
    are compiled with [SQLITE_ENABLE_STAT4].
    [http://www.sqlite.org/src/info/4c86b126f2 | Ticket &#91;4c86b126f2&#93]
................................................................................
<li>Bug fix: Repair a name-resolution error that can occur in sub-select statements
    contained within a TRIGGER.
    [http://www.sqlite.org/src/info/4ef7e3cfca | Ticket &#91;4ef7e3cfca&#93]
<li>Bug fix: Fix column default values expressions of the form
    "DEFAULT(-(-9223372036854775808))" so that they work correctly, initializing
    the column to a floating point value approximately equal to
    +9223372036854775808.0.


}

chng {2014-02-11 (3.8.3.1)} {
<li>Fix a bug (ticket [http://www.sqlite.org/src/info/4c86b126f2|4c86b126f2])
    that causes rows to go missing on some queries with OR clauses and
    IS NOT NULL operators in the WHERE clause, when the [SQLITE_ENABLE_STAT3]
    or [SQLITE_ENABLE_STAT4] compile-time options are used.







|











>
>







 







>
>







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
39
40
41
..
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
set nChng 0
proc chng {date desc {options {}}} {
  global nChng aChng
  set aChng($nChng) [list $date $desc $options]
  incr nChng
}

chng {2014-03-10 (3.8.4)} {
<li>Code optimization and refactoring for improved performance.
<li>Add the ".clone" and ".save" commands to the command-line shell.
<li>Update the banner on the command-line shell to alert novice users when they
    are using an ephemeral in-memory database.
<li>Fix editline support in the command-line shell.
<li>Add support for coverage testing of VDBE programs using the
    [SQLITE_TESTCTRL_VDBE_COVERAGE] verb of [sqlite3_test_control()].
<li>Update the _FILE_OFFSET_BITS macro so that builds work again on QNX.
<li>Change the datatype of SrcList.nSrc from type u8 to type int to work around 
    an issue in the C compiler on AIX.
<li>Get extension loading working on Cygwin.
<li>Bug fix: Fix the [char()] SQL function so that it returns an empty string
    rather than an "out of memory" error when called with zero arguments. 
<li>Bug fix: DISTINCT now recognizes that a [zeroblob] and a blob of all
    0x00 bytes are the same thing. 
    [http://www.sqlite.org/src/info/fccbde530a | Ticket &#91;fccbde530a&#93]
<li>Bug fix: Compute the correct answer for queries that contain an IS NOT NULL
    term in the WHERE clause and also contain an OR term in the WHERE clause and
    are compiled with [SQLITE_ENABLE_STAT4].
    [http://www.sqlite.org/src/info/4c86b126f2 | Ticket &#91;4c86b126f2&#93]
................................................................................
<li>Bug fix: Repair a name-resolution error that can occur in sub-select statements
    contained within a TRIGGER.
    [http://www.sqlite.org/src/info/4ef7e3cfca | Ticket &#91;4ef7e3cfca&#93]
<li>Bug fix: Fix column default values expressions of the form
    "DEFAULT(-(-9223372036854775808))" so that they work correctly, initializing
    the column to a floating point value approximately equal to
    +9223372036854775808.0.
<li>SQLITE_SOURCE_ID: "2014-03-10 12:20:37 530a1ee7dc2435f80960ce4710a3c2d2bfaaccc5"
<li>SHA1 for sqlite3.c: b0c22e5f15f5ba2afd017ecd990ea507918afe1c
}

chng {2014-02-11 (3.8.3.1)} {
<li>Fix a bug (ticket [http://www.sqlite.org/src/info/4c86b126f2|4c86b126f2])
    that causes rows to go missing on some queries with OR clauses and
    IS NOT NULL operators in the WHERE clause, when the [SQLITE_ENABLE_STAT3]
    or [SQLITE_ENABLE_STAT4] compile-time options are used.

Changes to pages/news.in

15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
  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-08} {Release 3.8.4} {
<p>SQLite [version 3.8.4] is a maintenance release featuring performance
   enhancements and fixes for a number of obscure bugs.
   There are no significant new features in SQLite version 3.8.4.
   However, the number of CPU cycles (measured by valgrind) needed to 
   do many common operations has be reduced by about 12% relative to the
   previous release, and by about 25% relative to [version 3.7.16]
   from approximately one year ago.







|







15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
  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-10} {Release 3.8.4} {
<p>SQLite [version 3.8.4] is a maintenance release featuring performance
   enhancements and fixes for a number of obscure bugs.
   There are no significant new features in SQLite version 3.8.4.
   However, the number of CPU cycles (measured by valgrind) needed to 
   do many common operations has be reduced by about 12% relative to the
   previous release, and by about 25% relative to [version 3.7.16]
   from approximately one year ago.