Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Last minute changes before the 3.6.22 release. |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
25998dce130a6ce813bff78605b7e4c7 |
| User & Date: | drh 2010-01-05 23:31:37 |
Context
|
2010-01-06
| ||
| 17:01 | Add the new Symbian book to the books.html page. (check-in: efbd2b8858 user: drh tags: trunk) | |
|
2010-01-05
| ||
| 23:31 | Last minute changes before the 3.6.22 release. (check-in: 25998dce13 user: drh tags: trunk) | |
|
2010-01-02
| ||
| 18:49 | Add source code for documentation search page. (check-in: 793a5fcb1b user: dan tags: trunk) | |
Changes
Changes to pages/lang.in.
2924
2925
2926
2927
2928
2929
2930
2931
2932
2933
2934
2935
2936
2937
2938
2939
....
2948
2949
2950
2951
2952
2953
2954
2955
2956
2957
2958
2959
2960
2961
2962
|
</tcl> </td></tr></table></blockquote>)^ <p>SQLite is extended to allow many keywords to be used unquoted as the names of databases, tables, indices, triggers, views, columns, user-defined functions, collations, attached databases, and virtual function modules. ^(The following subset of SQLite keywords can be used unquoted as object names:</p> <blockquote> <table width="100%"><tr> <td align="left" valign="top" width="20%"> <tcl> set nCol 5 set nRow [expr {($nRowStar+$nCol-1)/$nCol}] ................................................................................ incr i } hd_puts "$word<br>\n" } </tcl> </td></tr></table></blockquote>)^ <p>^(The next subset of keywords are those that must be quoted in order to be used as object names:</p> <blockquote> <table width="100%"><tr> <td align="left" valign="top" width="20%"> <tcl> set nCol 5 |
|
|
>
|
|
2924
2925
2926
2927
2928
2929
2930
2931
2932
2933
2934
2935
2936
2937
2938
2939
....
2948
2949
2950
2951
2952
2953
2954
2955
2956
2957
2958
2959
2960
2961
2962
2963
|
</tcl> </td></tr></table></blockquote>)^ <p>SQLite is extended to allow many keywords to be used unquoted as the names of databases, tables, indices, triggers, views, columns, user-defined functions, collations, attached databases, and virtual function modules. ^(The following subset of <tcl>hd_puts $nRowStar</tcl> SQLite keywords can be used unquoted as object names:</p> <blockquote> <table width="100%"><tr> <td align="left" valign="top" width="20%"> <tcl> set nCol 5 set nRow [expr {($nRowStar+$nCol-1)/$nCol}] ................................................................................ incr i } hd_puts "$word<br>\n" } </tcl> </td></tr></table></blockquote>)^ <p>^(The next subset of <tcl>hd_puts $nRowNoStar</tcl> keywords are those that must be quoted in order to be used as object names:</p> <blockquote> <table width="100%"><tr> <td align="left" valign="top" width="20%"> <tcl> set nCol 5 |
Changes to pages/news.in.
33 34 35 36 37 38 39 40 41 42 43 44 45 46 |
a problem where the use of the CAST operator in the WHERE clause can lead
to incorrect results if the column being cast to a new datatype is also
used in the same WHERE clause without being cast.
</ul>
Both bugs are obscure,
but because they could arise in an application after deployment, it is
recommended that all applications upgrade SQLite to version 3.6.22.
}
newsitem {2009-Dec-07} {Version 3.6.21} {
SQLite [version 3.6.21] focuses on performance optimization. For
a certain set of traces, this version uses 12% fewer CPU instructions
than the previous release (as measured by valgrind). In addition, the
[FTS3] extension has been through an extensive cleanup and rework and
|
> > > |
33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 |
a problem where the use of the CAST operator in the WHERE clause can lead to incorrect results if the column being cast to a new datatype is also used in the same WHERE clause without being cast. </ul> Both bugs are obscure, but because they could arise in an application after deployment, it is recommended that all applications upgrade SQLite to version 3.6.22. This release also includes other minor bug fixes and performance enhancements, especially in the [FTS3] extension. } newsitem {2009-Dec-07} {Version 3.6.21} { SQLite [version 3.6.21] focuses on performance optimization. For a certain set of traces, this version uses 12% fewer CPU instructions than the previous release (as measured by valgrind). In addition, the [FTS3] extension has been through an extensive cleanup and rework and |