Documentation Source Text

Check-in [3659d1f8cd]
Login

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

Overview
Comment:Add a change-log not about schema indexes being preferred over transient indexes.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: 3659d1f8cd2a45aba4247a26da6559a620b89c2d
User & Date: drh 2014-07-24 15:44:15.875
Context
2014-07-25
12:35
Add the book by Sribatsa Das. (check-in: 258b50a4d4 user: drh tags: trunk)
2014-07-24
15:44
Add a change-log not about schema indexes being preferred over transient indexes. (check-in: 3659d1f8cd user: drh tags: trunk)
15:36
Add a change log for version 3.8.6. Update the home page for version 3.8.6. (check-in: 0d81c00b9a user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
31
32
33
34
35
36
37


38
39
40
41
42
43
44
<li>Added the [file I/O functions|readfile(X) and writefile(X,Y)]
    extension functions to the [command-line shell]
<li>Added support for hexadecimal integer literals in the SQL parser.
    (Ex: 0x123abc)
<li>Increase the maximum value of [SQLITE_MAX_ATTACHED] from 62 to 125.
<li>Trigger automatic reprepares on all prepared statements when [ANALYZE] is
    run.


<p><b>Bug Fixes:</b>
<li>Fix the [sqlite3_stmt_busy()] interface so that it gives the correct answer
    for [ROLLBACK] statements that have been stepped but never reset.
<li>CSV output from the [command-line shell] now always uses CRNL for the
    row separator and avoids inserting CR in front of NLs contained in
    data.
<li>Fix a [column affinity] problem with the [IN operator].







>
>







31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
<li>Added the [file I/O functions|readfile(X) and writefile(X,Y)]
    extension functions to the [command-line shell]
<li>Added support for hexadecimal integer literals in the SQL parser.
    (Ex: 0x123abc)
<li>Increase the maximum value of [SQLITE_MAX_ATTACHED] from 62 to 125.
<li>Trigger automatic reprepares on all prepared statements when [ANALYZE] is
    run.
<li>Ensure that the query planner never tries to use a self-made transient
    index in place of a schema-defined index.
<p><b>Bug Fixes:</b>
<li>Fix the [sqlite3_stmt_busy()] interface so that it gives the correct answer
    for [ROLLBACK] statements that have been stepped but never reset.
<li>CSV output from the [command-line shell] now always uses CRNL for the
    row separator and avoids inserting CR in front of NLs contained in
    data.
<li>Fix a [column affinity] problem with the [IN operator].