Documentation Source Text

Timeline
Login

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

81 check-ins using file art/syntax/window-defn.gif version 08f29b4511

2019-10-02
11:36
Add the ability to put an ad unit at the top of the index page and the download page. If the file "adunit.txt" exists in the build directory, then the content of that file is copied into the appropriate spot on those two pages. (Leaf check-in: ea232463fc user: drh tags: branch-3.29)
2019-09-24
10:30
Use single-quoted strings in the documention for PRAGMA encoding. (check-in: 4c6aa056b7 user: drh tags: branch-3.29)
2019-09-20
17:37
Fix a minor typo in the transaction documentation. (check-in: 83b8745219 user: drh tags: branch-3.29)
2019-09-13
17:55
Fix a bug in the documentation generator for PRAGMAs. (check-in: d83262cc8b user: drh tags: branch-3.29)
2019-08-15
16:03
More precise description of when SQLITE_MASTER can be updated in the FAQ. (check-in: 5a6c1fea3c user: drh tags: branch-3.29)
2019-08-12
11:54
Trying to improve the documentation on transactions. (check-in: ead5e472f0 user: drh tags: branch-3.29)
2019-08-06
17:02
Improved documentation on how EXPLAIN only affects run-time but some PRAGMA statements operate at prepare-time and are thus unaffected by EXPLAIN. (check-in: e167521765 user: drh tags: branch-3.29)
2019-08-05
20:39
Back out the previous change. We are instead going to modify the code to match the documentation. (check-in: 3578d6c47b user: drh tags: branch-3.29)
12:55
Update the documentation on the affinity of the columns of VIEWs and subqueries that are generated from expressions to match the actual implementation of 10 years standing - namely such columns have BLOB affinity, not no affinity. Ticket https://www.sqlite.org/src/info/d52a29a9e6bc55c5 (check-in: 16a418966a user: drh tags: branch-3.29)
2019-07-16
13:44
Updates to the testing document. (check-in: 0d69a8d268 user: drh tags: branch-3.29)
2019-07-15
17:48
Minor typos fixes in the lemon documentation. (check-in: bd1181fb39 user: drh tags: trunk)
17:17
Fix a missing space in the selfcontained.html webpage. (check-in: 127e0a0347 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-07-11
16:31
More typo fixes in quirks.html (check-in: f6681985cd user: drh tags: trunk)
16:01
Fix typos in the quirks document. (check-in: 596c4951a0 user: drh tags: trunk)
14:15
Add the "quirks.html" document to the list of overview documents in the documentation summary. (check-in: 085c470f26 user: drh tags: trunk)
13:28
Add another example of using a stale file descriptor to the howtocorrupt page. (check-in: 8a4435f7ae user: drh tags: trunk)
2019-07-10
17:38
Version 3.29.0 (check-in: 059d7ea707 user: drh tags: trunk, release, version-3.29.0)
12:40
Update the speed-and-size spreadsheet. (check-in: ab8568d80c user: drh tags: trunk)
12:02
Add news for the 3.29.0 release. (check-in: c3bd426c86 user: drh tags: trunk)
11:45
Fix typos (check-in: 7a5056a138 user: drh tags: trunk)
2019-07-09
13:13
Minor tweaks to the change log and to the documentation for SQLITE_DQS. (check-in: d3b763b6a7 user: drh tags: trunk)
09:50
Merge documentation fixes from the 3.28 release. (check-in: 02ab9d6bd3 user: drh tags: trunk)
09:48
Fix documentation typo. (Leaf check-in: ee5e3f5b43 user: drh tags: branch-3.28)
2019-07-02
13:25
Fix to the 12-step procedure for generalized schema modifications. Additional text trying to describe why schema modifications are hard in SQLite. (check-in: df84d97d7b user: drh tags: trunk)
12:47
Add documentation for the SQLITE_DQS compile-time option. Adjust the documentation so that the default is now -DSQLITE_DQS=3. (check-in: e2807b06c2 user: drh tags: trunk)
2019-06-17
14:14
Add notes about the new sqlite3_db_config() interfaces. Enhanced discussion of the double-quoted string literal misfeature. (check-in: ab87f9f72b user: drh tags: trunk)
13:56
Track the revised DQS interface. (Closed-Leaf check-in: 09cea3924b user: drh tags: new-dbconfig-options)
2019-06-15
15:24
Documentation on the new SQLITE_DBCONFIG options. (check-in: 4ebc1051c2 user: drh tags: new-dbconfig-options)
2019-06-12
20:31
Fix the description of how collation is computed to indicate that the collation is not blocked by a CAST operator. Fix for ticket https://www.sqlite.org/src/info/b148fa61059fb6c2. (check-in: 9f887f15e5 user: drh tags: trunk)
10:55
Enhancements to the change log. (check-in: 06b9f7898d user: drh tags: trunk)
2019-06-11
15:54
Clarify the semantics of a CAST to NUMERIC. Ticket https://www.sqlite.org/src/tktview/afdc5a29dc (check-in: 7a51b32537 user: drh tags: trunk)
13:40
Clarify how mathematical operators function given string or blob operands. Ticket https://www.sqlite.org/src/tktview/1819598c09 (check-in: e0f700bb6c user: drh tags: trunk)
02:59
Augment the affinity rules to state that the affinity of a COLLATE operator is the same as the affinity of its left-hand side. Ticket https://www.sqlite.org/src/tktview/d60b3cd7cb (check-in: 722f0828b3 user: drh tags: trunk)
02:51
State that the COLLATE operator does not change affinity. (Leaf check-in: 5395fed295 user: drh tags: mistake)
2019-05-23
19:37
Add a row for 3.29.0 to the speed-and-size chart. (check-in: 7502249d01 user: drh tags: trunk)
2019-05-21
11:14
IE11 does not understand a 308 redirect, so always use a 301 redirect instead. (check-in: 91021e98e3 user: drh tags: trunk)
02:48
Use the <!DOCTYPE html> header on all pages. (check-in: b5aef4cfad user: drh tags: branch-3.28)
2019-05-17
20:39
Enhance the PRAGMA journal_mode=OFF documentation to make it clear that ordinary SQL can corrupt the database file while in that mode. See ticket https://www.sqlite.org/src/info/f4ec250930342e0c (check-in: 5f361950a7 user: drh tags: trunk)
17:22
Fix a harmless compiler warning about the return value of freopen() in althttpd. (check-in: 445195faaf user: drh tags: trunk)
17:20
Some redirects are now permanent. (check-in: dd8def223f user: drh tags: trunk)
2019-05-10
11:38
Fix a typo in the documentation for ANALYZE. (check-in: 0917d5f9d6 user: drh tags: branch-3.28)
2019-05-08
17:26
Document the fact that using PRAGMA case_sensitive_like in a database that uses LIKE operators in the schema can lead to problems. (check-in: bc4c1a7626 user: drh tags: trunk)
16:53
Clarify the ON CONFLICT clause documentation to make clear that FK violations always work as ABORT or ROLLBACK, never FAIL, IGNORE, or REPLACE. (check-in: 90a2cca5d0 user: drh tags: trunk)
2019-05-02
19:03
Use freopen() rather than assigning to "stdin" in althttpd.c. (check-in: 229fda6dfb user: drh tags: trunk)
16:25
Attempt to clarify the scope of when UPSERT processing applies. (check-in: aae75b6ac2 user: drh tags: branch-3.28)
2019-04-30
20:37
More "whynotgit.html" updates. (check-in: 71cccf3d65 user: drh tags: branch-3.28)
20:15
Further enhancements to the whynotgit.html page. (check-in: 763fc99770 user: drh tags: branch-3.28)
2019-04-29
19:27
Further clarification to the assert.html document. (check-in: ef3822f76d user: drh tags: branch-3.28)
18:45
Add documentation for the ".recover" command to the shell tool page. (check-in: 51202caa59 user: dan tags: trunk)
16:21
Merge changes from the 3.28 branch. (check-in: d220b2f30c user: drh tags: trunk)
15:46
Soften the criticism of Go because of their decision to omit assert() from the language. (check-in: 4a40995c05 user: drh tags: branch-3.28)
13:51
Update the file-format document to indicate that de-duplication of index columns in WITHOUT ROWID tables does not occur if the columns have different collating sequences. (check-in: 3047c99f8a user: drh tags: trunk)
2019-04-28
00:46
Fix althttpd.c so that it builds on non-linux machines. (check-in: 02b0d4d406 user: drh tags: trunk)
2019-04-27
21:01
Start a change log for version 3.29.0. (check-in: 4e1bc9c5f0 user: drh tags: trunk)
18:42
Updates to the althttpd.md documentation. (check-in: 7dcc5545d1 user: drh tags: trunk)
11:27
Fix a typo in althttpd.c - restore the behavior of index.cgi. (check-in: 8cda91e897 user: drh tags: trunk)
2019-04-24
19:28
The attack that the previous check-in sought to mitigate has stopped. So comment-out the change of the previous check-in. (check-in: 4e3b689944 user: drh tags: trunk)
17:18
In althttpd.c, disallow a single particular user-agent string that is recently appearing in spider attacks. (check-in: 01c0f297c1 user: drh tags: trunk)
2019-04-19
23:40
Clarify the documentation on PRAGMA cache_size to explain that the cache size will go up or down in proportion to a change in page size. (check-in: 184e897473 user: drh tags: trunk)
2019-04-18
16:39
Althttpd now prefers /home over /index.html if it exists. (check-in: 87856f6c54 user: drh tags: trunk)
16:34
Change althttpd.c to search for /home after /index.html if not filename is given. (check-in: efdc1b8e66 user: drh tags: trunk)
2019-04-17
19:17
Remove unmatched close parenthesis from fileformat.html. (check-in: 41027bf4a9 user: dan tags: trunk)
15:17
Additional information about the SQLITE_IOERR_SHMSIZE error code. (check-in: 5c5e6f523a user: drh tags: trunk)
2019-04-16
19:52
Version 3.28.0 (check-in: 8084bf3aaf user: drh tags: trunk, release, version-3.28.0)
17:15
Fix typos. (check-in: 5bdcbe6918 user: drh tags: trunk)
17:08
Add a news entry for the 3.28.0 release. (check-in: 4136052d27 user: drh tags: trunk)
15:20
Updates to the change log. (check-in: 1309ba3c39 user: drh tags: trunk)
2019-04-15
22:32
Update the speed-and-size spreadsheet. (check-in: 3fc49bdac0 user: drh tags: trunk)
2019-04-13
15:45
Wording changes in defense-against-dark-arts. (check-in: adb3c10d3e user: drh tags: trunk)
15:33
Additional suggestions for defense against dark arts. (check-in: b41d1c753f user: drh tags: trunk)
2019-04-08
18:06
Fix a minor error in the datatype documentation. (check-in: a5590f5f81 user: drh tags: trunk)
2019-04-05
21:18
Remove an obsolete reference to the addopcodes.tcl script. (check-in: efe862885f user: drh tags: trunk)
2019-04-04
19:07
Fix a typo. (check-in: e6f195d6f4 user: drh tags: trunk)
2019-04-02
13:26
Add the four new keywords: EXCLUDE GROUPS OTHERS TIES (check-in: 8db10efb63 user: drh tags: trunk)
01:06
Update the fts3_tokenizer() documentation to describe how it now wants parameters to be bound. (check-in: 30e7de5540 user: drh tags: trunk)
2019-04-01
14:45
Merge changes from the 3.27 branch. (check-in: 50513b6f28 user: drh tags: trunk)
2019-03-29
16:41
Fix spelling error in the previous check-in. (check-in: cfd3eb70b4 user: drh tags: trunk)
16:40
Mention the ON parsing ambiguity of UPSERT on the UPSERT documentation page. (check-in: c3bcaaf1e5 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)