Documentation Source Text

Check-in [884ea7b3ed]
Login

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

Overview
Comment:Add news for the 3.25.0 release.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 884ea7b3ed16eb30c25e49b9eceb5f2e27f63adee06b282de7c5e6d897e7fec4
User & Date: drh 2018-09-14 16:54:24.865
Context
2018-09-14
17:42
Fix minor typos detected by the spell checker. (check-in: c68e153fc6 user: drh tags: trunk)
16:54
Add news for the 3.25.0 release. (check-in: 884ea7b3ed user: drh tags: trunk)
16:34
The application_id is a signed integer. (check-in: 3580ba4b5b user: drh tags: trunk)
Changes
Unified Diff Ignore Whitespace Patch
Changes to pages/news.in.
14
15
16
17
18
19
20


























21
22
23
24
25
26
27
  hd_puts "<h3>$date - $title</h3>"
  regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
  regsub -all {[Tt]icket #(\d+)} $txt \
      {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
  hd_resolve "<blockquote>$txt</blockquote>"
  hd_puts "<hr width=\"50%\">"
}



























newsitem {2018-06-04} {Release 3.24.0} {
SQLite [version 3.24.0] is a regularly scheduled maintenance release.
Highlights of this release include support for PostgreSQL-style
UPSERT and improved performance, especially for ORDER BY LIMIT queries.
}








>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>







14
15
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
  hd_puts "<h3>$date - $title</h3>"
  regsub -all "\n( *\n)+" $text "</p>\n\n<p>" txt
  regsub -all {[Tt]icket #(\d+)} $txt \
      {<a href="http://www.sqlite.org/cvstrac/tktview?tn=\1">\0</a>} txt
  hd_resolve "<blockquote>$txt</blockquote>"
  hd_puts "<hr width=\"50%\">"
}

newsitem {2018-09-15} {Release 3.25.0} {
SQLite [version 3.25.0] is a regularly scheduled maintenance release.
Two big enhancements in this release:
<ol>
<li><p>
Support for [window functions] was added, using the PostgreSQL documentation
as the baseline.
<li><p>
The [ALTER TABLE] command was enhanced to support renaming of columns, and
so that column and table renames are propagated into trigger bodies and views.
</ol>
<p>In addition, there are various performance enhancements and minor fixes.
<p>One bug of note is 
[https://www.sqlite.org/src/info/9936b2fa443fec03ff25|ticket 9936b2fa443fec]
which describes a hard-to-reach condition where the ORDER BY LIMIT
optimization might cause an infinite loop during query evaluation.  
This ticket raised a lot of
concern on HackerNews and Reddit, probably due to my choice of the ticket
title.  "Infinite Loop" sounds scary.  But I argue that the bug isn't really
all that bad in that it is very difficult to reach, will show up during
testing (rather than magically appearing after a product is
deployed), does not cause any data loss, and does not return an
incorrect result.  It was an important error, but not nearly as dire
as many people interpreted it to be.  And, in any event, it is fixed now.
}

newsitem {2018-06-04} {Release 3.24.0} {
SQLite [version 3.24.0] is a regularly scheduled maintenance release.
Highlights of this release include support for PostgreSQL-style
UPSERT and improved performance, especially for ORDER BY LIMIT queries.
}