Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Add recent bug fixes to the 3.7.17 change log. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: | 2b8ea61f517cc87e5df0cdb4aeb101dd |
| User & Date: | drh 2013-05-15 18:58:16 |
Context
|
2013-05-18
| ||
| 17:45 | Documentation updates for version 3.7.17. check-in: 67d025e82c user: drh tags: trunk | |
|
2013-05-15
| ||
| 18:58 | Add recent bug fixes to the 3.7.17 change log. check-in: 2b8ea61f51 user: drh tags: trunk | |
|
2013-05-14
| ||
| 11:14 | Fix another typo in queryplanner.in. check-in: d1d2571bce user: drh tags: trunk | |
Changes
Changes to pages/changes.in.
78
79
80
81
82
83
84
85
86
87
88
89
90
91
...
107
108
109
110
111
112
113
114
115
116
117
118
119
120
|
number of terms on the right-hand side of the MATCH operator.
<li>Added the [fts3tokenize virtual table] to the [full-text search] logic.
<li>Query planner enhancement: Use the transitive property of constraints
to move constraints into the outer loops of a join whenever possible,
thereby reducing the amount of work that needs to occur in inner loops.
<li>Discontinue the use of posix_fallocate() on unix, as it does not work on all
filesystems.
<li>Bug fix:
Only consider AS names from the result set as candidates for resolving
identifiers in the WHERE clause if there are no other matches. In the
ORDER BY clause, AS names take priority over any column names.
Ticket [http://www.sqlite.org/src/info/2500cdb9be05 | 2500cdb9be05]
<li>Bug fix:
Prevent excessive stack usage in the [full-text search] engine when processing
................................................................................
<li>Bug fix: Makes sure the [sqlite3_set_authorizer | authorizer] callback gets
a valid pointer to the string "ROWID" for the column-name parameter when
doing an [UPDATE] that changes the rowid. Ticket
[http://www.sqlite.org/src/info/0eb70d77cb05bb2272 | 0eb70d77cb05bb2272]
<li>Bug fix: Do not move WHERE clause terms inside OR expressions that are
contained within an ON clause of a LEFT JOIN. Ticket
[http://www.sqlite.org/src/info/f2369304e4 | f2369304e4]
}
chng {2013-04-12 (3.7.16.2)} {
<li>Fix a bug (present since version 3.7.13) that could result in database corruption
on windows if two or more processes try to access the same database file at the
same time and immediately after third process crashed in the middle of committing
to that same file. See ticket
|
>
>
>
>
>
>
>
>
|
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
...
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
|
number of terms on the right-hand side of the MATCH operator.
<li>Added the [fts3tokenize virtual table] to the [full-text search] logic.
<li>Query planner enhancement: Use the transitive property of constraints
to move constraints into the outer loops of a join whenever possible,
thereby reducing the amount of work that needs to occur in inner loops.
<li>Discontinue the use of posix_fallocate() on unix, as it does not work on all
filesystems.
<li>Bug fix: Fix a potential <b>database corruption bug</b>
in [shared cache mode] when one
[database connection] is closed while another is in the middle of a write
transaction.
Ticket [http://www.sqlite.org/src/info/e636a050b7 | e636a050b7]
<li>Bug fix:
Only consider AS names from the result set as candidates for resolving
identifiers in the WHERE clause if there are no other matches. In the
ORDER BY clause, AS names take priority over any column names.
Ticket [http://www.sqlite.org/src/info/2500cdb9be05 | 2500cdb9be05]
<li>Bug fix:
Prevent excessive stack usage in the [full-text search] engine when processing
................................................................................
<li>Bug fix: Makes sure the [sqlite3_set_authorizer | authorizer] callback gets
a valid pointer to the string "ROWID" for the column-name parameter when
doing an [UPDATE] that changes the rowid. Ticket
[http://www.sqlite.org/src/info/0eb70d77cb05bb2272 | 0eb70d77cb05bb2272]
<li>Bug fix: Do not move WHERE clause terms inside OR expressions that are
contained within an ON clause of a LEFT JOIN. Ticket
[http://www.sqlite.org/src/info/f2369304e4 | f2369304e4]
<li>Bug fix: Make sure an error is always reported when attempting to preform
an operation that requires a [collating sequence] that is missing.
Ticket [http://www.sqlite.org/src/info/0fc59f908b | 0fc59f908b]
}
chng {2013-04-12 (3.7.16.2)} {
<li>Fix a bug (present since version 3.7.13) that could result in database corruption
on windows if two or more processes try to access the same database file at the
same time and immediately after third process crashed in the middle of committing
to that same file. See ticket
|
Changes to pages/index.in.
93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 |
<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_7_17.html">Version 3.7.17</a> of SQLite is recommended for all new development. Upgrading from version 3.7.16.2 is optional. Upgrading from all other SQLite versions is recommended.</li> </ul></p> <h3>Common Links</h3> <p><ul> <li> <a href="features.html">Features</a> </li> |
< | |
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_7_17.html">Version 3.7.17</a>
of SQLite is recommended for all new development.
Upgrading from all previous SQLite versions
is recommended.</li>
</ul></p>
<h3>Common Links</h3>
<p><ul>
<li> <a href="features.html">Features</a> </li>
|