Documentation Source Text

Timeline
Login

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

113 check-ins using file search/search.tcl.in version 7e40d0b531

2020-11-26
21:15
Fix a typo in the cli.html document. (Leaf check-in: 40ae2b975d user: drh tags: trunk)
2020-11-25
18:23
Remove obsolete GIF syntax diagram processing logic (check-in: 77e66d0f02 user: drh tags: trunk)
13:10
Clarify the differences between xFindFunction and xBestIndex with regard to handling the argument swapping behavior of LIKE, GLOB, REGEXP, and MATCH. See forum post 9440862379. (check-in: 2d468b65df user: drh tags: trunk)
2020-11-24
23:40
Fix typos. (check-in: 89ad8f9c2c user: drh tags: trunk)
2020-11-23
14:55
Allow substring() as an alias for substr(). (check-in: 33b7cf7178 user: drh tags: trunk)
2020-11-19
16:35
Fix some errors in the window functions documentation. (check-in: 29a58418bc user: dan tags: trunk)
2020-11-18
14:36
Fix a hyperlink in the carray documentation. (check-in: 46262280d2 user: drh tags: trunk)
2020-11-17
15:09
Add documentation for the single-argument variant of carray. Fix a broken hyperlink in rescode.in. (check-in: 8ac0887660 user: drh tags: trunk)
2020-11-16
12:03
Merge changes from the 3.33 branch. (check-in: 8bdbb88c52 user: drh tags: trunk)
2020-11-15
13:16
In althttpd.c, fix a potential NULL ptr dereference following a CGI that returns an empty string. (check-in: c1e08a3709 user: drh tags: trunk)
2020-11-09
13:42
Update the rescode.html document with recently added result codes. (check-in: c57bdcc203 user: drh tags: trunk)
2020-11-02
14:01
Clarify wording of recursive CTE documentation. (check-in: 6dc65b8b9b user: drh tags: trunk)
2020-10-31
19:26
Add the addition of --tabs to the change log. (check-in: 56c9757fd3 user: drh tags: trunk)
14:46
Put a public domain notice on the althttpd.c file. (check-in: 46a8eeecdf user: drh tags: trunk)
2020-10-23
16:07
Add semrushbot to the list of disallowed user agents in althttpd.c. (check-in: 6da69d0669 user: drh tags: trunk)
2020-10-21
04:40
Fix typos in lang_with.html (check-in: 1e7aae0b46 user: drh tags: trunk)
2020-10-20
19:05
Enhance the "timeline" link on the prerelease snapshot to use the p= and bt= query parameters in order to see all branches that have contributed to the build product. (Leaf check-in: 6346afca54 user: drh tags: branch-3.33)
18:58
Fix typos and improve wording in release notes. (check-in: 470ac01c42 user: drh tags: trunk)
2020-10-19
13:20
Document the ability to use a compound SELECT for the recursive portion of a recursive CTE. (check-in: 92cd57163d user: drh tags: trunk)
2020-10-14
19:14
Update the change log for 3.34.0 (check-in: ecc48e8715 user: drh tags: trunk)
2020-10-13
15:50
Minor tweaks to the whynotgit document. (check-in: d9a09974a2 user: drh tags: trunk)
2020-10-11
01:24
Remove a test file accidentally committed. (check-in: 8ded4bd270 user: drh tags: trunk)
2020-10-09
15:05
Merge changes from the 3.33 branch. (check-in: 57b76a1da9 user: drh tags: trunk)
15:02
Update the purchase options to the new purchase scripts. (check-in: 5ca88ff9db user: drh tags: branch-3.33)
2020-10-05
17:03
When building the full-text index, ignore <svg> blocks. (check-in: dd8aef912e user: dan tags: trunk)
16:42
Add documentation for the new experimental fts5 tokenizer "trigram". (check-in: a1963591a6 user: dan tags: trunk)
2020-10-04
00:24
Clarifications on the behavior of the NUMERIC affinity and on the affinity of result columns in compound SELECT statements. (check-in: b19a0e3fa8 user: drh tags: trunk)
2020-10-02
15:55
Merge 3.33 documentation fixes into trunk. (check-in: 04cbabd493 user: drh tags: trunk)
15:51
Fix typos in the floatingpoint.html document. (check-in: 103f72eade user: drh tags: branch-3.33)
15:47
Fix typos in the floatingpoint.html document. (check-in: 1d1c9d7ad7 user: drh tags: trunk)
2020-10-01
20:13
Enhance the renderer so that any Pikchr source text with <pikchr>...</pikchr> is automatically converted into SVG. (check-in: 15b15f7ace user: drh tags: trunk)
19:39
Add the ability to translate Pikchr text to the TCL interpreter used to build the website. Omit all of the *.svg files from the check-in because they are now generated at compile-time directly from the *.pikchr files. All SVG is inline instead of being in separately loaded files. (check-in: 64e6c50273 user: drh tags: trunk)
18:23
Put all of the syntax diagrams in-line rather than loading them as separate files. (check-in: 285efd6656 user: drh tags: trunk)
2020-09-30
12:16
Fix typos in the arch.html document. (check-in: b6873d1f98 user: drh tags: branch-3.33)
2020-09-27
11:54
Fix typo in famous.html (check-in: 9013ecdf63 user: drh tags: branch-3.33)
2020-09-26
22:45
Update the FAQ to describe the new syntax diagram technology. (check-in: 2966044012 user: drh tags: trunk)
22:31
Generate syntax diagrams using Pikchr (check-in: 9f5383c824 user: drh tags: trunk)
22:29
Create a TCL script that converts all *.pikchr files into *.svg files and constructs syntax_linkage and syntax_order. Clean up legacy. (Closed-Leaf check-in: c877e0ff4a user: drh tags: svg-syntax)
2020-09-25
17:27
Fix syntax diagram linkage so that it always goes to SVGs, never to GIFs. (check-in: 2280617160 user: drh tags: svg-syntax)
16:45
Remove the old Tk script for generating syntax diagrams. Patch up the Makefile. Still to do:
  1. Automate generation of the syntax_linkage.tcl file
  2. Include pikchr source code in the source tree
  3. README.md file explaining how to implement the syntax diagram pikchr scripts and how to build the SVG files
  4. Improve some of the existing diagrams
