Documentation Source Text

Check-in [5c91ca999e]
Login

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

Overview
Comment:Updates to the change log.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 5c91ca999ec45186619d1ffb8f6df57345cf4506bba8fef470ae26ce8ca4f99c
User & Date: drh 2018-09-11 18:17:07.176
Context
2018-09-11
22:44
Fix typos in the geopoly document. (check-in: 81cf14c724 user: drh tags: trunk)
18:17
Updates to the change log. (check-in: 5c91ca999e user: drh tags: trunk)
2018-09-10
14:56
Update the change log with recent bug fixes. (check-in: eba1c4fd81 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}

chng {2018-09-00 (3.25.0)} {
<li> Add support for [window functions]
<li> Added the [Geopoly module]
<li> Enhancements the [ALTER TABLE] command:
<ol type="a">
  <li> Add support for renaming columns within a table using
       ALTER TABLE <i>table</i> RENAME COLUMN <i>oldname</i> TO <i>newname</i>.
  <li> Fix table rename feature so that it also updates references
       to the renamed table in [CREATE TRIGGER|triggers] and [views].
</ol>







<







19
20
21
22
23
24
25

26
27
28
29
30
31
32
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}

chng {2018-09-00 (3.25.0)} {
<li> Add support for [window functions]

<li> Enhancements the [ALTER TABLE] command:
<ol type="a">
  <li> Add support for renaming columns within a table using
       ALTER TABLE <i>table</i> RENAME COLUMN <i>oldname</i> TO <i>newname</i>.
  <li> Fix table rename feature so that it also updates references
       to the renamed table in [CREATE TRIGGER|triggers] and [views].
</ol>
49
50
51
52
53
54
55


56
57
58
59
60
61
62
<li> Use a separate mutex on every inode in the unix [VFS], rather than
     a single mutex shared among them all, for slightly better concurrency
     in multi-threaded environments.
<li> Enhance the [PRAGMA integrity_check] command for improved detection
     of problems on the page freelist.
<li> Output infinity as 1e999 in the ".dump" command of the
     [command-line shell].


<p><b>Bug fixes:</b>
<li> The ORDER BY LIMIT optimization might have caused an infinite loop
     in the byte code of the prepared statement under very obscure
     circumstances,
     due to a confluence of minor defects in the query optimizer.
     Fix for ticket
     [https://www.sqlite.org/src/info/9936b2fa443fec03ff25|9936b2fa443fec03ff25]







>
>







48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
<li> Use a separate mutex on every inode in the unix [VFS], rather than
     a single mutex shared among them all, for slightly better concurrency
     in multi-threaded environments.
<li> Enhance the [PRAGMA integrity_check] command for improved detection
     of problems on the page freelist.
<li> Output infinity as 1e999 in the ".dump" command of the
     [command-line shell].
<li> Added the [SQLITE_FCNTL_DATA_VERSION] file-control.
<li> Added the [Geopoly module]
<p><b>Bug fixes:</b>
<li> The ORDER BY LIMIT optimization might have caused an infinite loop
     in the byte code of the prepared statement under very obscure
     circumstances,
     due to a confluence of minor defects in the query optimizer.
     Fix for ticket
     [https://www.sqlite.org/src/info/9936b2fa443fec03ff25|9936b2fa443fec03ff25]