Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
Overview
| Comment: | Version 3.25.0 |
|---|---|
| Downloads: | Tarball | ZIP archive | SQL archive |
| Timelines: | family | ancestors | descendants | both | trunk | release | version-3.25.0 |
| Files: | files | file ages | folders |
| SHA3-256: |
9089e073c48e5d79d643688a5345ebfc |
| User & Date: | drh 2018-09-15 04:26:02 |
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
Changes to pages/changes.in.
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
..
70
71
72
73
74
75
76
77
78
79
80
81
82
83
|
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].
................................................................................
[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
|
|
>
>
>
|
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
..
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
|
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].
................................................................................
[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
|