SQLite

All files named ”www/lang.tcl”
Login

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

History for www/lang.tcl

2008-05-26
20:19
Deleted: Update the amalgamation builder to incorporate the RTREE extension. (CVS 5160) (check-in: [aa8eba3360] user: drh branch: trunk, size: 0)
2007-10-12
19:11
[e015c489a3] part of check-in [4a807d48ea] Make the 3rd parameter of the SUBSTR() function optional. Ticket #2579. (CVS 4486) (check-in: [4a807d48ea] user: drh branch: trunk, size: 81565)
2007-10-03
20:15
[1c1e7573dc] part of check-in [84616a13af] Update documentation to talk about the response to errors within an explicit transaction. (CVS 4460) (check-in: [84616a13af] user: drh branch: trunk, size: 81444)
2007-10-01
17:45
[a2ee1ee272] part of check-in [ebe3e6913c] Document that END TRANSACTION is an alias for COMMIT. Ticket #2656 (CVS 4451) (check-in: [ebe3e6913c] user: drh branch: trunk, size: 79900)
13:45
[df99415fca] part of check-in [b2befc84c3] Add text to the load_extension SQL function documentation that explains limitations in the use of that function. Ticket #2672. (CVS 4446) (check-in: [b2befc84c3] user: drh branch: trunk, size: 79850)
2007-08-09
00:00
[bb73892bf9] part of check-in [4333b231af] Fix documentation typos. Tickets #2168 and #2560. (CVS 4201) (check-in: [4333b231af] user: drh branch: trunk, size: 79308)
2007-07-13
10:35
[d32eef14c4] part of check-in [d111b1daa5] Update documentation to make it clear that VACUUM is free to change implicit rowids. Ticket #2382. (CVS 4157) (check-in: [d111b1daa5] user: drh branch: trunk, size: 79308)
2007-06-15
18:59
[e481e68bc1] part of check-in [b55318b12d] Fix more documentation typos. Ticket #2416. (CVS 4076) (check-in: [b55318b12d] user: drh branch: trunk, size: 79095)
12:16
[49ef3e6dfc] part of check-in [5232fd29d0] Documentation updates in preparation for 3.4.0. (CVS 4064) (check-in: [5232fd29d0] user: drh branch: trunk, size: 79094)
2007-05-15
01:13
[8dde95ed76] part of check-in [75d573080d] The built-in substr() function applied to a BLOB counts bytes, not characters. (CVS 3997) (check-in: [75d573080d] user: drh branch: trunk, size: 78742)
2007-04-06
11:26
[26a38c36ec] part of check-in [8e2559b4da] 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: [8e2559b4da] user: drh branch: trunk, size: 78717)
2007-03-27
15:00
[dc4dedf00d] part of check-in [c61c97c978] Updates to the VACUUM documentation. Ticket #2257. (CVS 3728) (check-in: [c61c97c978] user: drh branch: trunk, size: 78752)
2007-03-17
18:22
[d449e4dc25] part of check-in [d42c963620] Add documentation of the REPLACE, TRIM, LTRIM, and RTRIM functions. (CVS 3699) (check-in: [d42c963620] user: drh branch: trunk, size: 78447)
2007-03-09
14:43
[cf204b6da4] part of check-in [570533c1ef] Remove extra heading accidentally added to lang.tcl by (3677). (CVS 3678) (check-in: [570533c1ef] user: danielk1977 branch: trunk, size: 77212)
14:40
[0e74378b42] part of check-in [485c52ddc0] Add a few "class" attributes to the html generated by lang.tcl to support conversion to pdf. (CVS 3677) (check-in: [485c52ddc0] user: danielk1977 branch: trunk, size: 77259)
2007-03-08
12:23
[f76b1853bf] part of check-in [d03d480544] Change the documentation to be more specific about the restriction on the use of keywords. Ticket #2264. (CVS 3676) (check-in: [d03d480544] user: drh branch: trunk, size: 76929)
2007-02-13
02:03
[5e7888c2d3] part of check-in [7799a0b63d] Changes in preparation for version 3.3.13. (CVS 3637) (check-in: [7799a0b63d] user: drh branch: trunk, size: 76690)
2007-02-01
23:02
[65d0aa787a] part of check-in [85cca7cd25] 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: [85cca7cd25] user: drh branch: trunk, size: 76641)
2007-01-29
17:58
[aa6d599679] part of check-in [f5ad74a9bc] Replace the randomHex() function with separate functions randomBlob() and hex(). (CVS 3620) (check-in: [f5ad74a9bc] user: drh branch: trunk, size: 76390)
15:50
[ccbd38d959] part of check-in [a6001589ab] Add the randomhex() function as a built-in. (CVS 3619) (check-in: [a6001589ab] user: drh branch: trunk, size: 76393)
2006-09-23
20:46
[fb1070256c] part of check-in [58c32ce35a] Fix documentation typo. Ticket #1986 (CVS 3437) (check-in: [58c32ce35a] user: drh branch: trunk, size: 76010)
2006-09-11
23:45
[73ce7ce69e] part of check-in [e4fe736cfb] Add support for IF EXISTS on CREATE/DROP TRIGGER/VIEW. Ticket #1899. (CVS 3406) (check-in: [e4fe736cfb] user: drh branch: trunk, size: 76010)
2006-08-29
13:08
[529f5f0f44] part of check-in [b99d845ef4] 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: [b99d845ef4] user: drh branch: trunk, size: 75938)
2006-08-16
22:58
[2cdc7d6a89] part of check-in [d4f182e5aa] Remove obsolete clause in the documentation. Ticket #1923. (CVS 3356) (check-in: [d4f182e5aa] user: drh branch: trunk, size: 75276)
2006-06-26
10:37
[d5414bd9f6] part of check-in [df601a7b37] Syntax documentation updates. (CVS 3294) (check-in: [df601a7b37] user: drh branch: trunk, size: 75350)
2006-06-17
14:12
[432ee67f75] part of check-in [e08e2ddafe] Add the load_extension() SQL function. (CVS 3269) (check-in: [e08e2ddafe] user: drh branch: trunk, size: 73433)
2006-05-31
11:12
[46d34df01c] part of check-in [fba8ce8c38] Fix typo in lang_analyze.html. (CVS 3195) (check-in: [fba8ce8c38] user: drh branch: trunk, size: 72388)
2006-03-15
16:26
[9fe2b8bb0a] part of check-in [c0d20fa97f] Fix CHECK constraints to use alternative conflict resolution. Ticket #1717. (CVS 3137) (check-in: [c0d20fa97f] user: drh branch: trunk, size: 72391)
2006-02-15
17:30
[53a3643fe8] part of check-in [3eca2d9868] Mention the NOT unary operator in the documentation. (CVS 3099) (check-in: [3eca2d9868] user: drh branch: trunk, size: 72309)
2006-02-11
17:34
[03c852ea4e] part of check-in [1c3e6002cd] 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: [1c3e6002cd] user: drh branch: trunk, size: 72302)
2006-02-09
22:13
[8761d4ce0d] part of check-in [9e04f8fdf1] 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: [9e04f8fdf1] user: drh branch: trunk, size: 72198)
2006-01-30
23:04
[3f7472e77a] part of check-in [669bcf5ab6] 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: [669bcf5ab6] user: drh branch: trunk, size: 71721)
2006-01-23
18:14
[ce9de23a66] part of check-in [d4e4ba132a] Add documentation on the IF NOT EXISTS clause to CREATE statements. Ticket #1608. (CVS 3010) (check-in: [d4e4ba132a] user: drh branch: trunk, size: 72333)
2006-01-12
22:17
[b3561af8d8] part of check-in [a7f528ff34] 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: [a7f528ff34] user: drh branch: trunk, size: 72031)
2006-01-04
15:58
[6f81b2726d] part of check-in [963ba8b8f3] Update document for CREATE INDEX IF NOT EXISTS and DROP INDEX IF EXISTS (CVS 2856) (check-in: [963ba8b8f3] user: drh branch: trunk, size: 71992)
2005-12-29
01:11
[b6f6c0584a] part of check-in [a4c547de83] Add support for DROP TABLE IF EXISTS. (CVS 2843) (check-in: [a4c547de83] user: drh branch: trunk, size: 71964)
2005-11-14
11:51
[7015a52116] part of check-in [c9b413ea22] Fix documentation typo. (CVS 2765) (check-in: [c9b413ea22] user: drh branch: trunk, size: 71837)
2005-11-03
00:41
[6ec7f6f325] part of check-in [2313d912ba] First cut at supporting CHECK constraints. Everything appears to work, but much more testing is needed as well as documentation. (CVS 2754) (check-in: [2313d912ba] user: drh branch: trunk, size: 71838)
2005-09-11
11:56
[b04a87ce05] part of check-in [2f397bd814] COUNT(DISTINCT x) is now fully functional, though it could benefit from additional testing. (CVS 2688) (check-in: [2f397bd814] user: drh branch: trunk, size: 71953)
2005-09-08
20:37
[7fd48a2d18] part of check-in [6281859425] SUM returns NULL when it has no inputs. Ticket #1413. (CVS 2678) (check-in: [6281859425] user: drh branch: trunk, size: 71571)
2005-08-28
17:00
[422b21b899] part of check-in [ef84ff795c] 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: [ef84ff795c] user: drh branch: trunk, size: 71031)
2005-08-23
11:03
[9e27ecd2a2] part of check-in [55f4b14e19] Fix another documentation typo. (CVS 2614) (check-in: [55f4b14e19] user: drh branch: trunk, size: 70983)
11:00
[0bf7cee29c] part of check-in [990d1f3a5b] Fix typos in syntax documentation. Ticket #1374 and a report on the mailing list. (CVS 2613) (check-in: [990d1f3a5b] user: drh branch: trunk, size: 70983)
2005-07-23
02:17
[d55f580cff] part of check-in [bd7583a5d6] Full-coverage testing and documentation for the ANALYZE command. The results of analysis are still not loaded or used, however. (CVS 2561) (check-in: [bd7583a5d6] user: drh branch: trunk, size: 70973)
2005-07-22
23:56
[e0b9c55bf1] part of check-in [1a573619f5] Clarify the meaning of the TEMP keyword on CREATE TABLE. (CVS 2559) (check-in: [1a573619f5] user: drh branch: trunk, size: 69966)
2005-06-26
20:00
[81310355cb] part of check-in [d5392866bf] Update SQL syntax documentation to describe the new CAST expressions. (CVS 2531) (check-in: [d5392866bf] user: drh branch: trunk, size: 69958)
2005-06-25
19:42
[0083a59de9] part of check-in [3dcdb7942e] Documentation fixes. Ticket #1306. (CVS 2529) (check-in: [3dcdb7942e] user: drh branch: trunk, size: 66854)
18:42
[be57d5f23a] part of check-in [17631785f9] Remove the blob(), text() and numeric() functions added in (2524) and replace them with the standard CAST operator. Ticket #1287. (CVS 2527) (check-in: [17631785f9] user: drh branch: trunk, size: 66959)
2005-05-10
16:11
[727b4769fb] part of check-in [748771a8ad] Fix a typo in the CREATE TABLE documentation. (CVS 2457) (check-in: [748771a8ad] user: drh branch: trunk, size: 66955)
2005-03-21
01:24
[b121bfd638] part of check-in [38897a509a] fix typo in CREATE VIEW documentation. Ticket #1135. (CVS 2411) (check-in: [38897a509a] user: drh branch: trunk, size: 66937)
00:28
[5b4c95284d] part of check-in [59892be6a4] Fix a formatting error in the syntax documentation. Ticket #1145. (CVS 2406) (check-in: [59892be6a4] user: drh branch: trunk, size: 66919)
2005-03-19
14:45
[074e2d08fb] part of check-in [90a00e9066] Preparations for the release of version 3.2.0. (CVS 2400) (check-in: [90a00e9066] user: drh branch: trunk, size: 67228)
01:41
[1f58511c7e] part of check-in [e53c77268c] Updates to comments and documentation. No changes to code. (CVS 2398) (check-in: [e53c77268c] user: drh branch: trunk, size: 67041)
2005-03-17
05:03
[21cb28bee6] part of check-in [94185dd4f7] Add the ALTER TABLE ... ADD COLUMN command. (CVS 2393) (check-in: [94185dd4f7] user: danielk1977 branch: trunk, size: 66836)
2005-02-19
12:44
[0e5aeb0986] part of check-in [76cacb4a39] Add documentation on the EXISTS expression. Ticket #1082. (CVS 2353) (check-in: [76cacb4a39] user: drh branch: trunk, size: 66074)
2005-02-14
06:38
[fad1d8d12b] part of check-in [41d2214b83] Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329) (check-in: [41d2214b83] user: danielk1977 branch: trunk, size: 65697)
2005-01-24
23:27
[aeb7670655] part of check-in [557eb2ec9d] Clarify documentation of DEFAULT CURRENT_TIME etc. (version 3.1.0 and greater only). (CVS 2274) (check-in: [557eb2ec9d] user: danielk1977 branch: trunk, size: 65697)
2005-01-10
06:39
[a79b222f29] part of check-in [5b7a5a4d69] Update some documentation for version 3.1. (CVS 2188) (check-in: [5b7a5a4d69] user: danielk1977 branch: trunk, size: 65640)
2004-11-21
01:02
[9670e34e0a] part of check-in [ac72a1d551] AUTOINCREMENT documentation added. Improvements to lang.html. (CVS 2129) (check-in: [ac72a1d551] user: drh branch: trunk, size: 63808)
2004-11-20
08:17
[b2d8272bc8] part of check-in [aceaa5f6e9] Documentation for REINDEX and ALTER TABLE commands. (CVS 2118) (check-in: [aceaa5f6e9] user: danielk1977 branch: trunk, size: 62280)
2004-11-19
11:59
[aa6ccee5ad] part of check-in [ea315668e5] Split up the lang.html page into a seperate page for each command. (CVS 2116) (check-in: [ea315668e5] user: danielk1977 branch: trunk, size: 60328)
2004-11-16
23:21
[4b2294003e] part of check-in [e05f52d907] Clarify the LIMIT clause in the documentation. Ticket #1002. (CVS 2105) (check-in: [e05f52d907] user: drh branch: trunk, size: 59131)
2004-11-11
01:50
[59da2e0053] part of check-in [c85f13f8f2] Add documentation for DEFAULT CURRENT_TIME & co. (CVS 2088) (check-in: [c85f13f8f2] user: danielk1977 branch: trunk, size: 58773)
2004-11-10
05:48
[7904dbc269] part of check-in [fe200eaf37] Add user documentation for the "pragma auto_vacuum" command. (CVS 2084) (check-in: [fe200eaf37] user: danielk1977 branch: trunk, size: 58135)
2004-10-10
17:24
[ba4fbca634] part of check-in [16e2ace2db] Typos and spelling errors in documention. (CVS 2014) (check-in: [16e2ace2db] user: drh branch: trunk, size: 69853)
2004-10-05
02:41
[dde78c1415] part of check-in [81ff8107ad] Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) (check-in: [81ff8107ad] user: drh branch: trunk, size: 69848)
2004-09-08
13:06
[604683def6] part of check-in [799f5383c0] Documentation updates. (CVS 1946) (check-in: [799f5383c0] user: drh branch: trunk, size: 68111)
2004-07-18
20:52
[b2ba401104] part of check-in [166234a2b6] min() ignores NULL values. Ticket #800. (CVS 1802) (check-in: [166234a2b6] user: drh branch: trunk, size: 67503)
2004-06-18
11:25
[5193e27d5a] part of check-in [61db159c7d] Fix typos and minor errors in lang.tcl. (CVS 1616) (check-in: [61db159c7d] user: danielk1977 branch: trunk, size: 67442)
2004-06-17
19:04
[608a3504fe] part of check-in [9fb29f7331] Documentation updates in preparation for the release of version 3.0.0. (CVS 1613) (check-in: [9fb29f7331] user: drh branch: trunk, size: 67069)
2004-05-31
15:06
[fc528581c4] part of check-in [2052911b1f] Website redesign in preparation for adding version 3 documentation. (CVS 1506) (check-in: [2052911b1f] user: drh branch: trunk, size: 68882)
2004-04-23
17:04
[17954f37c8] part of check-in [7ace576215] 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: [7ace576215] user: drh branch: trunk, size: 69145)
2004-01-19
05:09
[6cb027f548] part of check-in [06bd507096] documented pragma foreign_key_list(). updated docs for removed behavior: Oracle join syntax and temp indexes. (CVS 1193) (check-in: [06bd507096] user: jplyon branch: trunk, size: 69072)
2003-07-20
01:16
[5f39bbda1b] part of check-in [543479e3ae] 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: [543479e3ae] user: drh branch: trunk, size: 67584)
2003-07-16
11:51
[06b825c1e8] part of check-in [a31d0bd90a] Make LIMIT 0 return no rows. LIMIT -1 still returns all rows. Ticket #346. (CVS 1053) (check-in: [a31d0bd90a] user: drh branch: trunk, size: 67393)
2003-06-15
23:49
[2890eb8580] part of check-in [38461a7acb] Update the documentation to reflect the new capabilities of PRAGMA integrity_check. Rewording in the VACUUM documentation. (CVS 1025) (check-in: [38461a7acb] user: drh branch: trunk, size: 67389)
10:29
[860e881dd6] part of check-in [6c24dfbae5] Documented integer values used by PRAGMAs. Fixed missing end tags in generated anchors. (CVS 1022) (check-in: [6c24dfbae5] user: jplyon branch: trunk, size: 67327)
2003-06-08
08:36
[f206cb1b63] part of check-in [190252fee0] Documented SQL fns IFNULL() and NULLIF(). (CVS 1015) (check-in: [190252fee0] user: jplyon branch: trunk, size: 66535)
2003-06-07
08:56
[bc92ee5c8f] part of check-in [685a179aae] Hyperlinks and minor additions/corrections for lang.tcl (CVS 1011) (check-in: [685a179aae] user: jplyon branch: trunk, size: 66075)
2003-05-29
04:21
[0d3037b9d3] part of check-in [8b8fa0fff2] Added typeof() operator. Minor additions for ATTACH/DETACH. (CVS 987) (check-in: [8b8fa0fff2] user: jplyon branch: trunk, size: 65807)
2003-05-17
01:39
[4a22a96cfc] part of check-in [0874814ab0] Bump the version number to 2.8.1. Update documentation prior to release. (CVS 978) (check-in: [0874814ab0] user: drh branch: trunk, size: 65241)
2003-05-10
02:54
[bb945a1081] part of check-in [2bbb080495] Fixed metacharacter coloring with LP, RP, PLUS. Added more links. (CVS 962) (check-in: [2bbb080495] user: jplyon branch: trunk, size: 65253)
2003-05-07
13:37
[4cec7ec64b] part of check-in [ca75f1ca12] Format keyword lists in lang.html using a TCL proc. (CVS 961) (check-in: [ca75f1ca12] user: drh branch: trunk, size: 64424)
04:04
[bbd268bb12] part of check-in [55ae7b35ee] - Added entries for PRAGMAs database_list, temp_store and default_temp_store. - Fixed missing end tags. (CVS 960) (check-in: [55ae7b35ee] user: jplyon branch: trunk, size: 64021)
03:59
[46b42bd1b2] part of check-in [bb609f96e0] Cleaned up keywords section. (CVS 959) (check-in: [bb609f96e0] user: jplyon branch: trunk, size: 61567)
2003-05-04
07:02
[56f4c19967] part of check-in [87e1b6a936] new section for keywords, more docs for attached databases , links, cleanup (CVS 952) (check-in: [87e1b6a936] user: jplyon branch: trunk, size: 60459)
2003-05-03
19:04
[46fb1a3800] part of check-in [24b9b56924] More documentation updates. (CVS 951) (check-in: [24b9b56924] user: drh branch: trunk, size: 55879)
04:55
[1852abb0ef] part of check-in [fd28c5229e] - 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: [fd28c5229e] user: jplyon branch: trunk, size: 55281)
2003-02-13
02:54
[9bd9380dce] part of check-in [e05a7a552f] Update the documentation for the new journal format to be introduced in version 2.8.0. (CVS 865) (check-in: [e05a7a552f] user: drh branch: trunk, size: 52643)
2003-01-29
22:58
[7ad51d8730] part of check-in [af1e929946] 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: [af1e929946] user: drh branch: trunk, size: 52269)
2003-01-26
15:28
[1c11172bd6] part of check-in [c957f4f0c6] Added section on comments. Corrected broken end tags. (CVS 851) (check-in: [c957f4f0c6] user: jplyon branch: trunk, size: 52007)
2003-01-11
14:19
[1ea38a9fe8] part of check-in [e84d3afe7b] 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: [e84d3afe7b] user: drh branch: trunk, size: 51090)
2002-09-12
14:08
[6be4254a75] part of check-in [ef7116751d] Update the SQL language documentation to talk about SELECT DISTINCT. (CVS 748) (check-in: [ef7116751d] user: drh branch: trunk, size: 49943)
2002-08-25
20:11
[bf9d830aa0] part of check-in [e2d95f85a3] Documentation updates prior to the releae of 2.7.0. (CVS 728) (check-in: [e2d95f85a3] user: drh branch: trunk, size: 49932)
2002-08-18
19:09
[d2be2be032] part of check-in [e372a60be8] Documentation updates. (CVS 720) (check-in: [e372a60be8] user: drh branch: trunk, size: 48828)
2002-08-15
11:48
[a2785964e8] part of check-in [048b16c111] Additional test cases and documentation updates. (CVS 717) (check-in: [048b16c111] user: drh branch: trunk, size: 49080)
2002-08-14
00:08
[902f677258] part of check-in [4ff0f578ec] Update documentation to better explain the typelessness of SQLite and to describe the distinction between text and numeric data. (CVS 711) (check-in: [4ff0f578ec] user: drh branch: trunk, size: 49082)
2002-06-25
01:09
[8c3d0bda03] part of check-in [9c1432bf74] Added support for the "sqlite_temp_master" table. Increased the version number to 2.5.2. (CVS 640) (check-in: [9c1432bf74] user: drh branch: trunk, size: 49017)
2002-06-12
22:33
[cf22bf18db] part of check-in [3387d5b6d6] Fix for bug #70: Correct a typo in the documentation. (CVS 616) (check-in: [3387d5b6d6] user: drh branch: trunk, size: 48870)
2002-06-11
22:33
[da8057ac23] part of check-in [10da136125] Documentation that should have been checked in along with checkin (614) (CVS 615) (check-in: [10da136125] user: danielk1977 branch: trunk, size: 48879)
2002-06-06
23:30
[e25a7d383e] part of check-in [a0abef62bf] Fix for ticket #59: Add documentation for the || operator. Also added documentation for the new SQL92 join syntax. (CVS 608) (check-in: [a0abef62bf] user: drh branch: trunk, size: 47838)
2002-05-28
06:55
[bbff2febcc] part of check-in [5e74d0964b] Update trigger2.test to match checkin 591. Also fix ticket #51 (by documenting problem) (CVS 595) (check-in: [5e74d0964b] user: danielk1977 branch: trunk, size: 47505)
2002-05-26
23:24
[e87aa6b305] part of check-in [d9e48cd518] Require the INSTEAD OF syntax to create triggers on database views. (CVS 591) (check-in: [d9e48cd518] user: danielk1977 branch: trunk, size: 47075)
2002-05-15
11:43
[be7a241fe3] part of check-in [d1d8642b57] In the "lang.html" documentation file, put the CREATE TRIGGER and DROP TRIGGER sections in alphabetical order. (CVS 564) (check-in: [d1d8642b57] user: drh branch: trunk, size: 46879)
08:30
[a22cf9eff5] part of check-in [794bf67b6b] Added FOR EACH ROW triggers functionality (CVS 562) (check-in: [794bf67b6b] user: danielk1977 branch: trunk, size: 46889)
2002-05-06
11:47
[d47800eb1d] part of check-in [cc541b1030] Added documentation about the new CASE expression. (CVS 552) (check-in: [cc541b1030] user: drh branch: trunk, size: 42447)
2002-04-12
10:08
[2d4654255a] part of check-in [6e71493b9d] 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: [6e71493b9d] user: drh branch: trunk, size: 42504)
2002-04-06
14:10
[75615f1acd] part of check-in [6aca3f86bc] Added the last_insert_rowid() SQL function. (CVS 521) (check-in: [6aca3f86bc] user: drh branch: trunk, size: 42360)
13:57
[52a54be934] part of check-in [28ce42f787] 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: [28ce42f787] user: drh branch: trunk, size: 42088)
2002-03-28
14:20
[e6c277480c] part of check-in [f0f241e1cc] Two typos fixed in the documentation (lang.html). (CVS 502) (check-in: [f0f241e1cc] user: drh branch: trunk, size: 41957)
2002-03-11
02:06
[d589f9a39c] part of check-in [9f5b241cb2] Preparing for the 2.4.0 release. (CVS 426) (check-in: [9f5b241cb2] user: drh branch: trunk, size: 41956)
2002-03-04
02:26
[db13f9a9c5] part of check-in [36a8fe0ad0] Updates to the documentation. Changed version number to 2.4.0-beta1 (CVS 417) (check-in: [36a8fe0ad0] user: drh branch: trunk, size: 39080)
2002-02-19
22:42
[01e47b43cb] part of check-in [1686196a8a] New ROWIDs are numbered sequentially. (CVS 383) (check-in: [1686196a8a] user: drh branch: trunk, size: 35123)
13:39
[abf67afeb6] part of check-in [c6e9048e66] Change the name of the sanity_check PRAGMA to "integrity_check" and make it available on all compiles. (CVS 381) (check-in: [c6e9048e66] user: drh branch: trunk, size: 35118)
2002-02-18
18:30
[1712d94f96] part of check-in [78a50971e9] Add support for CREATE TABLE AS. (CVS 377) (check-in: [78a50971e9] user: drh branch: trunk, size: 35262)
03:21
[4865287af7] part of check-in [607c0c49b2] Test and documentation updates for sub-queries. (CVS 373) (check-in: [607c0c49b2] user: drh branch: trunk, size: 34810)
2002-02-03
19:06
[58077cb0c3] part of check-in [20ea737536] Fix a serious bug in INSERT when the source is a SELECT. (CVS 366) (check-in: [20ea737536] user: drh branch: trunk, size: 34653)
00:56
[260f3f9015] part of check-in [0115518f8e] Five-algorithm conflict resolution appears to be working. (CVS 363) (check-in: [0115518f8e] user: drh branch: trunk, size: 33970)
2002-01-31
15:54
[7ad595247f] part of check-in [d0e7cf4a83] 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: [d0e7cf4a83] user: drh branch: trunk, size: 30485)
2002-01-30
16:17
[f04d74017e] part of check-in [cf1538d71c] Added ON CONFLICT support to COPY. Updates to documentation. Bug fixes. (CVS 359) (check-in: [cf1538d71c] user: drh branch: trunk, size: 30280)
2001-12-22
19:27
[6843fd3f85] part of check-in [14392258c5] Update documentation for the 2.2.0 release. (CVS 335) (check-in: [14392258c5] user: drh branch: trunk, size: 26586)
2001-11-24
13:50
[6482d90e40] part of check-in [3be8a189e8] Fix typos. (CVS 320) (check-in: [3be8a189e8] user: drh branch: trunk, size: 25836)
13:23
[87ba01664d] part of check-in [f1a5808288] Update the FAQ. Change the GMT timezone label to UTC on all files. (CVS 318) (check-in: [f1a5808288] user: drh branch: trunk, size: 25726)
2001-11-06
14:10
[f0e953bfea] part of check-in [177012249a] Added support for LIMIT. (CVS 302) (check-in: [177012249a] user: drh branch: trunk, size: 25726)
2001-10-19
16:44
[1899ec4fb7] part of check-in [8467d84fc6] Version 2.0.6 (CVS 291) (check-in: [8467d84fc6] user: drh branch: trunk, size: 25452)
2001-10-15
00:44
[37d4a44bda] part of check-in [747bf1b30b] 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: [747bf1b30b] user: drh branch: trunk, size: 24861)
2001-10-13
02:59
[8cf5de0e7b] part of check-in [75e90cf09b] 2.0.3 (CVS 287) (check-in: [75e90cf09b] user: drh branch: trunk, size: 23642)
2001-10-08
13:22
[3a7900e3f8] part of check-in [9368c62e40] Support for temporary tables added. Still need more testing. (CVS 279) (check-in: [9368c62e40] user: drh branch: trunk, size: 23105)
2001-09-28
17:47
[33a74d7276] part of check-in [1df5386a55] Version 2.0.0 (CVS 272) (check-in: [1df5386a55] user: drh branch: trunk, size: 21005)
2001-09-20
01:44
[d093693db5] part of check-in [d2a1aac467] 2.0-Alpha-2 release (CVS 258) (check-in: [d2a1aac467] user: drh branch: trunk, size: 20794)
2001-05-21
13:45
[0969ba9f13] part of check-in [523d52dfa6] :-) (CVS 218) (check-in: [523d52dfa6] user: drh branch: trunk, size: 21845)
2001-04-04
11:48
[7fec414487] part of check-in [35a8feed0d] Added transaction support (CVS 196) (check-in: [35a8feed0d] user: drh branch: trunk, size: 21553)
2001-02-20
13:06
[e3905bec9f] part of check-in [d44abe54eb] Documentation updates only (CVS 189) (check-in: [d44abe54eb] user: drh branch: trunk, size: 19010)
2000-08-04
13:49
[9192e114b1] part of check-in [ab9c533a3a] :-) (CVS 125) (check-in: [ab9c533a3a] user: drh branch: trunk, size: 18233)
2000-06-09
14:14
[1645e9107d] part of check-in [d573b431ed] :-) (CVS 91) (check-in: [d573b431ed] user: drh branch: trunk, size: 18232)
03:47
[d694c3f361] part of check-in [3252269e90] :-) (CVS 88) (check-in: [3252269e90] user: drh branch: trunk, size: 9927)
01:58
[eb6a297c55] part of check-in [3661b5ff93] :-) (CVS 87) (check-in: [3661b5ff93] user: drh branch: trunk, size: 7733)
2000-06-08
21:53
Added: [2abf9ac038] part of check-in [049abcb37d] :-) (CVS 86) (check-in: [049abcb37d] user: drh branch: trunk, size: 6375)