Documentation Source Text

Timeline
Login

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

50 most recent check-ins that include changes to files matching 'art/*'

2019-07-15
19:25
Update syntax diagrams to show the FILTER clause on aggregate functions. Start a change log for version 3.30.0. Leaf check-in: ba9800704d user: drh tags: trunk
2019-07-13
16:24
Remove obsolete and unsupported BNF and TEXT representations of the grammar. check-in: b02f76d76f user: drh tags: trunk
2019-03-28
20:22
Remove the "expr FOLLOWING" case from frame-specs that only describe the starting boundary. check-in: 5eff6feebc user: drh tags: trunk
15:23
In the window-defn bubble diagram, change "existing-window-name" to "base-window-name" and make it an indentifier instead of a non-terminal. check-in: 67d1075ce3 user: drh tags: trunk
15:15
Improved railroad diagram for frame-spec. check-in: 6598d28114 user: drh tags: trunk
2019-03-26
13:11
Update window functions documentation. check-in: bdc2a67078 user: dan tags: trunk
2019-03-25
20:49
Update documentation to match the proposed window function changes. Closed-Leaf check-in: 783032878d user: dan tags: window-functions
2019-01-09
19:56
Fixes to the syntax diagrams for window functions: The parentheses were missing around the window-defn for the WINDOW clause. check-in: fd152b335d user: drh tags: branch-3.26
19:54
Fixes to the syntax diagrams for window functions: The parentheses were missing around the window-defn for the WINDOW clause. check-in: 83da33aabc user: drh tags: trunk
2018-12-09
22:23
Preliminary documentation for VACUUM INTO check-in: 130193a5b9 user: drh tags: trunk
2018-09-06
21:37
Improvements to the RENAME COLUMN syntax diagram. check-in: c951c8c482 user: drh tags: trunk
20:05
Update the ALTER TABLE bubble diagram to show the RENAME COLUMN syntax. check-in: f995368f57 user: drh tags: trunk
2018-07-06
18:30
Update the syntax diagrams to include the new window function syntax. check-in: f7a6a2f7c2 user: drh tags: trunk
2018-06-04
19:41
Add the upsert-clause.gif image. check-in: 7d927bcea1 user: drh tags: trunk
2018-04-19
13:28
Preliminary documentation for upsert. check-in: 74564b6da7 user: drh tags: trunk
2018-03-23
14:30
Add TRUE and FALSE to the syntax diagrams as new literal values. check-in: 1d1c0fc6ec user: drh tags: trunk
2016-09-17
17:53
Update the update-stmt-limited syntax diagram and the text of the UPDATE documentation for the addition of row values. check-in: ea28d5d596 user: drh tags: trunk
17:10
Update the syntax diagram for UPDATE to show the ability to use row values. check-in: 7f09c9eed4 user: drh tags: trunk
2016-09-14
17:28
Update syntax diagrams for expr and vacuum. check-in: 3f00f6192a user: drh tags: trunk
2016-08-30
16:37
Draft chagnes to the VACUUM documentation to describe the ability to VACUUM attached databases. Leaf check-in: 08b1963db5 user: drh tags: vacuum-enhancement
2016-07-12
20:54
Updates to reflect changes in 3.14.0. The "expr" syntax diagram is changed to show the ability to put table-valued functions on the RHS of an IN operator. Related text changes. Update the change log. check-in: 24cd5438cc user: drh tags: trunk
2015-12-22
16:03
Modify the bubble-diagram generator script to use the TkPath extension. check-in: 08bf2dfe78 user: chw tags: bubble-generator-tkpath
2015-09-08
15:16
Update the syntax diagrams for new syntax: (1) table-valued functions (2) column names on CREATE VIEW statements (3) Indexes on expressions check-in: 866fda3b5a user: drh tags: trunk
2014-07-24
14:27
Add documentation on the hexadecimal integer notation. check-in: 4656303de6 user: drh tags: trunk
2014-02-21
13:21
Update the all-bnf.html file. check-in: 424fd15707 user: drh tags: trunk
2014-02-02
22:43
Enhancements to the bubble diagram generator. Leaf check-in: 4dc85d1094 user: drh tags: bubble-diagrams
2014-01-30
20:55
Fix an error in the table-or-subquery syntax diagram. check-in: a467d7a4b8 user: drh tags: trunk
20:51
Add the "factored-select-stmt" syntax diagram. Improve the way diagrams are hidden and shown. check-in: fac98d12ae user: drh tags: trunk
19:39
Make the "select-stmt" syntax diagram a closer fit to reality. check-in: 0c43e7efb4 user: drh tags: trunk
17:41
Fix FROM clause in the SELECT syntax diagrams. Also fix typos in the text. check-in: a115a033da user: drh tags: trunk
14:11
Add the extended-simple-select-stmt syntax diagram. Update the documentation on SELECT statements to better explain limitations on the use of ORDER BY and LIMIT in compound SELECTs. check-in: c14dc7c23b user: drh tags: trunk
2014-01-23
18:37
Refactoring many of the bubble syntax diagrams, especially related to SELECT. Attempting to make the bubble diagrams easier to follow. check-in: 9aa1b8df9b user: drh tags: trunk
15:29
Fix a link in the with-clause syntax diagram. check-in: 3598251c1c user: drh tags: trunk
15:25
Recursive syntax diagram display. check-in: 87e7eb3d0d user: drh tags: trunk
2014-01-17
23:50
Update the syntax bubble diagrams to show that the WITH clause is allowed. check-in: 3f48c6857f user: drh tags: trunk
2013-11-08
20:06
First attempt at documenting WITHOUT ROWID. check-in: 3819df0c0d user: drh tags: trunk
2013-08-02
18:27
Enable partial indices. check-in: f990657458 user: drh tags: trunk
2013-08-01
18:23
Update syntax diagrams (on Mac OS 10.6.8 using Tk 8.5.7) for partial indices. check-in: 6f7d9ba15e user: drh tags: partial-indices
2012-01-28
19:42
Update the syntax diagram for CREATE VIRTUAL TABLE to show the optional IF NOT EXISTS clause. check-in: d170aa6e3f user: drh tags: trunk
15:23
Update the INSERT statement syntax diagram to show the support for multiple rows in the VALUES clause of an INSERT. check-in: 55bd8303d7 user: drh tags: trunk
2011-11-11
13:37
Rerender all bubble-diagram gifs using xvnc on "elly". The choice of X-server makes a huge difference in the final output, unfortunately. check-in: d8b1c2a562 user: drh tags: trunk
13:24
Update the bubble diagram for select-core so that GROUP BY does not allow ASC or DESC keywords. This brings the documentation into compliance with the implementation. check-in: 40ef9e8de8 user: drh tags: trunk
2011-04-05
14:31
Updates to the ANALYZE and FTS4 documentation to describe the latest changes. Updates to the changes.html file as we move closer to the 3.7.6 release. Added amalgamation32k to the download.html page. check-in: 4fb953fec0 user: drh tags: trunk
2011-02-04
00:52
Update the ATTACH documentation to allow an expression as the filename parameter. Core ticket http://www.sqlite.org/src/info/9013e13dba. check-in: be0c879c12 user: drh tags: trunk
2010-10-14
17:27
Fix the join-op syntax diagram so that it allows LEFT JOIN in addition to LEFT OUTER JOIN. check-in: 1a0decefd2 user: drh tags: trunk
2010-09-30
16:31
Add missing image: numeric-literal.gif. check-in: d1c65c4e95 user: drh tags: trunk
16:15
Added a syntax diagram for numeric literals, especially floating point literals. check-in: 598ff451ef user: drh tags: trunk
2010-09-24
19:00
Update the REINDEX syntax diagram to allow for no arguments. check-in: f55ccb05aa user: drh tags: trunk
2010-09-18
15:03
Remove the tags from a couple of untestable statements in lang_select.html. check-in: 0df9f2d381 user: dan tags: trunk
2010-09-17
19:52
Update the syntax diagram GIF files. check-in: 2adf0c0cca user: drh tags: trunk