/ History for www/lang.tcl
Login

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

History for www/lang.tcl

2007-10-12
19:11
[e015c489] part of check-in [4a807d48] Make the 3rd parameter of the SUBSTR() function optional. Ticket #2579. (CVS 4486) (check-in: [4a807d48] user: drh branch: trunk, size: 81565)
2007-10-03
20:15
[1c1e7573] part of check-in [84616a13] Update documentation to talk about the response to errors within an explicit transaction. (CVS 4460) (check-in: [84616a13] user: drh branch: trunk, size: 81444)
2007-10-01
17:45
[a2ee1ee2] part of check-in [ebe3e691] Document that END TRANSACTION is an alias for COMMIT. Ticket #2656 (CVS 4451) (check-in: [ebe3e691] user: drh branch: trunk, size: 79900)
13:45
[df99415f] part of check-in [b2befc84] Add text to the load_extension SQL function documentation that explains limitations in the use of that function. Ticket #2672. (CVS 4446) (check-in: [b2befc84] user: drh branch: trunk, size: 79850)
2007-08-09
00:00
[bb73892b] part of check-in [4333b231] Fix documentation typos. Tickets #2168 and #2560. (CVS 4201) (check-in: [4333b231] user: drh branch: trunk, size: 79308)
2007-07-13
10:35
[d32eef14] part of check-in [d111b1da] Update documentation to make it clear that VACUUM is free to change implicit rowids. Ticket #2382. (CVS 4157) (check-in: [d111b1da] user: drh branch: trunk, size: 79308)
2007-06-15
18:59
[e481e68b] part of check-in [b55318b1] Fix more documentation typos. Ticket #2416. (CVS 4076) (check-in: [b55318b1] user: drh branch: trunk, size: 79095)
12:16
[49ef3e6d] part of check-in [5232fd29] Documentation updates in preparation for 3.4.0. (CVS 4064) (check-in: [5232fd29] user: drh branch: trunk, size: 79094)
2007-05-15
01:13
[8dde95ed] part of check-in [75d57308] The built-in substr() function applied to a BLOB counts bytes, not characters. (CVS 3997) (check-in: [75d57308] user: drh branch: trunk, size: 78742)
2007-04-06
11:26
[26a38c36] part of check-in [8e2559b4] The FOR EACH STATEMENT clause in a trigger is now a syntax error. It used to be silently ignored. STATEMENT is no longer a keyword. (CVS 3821) (check-in: [8e2559b4] user: drh branch: trunk, size: 78717)
2007-03-27
15:00
[dc4dedf0] part of check-in [c61c97c9] Updates to the VACUUM documentation. Ticket #2257. (CVS 3728) (check-in: [c61c97c9] user: drh branch: trunk, size: 78752)
2007-03-17
18:22
[d449e4dc] part of check-in [d42c9636] Add documentation of the REPLACE, TRIM, LTRIM, and RTRIM functions. (CVS 3699) (check-in: [d42c9636] user: drh branch: trunk, size: 78447)
2007-03-09
14:43
[cf204b6d] part of check-in [570533c1] Remove extra heading accidentally added to lang.tcl by (3677). (CVS 3678) (check-in: [570533c1] user: danielk1977 branch: trunk, size: 77212)
14:40
[0e74378b] part of check-in [485c52dd] Add a few "class" attributes to the html generated by lang.tcl to support conversion to pdf. (CVS 3677) (check-in: [485c52dd] user: danielk1977 branch: trunk, size: 77259)
2007-03-08
12:23
[f76b1853] part of check-in [d03d4805] Change the documentation to be more specific about the restriction on the use of keywords. Ticket #2264. (CVS 3676) (check-in: [d03d4805] user: drh branch: trunk, size: 76929)
2007-02-13
02:03
[5e7888c2] part of check-in [7799a0b6] Changes in preparation for version 3.3.13. (CVS 3637) (check-in: [7799a0b6] user: drh branch: trunk, size: 76690)
2007-02-01
23:02
[65d0aa78] part of check-in [85cca7cd] First cut at adding the COLLATE operator. Regression tests pass (or at least the quick set does) and a few new tests have been added. But many more tests are needed. Rules for combining collations need to be worked out. (CVS 3624) (check-in: [85cca7cd] user: drh branch: trunk, size: 76641)
2007-01-29
17:58
[aa6d5996] part of check-in [f5ad74a9] Replace the randomHex() function with separate functions randomBlob() and hex(). (CVS 3620) (check-in: [f5ad74a9] user: drh branch: trunk, size: 76390)
15:50
[ccbd38d9] part of check-in [a6001589] Add the randomhex() function as a built-in. (CVS 3619) (check-in: [a6001589] user: drh branch: trunk, size: 76393)
2006-09-23
20:46
[fb107025] part of check-in [58c32ce3] Fix documentation typo. Ticket #1986 (CVS 3437) (check-in: [58c32ce3] user: drh branch: trunk, size: 76010)
2006-09-11
23:45
[73ce7ce6] part of check-in [e4fe736c] Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406) (check-in: [e4fe736c] user: drh branch: trunk, size: 76010)
2006-08-29
13:08
[529f5f0f] part of check-in [b99d845e] Document the fact that SQLite allows NULL values in PRIMARY KEY columns and the fact that we might design to change this in the future. Ticket #518. (CVS 3373) (check-in: [b99d845e] user: drh branch: trunk, size: 75938)
2006-08-16
22:58
[2cdc7d6a] part of check-in [d4f182e5] Remove obsolete clause in the documentation. Ticket #1923. (CVS 3356) (check-in: [d4f182e5] user: drh branch: trunk, size: 75276)
2006-06-26
10:37
[d5414bd9] part of check-in [df601a7b] Syntax documentation updates. (CVS 3294) (check-in: [df601a7b] user: drh branch: trunk, size: 75350)
2006-06-17
14:12
[432ee67f] part of check-in [e08e2dda] Add the load_extension() SQL function. (CVS 3269) (check-in: [e08e2dda] user: drh branch: trunk, size: 73433)
2006-05-31
11:12
[46d34df0] part of check-in [fba8ce8c] Fix typo in lang_analyze.html. (CVS 3195) (check-in: [fba8ce8c] user: drh branch: trunk, size: 72388)
2006-03-15
16:26
[9fe2b8bb] part of check-in [c0d20fa9] Fix CHECK constraints to use alternative conflict resolution. Ticket #1717. (CVS 3137) (check-in: [c0d20fa9] user: drh branch: trunk, size: 72391)
2006-02-15
17:30
[53a3643f] part of check-in [3eca2d98] Mention the NOT unary operator in the documentation. (CVS 3099) (check-in: [3eca2d98] user: drh branch: trunk, size: 72309)
2006-02-11
17:34
[03c852ea] part of check-in [1c3e6002] I give up. SUM() now throws an error on integer overflow. Those of us who think this is goofy can use TOTAL() instead. Tickets #1664, #1669, #1670, #1674. (CVS 3084) (check-in: [1c3e6002] user: drh branch: trunk, size: 72302)
2006-02-09
22:13
[8761d4ce] part of check-in [9e04f8fd] SUM never gives an error. An integer result is returned for exact results and a floating point result is returned for approximate results. Tickets #1664, #1669, and #1670. (CVS 3066) (check-in: [9e04f8fd] user: drh branch: trunk, size: 72198)
2006-01-30
23:04
[3f7472e7] part of check-in [669bcf5a] Remove support for the non-standard ON CONFLICT clause on CREATE INDEX. Ticket #1486. The ON CONFLICT clause has never worked on CREATE INDEX so removing it should not break anything. (CVS 3042) (check-in: [669bcf5a] user: drh branch: trunk, size: 71721)
2006-01-23
18:14
[ce9de23a] part of check-in [d4e4ba13] Add documentation on the IF NOT EXISTS clause to CREATE statements. Ticket #1608. (CVS 3010) (check-in: [d4e4ba13] user: drh branch: trunk, size: 72333)
2006-01-12
22:17
[b3561af8] part of check-in [a7f528ff] Add support for the TOTAL() aggregate function - works like SUM() except that it returns 0 instead of NULL when presented with an empty list. (CVS 2930) (check-in: [a7f528ff] user: drh branch: trunk, size: 72031)
2006-01-04
15:58
[6f81b272] part of check-in [963ba8b8] Update document for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS (CVS 2856) (check-in: [963ba8b8] user: drh branch: trunk, size: 71992)
2005-12-29
01:11
[b6f6c058] part of check-in [a4c547de] Add support for DROP TABLE IF EXISTS. (CVS 2843) (check-in: [a4c547de] user: drh branch: trunk, size: 71964)
2005-11-14
11:51
[7015a521] part of check-in [c9b413ea] Fix documentation typo. (CVS 2765) (check-in: [c9b413ea] user: drh branch: trunk, size: 71837)
2005-11-03
00:41
[6ec7f6f3] part of check-in [2313d912] First cut at supporting CHECK constraints. Everything appears to work, but much more testing is needed as well as documentation. (CVS 2754) (check-in: [2313d912] user: drh branch: trunk, size: 71838)
2005-09-11
11:56
[b04a87ce] part of check-in [2f397bd8] COUNT(DISTINCT x) is now fully functional, though it could benefit from additional testing. (CVS 2688) (check-in: [2f397bd8] user: drh branch: trunk, size: 71953)
2005-09-08
20:37
[7fd48a2d] part of check-in [62818594] SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678) (check-in: [62818594] user: drh branch: trunk, size: 71571)
2005-08-28
17:00
[422b21b8] part of check-in [ef84ff79] The LIKE optimization does the right thing when collating sequences are present. LIKE expressions where the left-hand side has COLLATE NOCASE are optimized in the default case. (CVS 2637) (check-in: [ef84ff79] user: drh branch: trunk, size: 71031)
2005-08-23
11:03
[9e27ecd2] part of check-in [55f4b14e] Fix another documentation typo. (CVS 2614) (check-in: [55f4b14e] user: drh branch: trunk, size: 70983)
11:00
[0bf7cee2] part of check-in [990d1f3a] Fix typos in syntax documentation. Ticket #1374 and a report on the mailing list. (CVS 2613) (check-in: [990d1f3a] user: drh branch: trunk, size: 70983)
2005-07-23
02:17
[d55f580c] part of check-in [bd7583a5] Full-coverage testing and documentation for the ANALYZE command. The results of analysis are still not loaded or used, however. (CVS 2561) (check-in: [bd7583a5] user: drh branch: trunk, size: 70973)
2005-07-22
23:56
[e0b9c55b] part of check-in [1a573619] Clarify the meaning of the TEMP keyword on CREATE TABLE. (CVS 2559) (check-in: [1a573619] user: drh branch: trunk, size: 69966)
2005-06-26
20:00
[81310355] part of check-in [d5392866] Update SQL syntax documentation to describe the new CAST expressions. (CVS 2531) (check-in: [d5392866] user: drh branch: trunk, size: 69958)
2005-06-25
19:42
[0083a59d] part of check-in [3dcdb794] Documentation fixes. Ticket #1306. (CVS 2529) (check-in: [3dcdb794] user: drh branch: trunk, size: 66854)
18:42
[be57d5f2] part of check-in [17631785] Remove the blob(), text() and numeric() functions added in (2524) and replace them with the standard CAST operator. Ticket #1287. (CVS 2527) (check-in: [17631785] user: drh branch: trunk, size: 66959)
2005-05-10
16:11
[727b4769] part of check-in [748771a8] Fix a typo in the CREATE TABLE documentation. (CVS 2457) (check-in: [748771a8] user: drh branch: trunk, size: 66955)
2005-03-21
01:24
[b121bfd6] part of check-in [38897a50] fix typo in CREATE VIEW documentation. Ticket #1135. (CVS 2411) (check-in: [38897a50] user: drh branch: trunk, size: 66937)
00:28
[5b4c9528] part of check-in [59892be6] Fix a formatting error in the syntax documentation. Ticket #1145. (CVS 2406) (check-in: [59892be6] user: drh branch: trunk, size: 66919)
2005-03-19
14:45
[074e2d08] part of check-in [90a00e90] Preparations for the release of version 3.2.0. (CVS 2400) (check-in: [90a00e90] user: drh branch: trunk, size: 67228)
01:41
[1f58511c] part of check-in [e53c7726] Updates to comments and documentation. No changes to code. (CVS 2398) (check-in: [e53c7726] user: drh branch: trunk, size: 67041)
2005-03-17
05:03
[21cb28be] part of check-in [94185dd4] Add the ALTER TABLE ... ADD COLUMN command. (CVS 2393) (check-in: [94185dd4] user: danielk1977 branch: trunk, size: 66836)
2005-02-19
12:44
[0e5aeb09] part of check-in [76cacb4a] Add documentation on the EXISTS expression. Ticket #1082. (CVS 2353) (check-in: [76cacb4a] user: drh branch: trunk, size: 66074)
2005-02-14
06:38
[fad1d8d1] part of check-in [41d2214b] Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329) (check-in: [41d2214b] user: danielk1977 branch: trunk, size: 65697)
2005-01-24
23:27
[aeb76706] part of check-in [557eb2ec] Clarify documentation of DEFAULT CURRENT_TIME etc. (version 3.1.0 and greater only). (CVS 2274) (check-in: [557eb2ec] user: danielk1977 branch: trunk, size: 65697)
2005-01-10
06:39
[a79b222f] part of check-in [5b7a5a4d] Update some documentation for version 3.1. (CVS 2188) (check-in: [5b7a5a4d] user: danielk1977 branch: trunk, size: 65640)
2004-11-21
01:02
[9670e34e] part of check-in [ac72a1d5] AUTOINCREMENT documentation added. Improvements to lang.html. (CVS 2129) (check-in: [ac72a1d5] user: drh branch: trunk, size: 63808)
2004-11-20
08:17
[b2d8272b] part of check-in [aceaa5f6] Documentation for REINDEX and ALTER TABLE commands. (CVS 2118) (check-in: [aceaa5f6] user: danielk1977 branch: trunk, size: 62280)
2004-11-19
11:59
[aa6ccee5] part of check-in [ea315668] Split up the lang.html page into a seperate page for each command. (CVS 2116) (check-in: [ea315668] user: danielk1977 branch: trunk, size: 60328)
2004-11-16
23:21
[4b229400] part of check-in [e05f52d9] Clarify the LIMIT clause in the documentation. Ticket #1002. (CVS 2105) (check-in: [e05f52d9] user: drh branch: trunk, size: 59131)
2004-11-11
01:50
[59da2e00] part of check-in [c85f13f8] Add documentation for DEFAULT CURRENT_TIME & co. (CVS 2088) (check-in: [c85f13f8] user: danielk1977 branch: trunk, size: 58773)
2004-11-10
05:48
[7904dbc2] part of check-in [fe200eaf] Add user documentation for the "pragma auto_vacuum" command. (CVS 2084) (check-in: [fe200eaf] user: danielk1977 branch: trunk, size: 58135)
2004-10-10
17:24
[ba4fbca6] part of check-in [16e2ace2] Typos and spelling errors in documention. (CVS 2014) (check-in: [16e2ace2] user: drh branch: trunk, size: 69853)
2004-10-05
02:41
[dde78c14] part of check-in [81ff8107] Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) (check-in: [81ff8107] user: drh branch: trunk, size: 69848)
2004-09-08
13:06
[604683de] part of check-in [799f5383] Documentation updates. (CVS 1946) (check-in: [799f5383] user: drh branch: trunk, size: 68111)
2004-07-18
20:52
[b2ba4011] part of check-in [166234a2] min() ignores NULL values. Ticket #800. (CVS 1802) (check-in: [166234a2] user: drh branch: trunk, size: 67503)
2004-06-18
11:25
[5193e27d] part of check-in [61db159c] Fix typos and minor errors in lang.tcl. (CVS 1616) (check-in: [61db159c] user: danielk1977 branch: trunk, size: 67442)
2004-06-17
19:04
[608a3504] part of check-in [9fb29f73] Documentation updates in preparation for the release of version 3.0.0. (CVS 1613) (check-in: [9fb29f73] user: drh branch: trunk, size: 67069)
2004-05-31
15:06
[fc528581] part of check-in [2052911b] Website redesign in preparation for adding version 3 documentation. (CVS 1506) (check-in: [2052911b] user: drh branch: trunk, size: 68882)
2004-04-23
17:04
[17954f37] part of check-in [7ace5762] Get the temp_store and default_temp_store pragmas working. Update the documentation. Also fix a malloc problem that popped up during the regression testing. (CVS 1302) (check-in: [7ace5762] user: drh branch: trunk, size: 69145)
2004-01-19
05:09
[6cb027f5] part of check-in [06bd5070] documented pragma foreign_key_list(). updated docs for removed behavior: Oracle join syntax and temp indexes. (CVS 1193) (check-in: [06bd5070] user: jplyon branch: trunk, size: 69072)
2003-07-20
01:16
[5f39bbda] part of check-in [543479e3] Fix the LIMIT clause so that it applies to the entire query in a compound query. Prior to this change LIMITs on compound queries did not work at all. Ticket #393. (CVS 1058) (check-in: [543479e3] user: drh branch: trunk, size: 67584)
2003-07-16
11:51
[06b825c1] part of check-in [a31d0bd9] Make LIMIT 0 return no rows. LIMIT -1 still returns all rows. Ticket #346. (CVS 1053) (check-in: [a31d0bd9] user: drh branch: trunk, size: 67393)
2003-06-15
23:49
[2890eb85] part of check-in [38461a7a] Update the documentation to reflect the new capabilities of PRAGMA integrity_check. Rewording in the VACUUM documentation. (CVS 1025) (check-in: [38461a7a] user: drh branch: trunk, size: 67389)
10:29
[860e881d] part of check-in [6c24dfba] Documented integer values used by PRAGMAs. Fixed missing end tags in generated anchors. (CVS 1022) (check-in: [6c24dfba] user: jplyon branch: trunk, size: 67327)
2003-06-08
08:36
[f206cb1b] part of check-in [190252fe] Documented SQL fns IFNULL() and NULLIF(). (CVS 1015) (check-in: [190252fe] user: jplyon branch: trunk, size: 66535)
2003-06-07
08:56
[bc92ee5c] part of check-in [685a179a] Hyperlinks and minor additions/corrections for lang.tcl (CVS 1011) (check-in: [685a179a] user: jplyon branch: trunk, size: 66075)
2003-05-29
04:21
[0d3037b9] part of check-in [8b8fa0ff] Added typeof() operator. Minor additions for ATTACH/DETACH. (CVS 987) (check-in: [8b8fa0ff] user: jplyon branch: trunk, size: 65807)
2003-05-17
01:39
[4a22a96c] part of check-in [0874814a] Bump the version number to 2.8.1. Update documentation prior to release. (CVS 978) (check-in: [0874814a] user: drh branch: trunk, size: 65241)
2003-05-10
02:54
[bb945a10] part of check-in [2bbb0804] Fixed metacharacter coloring with LP, RP, PLUS. Added more links. (CVS 962) (check-in: [2bbb0804] user: jplyon branch: trunk, size: 65253)
2003-05-07
13:37
[4cec7ec6] part of check-in [ca75f1ca] Format keyword lists in lang.html using a TCL proc. (CVS 961) (check-in: [ca75f1ca] user: drh branch: trunk, size: 64424)
04:04
[bbd268bb] part of check-in [55ae7b35] - Added entries for PRAGMAs database_list, temp_store and default_temp_store. - Fixed missing end tags. (CVS 960) (check-in: [55ae7b35] user: jplyon branch: trunk, size: 64021)
03:59
[46b42bd1] part of check-in [bb609f96] Cleaned up keywords section. (CVS 959) (check-in: [bb609f96] user: jplyon branch: trunk, size: 61567)
2003-05-04
07:02
[56f4c199] part of check-in [87e1b6a9] new section for keywords, more docs for attached databases , links, cleanup (CVS 952) (check-in: [87e1b6a9] user: jplyon branch: trunk, size: 60459)
2003-05-03
19:04
[46fb1a38] part of check-in [24b9b569] More documentation updates. (CVS 951) (check-in: [24b9b569] user: drh branch: trunk, size: 55879)
04:55
[1852abb0] part of check-in [fd28c522] - added entry for ATTACH DATABASE. - added entry for DETACH DATABASE. - added soundex() function. - added some new TEMP modifiers. - added new VACUUM behavior. - added the Oracle8 outer join "(+)" syntax. - documented the modulus/remainder operator %. - added ALL as alternative to DISTINCT in SELECT. - fixed assignment list in UPDATE to use * metacharacter. - fixed value in PRAGMA to be optional. - added link from INSERT topic to REPLACE. - added optional CONSTRAINT <name> before column constraints. - skip 2 lines before each Section in the TCL source. (CVS 950) (check-in: [fd28c522] user: jplyon branch: trunk, size: 55281)
2003-02-13
02:54
[9bd9380d] part of check-in [e05a7a55] Update the documentation for the new journal format to be introduced in version 2.8.0. (CVS 865) (check-in: [e05a7a55] user: drh branch: trunk, size: 52643)
2003-01-29
22:58
[7ad51d87] part of check-in [af1e9299] Additional testing and bug fixing with the non-callback API. Updated the C/C++ interface document to describe the non-callback API. (CVS 855) (check-in: [af1e9299] user: drh branch: trunk, size: 52269)
2003-01-26
15:28
[1c11172b] part of check-in [c957f4f0] Added section on comments. Corrected broken end tags. (CVS 851) (check-in: [c957f4f0] user: jplyon branch: trunk, size: 52007)
2003-01-11
14:19
[1ea38a9f] part of check-in [e84d3afe] Document the SHOW_DATATYPES pragma and add tests for it to the test suite. Make sure datatypes are show even for aliased columns. Tickets #220 and #221. (CVS 822) (check-in: [e84d3afe] user: drh branch: trunk, size: 51090)
2002-09-12
14:08
[6be4254a] part of check-in [ef711675] Update the SQL language documentation to talk about SELECT DISTINCT. (CVS 748) (check-in: [ef711675] user: drh branch: trunk, size: 49943)
2002-08-25
20:11
[bf9d830a] part of check-in [e2d95f85] Documentation updates prior to the releae of 2.7.0. (CVS 728) (check-in: [e2d95f85] user: drh branch: trunk, size: 49932)
2002-08-18
19:09
[d2be2be0] part of check-in [e372a60b] Documentation updates. (CVS 720) (check-in: [e372a60b] user: drh branch: trunk, size: 48828)
2002-08-15
11:48
[a2785964] part of check-in [048b16c1] Additional test cases and documentation updates. (CVS 717) (check-in: [048b16c1] user: drh branch: trunk, size: 49080)
2002-08-14
00:08
[902f6772] part of check-in [4ff0f578] Update documentation to better explain the typelessness of SQLite and to describe the distinction between text and numeric data. (CVS 711) (check-in: [4ff0f578] user: drh branch: trunk, size: 49082)
2002-06-25
01:09
[8c3d0bda] part of check-in [9c1432bf] Added support for the "sqlite_temp_master" table. Increased the version number to 2.5.2. (CVS 640) (check-in: [9c1432bf] user: drh branch: trunk, size: 49017)
2002-06-12
22:33
[cf22bf18] part of check-in [3387d5b6] Fix for bug #70: Correct a typo in the documentation. (CVS 616) (check-in: [3387d5b6] user: drh branch: trunk, size: 48870)
2002-06-11
22:33
[da8057ac] part of check-in [10da1361] Documentation that should have been checked in along with checkin (614) (CVS 615) (check-in: [10da1361] user: danielk1977 branch: trunk, size: 48879)
2002-06-06
23:30
[e25a7d38] part of check-in [a0abef62] Fix for ticket #59: Add documentation for the || operator. Also added documentation for the new SQL92 join syntax. (CVS 608) (check-in: [a0abef62] user: drh branch: trunk, size: 47838)
2002-05-28
06:55
[bbff2feb] part of check-in [5e74d096] Update trigger2.test to match checkin 591. Also fix ticket #51 (by documenting problem) (CVS 595) (check-in: [5e74d096] user: danielk1977 branch: trunk, size: 47505)
2002-05-26
23:24
[e87aa6b3] part of check-in [d9e48cd5] Require the INSTEAD OF syntax to create triggers on database views. (CVS 591) (check-in: [d9e48cd5] user: danielk1977 branch: trunk, size: 47075)
2002-05-15
11:43
[be7a241f] part of check-in [d1d8642b] In the "lang.html" documentation file, put the CREATE TRIGGER and DROP TRIGGER sections in alphabetical order. (CVS 564) (check-in: [d1d8642b] user: drh branch: trunk, size: 46879)
08:30
[a22cf9ef] part of check-in [794bf67b] Added FOR EACH ROW triggers functionality (CVS 562) (check-in: [794bf67b] user: danielk1977 branch: trunk, size: 46889)
2002-05-06
11:47
[d47800eb] part of check-in [cc541b10] Added documentation about the new CASE expression. (CVS 552) (check-in: [cc541b10] user: drh branch: trunk, size: 42447)
2002-04-12
10:08
[2d465425] part of check-in [6e71493b] Fix for bug #15: Add the sqlite_changes() API function for retrieving the number of rows that changed in the previous operation. (CVS 526) (check-in: [6e71493b] user: drh branch: trunk, size: 42504)
2002-04-06
14:10
[75615f1a] part of check-in [6aca3f86] Added the last_insert_rowid() SQL function. (CVS 521) (check-in: [6aca3f86] user: drh branch: trunk, size: 42360)
13:57
[52a54be9] part of check-in [28ce42f7] Make the FROM clause on a SELECT optional. If omitted, the result of the SELECT is a single row consisting of the values in the expression list. (CVS 520) (check-in: [28ce42f7] user: drh branch: trunk, size: 42088)
2002-03-28
14:20
[e6c27748] part of check-in [f0f241e1] Two typos fixed in the documentation (lang.html). (CVS 502) (check-in: [f0f241e1] user: drh branch: trunk, size: 41957)
2002-03-11
02:06
[d589f9a3] part of check-in [9f5b241c] Preparing for the 2.4.0 release. (CVS 426) (check-in: [9f5b241c] user: drh branch: trunk, size: 41956)
2002-03-04
02:26
[db13f9a9] part of check-in [36a8fe0a] Updates to the documentation. Changed version number to 2.4.0-beta1 (CVS 417) (check-in: [36a8fe0a] user: drh branch: trunk, size: 39080)
2002-02-19
22:42
[01e47b43] part of check-in [1686196a] New ROWIDs are numbered sequentially. (CVS 383) (check-in: [1686196a] user: drh branch: trunk, size: 35123)
13:39
[abf67afe] part of check-in [c6e9048e] Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) (check-in: [c6e9048e] user: drh branch: trunk, size: 35118)
2002-02-18
18:30
[1712d94f] part of check-in [78a50971] Add support for CREATE TABLE AS. (CVS 377) (check-in: [78a50971] user: drh branch: trunk, size: 35262)
03:21
[4865287a] part of check-in [607c0c49] Test and documentation updates for sub-queries. (CVS 373) (check-in: [607c0c49] user: drh branch: trunk, size: 34810)
2002-02-03
19:06
[58077cb0] part of check-in [20ea7375] Fix a serious bug in INSERT when the source is a SELECT. (CVS 366) (check-in: [20ea7375] user: drh branch: trunk, size: 34653)
00:56
[260f3f90] part of check-in [0115518f] Five-algorithm conflict resolution appears to be working. (CVS 363) (check-in: [0115518f] user: drh branch: trunk, size: 33970)
2002-01-31
15:54
[7ad59524] part of check-in [d0e7cf4a] Change to five conflict resolution algorithms: ROLLBACK, ABORT, FAIL, IGNORE, and REPLACE. This checkin is code only. Documentation and tests are still needed. Also, ABORT is not fully implemented. (CVS 360) (check-in: [d0e7cf4a] user: drh branch: trunk, size: 30485)
2002-01-30
16:17
[f04d7401] part of check-in [cf1538d7] Added ON CONFLICT support to COPY. Updates to documentation. Bug fixes. (CVS 359) (check-in: [cf1538d7] user: drh branch: trunk, size: 30280)
2001-12-22
19:27
[6843fd3f] part of check-in [14392258] Update documentation for the 2.2.0 release. (CVS 335) (check-in: [14392258] user: drh branch: trunk, size: 26586)
2001-11-24
13:50
[6482d90e] part of check-in [3be8a189] Fix typos. (CVS 320) (check-in: [3be8a189] user: drh branch: trunk, size: 25836)
13:23
[87ba0166] part of check-in [f1a58082] Update the FAQ. Change the GMT timezone label to UTC on all files. (CVS 318) (check-in: [f1a58082] user: drh branch: trunk, size: 25726)
2001-11-06
14:10
[f0e953bf] part of check-in [17701224] Added support for LIMIT. (CVS 302) (check-in: [17701224] user: drh branch: trunk, size: 25726)
2001-10-19
16:44
[1899ec4f] part of check-in [8467d84f] Version 2.0.6 (CVS 291) (check-in: [8467d84f] user: drh branch: trunk, size: 25452)
2001-10-15
00:44
[37d4a44b] part of check-in [747bf1b3] Added support for the COUNT_CHANGES pragma in order to help out the ODBC driver. Fixed a but on count(*) when applied to empty tables. (CVS 289) (check-in: [747bf1b3] user: drh branch: trunk, size: 24861)
2001-10-13
02:59
[8cf5de0e] part of check-in [75e90cf0] 2.0.3 (CVS 287) (check-in: [75e90cf0] user: drh branch: trunk, size: 23642)
2001-10-08
13:22
[3a7900e3] part of check-in [9368c62e] Support for temporary tables added. Still need more testing. (CVS 279) (check-in: [9368c62e] user: drh branch: trunk, size: 23105)
2001-09-28
17:47
[33a74d72] part of check-in [1df5386a] Version 2.0.0 (CVS 272) (check-in: [1df5386a] user: drh branch: trunk, size: 21005)
2001-09-20
01:44
[d093693d] part of check-in [d2a1aac4] 2.0-Alpha-2 release (CVS 258) (check-in: [d2a1aac4] user: drh branch: trunk, size: 20794)
2001-05-21
13:45
[0969ba9f] part of check-in [523d52df] :-) (CVS 218) (check-in: [523d52df] user: drh branch: trunk, size: 21845)
2001-04-04
11:48
[7fec4144] part of check-in [35a8feed] Added transaction support (CVS 196) (check-in: [35a8feed] user: drh branch: trunk, size: 21553)
2001-02-20
13:06
[e3905bec] part of check-in [d44abe54] Documentation updates only (CVS 189) (check-in: [d44abe54] user: drh branch: trunk, size: 19010)
2000-08-04
13:49
[9192e114] part of check-in [ab9c533a] :-) (CVS 125) (check-in: [ab9c533a] user: drh branch: trunk, size: 18233)
2000-06-09
14:14
[1645e910] part of check-in [d573b431] :-) (CVS 91) (check-in: [d573b431] user: drh branch: trunk, size: 18232)
03:47
[d694c3f3] part of check-in [3252269e] :-) (CVS 88) (check-in: [3252269e] user: drh branch: trunk, size: 9927)
01:58
[eb6a297c] part of check-in [3661b5ff] :-) (CVS 87) (check-in: [3661b5ff] user: drh branch: trunk, size: 7733)
2000-06-08
21:53
[2abf9ac0] part of check-in [049abcb3] :-) (CVS 86) (check-in: [049abcb3] user: drh branch: trunk, size: 6375) Added