Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 most recent check-ins that include changes to files matching 'art/syntax/*'
2023-12-05
| ||
14:43 | Merge the latest trunk changes into the jsonb branch. Update with the latest documentation about JSONB. (check-in: 3b673fad86 user: drh tags: jsonb) | |
2023-10-24
| ||
19:12 | Add the new "function-arguments" non-terminal to the bubble diagrams. (check-in: 4cf6e8d252 user: drh tags: trunk) | |
17:23 | Update syntax_linkage.tcl so that the new ordering-term non-terminal is linked from aggregate-function-invocation. (check-in: e028522ec2 user: drh tags: trunk) | |
17:10 | Get ORDER BY into aggregate function invoke diagram. (check-in: 1391a28657 user: larrybr tags: trunk) | |
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) | |
22:10 | In UPDATE with limit syntax diagram, get returning-clause independent of WHERE. See forum post d8f57775be. (check-in: 2aab6634b5 user: larrybr tags: trunk) | |
2022-06-21
| ||
14:41 | Update syntax diagrams to show that you can have a HAVING clause without a GROUP BY. (check-in: 4195254582 user: drh tags: trunk) | |
2022-05-12
| ||
15:23 | Documentation for IS DISTINCT FROM and IS NOT DISTINCT FROM. (check-in: ee6304ed53 user: drh tags: trunk) | |
2022-04-18
| ||
02:55 | sync w/trunk in preparation for extensible shell doc update and creation (check-in: 6614946a15 user: larrybr tags: cli_extension) | |
2022-04-13
| ||
13:11 | Update the change log, syntax diagrams, and SELECT documentation to describe RIGHT and FULL JOIN. More work to be done on this. (check-in: 7dc766ebe1 user: drh tags: trunk) | |
2021-09-24
| ||
00:28 | Correct over-lenient delete ... order by limit syntax diagram. (Per https://sqlite.org/forum/forumpost/35b89409e5 ) (check-in: 0ab7d5fa06 user: larrybr tags: trunk) | |
2021-08-20
| ||
15:48 | Initial documentation for STRICT tables. (check-in: a62eba124d user: drh tags: trunk) | |
00:18 | Document new STRICT table option (check-in: e668c1ce28 user: larrybr tags: strict-tables) | |
2021-07-18
| ||
17:27 | In big expr railroad chart, make only LIKE get an ESCAPE clause. (check-in: 6fa8195610 user: larrybr tags: trunk) | |
2021-06-12
| ||
18:40 | Merge 3.35 fixes into trunk. (check-in: 01f903cf1a user: drh tags: trunk) | |
18:32 | Fix the expression syntax diagram. DISTINCT is not required for the first argument of a function. (check-in: 12118bdbb8 user: drh tags: branch-3.35) | |
2021-06-10
| ||
00:24 | Merge in fixes from branch-3.35. (check-in: a91ad6f8ef user: drh tags: trunk) | |
2021-04-28
| ||
05:08 | Cherry pick add materialization hints to CTE syntax chart. (check-in: 01fdd97047 user: larrybr tags: branch-3.35) | |
04:35 | Add materialization hints to CTE syntax chart. (check-in: 5d087a7e27 user: Larry tags: trunk) | |
2021-04-27
| ||
19:34 | The "window-defn" on the syntax diagrams for select-core and select-stmt should be a box, not an oval, because it has substructure. (check-in: b57f867fa6 user: drh tags: branch-3.35) | |
2021-04-23
| ||
13:15 | Merge in the latest branch-3.35 changes. (check-in: 1545c4fd49 user: drh tags: trunk) | |
2021-03-31
| ||
17:25 | Fix a typo on the frame-spec.pikchr syntax diagram. (check-in: 3617d4f844 user: drh tags: branch-3.35) | |
2021-03-22
| ||
01:28 | Clarity tweaks to FROM clause diagrams. (check-in: 53e9fbe353 user: larrybr tags: trunk) | |
00:46 | Add join-clause into empty FROM clause list path of SELECT syntax diagrams. (check-in: 53a0a96734 user: larrybr tags: trunk) | |
2021-02-22
| ||
15:59 | Merge the materialization hint documentation to trunk. (check-in: 9fc8e65396 user: drh tags: trunk) | |
15:27 | Documentation on the materialization hints. (check-in: 01faf091f4 user: drh tags: as-materialized-redux) | |
2021-02-19
| ||
14:17 | Add documentation for ALTER TABLE DROP COLUMN. (check-in: 9682d5370f user: drh tags: trunk) | |
2021-02-03
| ||
16:07 | Merge the RETURNING changes. (check-in: bcc98c0be1 user: drh tags: trunk) | |
2021-02-01
| ||
21:53 | Add the RETURNING clause to the UPDATE/DELETE statements with LIMIT. (check-in: d3182cdbb6 user: drh tags: returning) | |
19:20 | Update the DELETE, INSERT, and UPDATE syntax diagrams to show the RETURNING clause. Still need to do delete-stmt-limited and update-stmt-limited. (check-in: fc9711b569 user: drh tags: returning) | |
13:50 | Add a syntax diagram for the RETURNING clause. (check-in: afce2544ec user: drh tags: returning) | |
2021-01-04
| ||
00:51 | Merge enhancements from the 3.34 branch. (check-in: 75f07e5d08 user: drh tags: trunk) | |
00:49 | If a missing "expr" box on the unary-operator branch of the expr syntax diagram. SQLite forum post 866a754699 (check-in: 8164556750 user: drh tags: branch-3.34) | |
2020-12-14
| ||
15:02 | Merge the UPSERT enhancements. Update the change log. (check-in: 9d0d26d35f user: drh tags: trunk) | |
2020-12-08
| ||
15:30 | Documentation for the proposed generalizations to UPSERT. (Closed-Leaf check-in: d7320caafa user: drh tags: generalized-upsert) | |
2020-10-11
| ||
01:24 | Remove a test file accidentally committed. (check-in: 8ded4bd270 user: drh tags: trunk) | |
2020-10-01
| ||
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-26
| ||
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
| ||
16:45 |
Remove the old Tk script for generating syntax diagrams. Patch up the
Makefile. Still to do:
| |
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) | |