Documentation Source Text

Check-in [9cb5891238]
Login

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

Overview
Comment:Add change-log entries for the next release (3.6.19)
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 9cb5891238f311c13d5afe50f318a0f1b2c67494
User & Date: drh 2009-09-23 15:20:32.000
Context
2009-09-25
04:35
Fix the mismatched tags problem identified by [2cda06fa85]. (check-in: 1c76780f1c user: dan tags: trunk)
2009-09-23
15:20
Add change-log entries for the next release (3.6.19) (check-in: 9cb5891238 user: drh tags: trunk)
09:19
Add a comment to foreignkeys.html to make it clear that an ON UPDATE action is only performed if the parent key values modified so that the new values are distinct from the old. (check-in: cb8c404c1e user: dan 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/src/timeline">
      http://www.sqlite.org/src/timeline</a>.</p>
    }
    hd_close_aux
    hd_enable_main 1
  }
}








chng {2009 Sep 11 (3.6.18)} {
<li>Versioning of the SQLite source code has transitioned from CVS to
    <a href="http://www.fossil-scm.org/">Fossil</a>.
<li>Query planner enhancements.
<li>The [SQLITE_ENABLE_STAT2] compile-time option causes the [ANALYZE] 
    command to collect a small histogram of each index, to help SQLite better








>
>
>
>
>
>
>








37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57

      <a href="http://www.sqlite.org/src/timeline">
      http://www.sqlite.org/src/timeline</a>.</p>
    }
    hd_close_aux
    hd_enable_main 1
  }
}

chng {2009 Oct 21 (3.6.19)} {
<li>Added support for [foreign key constraints].  Foreign key constraints
    are disabled by default.  Use the [foreign_keys pragma] to turn them on.
<li>Generalized the IS and IS NOT operators to take arbitrary expressions
    on their right-hand side.
}

chng {2009 Sep 11 (3.6.18)} {
<li>Versioning of the SQLite source code has transitioned from CVS to
    <a href="http://www.fossil-scm.org/">Fossil</a>.
<li>Query planner enhancements.
<li>The [SQLITE_ENABLE_STAT2] compile-time option causes the [ANALYZE] 
    command to collect a small histogram of each index, to help SQLite better
︙︙
Changes to pages/index.in.
︙︙
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92


</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_18.html">Version 3.6.18</a>
of SQLite is recommended for all new development.  Upgrading from
version 3.6.12, 3.6.13, 3.6.14.2, 3.6.16, or 3.6.17 is optional.
Upgrading from all other SQLite versions is recommended.</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>
<li> <a href="features.html">Features</a> </li>








|

|








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


</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_19.html">Version 3.6.19</a>
of SQLite is recommended for all new development.  Upgrading from
version 3.6.12, 3.6.13, 3.6.14.2, or 3.6.16 through 3.6.18 is optional.
Upgrading from all other SQLite versions is recommended.</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>
<li> <a href="features.html">Features</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-Sep-11} {Version 3.6.18} {
  Beginning with this release, the SQLite source code is tracked and
  managed using the <a href="http://www.fossil-scm.org/">Fossil</a>
  distributed configuration management system.  SQLite was previously
  versioned using CVS.  The entire CVS history has been imported into
  Fossil.  The older CVS repository remains on the website but is not








>
>
>
>
>








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

  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-Oct-21} {Version 3.6.19} {
  SQLite [version 3.6.19] adds native support for
  [foreign key constraints].  ...
}

newsitem {2009-Sep-11} {Version 3.6.18} {
  Beginning with this release, the SQLite source code is tracked and
  managed using the <a href="http://www.fossil-scm.org/">Fossil</a>
  distributed configuration management system.  SQLite was previously
  versioned using CVS.  The entire CVS history has been imported into
  Fossil.  The older CVS repository remains on the website but is not
︙︙