Documentation Source Text

Check-in [7ab25ac60e]
Login

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

Overview
Comment:Add new elements to the 3.8.3 change log.
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 7ab25ac60e96145dc706d6f8fe35c661efa990e8
User & Date: drh 2014-01-29 17:10:59
Context
2014-01-29
17:47
Update News and the change log. Bring the release date forward to 2014-02-03. Fix typos. Move older news entries out to oldnews.in. check-in: ea6e1d11de user: drh tags: trunk
17:10
Add new elements to the 3.8.3 change log. check-in: 7ab25ac60e user: drh tags: trunk
13:52
Typo fix. CAST(...TO...) should be CAST(...AS...). check-in: 64427669a7 user: drh tags: trunk
Changes
Hide Diffs Unified Diffs Show Whitespace Changes Patch

Changes to pages/changes.in.

24
25
26
27
28
29
30






31







32
33
34
35
36
37
38
<li>Added [SQLITE_DETERMINISTIC] as an optional bit in the 4th argument to the
    [sqlite3_create_function()] and related interfaces, providing applications with
    the ability to create new functions that can be factored out of inner loops when
    they have constant arguments.
<li>Add [SQLITE_READONLY_DBMOVED] error code, returned at the beginning of a
    transaction, to indicate that the underlying database file has been renamed
    or moved out from under SQLite.






<li>Performance enhancements.







}

chng {2013-12-06 (3.8.2)} {
<li>Changed the defined behavior for the [CAST expression] when floating point values
    greater than  +9223372036854775807 are cast into into integers so that the
    result is the largest possible integer, +9223372036854775807, instead of
    the smallest possible integer, -9223372036854775808.  After this change, 







>
>
>
>
>
>

>
>
>
>
>
>
>







24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
<li>Added [SQLITE_DETERMINISTIC] as an optional bit in the 4th argument to the
    [sqlite3_create_function()] and related interfaces, providing applications with
    the ability to create new functions that can be factored out of inner loops when
    they have constant arguments.
<li>Add [SQLITE_READONLY_DBMOVED] error code, returned at the beginning of a
    transaction, to indicate that the underlying database file has been renamed
    or moved out from under SQLite.
<li>Allow arbitrary expressions, including function calls and subqueries, in
    the filename argument to [ATTACH].
<li>Allow a [VALUES clause] to be used anywhere a [SELECT] statement is valid.
<li>Reseed the PRNG used by [sqlite3_randomness(N,P)] when invoked with N==0.
    Automatically reseed after a fork() on unix.
<li>Enhance the [spellfix1] virtual table so that it can search efficiently by rowid.
<li>Performance enhancements.
<li>Improvements to the comments in the VDBE byte-code display when running [EXPLAIN].
<li>Add the "%token_class" directive to LEMON parser generator and use it to simplify
    the grammar.
<li>Change the LEMON source code to avoid calling C-library functions that OpenBSD
    considers dangerous.  (Ex: sprintf).
<li>Bug fix: In the [command-line shell] CSV import feature, do not end a field
    when an escaped double-quote occurs at the end of a CRLN line.
}

chng {2013-12-06 (3.8.2)} {
<li>Changed the defined behavior for the [CAST expression] when floating point values
    greater than  +9223372036854775807 are cast into into integers so that the
    result is the largest possible integer, +9223372036854775807, instead of
    the smallest possible integer, -9223372036854775808.  After this change,