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