Documentation Source Text

History for pages/lang.in
Login

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

History for pages/lang.in

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