Documentation Source Text

Check-in [9089e073c4]
Login

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

Overview
Comment:Version 3.25.0
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk | release | version-3.25.0
Files: files | file ages | folders
SHA3-256: 9089e073c48e5d79d643688a5345ebfc57207e6de1776cddb55a08f94834a896
User & Date: drh 2018-09-15 04:26:02.661
Context
2018-09-17
12:48
Fix typo. (check-in: be9d86ac89 user: mistachkin tags: trunk)
2018-09-15
04:26
Version 3.25.0 (check-in: 9089e073c4 user: drh tags: trunk, release, version-3.25.0)
2018-09-14
17:42
Fix minor typos detected by the spell checker. (check-in: c68e153fc6 user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/changes.in.
︙︙
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

proc chng {date desc {options {}}} {
  global nChng aChng xrefChng
  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].








|








17
18
19
20
21
22
23
24
25
26
27
28
29
30
31

proc chng {date desc {options {}}} {
  global nChng aChng xrefChng
  set aChng($nChng) [list $date $desc $options]
  set xrefChng($date) $nChng
  incr nChng
}

chng {2018-09-15 (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].
︙︙
70
71
72
73
74
75
76



77
78
79
80
81
82
83

     [https://www.sqlite.org/src/info/7be932dfa60a8a6b3b26bcf76|7be932dfa60a8a6b3b26bcf76].
<li> The LIKE optimization was generating incorrect byte-code and hence
     getting the wrong answer
     if the left-hand operand has numeric affinity and the right-hand-side
     pattern is '/%' or if the pattern begins with the ESCAPE character.
     Fix for ticket
     [https://www.sqlite.org/src/info/c94369cae9b561b1f996d0054b|c94369cae9b561b1f996d0054b]



}

chng {2018-06-04 (3.24.0)} {
<li> Add support for PostgreSQL-style [UPSERT].
<li> Add support for [auxiliary columns in r-tree tables].
<li> Add C-language APIs for discovering SQL keywords used by
     SQLite: [sqlite3_keyword_count()], [sqlite3_keyword_name()], and








>
>
>








70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86

     [https://www.sqlite.org/src/info/7be932dfa60a8a6b3b26bcf76|7be932dfa60a8a6b3b26bcf76].
<li> The LIKE optimization was generating incorrect byte-code and hence
     getting the wrong answer
     if the left-hand operand has numeric affinity and the right-hand-side
     pattern is '/%' or if the pattern begins with the ESCAPE character.
     Fix for ticket
     [https://www.sqlite.org/src/info/c94369cae9b561b1f996d0054b|c94369cae9b561b1f996d0054b]
<p><b>Hashes:</b>
<li>SQLITE_SOURCE_ID: "2018-09-15 04:01:47 b63af6c3bd33152742648d5d2e8dc5d5fcbcdd27df409272b6aea00a6f761760"
<li>SHA3-256 for sqlite3.c: 989e3ff37f2b5eea8e42205f808ccf0ba86c6ea6aa928ad2c011f33a108ac45d
}

chng {2018-06-04 (3.24.0)} {
<li> Add support for PostgreSQL-style [UPSERT].
<li> Add support for [auxiliary columns in r-tree tables].
<li> Add C-language APIs for discovering SQL keywords used by
     SQLite: [sqlite3_keyword_count()], [sqlite3_keyword_name()], and
︙︙
Changes to pages/chronology.in.
︙︙
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.25.0
c7ee083322|2018-06-04|Version 3.24.0
4bb2294022|2018-04-10|Version 3.23.1
736b53f57f|2018-04-02|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








|








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 {
b63af6c3bd|2018-09-15|Version 3.25.0
c7ee083322|2018-06-04|Version 3.24.0
4bb2294022|2018-04-10|Version 3.23.1
736b53f57f|2018-04-02|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
︙︙