Documentation Source Text

Timeline
Login

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

200 most recent check-ins using file pages/affcase1.in version cbee5540a9

2023-10-24
11:39
Adjust the download page generator so that it can accept snapshot builds of the windows utility problems. (Leaf check-in: eeb54d184d user: drh tags: branch-3.43)
2023-10-17
22:48
In UPDATE with limit syntax diagram, get returning-clause independent of WHERE. See forum post d8f57775be. (check-in: 855a4e88ef user: drh tags: branch-3.43)
2023-10-14
13:41
Added a link to external references to fasterthanfs.html. (check-in: 09b9021e39 user: drh tags: branch-3.43)
2023-10-10
12:21
Version 3.43.2 (check-in: 7d684fc635 user: drh tags: release, branch-3.43, version-3.43.2)
12:10
Preparing for the 3.43.2 patch release. (check-in: 6641d4f5d5 user: drh tags: branch-3.43)
12:10
Amplify the intent of SQLITE_ENABLE_API_ARMOR. (check-in: 7e4ac9271f user: drh tags: branch-3.43)
2023-10-05
18:20
Increase the prices of SDS to 2500/year. (check-in: 535f4fef0d user: drh tags: branch-3.43)
2023-10-02
19:08
Use "primitive" rather than "singleton" as that is what RFC8259 uses. (check-in: 08df2095bc user: drh tags: jsonb)
18:57
Fix the spelling of PostgreSQL. (check-in: 943ec0eecd user: drh tags: jsonb)
18:51
Initial cut attempt at JSONB documentation. (check-in: 686b8716f9 user: drh tags: jsonb)
2023-09-16
13:28
Merge typo fix in the CLI document from branch-3.43. (check-in: d8e78b65da user: drh tags: trunk)
13:27
Fix typo in the CLI document. (check-in: 801f1184f2 user: drh tags: branch-3.43)
2023-09-14
14:42
Merge branch-3.43 fixes into trunk. (check-in: 241501a523 user: drh tags: trunk)
14:41
Fix typos in the result code documentation. Problem reported by https://sqlite.org/forum/forumpost/173ebd7dc1. (check-in: 6cea079c40 user: drh tags: branch-3.43)
2023-09-12
13:40
Fix rendering of embedded SVG. See forum post https://sqlite.org/forum/forumpost/9834724f0f4d4a (check-in: 762ef93f09 user: drh tags: branch-3.43)
13:38
Fix rendering of embedded SVG. See forum post https://sqlite.org/forum/forumpost/9834724f0f4d4a (check-in: d045fbf93a user: drh tags: trunk)
2023-09-11
17:57
Fix a harmless typo in the 3.42.0 change log. (check-in: dc2a11f63b user: drh tags: branch-3.43)
16:51
Avoid duplicating entries returned by changelog searches in all minor versions. (check-in: b5d3147243 user: dan tags: trunk)
15:43
Fix the timeline hyperlink for the snapshot tarball on the download page. (check-in: 0e083481a3 user: drh tags: branch-3.43)
15:38
Merge 3.43.1 changes. Update the change log. (check-in: 1bfa4ba9f4 user: drh tags: trunk)
12:11
Version 3.43.1 (check-in: c4cf636236 user: drh tags: branch-3.43, version-3.43.1)
2023-09-08
14:56
Update change log and news in preparations for a patch release. (check-in: 72388c464e user: drh tags: branch-3.43)
12:42
Fix grammo reported in forum. (check-in: b827623d78 user: drh tags: branch-3.43)
2023-09-07
20:42
Fix grammo reported in forum. (check-in: bb23eb2b79 user: larrybr tags: trunk)
2023-09-05
14:39
Improvements to the descriptions of threading modes, in an attempt to avoid confusion. (check-in: c93628caf3 user: drh tags: branch-3.43)
2023-08-29
19:12
Document the new conversion letters for strftime(). (check-in: ffcfef0089 user: drh tags: trunk)
15:38
Start the 3.44.0 development cycle. Add documentation for CONCAT() and CONCAT_WS(). (check-in: 87a39b4d6d user: drh tags: trunk)
2023-08-28
15:17
Document the fact that SUM() and related functions may return NULL if the input sequence contains both positive and negative infinities. (check-in: ae9b1ad384 user: drh tags: trunk)
13:50
Fix fts5 docs to correctly say that the structure record has id=10 and the averages record id=1. (check-in: 99a9efae59 user: dan tags: trunk)
2023-08-24
12:42
Version 3.43.0 (check-in: 93a4599cf8 user: drh tags: trunk, release, version-3.43.0)
2023-08-23
21:38
News article for 3.43.0 added. Release dates updated to tomorrow. (check-in: 32ea92a241 user: drh tags: trunk)
14:08
Minor tweaks to the change log for 3.43.0. (check-in: a7a2b39e99 user: drh tags: trunk)
2023-08-22
14:52
Update the speed-size spreadsheet with data for 3.43.0. (check-in: 35c6c21dba user: drh tags: trunk)
2023-08-21
10:27
Add new CVEs that mention SQLite but that are not about SQLite to the cves.html document. (check-in: dd7672ca1e user: drh tags: trunk)
2023-08-18
15:40
Rename the decimal_sci() function to decimal_exp(). (check-in: 6821cc7bdf user: drh tags: trunk)
2023-08-14
13:36
Remove the ".binary" dot-command from the CLI documentation. (check-in: 376df9af0f user: drh tags: trunk)
12:22
Change the target release date for 3.43.0 to 2023-08-29. (check-in: b3d03ceba2 user: drh tags: trunk)
11:30
Added a note about SQLITE_USE_SEH to the change log. (check-in: 05829e9376 user: drh tags: trunk)
10:57
Merge branch-3.42 changes into trunk. (check-in: cbf4d1a766 user: drh tags: trunk)
10:54
Fix indentation of the menu on the docs page. Forum post b44b6e3547. (Leaf check-in: 5836f51eb9 user: drh tags: branch-3.42)
09:50
Remove the sh_mark styling from docs.in, as it has almost zero visible effect except for certain browsers where it's causing the whole /docs.html page to render incorrectly (reported in [fourm:b44b6e3547]). (check-in: cc3929fa24 user: stephan tags: trunk)
2023-08-11
20:15
Be explicit that json_valid() returns NULL on a NULL input. (check-in: 83c1de26ae user: drh tags: trunk)
2023-08-08
16:52
Update documentation of fts5 contentless-delete tables. (check-in: 1444addab4 user: dan tags: trunk)
02:07
Replace some http:// with https://. (check-in: 74762ee361 user: stephan tags: trunk)
2023-08-07
09:44
Rename pContext to pUserData in the fts5 docs, to match the same change in [src:2ca064d8eb37252e16b]. (check-in: fc20f99c7f user: stephan tags: trunk)
2023-08-05
19:13
Tiny typo fixes from [forum:31eb707250|forum post 31eb707250] and adjacent end-of-line white cleanups. (check-in: 3a4f309162 user: stephan tags: trunk)
2023-08-03
14:10
Add documentation for the verify-source makefile target. (check-in: 504eefdace user: drh tags: trunk)
2023-08-02
12:55
Clarification of the behavior of the MATERIALIZED hints on common table expressions. (check-in: 6de000dfa3 user: drh tags: trunk)
2023-08-01
17:34
New examples of using the -> and ->> operators. (check-in: abce4ae7d0 user: drh tags: trunk)
14:01
Next release will occur from trunk. (check-in: 2be349a191 user: drh tags: branch-3.42)
13:58
Enhancements to the date/time documentation and expecially regarding the new timediff() function. (check-in: de7ff77b42 user: drh tags: trunk)
2023-07-30
10:50
Merge 3.42.0 changes into trunk. (check-in: 69df2ed48f user: drh tags: trunk)
10:48
Updates to the change log for 3.43.0 (check-in: 80512efd52 user: drh tags: trunk)
2023-07-27
20:27
Add documentation for ".scanstats vm" to profile.html. (check-in: 2958c3e869 user: dan tags: trunk)
18:01
Add documentation for the fts5 contentless_delete=1 and 'deletemerge' options. (check-in: 73ab6b2b65 user: dan tags: trunk)
2023-07-26
17:26
Fix another typo in fts5.html. (check-in: f39548c42e user: dan tags: trunk)
11:14
Fix problems in fts5 documentation. (check-in: 025d350331 user: dan tags: trunk)
2023-07-19
19:13
Lower the performance estimate for JSON parsing to a more conservative 250 MB/s, which is a number we can easily meet. I'm not sure where the 1 GB/s figure came from. (check-in: 561c0607e9 user: drh tags: branch-3.42)
2023-07-10
11:52
Attempt to improve the wording of the Contentless Table documentation for FTS5. (check-in: e5af001918 user: drh tags: trunk)
2023-07-04
20:07
Simplify the footprint.html page. (check-in: 367bad9f22 user: drh tags: branch-3.42)
2023-06-29
23:49
Talk about decimal_sum() in the sum() documentation and provide a hyperlink over to the floating-point documentation. (check-in: 5e348e167c user: drh tags: trunk)
23:23
Notate the decimal extension enhancements in the change log. (check-in: a4459d5a47 user: drh tags: trunk)
23:18
Update the decimal extension and printf() documentation to reflect the latest changes and comments. (check-in: 080037ba17 user: drh tags: trunk)
2023-06-23
13:30
Merge version 3.42 updates into trunk. (check-in: 2cbb7ed123 user: drh tags: trunk)
13:20
Remove the statement about PGO from the footprint.html document. (check-in: 43c1154ec6 user: drh tags: branch-3.42)
11:37
Documentation for octet_length(). (check-in: d61235143a user: drh tags: trunk)
11:26
Updates to the speed-size chart. (check-in: 63aa5788cf user: drh tags: trunk)
2023-06-19
20:32
Add a license for SDS-SEE.exml to the prosupport options. (check-in: 5815443a19 user: drh tags: branch-3.42)
17:16
Minor enhancement to the date/time examples. (check-in: 9ed168eaff user: drh tags: trunk)
17:09
Initial draft of support page for System.Data.SQLite. (Leaf check-in: 8d1d330648 user: mistachkin tags: sds)
2023-06-16
10:11
Remove a stray parenthesis, reported in the forum. (check-in: c271a46440 user: stephan tags: trunk)
2023-06-13
18:56
Improve explanation of SQLITE_ENABLE_FTS3 as noted in forum post b10cd8312f. (check-in: 97210f4fce user: larrybr tags: trunk)
13:23
Point the bare column documentation to the recent forum discussion. (check-in: d3a21bf2aa user: drh tags: trunk)
2023-06-10
17:29
Documentation for SQLITE_DBCONFIG_STRICT_AGGREGATE. (Closed-Leaf check-in: 1d597840ae user: drh tags: newbie-safe-aggregates)
2023-06-07
13:17
Fix problem with example of inserting a symbolic link in zipfile.in. (check-in: 9546f48b09 user: drh tags: branch-3.42)
11:24
Fix problem with example of inserting a symbolic link in zipfile.in. (check-in: 68bb2c8a3e user: dan tags: trunk)
2023-06-01
20:46
Document the enhancement to the OUTER JOIN strength reduction optimization. (check-in: 1486a61269 user: drh tags: trunk)
18:28
Generalize the documentation on the LEFT JOIN strength reduction and omit-LEFT-JOIN optimizations to talk about RIGHT and FULL JOINs as well. The implementation of those optimizations still only works for LEFT JOIN, so in some sense the documentation is getting ahead of the implementation. (check-in: 4635dbba87 user: drh tags: trunk)
2023-05-30
16:54
Update the version number and start the 3.43.0 change log. (check-in: 307b763072 user: drh tags: trunk)
16:43
Documentation on the timediff() enhancement. (check-in: 09231d045c user: drh tags: trunk)
12:46
Preliminary documentation for the new timediff() function. (Closed-Leaf check-in: 71097e7496 user: drh tags: timediff)
2023-05-29
17:38
Add examples to fts5.html. (check-in: e043cdf1a1 user: dan tags: trunk)
2023-05-27
15:39
Fix a typo in the "search.d/admin" script. (check-in: a5fe4561cf user: drh tags: trunk)
2023-05-24
20:57
Fix typo in the file format document. forum post 93cc6c6e46. (check-in: f410802c23 user: drh tags: trunk)
2023-05-20
19:19
Fix a typo in the flextypegood.html documentation page. (check-in: 4ddba86c59 user: drh tags: trunk)
2023-05-16
15:07
Fix the generation of the toc.db file. Bug report against 3.42.0 reported by Roger Binns. (check-in: f77cf5a868 user: drh tags: trunk)
12:42
Version 3.42.0 (check-in: 24990dc445 user: drh tags: trunk, release, version-3.42.0)
10:48
Add News for the 3.42.0 release. (check-in: c0a70a8fb8 user: drh tags: trunk)
2023-05-12
17:36
Typos fixed and phrasing improved for the new JSON documentation. (check-in: 6d15d8641c user: drh tags: trunk)
2023-05-10
20:21
Update the stats in testing.html. (check-in: eba6dace26 user: drh tags: trunk)
15:55
Updates to the speed-size chart. (check-in: a985d90904 user: drh tags: trunk)
2023-05-08
20:17
Fix a typo in JSON documentation. (check-in: 43d43a2b97 user: drh tags: trunk)
18:47
Further clarifications of the change log for 3.42.0. (check-in: 9a10f6034e user: drh tags: trunk)
17:45
Additional clarification to the JSON5 enhancement documentation. (check-in: 6908866970 user: drh tags: trunk)
17:29
Mention the new omit-unused-subquery-columns optimization in the change log. (check-in: 4865999966 user: drh tags: trunk)
2023-05-05
20:23
Update the 3.42.0 change log to observe that the maximum JSON recursion depth has been reduced to 1000. (check-in: af7c12a5a0 user: drh tags: trunk)
15:49
Reduce the JSON maximum nesting depth to 1000. (check-in: 9a65bdf937 user: drh tags: trunk)
2023-05-04
20:20
Add documentation about the subsecond modifier to date/time functions in anticipation of merging that enhancement to trunk. (check-in: 16861f41cb user: drh tags: trunk)
17:35
Add the enhanced comma-option to the change log for 3.42.0. (check-in: 0109e019c4 user: drh tags: trunk)
2023-05-03
18:38
Minor enhancements to the JSON documentation. (check-in: 9fe07cb0bd user: drh tags: trunk)
2023-05-02
17:03
Add sqlite3_sleep() change to the change log. Fix typo in JSON docs. (check-in: e6a4cea8fe user: drh tags: trunk)
2023-05-01
23:11
Describe CLI --utf8 option in CLI doc page. (check-in: 5f7354370f user: larrybr tags: trunk)
22:47
In 3.42 changes, describe CLI --utf8 option accurately. (check-in: dc615631a6 user: larrybr tags: trunk)
21:49
Minor improvements to generate_series() vtab descriptions. (check-in: fbb30c2f25 user: larrybr tags: trunk)
18:27
More documentation tweaks in preparation for the 3.42.0. (check-in: 844b3af7fe user: drh tags: trunk)
17:59
Mention the session changes in the change log. (check-in: efa12463e2 user: drh tags: trunk)
17:02
Documentation of the JSON5 enhancement. (check-in: f77ffdbd60 user: drh tags: trunk)
15:58
Tweaks to the new change log. (check-in: 6cffa7f94f user: drh tags: trunk)
15:23
Initial attempt to add a change log for version 3.42.0 (check-in: 16a9216a09 user: drh tags: trunk)
2023-04-29
00:28
Cure a grammo in flextypegood noted in forum, plus a few more. (check-in: b487338450 user: larrybr tags: trunk)
2023-04-28
22:12
Revise generate_series() extension description to better reflect its behavior with negative step arguments (conforming to like-named PostgreSQL function.) (Closed-Leaf check-in: ab33979fd6 user: larrybr tags: generate_series)
2023-04-22
19:56
Document new CLI option, --unsafe-testing. (check-in: 5b301306f3 user: larrybr tags: trunk)
17:39
Clarify CLI response to .open with no db name. (check-in: c1f67a550d user: larrybr tags: trunk)
2023-04-19
10:53
Update fts5.in so that the trigram tokenizer is no longer described as "experimental". (check-in: 747cdcee0f user: dan tags: trunk)
01:14
Fix typo in "testing" noted in forum post a5dbe3a2bf. (check-in: 9437bdba44 user: larrybr tags: trunk)
2023-04-16
12:53
Fix typo in Quirks noted in forum post 6567786475. (check-in: c69640a74c user: larrybr tags: trunk)
2023-04-15
17:48
Add documentation for the 'secure-delete' option to fts5.in. (check-in: 5ceb265f3a user: dan tags: trunk)
15:42
Add documentation for 'secure-delete' to fts5.html. (Closed-Leaf check-in: 887ff60b31 user: dan tags: fts5-secure-delete)
2023-04-06
20:35
Add FAQ relating to puzzlements aided by DB auto-creation. (check-in: 58e66a9c19 user: larrybr tags: trunk)
2023-04-04
23:20
Express that last JSON fact absent perplexing repetition. (check-in: 92d830ab0e user: larrybr tags: trunk)
23:16
Mention absence of special treatment for Unicode escape sequences in JSON functions. (check-in: a572bb5a9f user: larrybr tags: trunk)
2023-03-31
19:57
Get interdependent pages/.in files to be separately processable (for make faster.) (Leaf check-in: 7d59751a5e user: larrybr tags: inout-of-tree)
2023-03-30
18:34
Say how unixepoch() deals with fractional seconds on input. (check-in: 30020367e9 user: larrybr tags: trunk)
2023-03-25
03:02
Clarify TCL eval subcommand option (non)plurality. (check-in: e34618cd04 user: larrybr tags: trunk)
2023-03-22
16:56
Document the new effect of the zero-padding option on floating point conversions of infinity and NaN. (check-in: 2325489f23 user: drh tags: trunk)
16:32
Update the documentation on the double-quoted string literal misfeature to mention that it is disabled by default beginning with version 3.41.0. (check-in: b11a9fe8cd user: drh tags: trunk)
15:10
Fix typos in the change log for 3.41.2 (check-in: b4cdb23bd8 user: drh tags: trunk)
12:00
Version 3.41.2 (check-in: 3ab894cf74 user: drh tags: trunk, release, version-3.41.2)
2023-03-20
10:33
Fix a mistake in the CAST documentation Forum post 52f446c028. (check-in: 0ad734f7eb user: drh tags: trunk)
2023-03-17
22:28
Clarify the argument needed for VACUUM INTO [filename]. (check-in: 36d7287b27 user: larrybr tags: trunk)
2023-03-14
14:31
Minor typo fix reported in forum post 13d539fe49 and clean up nearby EOL whitespace. (check-in: 5cce9b4a8a user: stephan tags: trunk)
2023-03-12
14:42
Remove mention of the obsolete SQLITE_ENABLE_JSON1 from the amalgamation build instructions. Remove nearby EOL whitespace. (check-in: 077be9663c user: stephan tags: trunk)
2023-03-10
12:19
Version 3.41.1 (check-in: 719bc8f8db user: drh tags: trunk, version-3.41.1)
11:42
Proposed changes for version 3.41.1. (check-in: bbe6fb07d9 user: drh tags: trunk)
2023-03-06
12:28
Address feedback from [forum:a228b4522b|forum post a228b4522b] and remove references to HAVE_USLEEP, per /chat. (check-in: b3f48779ee user: stephan tags: trunk)
2023-03-03
01:19
Complete (nearly) transition to explicit doc build output DEST dir. (check-in: c464faf208 user: larrybr tags: inout-of-tree)
2023-03-01
16:27
Fix the makefile so that it works again for out-of-tree builds. (check-in: 328608ba45 user: drh tags: trunk)
14:07
Fix typos in fts5.in. (check-in: 1d3b0b821c user: dan tags: trunk)
2023-02-28
11:22
Update recovery.html to mention that -DSQLITE_ENABLE_DBPAGE_VTAB is required. (check-in: 42c1edc161 user: dan tags: trunk)
2023-02-27
15:51
Revise build so that in-tree and out-of-tree make targets yield the same results, including side-effects. (check-in: e8d7950cd5 user: larrybr tags: trunk)
03:04
Make spell target work out-of-tree too. (Closed-Leaf check-in: 6bc167df1c user: larrybr tags: inout_of_tree)
02:07
Sync w/trunk (better spelling) (check-in: 75de411cc9 user: larrybr tags: inout_of_tree)
00:41
Spelling and spell-check improvements. (linecount /= 56) (check-in: 2f4ea6952b user: larrybr tags: trunk)
2023-02-24
16:53
Spelling fix for How to Compile (from forum) (check-in: 173dac530a user: larrybr tags: inout_of_tree)
16:52
Spelling fix for How to Compile (from forum) (check-in: 156e745d63 user: larrybr tags: trunk)
16:14
For evidence build, fail more gracefully for bad make arguments. (check-in: 69abfac43c user: larrybr tags: inout_of_tree)
15:49
Fix remaining relative filename stragglers. Zap adunit.txt injection. (check-in: d331039243 user: larrybr tags: inout_of_tree)
13:11
Fix a few relative filename stragglers. (check-in: 2d22dc4b94 user: larrybr tags: inout_of_tree)
03:00
WIP: Make doc builds work in-tree and out-of-tree. (check-in: 89771190f9 user: larrybr tags: inout_of_tree)
2023-02-23
15:37
Fix a grammo in DQS description. (check-in: 084d0b5c7b user: larrybr tags: trunk)
2023-02-22
21:47
Alleviate a distracting awkwardness in explication. (check-in: 4e18c20631 user: larrybr tags: trunk)
21:17
Get toc.db to tag along with full doc/*.html build. (check-in: be8b4e3939 user: larrybr tags: trunk)
2023-02-21
18:14
Version 3.41.0 (check-in: 6261fc49cc user: drh tags: trunk, release, version-3.41.0)
13:24
Update the speed-and-size spreadsheet. (check-in: eadd0bc3b2 user: drh tags: trunk)
12:52
Updates to the change log. (check-in: 538b6cb442 user: drh tags: trunk)
2023-02-20
00:00
Merge branch-3.40 changes into trunk. (check-in: 691c346bb0 user: drh tags: trunk)
2023-02-19
23:57
Updates to the text describing when RTree and Geopoly are available in amalgamation builds. (Leaf check-in: 58bfae254b user: drh tags: branch-3.40)
2023-02-17
15:36
Mention the CLI's new base64() and base85() SQL functions. (check-in: 768fdc131d user: larrybr tags: trunk)
13:24
Additional information about "struct iovec", as suggested by SQLite forum post 0bf2455d62a98da6. (check-in: bf6c5890c7 user: drh tags: trunk)
2023-02-16
21:36
Add a note to the secure_delete documentation to point out that forensic traces might be left behind in shadow tables of FTS3 and FTS5. (check-in: fc347f72ff user: drh tags: trunk)
21:08
Merge the latest version-3.40 updates into trunk. (check-in: 9ba00b285b user: drh tags: trunk)
21:06
Fix typo on the flextypegood.html page. (check-in: e562135c76 user: drh tags: branch-3.40)
18:10
Minor typo fix to flextypegood.in reported in the forum. (check-in: 647ebe8f73 user: stephan tags: trunk)
2023-02-15
20:50
Minor json_quote() typo fix reported in the forum. (check-in: 7962d5cbe2 user: stephan tags: trunk)
2023-02-14
21:05
Fix a typo in the new RETURNING documentation. (check-in: ccd08fd65d user: drh tags: trunk)
21:01
Add a clarification to the RETURNING documentation in response to forum post 935a08cbdc. (check-in: 2816414c3f user: drh tags: trunk)
00:22
Document the behavior change associated with excess parentheses around a subquery on the RHS of an IN operator. (check-in: e377133228 user: drh tags: trunk)
2023-02-11
21:06
Add mention of the "releasetest" and "devtest" makefile targets to the change log. (check-in: e7b6d071db user: drh tags: trunk)
20:57
Updates to the change log. Minor tweaks to other docs to which the change log refers. (check-in: e75646d8c9 user: drh tags: trunk)
2023-02-08
20:33
Back out the documentation changes associated with the 'txn' enhancement to the date/time functions, as that enhancement has been backed out of the core. (check-in: 97a9fca664 user: drh tags: trunk)
17:25
Update the change log and news in preparation for pencils-down on 3.41.0. (check-in: 77a236dd14 user: drh tags: trunk)
17:13
For matrix target, tell make of its full-build dependency. (check-in: 110b886945 user: larrybr tags: trunk)
12:39
Update documentation of date/time functions to talk about the new 'txn' format. (check-in: bddfe9ebb1 user: drh tags: trunk)
12:38
Prevent division-by-zero errors in the matrix computation. The matrix is currently broken, but at least now it builds. (check-in: 484bfc747f user: drh tags: trunk)
2023-01-31
06:09
Correct a trailing comma in a CREATE TABLE demonstration, reported in [forum:3d4940f6d549da66|forum post 3d4940f6d549da66]. (check-in: 87eafc5662 user: stephan tags: trunk)
2023-01-27
14:08
New items added to the change log. Carray documentation updated. (check-in: d98546fd71 user: drh tags: trunk)
13:42
Add documentation for the sqlite3_vtab_in_first() enhancement and the new unhex() SQL function. (check-in: 4c51970d12 user: drh tags: trunk)
02:15
Correct generate_series() mistakes noted in [forum:forumpost/c2101840f1|forum post c2101840f1]. (check-in: 96a13a1c67 user: larrybr tags: trunk)
2023-01-25
11:14
Correct typos noted in Forum post f381c42ab1. (check-in: 8e3ddbd5b8 user: drh tags: branch-3.40)
11:13
Change labels on the download page to say "SHA3-256" instead of just SHA3. (check-in: 54db71c83a user: drh tags: branch-3.40)
10:47
Correct typos noted in Forum post f381c42ab1. (check-in: 5702963af2 user: larrybr tags: trunk)
2023-01-21
23:07
Typo fixes in JSON documentation. (check-in: 7f680aab5f user: drh tags: trunk)
14:42
Fix subject-verb agreement in one sentence in the JSON documentation. (check-in: 82435642b2 user: drh tags: trunk)
2023-01-17
23:02
Parenthetically mention toleration of conflict resolution clause and absent effect in table CHECK constraints. (check-in: f846012243 user: larrybr tags: trunk)
2023-01-16
20:16
For object doc pages, show more clearly that the page is not a whole interface description. (check-in: 029730d32b user: larrybr tags: trunk)
2023-01-12
11:08
Describe sqlar_compress(X) more accurately. (check-in: 83fd668e46 user: larrybr tags: trunk)
2023-01-11
12:30
Fix typo in the windowfunctions.in document. (check-in: 8c7e9b6d4f user: drh tags: trunk)
2023-01-10
16:55
Fix typo on the quirks page. (check-in: 1e1a81e650 user: drh tags: trunk)
15:33
New quirk: SQLite destinguishes between integer and text literals. Forum post 887eeeeec5fc7185. (check-in: 86aa8a3e42 user: drh tags: trunk)
14:04
Note that errors produced by window function xFinal() calls made from within sqlite3_reset() or finalize() are ignored. (check-in: e164967b15 user: dan tags: trunk)
2023-01-09
18:50
Reflect clarified CLI help for .quit (check-in: 438918d8cb user: larrybr tags: trunk)
2023-01-07
01:13
Clarify what table types can be tracked with session extension. (check-in: 6d69233043 user: larrybr tags: trunk)
2023-01-06
11:00
Document Tcl interface preupdate subcommand. This also clears the last of the missing page fragment hyperlink targets. (So "make linkcheck" reports all internal links good.) (check-in: 70de644daf user: larrybr tags: trunk)
02:35
Say "SHA3-256" on hashes so nobody has to count hex digits. (check-in: 742c6eb7d1 user: larrybr tags: trunk)
00:45
Clear most missing page fragment link issues, and add tally of those to linkcheck make target. Defer Tcl interface doc improvement for separate check-in, so it now shows missing page fragments. (check-in: 6ea20767ad user: larrybr tags: trunk)
2023-01-04
16:25
Add the PRAGMA integrity_check enhancement to the change log. (check-in: a21b004e53 user: drh tags: trunk)
16:23
Merge the latest branch-3.40 changes into trunk. (check-in: 2d2e584cf1 user: drh tags: trunk)
16:18
The PRAGMA table-valued function feature is no longer experiemental. It is a long-established and stable feature that we depend upon. Update the docs to say as much. Cherry-picked onto the 3.40 branch by request of forum post a86299ccc3. (check-in: bfb7a9010a user: drh tags: branch-3.40)
16:14
Update the Expensify logo on the homepage to the latest version of their official logo. (check-in: 1b31b16a2d user: drh tags: branch-3.40)
2023-01-02
14:22
Add hyperlink checking tools. Fix broken links it found. Add CHECKOUT_ONLY make option to do doc builds using only version-controlled sources. Fix obscure bug in HTML parser. Collect relevant changes from branch-3.40 . (check-in: 7d17890956 user: larrybr tags: trunk)