Documentation Source Text

Check-in [01bd9245c3]
Login

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

Overview
Comment:Changes for version 3.6.9.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 01bd9245c3c1311e9f2686309fb38eb8c9d2c014
User & Date: drh 2009-01-14 02:17:03.000
Context
2009-01-14
06:51
Fix minor typo in pragma.html. (check-in: 0fec42b940 user: dan tags: trunk)
02:17
Changes for version 3.6.9. (check-in: 01bd9245c3 user: drh tags: trunk)
2009-01-12
15:39
Fix documentation typos. (check-in: 5fec82ddb1 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
37
38
39
40
41
42
43






44
45
46
47
48
49
50
      <a href="http://www.sqlite.org/cvstrac/timeline">
      http://www.sqlite.org/cvstrac/timeline</a>.</p>
    }
    hd_close_aux
    hd_enable_main 1
  }
}







chng {2009 Jan 12 (3.6.8)} {
<li>Added support for [SAVEPOINT | nested transactions]</li>
<li>Enhanced the query optimizer so that it is able to use
    multiple indices to efficiently process 
    <a href="optoverview.html#or_opt">OR-connected constraints</a>
    in a WHERE clause.</li>







>
>
>
>
>
>







37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
      <a href="http://www.sqlite.org/cvstrac/timeline">
      http://www.sqlite.org/cvstrac/timeline</a>.</p>
    }
    hd_close_aux
    hd_enable_main 1
  }
}

chng {2009 Jan 14 (3.6.9)} {
<li>Fix two bugs, which when combined might result in incorrect
    query results.  Both bugs were harmless by themselves; only when
    they team up do they cause problems.  Ticket #3581.
}

chng {2009 Jan 12 (3.6.8)} {
<li>Added support for [SAVEPOINT | nested transactions]</li>
<li>Enhanced the query optimizer so that it is able to use
    multiple indices to efficiently process 
    <a href="optoverview.html#or_opt">OR-connected constraints</a>
    in a WHERE clause.</li>
Changes to pages/index.in.
76
77
78
79
80
81
82
83
84
85
86

87
88
89
90
91
92
93

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

<p><ul>
<li><a href="releaselog/3_6_8.html">Version 3.6.8</a>
of SQLite is recommended for all new development.  Upgrading from
versions 3.6.4 through 3.6.6.1 is strongly recommented.  Upgrading
from versions 3.6.6.2 or 3.6.7 is optional.</li>

</ul></p>

<h3>Common Links</h3>

<p><ul>
<li> <a href="features.html">Features</a> </li>
<li> <a href="faq.html">Frequently Asked Questions</a> </li>







|


|
>







76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94

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

<p><ul>
<li><a href="releaselog/3_6_9.html">Version 3.6.9</a>
of SQLite is recommended for all new development.  Upgrading from
versions 3.6.4 through 3.6.6.1 is strongly recommented.  Upgrading
from versions 3.6.6.2 or 3.6.7 is optional.  Upgrading from
version 3.6.8 is recommended.</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>
<li> <a href="features.html">Features</a> </li>
<li> <a href="faq.html">Frequently Asked Questions</a> </li>
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 "<p>$txt</p>"
  hd_puts "<hr width=\"50%\">"
}











newsitem {2009-Jan-12} {Version 3.6.8} {
  SQLite [version 3.6.8] adds support for
  [SAVEPOINT | nested transactions] and improved optimization of
  WHERE clauses with
  <a href="optoverview.html#or_opt">OR-connected terms</a>.  There is also
  a new [SQLITE_ENABLE_FTS3_PARENTHESIS | compile-time option] that changes







>
>
>
>
>
>
>
>
>
>







14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
  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 "<p>$txt</p>"
  hd_puts "<hr width=\"50%\">"
}

newsitem {2009-Jan-14} {Version 3.6.9} {
  Internal stress testing revealed a corner case where the cost function 
  on the query optimizer might mislead the query optimizer into making a 
  poor indexing choice.  That choice could then tickle another bug in 
  the VDBE which might result in an incorrect query result.  This
  release fixes both problems.  The chances of actually hitting this
  combination of problems in a real application seems remote.
  Nevertheless upgrading is recommended.
}

newsitem {2009-Jan-12} {Version 3.6.8} {
  SQLite [version 3.6.8] adds support for
  [SAVEPOINT | nested transactions] and improved optimization of
  WHERE clauses with
  <a href="optoverview.html#or_opt">OR-connected terms</a>.  There is also
  a new [SQLITE_ENABLE_FTS3_PARENTHESIS | compile-time option] that changes