Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | The change log addition of the previous check-in went into the wrong release. This check-in fixes the problem. |
|---|---|
| Timelines: | family | ancestors | descendants | both | trunk |
| Files: | files | file ages | folders |
| SHA1: |
71622aac82be573d2e7e604a2ab0800e |
| User & Date: | drh 2017-03-17 23:06:06 |
Context
|
2017-03-20
| ||
| 12:10 | Refinements to the change log for 3.18.0. check-in: 967d54a0f6 user: drh tags: trunk | |
|
2017-03-17
| ||
| 23:06 | The change log addition of the previous check-in went into the wrong release. This check-in fixes the problem. check-in: 71622aac82 user: drh tags: trunk | |
| 23:00 | Add enforcement of SQLITE_LIMIT_VDBE_OP to the change log. check-in: 6e5fa8b967 user: drh tags: trunk | |
Changes
Changes to pages/changes.in.
35
36
37
38
39
40
41
42
43
44
45
46
47
48
..
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
halt without doing unnecessary work.
<li>Enhance the [sqlite3_mprintf()] family of interfaces and the [printf SQL function]
to put comma separators at the thousands marks for integers, if the "," format modifier
is used in between the "%" and the "d" (example: "%,d").
<li>Added the -D[SQLITE_MAX_MEMORY]=<i>N</i> compile-time option.
<li>Added the [.sha3sum dot-command] and the [.selftest dot-command]
to the [command-line shell]
<li>Various performance improvements.
<p><b>Bug Fixes:</b>
<li>Ensure that indexed expressions with collating sequences are handled correctly.
Fix for ticket [https://www.sqlite.org/src/info/eb703ba7b50c1a5|eb703ba7b50c1a5].
<li>Fix a bug in the 'start of ...' modifiers for the [date and time functions].
Ticket [https://www.sqlite.org/src/info/6097cb92745327a1|6097cb92745327a1]
<li>In the [RBU extension], add extra sync operations to avoid the possibility of
................................................................................
<li>Enhance the [SQLITE_DIRECT_OVERFLOW_READ] option so that it works
in [WAL mode] as long as the pages being read are not in the WAL file.
<li>Enhance the
[https://www.sqlite.org/src/doc/trunk/doc/lemon.html|LEMON parser generator]
so that it can store the parser object as a stack variable rather than
allocating space from the heap and make use of that enhancement in
the [amalgamation].
<li>Begin enforcing [SQLITE_LIMIT_VDBE_OP]. The documentation has always
warned that this limit might be enforced in the future. That day has
now come.
<li>Other performance improvements. Uses about [CPU cycles used|6.5% fewer CPU cycles].
<p><b>Bug Fixes:</b>
<li>Throw an error if the ON clause of a LEFT JOIN references tables
to the right of the ON clause. This is the same behavior as
PostgreSQL. Formerly, SQLite silently converted the LEFT JOIN
into an INNER JOIN. Fix for ticket
[https://www.sqlite.org/src/info/25e335f802dd|25e335f802dd].
|
>
>
>
<
<
<
|
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
..
95
96
97
98
99
100
101
102
103
104
105
106
107
108
|
halt without doing unnecessary work.
<li>Enhance the [sqlite3_mprintf()] family of interfaces and the [printf SQL function]
to put comma separators at the thousands marks for integers, if the "," format modifier
is used in between the "%" and the "d" (example: "%,d").
<li>Added the -D[SQLITE_MAX_MEMORY]=<i>N</i> compile-time option.
<li>Added the [.sha3sum dot-command] and the [.selftest dot-command]
to the [command-line shell]
<li>Begin enforcing [SQLITE_LIMIT_VDBE_OP]. The documentation has always
warned that this limit might be enforced in the future. That day has
now come.
<li>Various performance improvements.
<p><b>Bug Fixes:</b>
<li>Ensure that indexed expressions with collating sequences are handled correctly.
Fix for ticket [https://www.sqlite.org/src/info/eb703ba7b50c1a5|eb703ba7b50c1a5].
<li>Fix a bug in the 'start of ...' modifiers for the [date and time functions].
Ticket [https://www.sqlite.org/src/info/6097cb92745327a1|6097cb92745327a1]
<li>In the [RBU extension], add extra sync operations to avoid the possibility of
................................................................................
<li>Enhance the [SQLITE_DIRECT_OVERFLOW_READ] option so that it works
in [WAL mode] as long as the pages being read are not in the WAL file.
<li>Enhance the
[https://www.sqlite.org/src/doc/trunk/doc/lemon.html|LEMON parser generator]
so that it can store the parser object as a stack variable rather than
allocating space from the heap and make use of that enhancement in
the [amalgamation].
<li>Other performance improvements. Uses about [CPU cycles used|6.5% fewer CPU cycles].
<p><b>Bug Fixes:</b>
<li>Throw an error if the ON clause of a LEFT JOIN references tables
to the right of the ON clause. This is the same behavior as
PostgreSQL. Formerly, SQLite silently converted the LEFT JOIN
into an INNER JOIN. Fix for ticket
[https://www.sqlite.org/src/info/25e335f802dd|25e335f802dd].
|