Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
Comment: | Create a change log entry for 3.23.0. |
---|---|
Downloads: | Tarball | ZIP archive |
Timelines: | family | ancestors | descendants | both | trunk |
Files: | files | file ages | folders |
SHA3-256: |
45bd3cdd391b50d05803acd037c8210f |
User & Date: | drh 2018-02-27 16:36:39.962 |
Context
2018-02-27
| ||
21:29 | Add documentation on althttpd. (check-in: d9cb224c9f user: drh tags: trunk) | |
16:36 | Create a change log entry for 3.23.0. (check-in: 45bd3cdd39 user: drh tags: trunk) | |
2018-02-25
| ||
19:24 | Be sure to ParseRfc822Date() has enough precision in its output. (check-in: 3fed9a6fc9 user: drh tags: trunk) | |
Changes
Changes to pages/changes.in.
︙ | ︙ | |||
16 17 18 19 20 21 22 23 24 25 26 27 28 29 | set nChng 0 proc chng {date desc {options {}}} { global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } chng {2018-01-22 (3.22.0)} { <li> The output of [sqlite3_trace_v2()] now shows each individual SQL statement run within a trigger. <li> Add the ability to read from [WAL mode] databases even if the application lacks write permission on the database and its containing directory, as long as the -shm and -wal files exist in that directory. | > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > | 16 17 18 19 20 21 22 23 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 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 | set nChng 0 proc chng {date desc {options {}}} { global nChng aChng xrefChng set aChng($nChng) [list $date $desc $options] set xrefChng($date) $nChng incr nChng } chng {2018-00-00 (3.23.0)} { <li> Recognize TRUE and FALSE as constants. (For compatibility, if there are columns named "true" or "false", then the identifiers refer to the columns rather than Boolean constants.) <li> Support operators IS TRUE, IS FALSE, IS NOT TRUE, and IS NOT FALSE. <li> Improve the omit-left-join optimization so that it works in cases where the right-hand table is UNIQUE but not necessarily NOT NULL. <li> The "alternate-form-2" flag ("!") on the [built-in printf] implemention now causes string substitutions to measure the width and precision in characters instead of bytes. <li> If the [xColumn] method in a [virtual table] implementation returns an error message using [sqlite3_result_error()] then give that error message preference over internally-generated messages. <li> Bug fixes: <ol type='a'> <li> Fix the parser to acceept valid [row value] syntax. Ticket [https://www.sqlite.org/src/info/7310e2fb3d046a5|7310e2fb3d046a5] <li> Fix the query planner so that it takes into account dependencies in the arguments to table-valued functions in subexpressions in the WHERE clause. Ticket [https://www.sqlite.org/src/info/80177f0c226ff54|80177f0c226ff54] <li> Fix incorrect result with complex OR-connected WHERE and STAT4. Ticket [https://www.sqlite.org/src/info/ec32177c99ccac2|ec32177c99ccac2] <li> Fix potential corruption in [indexes on expressions] due to automatic datatype conversions. Ticket [https://www.sqlite.org/src/info/343634942dd54ab|343634942dd54ab] <li> Assertion fault in FTS4. Ticket [https://www.sqlite.org/src/info/d6ec09eccf68cfc|d6ec09eccf68cfc] <li> Incorrect result on the less-than operator in [row values]. Ticket [https://www.sqlite.org/src/info/f484b65f3d62305|f484b65f3d62305] <li> Always interpret non-zero floating-point values as TRUE, even if the integer part is zero. Ticket [https://www.sqlite.org/src/info/36fae083b450e3a|36fae083b450e3a] </ol> <li> Additional fixes for issues detected by [https://github.com/google/oss-fuzz|OSSFuzz]: <ol type='a'> <li> Fix a possible infinite loop on VACUUM for corrupt database files. Check-in [https://www.sqlite.org/src/info/27754b74ddf64|27754b74ddf64] <li> Disallow [parameters] in the [WITH clause] of triggers and views. Check-in [https://www.sqlite.org/src/info/b918d4b4e546d|b918d4b4e546d] <li> Fix a potential memory leak in [row value] processing. Check-in [https://www.sqlite.org/src/info/2df6bbf1b8ca8|2df6bbf1b8ca8] <li> Improve the performance of the [replace() SQL function] for cases where there are many substitutions on megabyte-sized strings, in an attempt to avoid OSSFuzz timeouts during testing. Check-in [https://www.sqlite.org/src/info/fab2c2b07b5d3|fab2c2b07b5d3] </ol> <p><b>Hashes:</b> <li>SQLITE_SOURCE_ID: <i>pending</i> <li>SHA3-256 for sqlite3.c: <i>pending</i> } chng {2018-01-22 (3.22.0)} { <li> The output of [sqlite3_trace_v2()] now shows each individual SQL statement run within a trigger. <li> Add the ability to read from [WAL mode] databases even if the application lacks write permission on the database and its containing directory, as long as the -shm and -wal files exist in that directory. |
︙ | ︙ |
Changes to pages/chronology.in.
︙ | ︙ | |||
24 25 26 27 28 29 30 31 32 33 34 35 36 37 | # ORDER BY mtime DESC; # # A small amount of manual editing and de-duplication followed. # # Manually edit the list for each subsequent release. # foreach line [split { 0c55d17973|2018-01-22|Version 3.22.0 1a584e4999|2017-10-24|Version 3.21.0 8d3a7ea6c5|2017-08-24|Version 3.20.1 9501e22dfe|2017-08-01|Version 3.20.0 036ebf729e|2017-06-17|Version 3.18.2 77bb46233d|2017-06-16|Version 3.18.1 0ee482a1e0|2017-06-08|Version 3.19.3 | > | 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 | # ORDER BY mtime DESC; # # A small amount of manual editing and de-duplication followed. # # Manually edit the list for each subsequent release. # foreach line [split { xxxxxxxxxx|pending|Version 3.23.0 0c55d17973|2018-01-22|Version 3.22.0 1a584e4999|2017-10-24|Version 3.21.0 8d3a7ea6c5|2017-08-24|Version 3.20.1 9501e22dfe|2017-08-01|Version 3.20.0 036ebf729e|2017-06-17|Version 3.18.2 77bb46233d|2017-06-16|Version 3.18.1 0ee482a1e0|2017-06-08|Version 3.19.3 |
︙ | ︙ |
Changes to pages/index.in.
︙ | ︙ | |||
10 11 12 13 14 15 16 | [full-featured SQL|full-featured], [public-domain], SQL database engine. SQLite is the [most used] database engine in the world. <a class="button" href="about.html">More Info</a></p> <hr class="xhr"> <span class="hdrfont">Latest Release: </span> | | | 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 | [full-featured SQL|full-featured], [public-domain], SQL database engine. SQLite is the [most used] database engine in the world. <a class="button" href="about.html">More Info</a></p> <hr class="xhr"> <span class="hdrfont">Latest Release: </span> <a href="releaselog/3_23_0.html">Version 3.23.0</a> ([dateof:3.23.0]). <a class="button" href="download.html">Download</a> <a class="button" href="chronology.html">Prior Releases</a> <div class="mobileonly"> <hr class="xhr"> <h3>Common Links</h3> <tcl>common_links</tcl> |
︙ | ︙ |