Documentation Source Text

Check-in [e0e37413af]
Login

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

Overview
Comment:Update the change log and the home page for the R-Tree "rowid IN ..." bug.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA1: e0e37413af849a678100d56ab92cdcbfe3681ba9
User & Date: drh 2014-07-29 12:59:09.455
Context
2014-07-30
14:31
Update the change log to include the CREATE UNIQUE INDEX fix. (check-in: dfe6ec1900 user: drh tags: trunk)
2014-07-29
12:59
Update the change log and the home page for the R-Tree "rowid IN ..." bug. (check-in: e0e37413af user: drh tags: trunk)
2014-07-26
18:03
New image for the Das book. (check-in: 800e621e25 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
34
35
36
37
38
39
40





41
42
43
44
45
46
47
    (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].
    Ticket [http://www.sqlite.org/src/info/9a8b09f8e6|9a8b09f8e6].







>
>
>
>
>







34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
    (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 a bug in [R-Tree extension], introduced in the previous release,
    that can cause an
    incorrect results for queries that use the rowid of the R-Tree on the
    left-hand side of an [IN operator].
    Ticket [http://www.sqlite.org/src/info/d2889096e7bdeac6|d2889096e7bdeac6].
<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].
    Ticket [http://www.sqlite.org/src/info/9a8b09f8e6|9a8b09f8e6].
Changes to pages/index.in.
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
<td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td>
<td valign="top">
<h3>Current Status</h3>

<p><ul>
<li><a href="releaselog/3_8_6.html">Version 3.8.6</a>
of SQLite is recommended for all new development.
Upgrading from version 3.8.5 is optional.
Upgrading from all other versions of SQLite
is recommended.</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>







<







93
94
95
96
97
98
99

100
101
102
103
104
105
106
<td width="20"></td><td bgcolor="#044a64" width="1"></td><td width="20"></td>
<td valign="top">
<h3>Current Status</h3>

<p><ul>
<li><a href="releaselog/3_8_6.html">Version 3.8.6</a>
of SQLite is recommended for all new development.

Upgrading from all other versions of SQLite
is recommended.</li>
</ul></p>

<h3>Common Links</h3>

<p><ul>