Documentation Source Text

Check-in [6a6488d91d]
Login

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

Overview
Comment:Change log updates.
Downloads: Tarball | ZIP archive
Timelines: family | ancestors | descendants | both | trunk
Files: files | file ages | folders
SHA3-256: 6a6488d91db2fc29a4b487091fdad99b1e969915b5dfbcf5c4b944ff1b41ce9a
User & Date: drh 2018-07-27 23:55:25.282
Context
2018-07-27
23:56
Sublists in the change log are a-b-c instead of 1-2-3. (check-in: 3e5cf6efac user: drh tags: trunk)
23:55
Change log updates. (check-in: 6a6488d91d user: drh tags: trunk)
2018-07-23
18:32
Improved documentation for snapshots. (check-in: 62d574457f 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
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







|










>
>
>

>
>
>
>
>


>
>
>
>
>
>
>
>







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
54
55
56
57
58
59
60
61
62
  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> Query optimizer improvements:
<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.
  <li> Use the transitive property to try to propagate constant
       values within the WHERE clause.  For example, convert
       "a=99 AND b=a" into "a=99 AND b=99".
</ol>
<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> On an UPSERT when the order of constraint checks is rearranged,
     ensure that the affinity transformations on the inserted content
     occur before any of the constraint checks. Fix for ticket
     [https://www.sqlite.org/src/info/79cad5e4b2e219dd197242e9e|79cad5e4b2e219dd197242e9e].
<li> Avoid using a prepared statement for ".stats on" command of the
     [CLI] after it has been closed by the ".eqp full" logicc. Fix for ticket
     [https://www.sqlite.org/src/info/7be932dfa60a8a6b3b26bcf76|7be932dfa60a8a6b3b26bcf76].
}

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