Documentation Source Text

File History
Login

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

History of pages/lang.in

2018-12-10
00:52
Begin a new change log entries for 3.27.0. file: [f4b5e8921d] check-in: [41f9becb46] user: drh branch: trunk, size: 229821
2018-12-09
22:23
Preliminary documentation for VACUUM INTO file: [769cc9e711] check-in: [130193a5b9] user: drh branch: trunk, size: 229823
2018-12-06
15:20
Enhanced ALTER TABLE documentation, and in particular show the dangers of not following the generalized 12-step ALTER TABLE procedure precisely. file: [4406da4477] check-in: [4ffbc3f635] user: drh branch: trunk, size: 227471
2018-11-30
21:04
Fix documentation typos. file: [055790bf41] check-in: [297fc5035b] user: drh branch: trunk, size: 224172
2018-11-26
18:57
Caution users to have well-defined column names in VIEWs. file: [b8aeab64c0] check-in: [5a0203cdca] user: drh branch: trunk, size: 224168
2018-10-14
20:33
Fix typo on the GLOB documentation. file: [9985b968cc] check-in: [ddacae7fd0] user: drh branch: branch-3.25, size: 223667
2018-09-27
12:56
Say that the recursive part of a CTE may not use aggregate or window functions. file: [e36c713dc3] check-in: [aa1202143a] user: drh branch: trunk, size: 223667
2018-09-25
19:28
Clarification to the order of arguments in like() and glob(). file: [2422440590] check-in: [86e05fde50] user: drh branch: branch-3.25, size: 223536
2018-09-24
14:46
Clarify the operation of the "weekday" date and time modifier. file: [f6c2449eaa] check-in: [b4b8f35ef1] user: drh branch: branch-3.25, size: 223125
14:38
Improved linkage to window functions. file: [c3aa99a6e3] check-in: [1c7ab913f0] user: drh branch: branch-3.25, size: 223011
2018-09-06
21:37
Improvements to the RENAME COLUMN syntax diagram. file: [94cdc0dc12] check-in: [c951c8c482] user: drh branch: trunk, size: 222913
20:36
Fix a long-standing typo in the ALTER TABLE documentation. file: [e868fd9b02] check-in: [9b5947f2ee] user: drh branch: trunk, size: 222917
20:34
Update the documentation to reflect the enhancements to ALTER TABLE. file: [1c2ce29671] check-in: [c3c04a7bb4] user: drh branch: trunk, size: 222920
20:02
Merge documentation fixes from the 3.24.0 release branch. file: [fbccd541dd] check-in: [4235bb053e] user: drh branch: trunk, size: 223170
2018-09-03
10:57
Fix a typo in the CREATE TABLE documentation. file: [ec52d5b0a2] check-in: [aff4908d94] user: drh branch: trunk, size: 223170
2018-09-02
10:12
Fix a duplicate anchor in the lang.in page. file: [c7f5c7f07d] check-in: [718909cfaf] user: drh branch: branch-3.24, size: 223038
2018-08-25
14:56
Fix a duplicate fragment name in lang_expr.html file: [346e0f3f87] check-in: [8ffd68dac7] user: drh branch: trunk, size: 223175
2018-07-23
11:02
Merge changes from the 3.24 branch. file: [3ee44946f9] check-in: [137b4b6a0f] user: drh branch: trunk, size: 223171
2018-07-11
11:08
Update the keyword list with all of the new keywords added for UPSERT and window functions. file: [6d6db35df2] check-in: [824b38d28e] user: drh branch: trunk, size: 223092
2018-06-26
18:24
Mention that UPSERT does not work for virtual tables. file: [d0acbbd99f] check-in: [887762cf99] user: drh branch: branch-3.24, size: 223038
2018-06-08
13:21
Use https for all internal hyperlinks. file: [f31ea02fa4] check-in: [59e5f9e3da] user: drh branch: branch-3.24-https, size: 222957
2018-05-08
14:32
More details on the UPSERT documentation. file: [4d0893c32b] check-in: [7ca811b29f] user: drh branch: trunk, size: 222959
2018-04-19
13:28
Preliminary documentation for upsert. file: [c0bb7ab18a] check-in: [74564b6da7] user: drh branch: trunk, size: 220407
2018-04-09
01:19
Fix typo in the lang_createindex.html document. file: [71335f500e] check-in: [f8c8d8614f] user: drh branch: version-3.23, size: 217808
2018-04-06
12:16
Align the use of the "BLOB" affinity in lang_createtable.html with the definitions in datatype3.html. file: [6b438c8f37] check-in: [e4161dc6b1] user: drh branch: version-3.23, size: 217811
2018-03-30
18:33
Fix typos discovered by spell-check. file: [4f892558c7] check-in: [e436f9d464] user: drh branch: trunk, size: 217811
2018-03-23
14:46
Update syntax diagrams and expression text to cover the new TRUE and FALSE literals and the IS TRUE and IS FALSE operators. file: [880fa3ba84] check-in: [dfdf980e6c] user: drh branch: trunk, size: 217811
2018-02-20
13:46
Further refinement of the new printf.html document. file: [7e34e08a1d] check-in: [6c1f37df7f] user: drh branch: trunk, size: 217078
2018-01-26
18:38
Update documentation for CAST to integer to describe what happens when the integer is too large. This behavior is only supported on the latest trunk, so with this check-in the documentation is no longer suitable for use with 3.22.0. file: [b165cc08b1] check-in: [6b1b360098] user: drh branch: trunk, size: 217005
2018-01-04
19:28
Documentation on the sqlite_offset() SQL function. file: [b246aa12e2] check-in: [4ce0a400c2] user: drh branch: trunk, size: 216432
2017-08-03
20:39
Begin a change log entry for the 3.21.0 release. file: [190813ead8] check-in: [4cadcc5b9c] user: drh branch: trunk, size: 215641
2017-07-14
12:59
Fix the wording on a requirement about the REPLACE operation. file: [9842e4dfbc] check-in: [f2f32e8bfe] user: drh branch: trunk, size: 215720
2017-07-11
14:00
Clarify how the % operator works. file: [b55fb1e5ce] check-in: [3cb8f4e5f2] user: drh branch: branch-3.19, size: 215721
2017-07-01
23:23
Attempt to improve the INSERT documentation. file: [cfaa4828f3] check-in: [89ca937f0e] user: drh branch: trunk, size: 215623
2017-06-09
12:23
Clarify the rules for referencing tables in triggers. file: [e8e4b9de16] check-in: [e0f55595d4] user: drh branch: trunk, size: 215464
2017-03-20
14:42
Improved documentation for automatic analyze using PRAGMA optimize. file: [74805a4832] check-in: [1bbfd06810] user: drh branch: trunk, size: 215259
2017-02-02
14:48
Update the wording on the description of the WHEN clause on triggers. file: [6d658e45f1] check-in: [09d3dc5c51] user: drh branch: trunk, size: 212720
2016-12-03
20:59
Update the change log for recent enhancements and bug fixes. file: [79d17e66f9] check-in: [332dab5c56] user: drh branch: trunk, size: 212720
2016-11-30
19:07
Refinements to the bare column in aggregate query documentation. file: [d064443cf4] check-in: [f84dc83db4] user: drh branch: trunk, size: 212750
2016-11-22
18:59
Further tweaks to language description due to row values. file: [2d00a5011f] check-in: [6d7d509612] user: drh branch: trunk, size: 212724
18:37
SQL language documentation updates due to row values. file: [6ca29159f5] check-in: [437288e896] user: drh branch: trunk, size: 212526
15:24
Discussion of bare columns in aggregate queries. file: [974ea46de6] check-in: [8a4f72ebf1] user: drh branch: trunk, size: 212340
2016-10-14
10:16
Fix two spelling errors. file: [2301e11c20] check-in: [b951d26933] user: drh branch: trunk, size: 210356
2016-09-28
16:04
Fix typos. file: [be9fd5ee4a] check-in: [2a02e13870] user: drh branch: trunk, size: 210355
13:07
Add more [dateof:...] markup in the language description pages. file: [573cbcb27c] check-in: [6c79d37f0a] user: drh branch: trunk, size: 210353
12:59
New hyperlinks on the Full-Featured SQL page. file: [658ec62624] check-in: [ba6e48411e] user: drh branch: trunk, size: 210172
04:01
Futher refinement of the Full-featured SQL page. file: [b51910ba68] check-in: [d3731ef887] user: drh branch: trunk, size: 210087
2016-09-26
16:02
New warnings about the possibility of corruption the database when certain pragmas are used. file: [7deef20247] check-in: [bc4e6344c0] user: drh branch: trunk, size: 209961
2016-09-21
19:28
Requirements mark fixes. file: [6d78c19206] check-in: [0321b2ac62] user: drh branch: trunk, size: 209949
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. file: [77336198ad] check-in: [ea28d5d596] user: drh branch: trunk, size: 210045
16:57
Show "(pending)" for the dateof: of unreleased versions. Improvements to wording of recently added or modified documents. file: [9b953c2bec] check-in: [30cfddb6c9] user: drh branch: trunk, size: 209827
2016-09-14
17:45
Update documentation on VACUUM to describe how attached databases can be vacuumed. file: [b76a899501] check-in: [6f01723464] user: drh branch: trunk, size: 209751
04:12
Start a change log for 3.15.0. Begin writing documentation for row values and for the generate_series table-valued function. file: [c0dad62a9f] check-in: [bdbea7dc63] user: drh branch: trunk, size: 209444
2016-09-02
16:57
Rename the output_list proc to hd_list_of_links and move its implementation from capi3ref.in into wrap.tcl, since it is used as common code. file: [c97b9daf26] check-in: [c3c40d6711] user: drh branch: trunk, size: 209408
2016-09-01
00:48
Reformat the core and aggregate function descriptions in a way that works better on mobile. Use the "output_list" proc for the lists of pragma and aggregate and core functions. file: [181af31191] check-in: [fc4a66aa03] user: drh branch: mobile-friendly, size: 209444
2016-08-31
20:03
Use the variable-number-of-columns routine for the keyword list. file: [ba34430efe] check-in: [9e95bb666d] user: drh branch: mobile-friendly, size: 207860
2016-08-30
16:37
Draft chagnes to the VACUUM documentation to describe the ability to VACUUM attached databases. file: [1e417f2151] check-in: [08b1963db5] user: drh branch: vacuum-enhancement, size: 209016
2016-08-18
20:07
Rework the site search to use FTS5. file: [cf137f0710] check-in: [18e4a7b157] user: dan branch: experimental, size: 208246
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. file: [80c77b8431] check-in: [24cd5438cc] user: drh branch: trunk, size: 208194
2016-05-23
18:10
Fix typo. file: [6c8a95bbf3] check-in: [a88d4c2239] user: mistachkin branch: trunk, size: 208004
2016-01-02
04:14
Further tweaks to the website. file: [634623ceac] check-in: [5619b986d5] user: drh branch: bubble-generator-tkpath, size: 208003
2015-12-31
14:06
Update the change log with the latest enhancements. file: [0bf385dc83] check-in: [5077172640] user: drh branch: bubble-generator-tkpath, size: 207996
2015-11-25
18:42
Update the documentation for the LIKE/GLOB/REGEXP enhancement to virtual tables. file: [787dfa675b] check-in: [6b8138c898] user: drh branch: trunk, size: 207969
2015-11-01
18:01
Changes all references to the "tcl.tk" domain into "tcl-lang.org" as the maintainer of the "tk" top-level domain has been hacked and seems not to care. file: [fd41974e2f] check-in: [25a56d695c] user: drh branch: trunk, size: 207813
2015-10-12
05:51
More documentation updates for 3.9.0. file: [fe0adf7159] check-in: [1c92bfea70] user: drh branch: trunk, size: 207807
2015-10-08
13:29
Proposed new version numbering scheme. file: [2a34750132] check-in: [82a2560a88] user: drh branch: new-version-numbering, size: 207781
2015-10-07
19:35
Add a new documentation page that talks specifically about indexes on expressions. file: [3541f7ba59] check-in: [8b6ed636e3] user: drh branch: trunk, size: 207782
2015-09-11
22:51
Add links from the requirements.html page into the matrix. Clarifications to the CREATE INDEX and REINDEX documentation. file: [1ebfa7a79b] check-in: [c1c7b5e3d1] user: drh branch: trunk, size: 207678
20:19
Update the requirements.html document to provide links into the matrix for each requirement. file: [76f6eb6ea5] check-in: [a6da4c726a] user: drh branch: trunk, size: 207728
2015-09-09
15:39
Enhance wrap.tcl to recognize <yyterm> elements in the input HTML and convert them into real HTML that renders an terminal-symbol oval around the enclosed text. Use this markup when talking about terminal symbols in the language specification. file: [9b0fd2f0be] check-in: [8e1d4f3bb5] user: drh branch: trunk, size: 207726
2015-09-08
21:33
Improved documentation for table-valued functions and eponymous virtual tables. file: [7997897e63] check-in: [9b1f04e2d1] user: drh branch: trunk, size: 207264
18:41
Updates to the change log for 3.8.12. Add documentation for eponymous virtual tables, for table-valued functions, and other new capabilities. file: [1e249552e2] check-in: [456508e2ed] user: drh branch: trunk, size: 208297
16:25
Update language documentation to begin describing new features: (1) indexes on expressions (2) table-valued functions (3) column names on VIEWs. file: [2f78c545c7] check-in: [d9a422f858] user: drh branch: trunk, size: 208292
2015-09-07
10:53
Fix two typos. file: [4a78ebb3ae] check-in: [0506240273] user: drh branch: trunk, size: 205556
2015-06-17
15:59
Update the change log. Better fragments for matchinfo() flags. file: [25ddca3f48] check-in: [dcccfa67e1] user: drh branch: trunk, size: 205593
2015-05-15
14:51
Link from the ATTACH documentation page to the DETACH page. file: [797bd95f46] check-in: [b3cbd71993] user: drh branch: trunk, size: 205540
2015-03-27
10:58
Improved wording of a statement in the CREATE VIEW documentation. file: [4450b431a3] check-in: [629e137c8d] user: drh branch: trunk, size: 205439
2015-03-23
13:24
Escape less-than characters in code examples. file: [b175852449] check-in: [b6106e65ef] user: drh branch: trunk, size: 205423
2015-03-05
01:22
Fix a bug in matrix generation. Relax a restriction on the use of VALUES clauses - a restriction that did not actually apply. Fix a formatting problem in the FTS5 docs. file: [805a5f4a6c] check-in: [f61b2a7935] user: drh branch: trunk, size: 205408
2015-03-04
23:15
Clarifications on INDEXED BY documentation. Syntax diagrams which are default visible are always requirements even if they occur multiple times, but syntax diagrams that are default hidden now have the "data-noreq" attribute which prevents them from being marked as requirements. file: [17279fb42e] check-in: [000660158c] user: drh branch: trunk, size: 205455
20:56
Clarification of the "INSERT OR" and "REPLACE" forms of the INSERT statement. file: [30dec24c07] check-in: [58895ad201] user: drh branch: trunk, size: 205557
2015-03-03
18:11
Update so the alter table procedures. file: [11f42b0328] check-in: [615b0d3f7e] user: drh branch: trunk, size: 205556
2015-03-02
15:31
Remove SQLITE_INTERRUPT as a condition for which a manual ROLLBACK is recommended, as an automatic ROLLBACK always occurs following an interrupt. file: [541869ef59] check-in: [79f6b17595] user: drh branch: trunk, size: 205619
2015-02-11
17:28
Add a note to the date-time function documentation to say that the "s" at the end of modifiers like "days" is optional. file: [2c3d6c2d7b] check-in: [b800b2aa94] user: drh branch: trunk, size: 205715
2015-01-10
19:17
Update the change log. Add descriptions of the HAVE_* compile-time options to the copmile.html page. file: [e37f525a49] check-in: [5f01e4dd6c] user: drh branch: trunk, size: 205650
2015-01-05
21:38
Update the documentation to report that there is no limit on the number of terms in a VALUES clause. file: [b6c15f7974] check-in: [9cc86fd71d] user: drh branch: trunk, size: 205570
2014-12-03
15:50
Updates related to SQLITE_CHECKPOINT_TRUNCATE and especially to the PRAGMA wal_checkpoint documentation. file: [8e0f102744] check-in: [8418b34bb8] user: drh branch: trunk, size: 205510
2014-11-20
23:19
Fix a typo in the documention for abs(). file: [05f475a54d] check-in: [243484a535] user: drh branch: trunk, size: 205499
2014-11-12
01:43
Update the documentation to state that CTEs are not supported inside of triggers. file: [f33a358424] check-in: [a88023a792] user: drh branch: trunk, size: 205498
2014-11-11
21:11
Update ROLLBACK documentation to explain that SQLITE_ABORT_ROLLBACK is avoided for read operations if the schema is unchanged. file: [f050d1517a] check-in: [dbad62eafd] user: drh branch: trunk, size: 205369
2014-10-23
17:41
Change the documentation to show that ROWID values are preserved across a VACUUM. file: [3472c6f676] check-in: [f9a2ecb980] user: drh branch: trunk, size: 205099
2014-09-24
13:25
Clarify that bound parameters may not appear in the DEFAULT clause of a CREATE TABLE statement. file: [58d8ede46e] check-in: [d59078695f] user: drh branch: trunk, size: 205182
2014-08-15
00:49
Clarifications to the ON CONFLICT documentation. file: [5f454626b1] check-in: [445adeb211] user: drh branch: trunk, size: 205187
2014-08-14
13:06
Fix typos. file: [5dc059d43a] check-in: [09088d9a21] user: drh branch: trunk, size: 205248
2014-08-11
18:36
Updates to expression documentation. file: [afda3c8465] check-in: [5608ec77f8] user: drh branch: trunk, size: 205245
2014-08-08
21:27
Fix documentation errors and typos. file: [bd0fe336f7] check-in: [066b35fad5] user: drh branch: trunk, size: 205026
17:05
First complete draft of the "rescode.html" document. file: [9484227306] check-in: [e5ea14f1ff] user: drh branch: trunk, size: 204936
2014-08-07
13:22
General documentation updates. Attempts to provide better links and improve wording for better readability. file: [46d281c629] check-in: [430bf0b418] user: drh branch: trunk, size: 204921
2014-08-05
20:22
Update the change log for the latest changes. Make it easier to find the "How To Compile" documentation. Remove Nokia from the sponsors list. file: [d1f9220b91] check-in: [c22649df68] user: drh branch: trunk, size: 204782
2014-07-31
19:02
Clarification to the "Examples" section on the CREATE TRIGGER documentation page. file: [99cc97612a] check-in: [bd0aa2fc3b] user: drh branch: trunk, size: 204359
2014-07-24
15:36
Add a change log for version 3.8.6. Update the home page for version 3.8.6. file: [1b4b88143f] check-in: [0d81c00b9a] user: drh branch: trunk, size: 203479
14:27
Add documentation on the hexadecimal integer notation. file: [caa02100e0] check-in: [4656303de6] user: drh branch: trunk, size: 202906
13:50
Add documentation about the readfile() and writefile() extension functions in the command-line shell. Additional command-line shell documentation updates. file: [36f1cdfbb1] check-in: [d4097ee3bf] user: drh branch: trunk, size: 201576
2014-05-26
13:58
Fix typos in the new ALTER TABLE documentation and in the queryplanner.html document. file: [4a51c96c55] check-in: [be73465c0f] user: drh branch: trunk, size: 201555
11:56
Updates to the ALTER TABLE documentation. Provide a clear warning that RENAME TO does not rewrite referencing triggers and views. Provide two correct procedures for making other kinds of schema changes. file: [fba4e786aa] check-in: [d4418abf42] user: drh branch: trunk, size: 201690
2014-05-25
22:00
Revisions to the arbitrary table schema change text in ALTER TABLE. file: [7bdd4f2837] check-in: [b730943d19] user: drh branch: trunk, size: 197729
21:54
Add instructions for how to do arbitrary schema changes to the ALTER TABLE documentation. file: [da028964af] check-in: [227fb14d50] user: drh branch: trunk, size: 197614
2014-05-09
22:27
Fix typo in VALUES clause documentation in lang.html. file: [eb338063df] check-in: [fee01c2d5b] user: drh branch: trunk, size: 195341
2014-02-22
13:55
Clarification of what it means for the expression in a DEFAULT clause to be constant. file: [8667fb7e03] check-in: [0b36750358] user: drh branch: trunk, size: 195340
2014-02-20
16:09
Make sure bubble diagrams are all shown in the right places. file: [d1e5dd4d3b] check-in: [a67364e06f] user: drh branch: trunk, size: 195287
2014-02-12
19:36
Fix a mistake in the date/time function documentation. file: [8402694ede] check-in: [5cb71ea877] user: drh branch: trunk, size: 195195
2014-02-10
17:49
Fix a typo in the WITH documentation. file: [4ca42cd87d] check-in: [4cd3bb5ab2] user: drh branch: trunk, size: 195195
2014-02-06
16:52
Further clarification on the difference between recursive and ordinary CTEs. file: [4e29324528] check-in: [ecdd0d43d0] user: drh branch: trunk, size: 195197
13:25
Fix an example code error in the WITH documentation. file: [0de1f644db] check-in: [a6ce882b01] user: drh branch: trunk, size: 194947
2014-02-05
00:16
Fix a hyperlink in the SELECT documentation. file: [220511cea8] check-in: [1c86b01b95] user: drh branch: trunk, size: 194947
2014-01-30
20:51
Add the "factored-select-stmt" syntax diagram. Improve the way diagrams are hidden and shown. file: [835edf31b6] check-in: [fac98d12ae] user: drh branch: trunk, size: 194973
19:39
Make the "select-stmt" syntax diagram a closer fit to reality. file: [e690dc0388] check-in: [0c43e7efb4] user: drh branch: trunk, size: 195368
17:41
Fix FROM clause in the SELECT syntax diagrams. Also fix typos in the text. file: [48dd53a895] check-in: [a115a033da] user: drh branch: trunk, size: 195473
15:32
Additional clarification on syntax restrictions in SELECT statements. file: [b2c0da29f2] check-in: [4c5d78209a] user: drh branch: trunk, size: 195475
15:03
Further enhancements to the SELECT documentation. file: [ebcd466125] check-in: [979599b0b6] user: drh branch: trunk, size: 195250
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. file: [e2579512f3] check-in: [c14dc7c23b] user: drh branch: trunk, size: 193524
11:15
Additional hyperlinks to "compound SELECT", "ORDER BY" and "LIMIT". file: [051d0c1ef8] check-in: [1c8ccd6d21] user: drh branch: trunk, size: 191749
11:08
Clarification of the role of ORDER BY and LIMIT in compound SELECT statements. file: [7b72f7ec6e] check-in: [7b8d43a8ef] user: drh branch: trunk, size: 191684
2014-01-29
17:47
Update News and the change log. Bring the release date forward to 2014-02-03. Fix typos. Move older news entries out to oldnews.in. file: [69e83fce15] check-in: [ea6e1d11de] user: drh branch: trunk, size: 191253
13:52
Typo fix. CAST(...TO...) should be CAST(...AS...). file: [86fc69c0f8] check-in: [64427669a7] user: drh branch: trunk, size: 191200
2014-01-24
23:43
Fix typos in the WITH clause documentation reported on the mailing list. file: [52868800c7] check-in: [5415be54c0] user: drh branch: trunk, size: 191200
13:20
Add examples to WITH documentation showing how to control depth-first versus breath-first search of a tree using an ORDER BY clause on the recursive query. file: [014f3b2cab] check-in: [fb11eda20b] user: drh branch: trunk, size: 191212
04:05
Further refinement and cleanup of the WITH and SELECT documentation. file: [cd0558af3b] check-in: [2941cf658c] user: drh branch: trunk, size: 188954
01:20
First cut at WITH documentation. file: [05a28e9633] check-in: [2636279279] user: drh branch: trunk, size: 188252
2014-01-23
22:25
Incremental checkin of work on the common-table-expression documentation. file: [56f76ce56f] check-in: [52484ca596] user: drh branch: trunk, size: 177518
18:37
Refactoring many of the bubble syntax diagrams, especially related to SELECT. Attempting to make the bubble diagrams easier to follow. file: [7a3e5f1454] check-in: [9aa1b8df9b] user: drh branch: trunk, size: 168655
15:25
Recursive syntax diagram display. file: [09b64ee1b7] check-in: [87e7eb3d0d] user: drh branch: trunk, size: 168673
2014-01-17
23:50
Update the syntax bubble diagrams to show that the WITH clause is allowed. file: [9327a298a6] check-in: [3f48c6857f] user: drh branch: trunk, size: 169192
2014-01-15
03:02
Clarify some sentences in the documentation on ANALYZE. file: [6c32b5552c] check-in: [5fc1073e06] user: drh branch: trunk, size: 169170
2013-12-17
16:33
Documentation for the printf() SQL function. file: [0758c3e4e0] check-in: [9cbe2e4d08] user: drh branch: trunk, size: 169212
2013-11-27
19:20
Add a tentative news item for the 3.8.2 release. Updates to CAST documentation. Fix typos. file: [22afb42d2f] check-in: [825b2c6448] user: drh branch: trunk, size: 168461
2013-11-26
21:07
Change the documented behavior of casting a large real into an integer. file: [b8b424cee0] check-in: [f9d830d206] user: drh branch: trunk, size: 168007
2013-11-19
00:20
Update the list of keywords to include COVERING, WITH, and WITHOUT. COVERING and WITH are currently unused. file: [b94611bb57] check-in: [74e28675d4] user: drh branch: trunk, size: 167853
2013-11-18
18:48
Fix documentation typos pointed out on the mailing list by Philip Newton. file: [8dfc63fc67] check-in: [b8e6ac4ce4] user: drh branch: trunk, size: 167822
2013-11-11
23:27
Documentation updates associated with WITHOUT ROWID and the extension of the sqlite3_index_info object. file: [5d30a4a33d] check-in: [21034f356e] user: drh branch: trunk, size: 167783
2013-11-09
17:14
Add the WITHOUT ROWID document. Enhance the file-format, CREATE TABLE, and AUTOINCREMENT documents to reflect changes due to WITHOUT ROWID. file: [42e8715415] check-in: [ffe4c464ea] user: drh branch: trunk, size: 167753
2013-10-27
03:44
Fix a typo in the documentation for the ABS() function. file: [77711e0cee] check-in: [9e1d78e903] user: drh branch: trunk, size: 167824
2013-10-19
16:21
Updates to documentation for recent changes, especially the unlikely() function and STAT4. Also fix some typos. file: [56ef7dad2e] check-in: [0998ee24a4] user: drh branch: trunk, size: 167824
15:17
Add discussion and cautions on the use of TEMP triggers on non-TEMP tables. file: [403c3d0627] check-in: [59201e1cfb] user: drh branch: trunk, size: 167559
2013-10-16
23:58
Fix typos in documentation. file: [4c911f8f03] check-in: [df95e4e1ec] user: drh branch: trunk, size: 166464
2013-10-14
19:36
Add documentation for toInteger() and toReal(). file: [00d2d1ab39] check-in: [782c63b8f0] user: drh branch: trunk, size: 166971
2013-10-11
23:33
Improved documentation for DETACH - explain how behavior changes in shared cache mode. Update the makefile to scan the th3/core/*.c files for requirements marks. file: [0355b91896] check-in: [949c314919] user: drh branch: trunk, size: 166463
20:16
Improve the text (rephrasing, not changing the meaning) of some requirements related to functions and pragmas. Improve or correct requirements marks. file: [eaea4525f6] check-in: [77dee5dcd0] user: drh branch: trunk, size: 166324
2013-10-07
08:27
Add documentation on the optional timezone suffixes to timestrings in the date and time functions. file: [076257186e] check-in: [d4924d1139] user: drh branch: trunk, size: 166351
2013-09-19
14:14
Fix typos and enhance the text of documentation for 3.8.1 changes. file: [2547e93d51] check-in: [1d0df412df] user: drh branch: trunk, size: 165806
2013-09-16
13:32
Update the date and time function documentation to guarantee that 'now' is stable within a single sqlite3_step() call. file: [c6f37f6ecb] check-in: [a2842a55e9] user: drh branch: trunk, size: 165710
2013-09-13
22:03
Add documentation for unlikely(), likelihood() and the soft_heap_limit pragma. file: [90fd02b647] check-in: [dc4eae98aa] user: drh branch: trunk, size: 165561
2013-08-28
14:13
Add documentation for STAT4. file: [8038d9cd7c] check-in: [04ab4fa5ec] user: drh branch: trunk, size: 164542
2013-08-23
16:16
Fix documentation typos. file: [c0cd1ed77d] check-in: [ce2a4ec1e7] user: drh branch: trunk, size: 164360
2013-08-20
03:06
Revised and amplified definition of the tointeger() and toreal() functions. file: [b0cc39d603] check-in: [85757c1492] user: drh branch: toTypeFuncs, size: 165439
2013-08-19
21:17
Initial docs for tointeger() and toreal() SQL functions. file: [fbc6117260] check-in: [083cd58817] user: mistachkin branch: toTypeFuncs, size: 164715
2013-08-02
23:41
Updates to requirements marks. file: [695bc31c71] check-in: [498cd0709e] user: drh branch: trunk, size: 164360
2013-08-01
17:48
Fix the description of COLLATE operator precedence so that it is aligned with the implementation. file: [2cd4a0557b] check-in: [52366f9588] user: drh branch: trunk, size: 164361
2013-07-12
20:03
Add the isolation.in document. Other changes for 3.8.0. file: [270fdba399] check-in: [2eb277d7fc] user: drh branch: trunk, size: 164275
2013-07-01
16:07
Lots of tweaking and enhancements to the documentation, especially regarding the query planner and ways of controlling the query planner. file: [8ba6a2fd8f] check-in: [641e107a66] user: drh branch: trunk, size: 164205
2013-04-27
12:01
Updates to documentation, especially the C API introduction. file: [8edb4a7ac8] check-in: [f0275a9b47] user: drh branch: trunk, size: 162724
2013-04-17
12:58
Add a documentation page describing how to write run-time loadable extensions. file: [18ec46cbf0] check-in: [6da9f893bc] user: drh branch: trunk, size: 162606
2013-04-14
20:55
Fix a typo in the ON CONFLICT clause documentation. file: [a9d6f5a3b0] check-in: [0042260937] user: drh branch: trunk, size: 162604
2013-03-13
17:11
Documentation updates and typo fixes in preparation for the next release. file: [89bb1ccb7c] check-in: [d29bab5808] user: drh branch: trunk, size: 162603
2013-02-25
14:52
Add documentation for the unicode() and char() functions. file: [e570fbac59] check-in: [0b81bc6851] user: drh branch: trunk, size: 162603
2013-01-04
14:05
Fix the order of parameters in the documentation of the INSTR() function. file: [a0c4626798] check-in: [ffc982706c] user: drh branch: trunk, size: 162179
2012-12-11
19:11
Documentation typos fixed. file: [b0c57e37d9] check-in: [5d8312cd94] user: drh branch: trunk, size: 162179
2012-12-03
20:10
Tweaks to the change log in preparation for 3.7.15. file: [305a722a06] check-in: [50fc706041] user: drh branch: trunk, size: 162180
2012-10-15
20:39
Fix the INSERT documentation to describe the fact that the VALUES form of an INSERT can insert multiple rows. file: [cecc069653] check-in: [ee9ff30ec6] user: drh branch: trunk, size: 161620
2012-08-11
14:35
Fix typos on page onconflict.html: SQLITE_CONSTAIT -> SQLITE_CONSTRAINT and "proscribed" -> "specified by". file: [f9168ffc95] check-in: [81daf9c340] user: dan branch: trunk, size: 161514
2012-06-27
19:57
Clarification of the input time string formats for date/time functions. file: [4f496a4a77] check-in: [738f9af9ca] user: drh branch: trunk, size: 161511
2012-05-28
17:52
Improvements to shared cache hyperlinking and fixes to the URI parameter documentation. file: [7655d141d2] check-in: [918202f13d] user: drh branch: trunk, size: 160961
2012-05-11
17:01
Update the change history and news. And make some minor fixes to requirements text. file: [0e4111896e] check-in: [9778992724] user: drh branch: trunk, size: 160780
2012-03-29
14:14
Enhance the file format documentation with additional information about internal schema objects. file: [6b6a603840] check-in: [68d2666398] user: drh branch: trunk, size: 160757
2012-02-23
12:32
Fix a typo in the lang_keywords.html page. file: [543b069ce0] check-in: [f8a77cd24f] user: drh branch: trunk, size: 160374
2011-11-07
14:45
Start documentation for 3.7.10 by noting the change in DEFAULT_FILE_FORMAT. file: [7bc5934373] check-in: [50947bf51f] user: drh branch: trunk, size: 160375
2011-10-21
16:42
Documentation updates for the round() function. file: [8085577422] check-in: [81fe64736e] user: drh branch: trunk, size: 160264
2011-10-19
17:14
Add tentative release notes for 3.7.9. Update the documentation on the length() and upper() SQL functions. file: [5a99a31fcf] check-in: [bb404327e3] user: drh branch: trunk, size: 160310
2011-10-11
12:36
Fix requirements marks on ANALYZE documentation. file: [94daefc93b] check-in: [5eb8cc7380] user: drh branch: trunk, size: 159878
2011-10-07
23:26
Update documentation for SQLITE_ENABLE_STAT3. file: [550f118925] check-in: [4b78e06344] user: drh branch: trunk, size: 159879
2011-09-12
18:29
Remove stray "(" character from the ON CONFLICT documentation. file: [446ef28d3b] check-in: [dd27f660f9] user: drh branch: trunk, size: 159788
2011-06-20
23:51
More typo fixes. file: [a0502fbf0d] check-in: [8f9d1225b6] user: drh branch: trunk, size: 159789
21:48
Documentation typos. file: [5e7e0de24d] check-in: [b503d1f516] user: drh branch: trunk, size: 159790
19:49
Fix the ON CONFLICT documentation to avoid the erroneous implication that you can put an ON CONFLICT clause on a CHECK constraint. file: [de8ee14028] check-in: [11f4999021] user: drh branch: trunk, size: 159791
2011-06-04
23:20
Fix a missing end-requirement mark in the expression documentation. file: [b718fcadd0] check-in: [957ac800cf] user: drh branch: trunk, size: 159799
2011-05-31
11:56
Update the documentation to state that the LIMIT of a scalar subquery is always 1. file: [325753ce6e] check-in: [8d37b80354] user: drh branch: trunk, size: 159798
2011-05-13
16:57
Rather than document goofy behavior, better to make the behavior less goofy. (Was: Clarify in the documentation that last_insert_rowid() does not work for virtual tables.) file: [f7667b3599] check-in: [f102116e8a] user: drh branch: mistake, size: 159839
16:47
Add a requirement that CHECK constraints cannot contain subqueries. file: [d275d11d8e] check-in: [1f3d321253] user: drh branch: trunk, size: 159695
2011-05-11
19:01
Add documentation for URI filenames. Update capi3ref.in so that it is able to have [[label]] style anchors in the middle of a single documentation unit. file: [79ecd2246b] check-in: [66c5bcbaf8] user: drh branch: trunk, size: 159545
2011-04-20
10:46
Change CURRENT_DATETIME to CURRENT_TIMESTAMP in the documentation. Clarify the 32K-amalgamation description. file: [78dd1c24fa] check-in: [372f970213] user: drh branch: trunk, size: 159433
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. file: [5044d48ed5] check-in: [4fb953fec0] user: drh branch: trunk, size: 159432
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. file: [9a8f31b96d] check-in: [be0c879c12] user: drh branch: trunk, size: 159042
2010-12-01
11:23
Change a testable statement mark in lang.in. file: [d53d8a4dc9] check-in: [05fc2c982b] user: dan branch: trunk, size: 158586
2010-11-30
12:11
Minor changes to lang_dropview.html. Add section to lang.in describing resolution of object names. file: [9bc971612c] check-in: [6ec0e9720c] user: dan branch: trunk, size: 158589
2010-11-29
12:05
Change a sentence in lang_droptable.html. file: [7bd79f451b] check-in: [8c82296b21] user: dan branch: trunk, size: 155863
2010-11-21
01:36
Updates to documentation on date/time functions and pragmas. file: [c9431c125b] check-in: [2d231c8139] user: drh branch: trunk, size: 155734
2010-11-18
16:21
Update the documentation to be explicit that a parent key must not be a rowid. file: [a2f34e21b5] check-in: [d1edb27943] user: drh branch: trunk, size: 155742
2010-11-13
19:00
Move the examples on lang_explain.html to new document eqp.html. file: [7f2fc25813] check-in: [0c8678b577] user: dan branch: trunk, size: 155604
17:10
Update EXPLAIN QUERY PLAN examples to match changes to sqlite. file: [3af23d6e4d] check-in: [3f8c0a0c1f] user: dan branch: trunk, size: 166641
2010-11-12
17:40
Add evidence marks to examples on lang_explain.html. file: [b003a7713b] check-in: [360fe45245] user: dan branch: trunk, size: 166282
2010-11-11
17:47
Add extra documentation for EXPLAIN QUERY PLAN. file: [0d372b4abd] check-in: [759dfb93a1] user: dan branch: trunk, size: 166222
2010-11-10
18:43
Add some more documentation for EXPLAIN QUERY PLAN. file: [3b5ad2e43e] check-in: [37f6e9f261] user: dan branch: trunk, size: 164945
2010-10-08
16:09
Changes to lang_createtable.html. file: [393c27afb0] check-in: [dcfeca529f] user: dan branch: trunk, size: 155419
2010-10-01
19:03
Clarify that if a CHECK expression evaluates to NULL, it is not a constraint violation. file: [1b32cc8422] check-in: [217545f050] user: dan branch: trunk, size: 154295
2010-09-30
18:23
Fix a typo on lang_createtable.html. file: [c4bec0a0dc] check-in: [2d50d47170] user: dan branch: trunk, size: 154102
16:15
Added a syntax diagram for numeric literals, especially floating point literals. file: [d457b77ff3] check-in: [598ff451ef] user: drh branch: trunk, size: 154072
2010-09-29
18:22
Fix a problem with the definition of the DEFAULT clause on lang_conflict.html. file: [61d4fc13d8] check-in: [73b4c1e498] user: dan branch: trunk, size: 153681
11:10
Change "'CREATE TABLE AS' statements" to "'CREATE TABLE ... AS SELECT ...' statements" on lang_createtable.html. file: [7c40442f20] check-in: [4534ea5789] user: dan branch: trunk, size: 153496
01:38
Various documentation typo fixes and updates. file: [bc6e834ef8] check-in: [161f14d929] user: drh branch: trunk, size: 153474
2010-09-28
17:38
Changes to the CREATE TABLE documentation. file: [721ebe50e0] check-in: [2092d92251] user: dan branch: trunk, size: 153474
2010-09-24
18:59
Document the effect of the "REINDEX;" statement. file: [39447de435] check-in: [6405a81c7b] user: dan branch: trunk, size: 147056
17:58
Fixes and testability improvements to lang_vacuum.html. file: [6a8d616e8d] check-in: [91efaa0fc0] user: dan branch: trunk, size: 146822
07:59
Add a definition for interpreting the result of an expression as a boolean value (e.g. for WHERE or HAVING clauses) to lang_expr.html. Link to this from lang_update.html, lang_delete.html and lang_select.html instead of repeating the definition on each page. file: [3819f88f13] check-in: [36c1765653] user: dan branch: trunk, size: 145765
2010-09-23
18:46
Changes to lang_update.html. file: [75bd05a86e] check-in: [32506c4e82] user: dan branch: trunk, size: 145104
2010-09-21
16:58
Further changes to lang_update.html. file: [1bd35b9b9e] check-in: [e7259b8c39] user: dan branch: trunk, size: 143233
2010-09-20
19:09
Changes to lang_update.html to make it more testable. file: [173d492e49] check-in: [5df6adc2a9] user: dan branch: trunk, size: 141896
2010-09-18
18:52
Tweaks to lang_insert.html. file: [d3e00ec647] check-in: [15cc2204a5] user: dan branch: trunk, size: 140694
15:03
Remove the tags from a couple of untestable statements in lang_select.html. file: [1937767975] check-in: [0df9f2d381] user: dan branch: trunk, size: 139983
2010-09-16
18:50
Change the documentation for LIMIT and OFFSET clauses to be more testable. file: [dcc2529e80] check-in: [1cb27a268e] user: dan branch: trunk, size: 139985
2010-09-15
18:54
Changes to make the documentation for ORDER BY more testable. file: [406a564914] check-in: [095cad2463] user: dan branch: trunk, size: 138801
2010-09-14
18:57
Fix a recently introduced error regarding collation sequences and compounds SELECT statements. file: [7d67c74036] check-in: [8d9fe20890] user: dan branch: trunk, size: 137018
2010-09-13
18:56
Changes to SELECT documentation related to compound SELECT operators. file: [448cd5cf0b] check-in: [182ba19363] user: dan branch: trunk, size: 136901
2010-09-11
17:46
Change to requirement marks in lang.in. file: [2c81937a87] check-in: [b5882b3f8f] user: dan branch: trunk, size: 135889
2010-09-10
19:11
Minor changes to lang.in. file: [82e451e03a] check-in: [8efac9af2b] user: dan branch: trunk, size: 135883
2010-09-09
18:48
Change some testable statement formatting marks in lang.in. file: [217d1dd494] check-in: [a4b6b57093] user: dan branch: trunk, size: 135764
11:32
Combine two requirements into one in lang_select.html. file: [46442578c6] check-in: [85d1540336] user: dan branch: trunk, size: 135248
09:51
Fix a broken link in lang_select.html. file: [61e2c3ece4] check-in: [53081e3979] user: dan branch: trunk, size: 135292
2010-09-08
19:01
Clarifications to lang_select.html file: [d0ac11ddcd] check-in: [49e2c0eae6] user: dan branch: trunk, size: 135282
2010-09-07
14:58
Added link to the Belorussion translation of the FAQ. Added links from parameter binding to SQLITE_LIMIT_VARIABLE_NUMBER. Added section to the "How SQLite Is Tested" document describing disabled optimization tests. file: [2a6739b447] check-in: [71ae536af0] user: drh branch: trunk, size: 133437
2010-09-06
19:12
Fix some mistakes in lang_select.html. file: [b001f450d3] check-in: [55e829f468] user: dan branch: trunk, size: 133141
2010-09-04
18:36
Fix a couple of errors in the recent changes to lang_select.html. file: [b5d148a427] check-in: [b47f9e77a6] user: dan branch: trunk, size: 133044
2010-09-03
19:07
Changes to lang_select.html to make it more testable. file: [bbb7d4d78e] check-in: [2441ba87c8] user: dan branch: trunk, size: 132467
2010-09-02
19:21
Reword some testable statements related to scalar subqueries in lang_expr.html. file: [89168bd422] check-in: [573431382a] user: dan branch: trunk, size: 123915
11:52
Add section to lang_expr.html for the EXISTS operator. file: [06eb2452ed] check-in: [c8e9d99b1d] user: dan branch: trunk, size: 124166
04:20
More typo fixes. file: [bf4389df8b] check-in: [db66d3a1d4] user: shaneh branch: trunk, size: 123449
2010-08-28
05:48
Fix documentation typos. file: [6481e6a4ef] check-in: [78fe166463] user: shaneh branch: trunk, size: 123459
2010-08-27
11:20
Minor fixes to CAST documentation. file: [f18c4f4045] check-in: [302d0bb876] user: dan branch: trunk, size: 123459
2010-08-26
19:07
Changes to CAST expression documentation to make for more testable statements. file: [a71d12231d] check-in: [6c20f79cbc] user: dan branch: trunk, size: 123310
2010-08-24
13:11
Modifications to documentation for CASE expressions. file: [282f192f7c] check-in: [6c47d70dc0] user: dan branch: trunk, size: 122406
2010-08-14
12:25
Break a big testable statement in lang_expr.html into several smaller blocks. file: [0fdd5ddd13] check-in: [61d45eaf94] user: dan branch: trunk, size: 121853
2010-08-13
17:44
Enhancements to the description of how the COLLATE operator works. file: [aa0d770c1e] check-in: [17093bc7d6] user: drh branch: trunk, size: 121450
2010-08-09
15:45
Fix a bunch of documentation typos reported on the mailing list. file: [9b4d892141] check-in: [d9e242f92a] user: drh branch: trunk, size: 121046
2010-08-03
13:14
ON CONFLICT does in fact work with CHECK constraints. Fix the documentation to show this. The docs used to be right, but were broken by the prior check-in. file: [df328dde8a] check-in: [5395a69f2f] user: drh branch: trunk, size: 121040
02:26
Updates to language documentation. file: [2af87784d7] check-in: [c412626afe] user: drh branch: trunk, size: 120923
2010-08-02
18:03
Updates to documentation for ATTACH. file: [3993ed4d3d] check-in: [213b37eef1] user: drh branch: trunk, size: 120608
13:05
Always generate the SEARCH box on the website. file: [d2ae990c47] check-in: [09c7a61e1a] user: drh branch: trunk, size: 120868
2010-07-28
15:04
Add sqlite3_prepare16_v2() to the list of routines that accept SQL. file: [b394660ced] check-in: [83cbf2ca08] user: drh branch: trunk, size: 120838
2010-07-17
18:42
Minor changes to the 'Expressions' section of lang.in. file: [bb6b397647] check-in: [8ddf5c33ed] user: dan branch: trunk, size: 120811
15:42
Note in the docs that "+ NULL" is NULL. file: [fdd4ec6a7e] check-in: [29da1fe525] user: dan branch: trunk, size: 120420
2010-07-14
18:39
Improved documentation of the IN and NOT IN operators. Push back the 3.7.0 release date to 2010-07-22. file: [c9d5f5e79c] check-in: [07096801a3] user: drh branch: trunk, size: 120408
2010-06-29
16:05
Fix a typo in the date/time function documentation. file: [f8ff4a67bf] check-in: [cf14a52e82] user: drh branch: trunk, size: 118710
2010-06-15
12:50
Add the new book by Kay Droessler to the "Books About SQLite" page. file: [1c2b0549e1] check-in: [089a50e46d] user: drh branch: trunk, size: 118709
2010-02-26
15:39
Add documentation for sqlite3_compileoption_get() and related routines and pragmas. Fix up hyperlinks. file: [b87be6dac0] check-in: [4d3f01f58b] user: drh branch: trunk, size: 118629
2010-01-11
21:37
Reword the documentation on the changes() SQL function to be more precise. file: [2a25b36de3] check-in: [eb60d9c9d6] user: drh branch: trunk, size: 117923
2010-01-08
18:17
Corrections to substr() documentation text. Updates to the makefile. file: [19ba7f687d] check-in: [bdfb8d83ff] user: drh branch: trunk, size: 117852
16:08
Move anchors of core function definitions from the description to the function name. This gives better search results. file: [e12da27cd5] check-in: [ae27557119] user: drh branch: trunk, size: 117848
2010-01-07
15:58
Updates to the aggregate function documentation. file: [3bedadbcca] check-in: [716c872b13] user: drh branch: trunk, size: 117835
2010-01-06
23:32
Simplifications to the description of keywords. Avoid any decision of the keywords that can, sometimes, be used as identifiers because that adds nothing to the conversation. file: [f7252eed81] check-in: [a9db62dba3] user: drh branch: trunk, size: 117824
2010-01-05
23:31
Last minute changes before the 3.6.22 release. file: [844f0e539c] check-in: [25998dce13] user: drh branch: trunk, size: 119791
2010-01-02
03:20
Add ACTION and NO to the list of keywords in the lang_keywords.html document. Reformat the keyword lists into testable statements. file: [a33d8cc5d1] check-in: [8cad2470c0] user: drh branch: trunk, size: 119731
2009-12-24
21:37
Update and clarify the documentation on datatypes and on CAST expressions. file: [5f83aa2350] check-in: [e357f599e3] user: drh branch: trunk, size: 118421
2009-12-14
23:00
Identify requirements in the autoinc.html and datatype3.html documents. Make corrections in datatype3.html for accuracy and for clearer presentation. file: [561adb4399] check-in: [e18ce3ebd0] user: drh branch: trunk, size: 116174
17:41
For the requirements matrix, scan evidence marks in the original source code, not in the amalgamation. Updates to SQL comment documentation. file: [187bb581dd] check-in: [dca51f132e] user: drh branch: trunk, size: 116121
2009-12-13
23:03
Additional cleanup in the SQL language documentation. file: [740c05d67d] check-in: [d508b9e21c] user: drh branch: trunk, size: 116163
22:20
Updates to the SQL language documentation - mostly to fix requirements marks. file: [69d6a966ec] check-in: [b80a69c002] user: drh branch: trunk, size: 116052
2009-12-12
23:58
Continuing improvements to the SQL language documentation. file: [68617da1d1] check-in: [f9931b6e49] user: drh branch: trunk, size: 115893
18:29
Updates to the matrix generator so that it outputs prototype evidence comments for easy cut-and-paste into test cases. Rewrite the CASE section of the SQL expression documentation. file: [db787fa6bf] check-in: [01a939084b] user: drh branch: trunk, size: 116663
15:32
Fix some requirements markings. Changes the evidence scanner to understand that requirement text that begins with "--" is comment, not actual requirement text. file: [218d7bf1c1] check-in: [88da6668cb] user: drh branch: trunk, size: 116937
01:14
Add requirements markings and a section on the CASE expression to the SQL language documentation. file: [0c69c314ac] check-in: [ac0c9ef1a2] user: drh branch: trunk, size: 116934
2009-12-08
02:04
Further updates to the SQL function documentation. file: [e9dc24eeea] check-in: [e265a59cf0] user: drh branch: trunk, size: 113804
2009-12-07
23:47
Updates and clarifications to the built-in SQL function documentation. Mark key sentences in that documentation as requirements. file: [4142f2bd9a] check-in: [34346a758d] user: drh branch: trunk, size: 113660
2009-11-30
13:55
Fix typo on the famous.html page. Other updates prior to publication. file: [2f82914d05] check-in: [5572b2965d] user: drh branch: trunk, size: 111727
2009-11-28
13:11
Set the target release date for 3.6.21 to 2009-12-05 file: [f28b7e2d99] check-in: [8aa1114bbb] user: drh branch: trunk, size: 111708
2009-11-20
10:19
Clarify the documentation for ATTACH to note that it is not possible to attach the same database file twice while in shared-cache mode. file: [de346f1c1d] check-in: [6800ae21eb] user: dan branch: trunk, size: 111690
2009-11-12
05:15
Updated description for substr(). file: [66fb419b98] check-in: [2f8e06326a] user: shaneh branch: trunk, size: 111638
2009-11-05
12:20
Fix a typo in the CREATE TABLE documentation. file: [b3612bdca2] check-in: [0c09e6614f] user: drh branch: trunk, size: 111538
2009-11-02
15:50
Added the website keyword index. file: [5346145dad] check-in: [ec4a51db99] user: drh branch: trunk, size: 111539
2009-10-30
23:46
Documentation updates - attempting to make the website easier to navigate. file: [3d4976b707] check-in: [b243271f28] user: drh branch: trunk, size: 110879
2009-10-26
14:52
Add a "&#x27FE" mark after all hyperlinks to external websites. file: [779a8fa404] check-in: [4fb1b232ad] user: drh branch: trunk, size: 110857
2009-10-21
13:44
Fix a typo in the foreign key documentation. (This changes on requirement number.) Identify new requirements in SQL function implementations. file: [2ac96d4d7a] check-in: [00a66e6757] user: drh branch: trunk, size: 110961
2009-10-20
20:51
Update the documentation for the built-in replace() function to make it clear that it works with text strings only, and not blobs. file: [41cafb9a14] check-in: [dbf93ec2f9] user: drh branch: trunk, size: 110958
2009-10-14
02:43
Documentation updates prior to the release of version 3.6.19. file: [0b1dc05611] check-in: [9598affd43] user: drh branch: trunk, size: 110866
2009-10-10
15:40
Fix typo in hyperlink in date-time function documentation. file: [91d1e4888d] check-in: [dab9f1a7ac] user: drh branch: trunk, size: 110571
2009-10-09
13:33
Updates to Omitted Features. Add fragments to the foreign key document. Other documentation tweaks. file: [65344ea527] check-in: [fe28facf39] user: drh branch: trunk, size: 110571
2009-10-07
00:31
Update SQL language and foreign key documentation to better identify testable statements of truth about foreign keys. file: [87e6d2db85] check-in: [cc6bec4374] user: drh branch: trunk, size: 110501
2009-10-06
19:07
Add foreign key related statements to the documentation for the ALTER and DROP TABLE commands. file: [0dd21db207] check-in: [4ca8a0c958] user: dan branch: trunk, size: 110379
2009-09-21
01:41
Publish limitations on the 'unixepoch' modifier in the date and time functions. file: [9c60d72ab6] check-in: [90ac5bfac9] user: drh branch: trunk, size: 109197
2009-09-12
04:03
Mention in the date/time function documentation that dates outside the range 0000 through 9999 are unsupported. file: [7393b90c21] check-in: [62853a0196] user: drh branch: trunk, size: 108965
2009-09-09
16:22
Additional documentation updates in preparation for 3.6.18. file: [2b4fc6cdac] check-in: [ab3114e96d] user: drh branch: trunk, size: 108858
2009-09-07
20:06
Make it clear that BEFORE triggers that change rows out from under the subsequent UPDATE or DELETE will result in undefined behavior. file: [68e575dfeb] check-in: [a48fa42fae] user: drh branch: trunk, size: 108721
18:27
Add documentation of SQLITE_MAX_TRIGGER_DEPTH. file: [7af4c42fce] check-in: [df753f0371] user: drh branch: trunk, size: 108570
2009-08-26
02:00
Updates, clarifications, and typo fixes in the SQL language documentation. file: [b11366a6eb] check-in: [7b2b285803] user: drh branch: trunk, size: 108443
2009-08-22
02:53
Updates to the query planner documentation. file: [149eb22b4b] check-in: [ded8a7f88c] user: drh branch: trunk, size: 109311
2009-08-19
13:54
Fix a typo in the documentation of INSERT. Ticket [e07f262a63441]. file: [598b032a97] check-in: [6fbc1f9707] user: drh branch: trunk, size: 108473
2009-08-14
18:28
Add documentation for the sqlite_source_id() SQL function. file: [4a0c8d1d5f] check-in: [ad4301a8a1] user: drh branch: trunk, size: 108472
2009-07-29
23:07
Merge lang.html and vtab.html corrections that got marooned on a branch into the main line. file: [8f95fa3c56] check-in: [ab7c4f5247] user: drh branch: trunk, size: 107975
2009-07-03
15:38
Enhance the CREATE TRIGGER documentation to describe restrictions on INSERT, UPDATE, and DELETE statements that occur within triggers. CVS Ticket #3947. file: [9b05c1f39b] check-in: [b7dfcf7883] user: drh branch: trunk, size: 107920
2009-05-14
23:56
Miscellaneous documentation and hyperlink tweaks. file: [a393f1ed2d] check-in: [5856a03e9a] user: drh branch: trunk, size: 104825
18:12
Changed lang.html to use hd_resolve for linkage rather than crafted links. file: [2cc5ccb5fc] check-in: [17a3eefb66] user: shaneh branch: trunk, size: 104413
2009-05-11
17:41
Document the goofy behavior of PRIMARY KEY(x DESC) still allowing x to be a rowid if it is of type INTEGER. file: [f17416571e] check-in: [b354d15151] user: drh branch: trunk, size: 104205
2009-04-30
16:00
Update the DELETE documentation to discuss the truncation optimization. file: [ae9ca5537c] check-in: [dcd3325dd3] user: drh branch: trunk, size: 103345
2009-04-29
14:33
Update trigger documentation. file: [fee7a3514c] check-in: [1179f9425f] user: drh branch: trunk, size: 102950
2009-04-20
17:43
Update documentation to describe how pragma journal_mode will work as long as there is no pending transaction. file: [53cc266a4e] check-in: [8bb233e0af] user: drh branch: trunk, size: 102527
2009-04-13
14:43
Further enhancements to the virtual table documentation. file: [964a95293c] check-in: [ebd923dab6] user: drh branch: trunk, size: 102434
12:58
Initial check-in of documentation on the virtual table interface. file: [5d76a8fa34] check-in: [0776bf4007] user: drh branch: trunk, size: 102379
2009-04-02
02:23
Add documentation on the changes() and total_changes() SQL functions. file: [bfa706cf6e] check-in: [71bdfb826a] user: drh branch: trunk, size: 102341
2009-03-22
20:48
Mark the INDEXED token as being usable as an object name. file: [559ea70c44] check-in: [d2a68d4718] user: drh branch: trunk, size: 101878
2009-03-05
21:46
Fixed some typos and spelling mistakes. file: [7afe367ba3] check-in: [832ea9eb72] user: shaneh branch: trunk, size: 101877
2009-03-04
12:20
Fix spelling of precede and preceding in a few places. Cvs ticket 3700. file: [0a178617f6] check-in: [67c02fcc03] user: dan branch: trunk, size: 101879
2009-02-14
19:00
Tweaks to the syntax diagrams to make them more readable. file: [21d0e4d4de] check-in: [b28d410e7d] user: drh branch: trunk, size: 101882
2009-02-13
15:09
Additional hyperlinks associated with shared cache mode and limits. file: [639a3f3530] check-in: [1762225ee3] user: drh branch: trunk, size: 101856
2009-02-05
02:33
Enhancements to the SQL language documentation. file: [b4fff53dc0] check-in: [c8dc1e13d7] user: drh branch: trunk, size: 102138
2009-02-04
23:29
Documentation changes in preparation for the 3.6.11 release. file: [08ce9883e2] check-in: [b9fd0996f1] user: drh branch: trunk, size: 101087
2009-02-02
02:15
Clarifications to core function documentation. file: [3fb61133a7] check-in: [1747b46fb5] user: drh branch: trunk, size: 100405
2009-01-29
19:28
Update the keyword list and description in the language documentation. CVSTrac ticket #3612. file: [2b49e18e46] check-in: [561c52b85b] user: drh branch: trunk, size: 100494
2009-01-16
12:11
Add SAVEPOINT and RELEASE to the list of SQL keywords. file: [c41a111049] check-in: [83b399eb79] user: dan branch: trunk, size: 99522
2009-01-02
17:36
Updating documentation for version 3.6.8. file: [c2a63b72b8] check-in: [0a327982e8] user: drh branch: trunk, size: 99498
2008-12-15
22:49
Attempt to do a better job of explaining INTEGER PRIMARY KEY. file: [7d3cb35422] check-in: [47171588ec] user: drh branch: trunk, size: 94016
18:30
Enhanced documentation for INTEGER PRIMARY KEY. file: [7cbdd326e6] check-in: [a3dc852796] user: drh branch: trunk, size: 94120
2008-11-16
09:30
(no comment) file: [67aaabefe6] check-in: [656cbb6058] user: dan branch: trunk, size: 92793
2008-11-12
14:58
Add a "binary operators" hyperlink name and fragment. file: [07534601fb] check-in: [8e5c5d7ab7] user: drh branch: trunk, size: 92792
14:55
Updates in preparation for the 3.6.5 release. Added documentation on the precedence of LIKE operators and on the BETWEEN operator. file: [7c390d5285] check-in: [bef59c46f7] user: drh branch: trunk, size: 92740
2008-11-05
18:07
Documentation updates to describe recent changes to the way COMMIT and ROLLBACK operate. file: [11c353e306] check-in: [f4f19b5484] user: drh branch: trunk, size: 92316
2008-11-04
21:54
Spelling error in documentation of "vacuum" command. Ticket #3475. file: [c0c415993f] check-in: [6af724d84f] user: shaneh branch: trunk, size: 91626
2008-11-01
03:11
Consistent OS names and capitalization. Fixed typos. Added SQLITE_DISABLE* options to compile.in. Added links on the news.in page for versions. file: [84fed70f61] check-in: [0c5af9d973] user: shaneh branch: trunk, size: 91626
2008-10-29
01:31
Fix problems with the syntax diagrams. Added the new sql-stmt-list syntax diagram. file: [d33822ae3d] check-in: [0fa64d8eb0] user: drh branch: trunk, size: 91626
2008-10-28
21:26
Update documentation to describe recent changes on the truncate optimization and on memory allocation. file: [97bcc90140] check-in: [cd968e8e43] user: drh branch: trunk, size: 91361
2008-10-15
19:58
Fix for CVS ticket #3441. Looks like some prior changes got into this checkin too - they should have been checked in previously. file: [d1a0218078] check-in: [0cab86593f] user: drh branch: trunk, size: 91420
2008-10-10
23:47
Add documentation on the SQLITE_OMIT_TRUNCATE_OPTIMIZATION compile-time option. file: [ada0129c1a] check-in: [0e3d036dea] user: drh branch: trunk, size: 90714
2008-10-08
01:10
Fix a typo in changes.html. Begin adding changes for the next release. file: [77be1496eb] check-in: [d1cef237a2] user: drh branch: trunk, size: 90573
2008-10-07
20:12
Explain that truncate optimization of the DELETE statement disables triggers and that the LIMIT clause disables the truncate optimization. file: [9860470daa] check-in: [2e9edb204a] user: drh branch: trunk, size: 90557
20:01
Update language documentation to contain information about INDEXED BY and the LIMIT clause on UPDATE and DELETE. Updated information on the SQLITE_MAX_FUNCTION_ARG compile-time option. file: [047956c150] check-in: [e61538e201] user: drh branch: trunk, size: 90372
2008-10-03
22:48
Add test describing the surprising (but correct) behavior of the 'NNN month' modifier in the date and time functions. CVS ticket #3411. http://www.sqlite.org/cvstrac/tktview?tn=3411 file: [09614bd912] check-in: [e493a37cfc] user: drh branch: trunk, size: 87273
19:37
Implement community-suggested edits to the SQL language documentation. file: [7ce86a89eb] check-in: [2628a04ba8] user: drh branch: trunk, size: 86794
02:18
Updates to the language documentation. Added syntax diagrams for comments and for SQL statements. file: [cd581b4baf] check-in: [d16fcfeef7] user: drh branch: trunk, size: 86761
00:56
Add the syntaxdiagrams.html page to the documentation. Updates to the language documentation pages to talk about the LIMIT and ORDER BY clauses on DELETE and UPDATE. file: [b59a7cad4c] check-in: [289df32643] user: drh branch: trunk, size: 85296
2008-10-02
18:04
Replace BNF with bubble diagrams in the language definition pages. Still a lot of text to update. file: [2e5fe3445a] check-in: [c1cdac9b55] user: drh branch: trunk, size: 85488
14:49
Fix a typo in the documentation of the lower() SQL function. file: [3e36d7c045] check-in: [31aaf2c3f5] user: drh branch: trunk, size: 90135
2008-09-24
18:52
Trying for improvements in the appearance of the syntax in lang*.html. file: [5e449e1c1c] check-in: [4bae4cc5b7] user: drh branch: trunk, size: 90135
17:49
Fix a bug in the CREATE TRIGGER documentation. file: [c60d1bba6f] check-in: [2f8b2b9ead] user: drh branch: trunk, size: 90136
2008-08-12
18:10
Updates to the LIKE and GLOB documentation. CVSTrac ticket #3290. file: [d16f81d588] check-in: [ec08a46c8b] user: drh branch: trunk, size: 90135
2008-08-08
15:46
Continuing work on syntax requirements. This is just an incremental check-in. file: [58b1484f92] check-in: [b45c611781] user: drh branch: trunk, size: 89883
2008-07-16
18:58
Add documentation on the enable_load_extension method in the TCL interface. file: [1bfc81dc61] check-in: [13bb521f7e] user: drh branch: trunk, size: 89797
2008-07-12
20:35
Updates to SQL language documentatioon and the 3.5-to-3.6 document. file: [581198edfb] check-in: [0869739eb5] user: drh branch: trunk, size: 89771
2008-07-10
16:52
Add documentation on SQLITE_ENABLE_MEMSYS3/5. file: [2e446fd205] check-in: [ecf5c9238d] user: drh branch: trunk, size: 88827
2008-06-28
13:31
Copy the date+time function documentation out of the wiki. file: [9afa4dea8b] check-in: [5178724f27] user: drh branch: trunk, size: 88816
2008-06-25
12:48
Fixed #2051 file: [37d8198150] check-in: [83e99e89a8] user: mihailim branch: trunk, size: 81623
2008-04-27
17:51
Updates to the SQL language documentation with many added hyperlink targets. file: [589c1e9eac] check-in: [f060763119] user: drh branch: trunk, size: 81622
15:10
Updates to the CREATE TABLE documentation. file: [52a320e0d6] check-in: [be570dc031] user: drh branch: trunk, size: 82418
2008-04-15
01:32
Update the keyword list. CVSTrac ticket #3054. file: [c1339d7d53] check-in: [1b43c0419c] user: drh branch: trunk, size: 82418
2008-03-08
12:38
Fix typo in the GROUP BY documentation. file: [b18f24ad50] check-in: [9b7284faf3] user: drh branch: trunk, size: 82388
2007-12-20
23:01
Additional work toward denser hyperlinking in the documentation. file: [bcd285ed67] check-in: [aa8a072b1b] user: drh branch: trunk, size: 82389
03:29
An attempt to get automatic hyperlinking working on all web pages. The website builds, but there are still many problems. file: [a8aee09b98] check-in: [16b1f03012] user: drh branch: trunk, size: 82022
2007-12-18
18:09
SQLite does not have an ! operator. CVSTrac ticket #2849. file: [f05116cc9d] check-in: [253e0c9a09] user: drh branch: trunk, size: 82051
2007-12-14
17:56
Documentation updates for version 3.5.4 file: [14e0d126d8] check-in: [f19019f745] user: drh branch: trunk, size: 82056
2007-11-28
22:22
Add documentation for the group_concat() function. file: [77b81f35b9] check-in: [2fc1269200] user: drh branch: trunk, size: 81061
16:24
Fix hyperlink errors in the documentation. CVSTrac ticket #2807. file: [0e063cbdc7] check-in: [10fa1f2eea] user: drh branch: trunk, size: 80711
2007-11-21
14:00
Fix broken links in the SQL Syntax document. CVSTrac ticket #2783. file: [53008dd307] check-in: [4f5adc7af2] user: drh branch: trunk, size: 80712
2007-11-14
03:14
Changes capi3ref.html references to c3ref/ pages everywhere. file: [7383dec5e1] check-in: [c3a14fe2c7] user: drh branch: trunk, size: 80397
2007-11-13
15:08
Fix the lang.html document. file: [20a97b0196] check-in: [a7f37fc58d] user: drh branch: trunk, size: 80524
2007-11-12
15:32
Complete reorganization of the documentation sources. file: [a8e0d4a36d] check-in: [275febef8f] user: drh branch: trunk, size: 81449 Added