(check-in: ec5c7e80fa user: drh tags: svg-syntax)
16:39
Last three GIFs converted. (check-in: 05c85f544f user: drh tags: svg-syntax)
16:17
upsert-clause, vacuum-stmt, and window-definition (check-in: c864439cba user: drh tags: svg-syntax)
15:23
type-name, update-stmt, and update-stmt-limited (check-in: 9d6aaa6c11 user: drh tags: svg-syntax)
13:03
table-or-subquery (check-in: 1776394058 user: drh tags: svg-syntax)
2020-09-24
20:53
table-constraint (check-in: 34d929e01e user: drh tags: svg-syntax)
14:37
sql-stmt-list (check-in: 8f63a61ff7 user: drh tags: svg-syntax)
14:24
sql-stmt (check-in: 7ea65ac585 user: drh tags: svg-syntax)
13:46
simple-function-invocation and simple-select-stmt. (check-in: 305dc14430 user: drh tags: svg-syntax)
13:11
signed-number (check-in: 65b46ed928 user: drh tags: svg-syntax)
12:39
Minor tweaks to select-stmt. (check-in: 73084eb917 user: drh tags: svg-syntax)
11:53
No background color at all on the select-core subset of select-stmt - just a gray border. (check-in: aa884bd27e user: drh tags: svg-syntax)
11:25
Lighter background color for "select-core" within "select-stmt" (check-in: e8177053e8 user: drh tags: svg-syntax)
05:31
select-stmt, with a tinted background for the select-core. (check-in: 296f548eeb user: drh tags: svg-syntax)
04:22
select-core (check-in: 405151ac80 user: drh tags: svg-syntax)
01:14
savepoint-stmt (check-in: 8698f49d49 user: drh tags: svg-syntax)
01:11
release-stmt, result-column, and rollback-stmt (check-in: 0fa36afc9b user: drh tags: svg-syntax)
00:45
raise-function, recursive-cte, and reindex-stmt (check-in: 25e8db2da4 user: drh tags: svg-syntax)
00:14
pragma-stmt, pragma-value, and qualified-table-name (check-in: 197fb70d06 user: drh tags: svg-syntax)
2020-09-23
21:26
over-clause (check-in: 03e44f6545 user: drh tags: svg-syntax)
20:00
Unmanage a couple of unused and obsolete syntax GIFs (check-in: ec5f4852e3 user: drh tags: svg-syntax)
19:51
numeric-literal and ordering-term (check-in: e5ef88d2b2 user: drh tags: svg-syntax)
18:44
Four new smaller diagrams. (check-in: 81e15dd8f8 user: drh tags: svg-syntax)
15:16
insert-stmt (check-in: b2c60f5d3a user: drh tags: svg-syntax)
12:59
indexed-column (check-in: 9437f9afd4 user: drh tags: svg-syntax)
12:39
frame-spec (check-in: 5c4e4507e5 user: drh tags: svg-syntax)
01:02
factored-select-stmt, filter-clause, and foreign-key-clause (check-in: 2ffb8b43ab user: drh tags: svg-syntax)
2020-09-22
23:11
Add the expr diagram. (check-in: 8b533b0b3d user: drh tags: svg-syntax)
18:34
Add the various DROP statements (check-in: fc300ff912 user: drh tags: svg-syntax)
17:56
Add cte-table-name, delete-stmt, and delete-stmt-limited. (check-in: 2b6dd6d053 user: drh tags: svg-syntax)
16:52
Add the create-view-stmt and create-virtual-table-stmt diagrams. (check-in: 107702e238 user: drh tags: svg-syntax)
15:44
Add the create-trigger-stmt. The arrows on FOR EACH ROW and WHEN expr seem a little confused. We might want to revisit the design later. (check-in: 91293e0c33 user: drh tags: svg-syntax)
14:39
Minor tweaks to create-table-stmt (check-in: 73f92ad202 user: drh tags: svg-syntax)
13:49
Adding conflict-clause, create-index-stmt, and create-table-stmt (check-in: 7c5c929fe7 user: drh tags: svg-syntax)
02:56
Minor tweaks to the compound-select-stmt diagram. (check-in: abec402383 user: drh tags: svg-syntax)
02:50
Add the Pikchr version of compound-select-stmt (check-in: 44f0ca00e5 user: drh tags: svg-syntax)
00:40
Add syntax diagrams through compound-operator (check-in: aa50764739 user: drh tags: svg-syntax)
2020-09-21
22:56
Add the column-def and column-name-list diagrams in SVG (check-in: 18d0a89fc6 user: drh tags: svg-syntax)
20:53
Add the column-constraint diagram. 151 lines of Pikchr. (check-in: fe260f0054 user: drh tags: svg-syntax)
19:49
Add pikchr scripts for attach-stmt and begin-stmt. (check-in: 7b336eb761 user: drh tags: svg-syntax)
19:20
Add analyze-stmt.pikchr (check-in: 95d38371c5 user: drh tags: svg-syntax)
18:57
Fix teh syntax.html and syntaxdiagrams.html page so that they use either the SVG or the GIF, whichever is available. But both depend upon the syntax_link.tcl data. This is sufficient for now. After all diagrams have been converted into Pikchr, we need to go back and revisit all of the legacy logic. (check-in: a9f58cd9f5 user: drh tags: svg-syntax)
17:49
Add Pikchr for aggregate-function-invocation. Realize now that I need to work on replicating the syntax_linkage.tcl data. (check-in: e25d0c295b user: drh tags: svg-syntax)
15:02
Update documentation for fts5 integrity-check command. (check-in: 179ade5492 user: dan tags: trunk)
14:56
Extract the width of each SVG and add a max-width to the <img> (check-in: c82a99b440 user: drh tags: svg-syntax)
14:23
Add infrastructure for porting syntax diagrams to SVG. (check-in: 277011128a user: drh tags: svg-syntax)
2020-09-20
12:35
Fix markup errors an appfunc.in. (check-in: 2cda5fcaf9 user: drh tags: branch-3.33)
11:42
Documentation typo (check-in: f581b7f6be user: drh tags: branch-3.33)
2020-09-14
11:04
Two more typo fixes. (check-in: 3d6dfc9933 user: drh tags: branch-3.33)
11:00
Fix typo in Json documentation. (check-in: 21a593daf3 user: drh tags: branch-3.33)
2020-09-10
11:36
Typo fix in lang_altertable.in (check-in: 05526832f0 user: drh tags: branch-3.33)
2020-09-07
22:29
Fix documentation typos. (check-in: 84df4e3535 user: drh tags: branch-3.33)
2020-08-28
15:34
Remove obsolete contract link from the consortium page. (check-in: 53d98374ae user: drh tags: branch-3.33)
2020-08-27
19:44
Add an entry in the change log about improved error messages on CHECK constraints. (check-in: 15ec3fe739 user: drh tags: trunk)
13:32
Clarify the behavior of the "%" operator when presented with non-integer operands. (check-in: 153857859d user: drh tags: branch-3.33)
2020-08-26
19:41
Clarify the long-standing behavior of the "PRAGMA query_only=TRUE;" command. (check-in: 52e85453bb user: drh tags: trunk)
14:05
Rearrange the sections of the CLI documentation, slightly. (check-in: 33bc7b858b user: drh tags: trunk)
13:53
Begin changes for the 3.34.0 release. Add a new changelog entry with notations of the enhancements since the previous release. (check-in: 13335de219 user: drh tags: trunk)
2020-08-25
16:49
Fix the display of constructors and destructors in the object documentation. (check-in: ba732954be user: drh tags: trunk)
2020-08-20
11:32
Fix formatting error in the optoverview.html document. (check-in: c5f5f967d1 user: drh tags: trunk)
2020-08-16
19:18
Fix typos in the floatingpoint.html document. (check-in: ec6ebb5204 user: drh tags: trunk)
11:16
Fix some broken hyperlinks. (check-in: ea43e17478 user: drh tags: trunk)
11:14
Clarify the value of "K", the number of keys on an interior node of a b-tree in the file format documentation. (check-in: 14768fbd25 user: drh tags: trunk)
2020-08-14
13:28
Version 3.33.0 (check-in: 21c05e9d58 user: drh tags: trunk, release, version-3.33.0)
2020-08-13
20:26
Add a news entry for 3.33.0. (check-in: 079e262d86 user: drh tags: trunk)
20:21
Fix typos in documentation. (check-in: 5e73e48d33 user: drh tags: trunk)
20:13
Update testing statistics for 3.33.0. (check-in: b901bab566 user: drh tags: trunk)
19:52
Update the speed-size data for the 3.33.0 anticipated release. (check-in: fa525972cb user: drh tags: trunk)
2020-08-12
22:06
New filtering rules in althttpd.c for aggressive Chinese bots. (check-in: 8bf987cd16 user: drh tags: trunk)
2020-08-11
17:01
Minor nomenclature changes. (check-in: c0be8169a7 user: drh tags: trunk)
2020-08-08
15:37
Fix a requirement mark formatting error on the integrity_check docs. (check-in: 70e6eb5281 user: drh tags: trunk)
15:13
Improvements to wording and typo fixes in pragma documentation. (check-in: 91ba2807f5 user: drh tags: trunk)
2020-08-07
20:08
Merge fixes from the 3.32 branch. (check-in: 7f7cb02e96 user: drh tags: trunk)
2020-08-06
11:12
In the search script, remove all punctuation from the search string before injecting it into TCL. (Leaf check-in: 382a046780 user: drh tags: branch-3.32)