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 |
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
25998dce130a6ce813bff78605b7e4c7 |
| User & Date: | drh 2010-01-05 23:31:37.000 |
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 | </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. | > | < | 2924 2925 2926 2927 2928 2929 2930 2931 2932 2933 2934 2935 2936 2937 2938 2939 |
</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}]
|
| ︙ | ︙ | |||
2948 2949 2950 2951 2952 2953 2954 |
incr i
}
hd_puts "$word<br>\n"
}
</tcl>
</td></tr></table></blockquote>)^
| > | | 2948 2949 2950 2951 2952 2953 2954 2955 2956 2957 2958 2959 2960 2961 2962 2963 |
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
|
| ︙ | ︙ |