Documentation Source Text

Check-in [5ef0fc4e97]
Login

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

Overview
Comment:New entries in the change log.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 5ef0fc4e97bc5bd561d72fc9112a2568a4addb3fb3d305637f155b6998e36080
User & Date: drh 2018-06-30 20:30:29.626
Context
2018-07-02
08:00
Add a sentence to the FTS3/4 documentation to make it clear that only columns that are part of the FTS3/4 table declaration exist, even if an external content table with more columns is in use. (check-in: ea0f0b4c4a user: dan tags: trunk)
2018-06-30
20:30
New entries in the change log. (check-in: 5ef0fc4e97 user: drh tags: trunk)
20:23
Create a change log for version 3.25.0 (check-in: 5697c09027 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
  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]














}

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







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







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
  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> Performance optimizations:
<ol>
  <li> Avoid unnecessary loads of columns in an aggregate query that
       are not within an aggregate function and that are not part
       of the GROUP BY clause.
  <li> The IN-early-out optimization: When doing a look-up on a
       multi-column index and an IN operator is used on a column
       other than the left-most column, then if no rows match against
       the first IN value, check to make sure there exist rows that
       match the columns to the right before continuing with the
       next IN value.
</ol>
<li> Output infinity as 1e999 in the ".dump" command of the
     [command-line shell].
}

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