Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
200 descendants and 200 ancestors of e5aa489453bf3112
|
2005-03-11
| ||
| 04:40 | Increase the version number to 3.1.4. (CVS 2376) (check-in: e438b65cf9 user: drh tags: trunk) | |
| 04:39 | Documentation updates for version 3.1.4. (CVS 2375) (check-in: a7261f1590 user: drh tags: trunk) | |
|
2005-03-10
| ||
| 17:06 | Another case of returning SQLITE_CORRUPT when a corrupt database file is detected. (CVS 2374) (check-in: 8710192797 user: drh tags: trunk) | |
| 14:32 | Fix a problem with crashtest caused by the F_FULLSYNC change. (CVS 2373) (check-in: f11c6e7452 user: drh tags: trunk) | |
| 14:11 | Disable F_FULLSYNC if the sychronous pragma is not set to FULL. (CVS 2372) (check-in: 58b8733b96 user: drh tags: trunk) | |
| 12:58 | Disable the use of ./crashtest in builds that include a codec. (CVS 2371) (check-in: 7e4af62238 user: drh tags: trunk) | |
| 12:52 | Disable the alter2 tests if there is a codec compiled into the library. (CVS 2370) (check-in: 06a48da67b user: drh tags: trunk) | |
| 12:35 | Fix a #ifdef in util.c. (CVS 2369) (check-in: f426c625c4 user: drh tags: trunk) | |
|
2005-03-09
| ||
| 13:09 | Fix a file corruption bug in CREATE INDEX in auto-vacuum databases. (CVS 2368) (check-in: 64c4c717d3 user: danielk1977 tags: trunk) | |
| 12:26 | Support for a future ALTER TABLE command to add columns with default values. (CVS 2367) (check-in: 9d5abc1ddf user: danielk1977 tags: trunk) | |
|
2005-03-02
| ||
| 05:18 | Print an error message and quit if the regression tests are run as root. Ticket #1153. (CVS 2366) (check-in: 9b96078763 user: drh tags: trunk) | |
| 05:18 | Fix the header comment on experimental.c. (CVS 2365) (check-in: 0c4d2b11c9 user: drh tags: trunk) | |
|
2005-02-28
| ||
| 01:52 | Version 3.1.3.1 (not an official release) (CVS 2364) (check-in: 957333a7b2 user: drh tags: trunk) | |
| 01:42 | Bump the version number to 3.1.3.1. (CVS 2363) (check-in: 1ca8bbf749 user: drh tags: trunk) | |
|
2005-02-26
| ||
| 18:10 | Add the SQLITE_OMIT_FLAG_PRAGMAS compile-time option. (CVS 2362) (check-in: c167e90542 user: drh tags: trunk) | |
| 17:31 | Fix an assertion fault that can occur while autovacuuming a corrupt database file. Add the SQLITE_OMIT_COMPLETE compile-time parameter. (CVS 2361) (check-in: bb0e7e3857 user: drh tags: trunk) | |
|
2005-02-24
| ||
| 04:51 | Revised man page from Bill Bumgarner. (CVS 2360) (check-in: 5c99bea5a4 user: drh tags: trunk) | |
|
2005-02-23
| ||
| 12:35 | Remove strcasecmp from shell.c. Tickets #1108, #1122. (CVS 2359) (check-in: 4ae1a9fc2c user: drh tags: trunk) | |
| 00:26 | The script that cross-compiles the windows DLLs now exports the symbols Tclsqlite_Init and Sqlite_Init used to initialize the TCL extension. Ticket #1137. (CVS 2358) (check-in: f187047774 user: drh tags: trunk) | |
|
2005-02-22
| ||
| 09:47 | Fix bug reported on the mailing list for WHERE clauses like (rowid<'2'). (CVS 2357) (check-in: b323f0f283 user: danielk1977 tags: trunk) | |
|
2005-02-20
| ||
| 02:25 | Version 3.1.3 (CVS 2356) (check-in: 36dbf5e929 user: drh tags: trunk) | |
|
2005-02-19
| ||
| 13:46 | Prepare for the release of 3.1.3. (CVS 2355) (check-in: 5b66631fd4 user: drh tags: trunk) | |
| 13:05 | Rework parts of the pragma documentation. Ticket #1081. (CVS 2354) (check-in: 25141d9e21 user: drh tags: trunk) | |
| 12:44 | Add documentation on the EXISTS expression. Ticket #1082. (CVS 2353) (check-in: 76cacb4a39 user: drh tags: trunk) | |
| 12:32 | Remove duplicate word from documentation. Ticket #1103. (CVS 2352) (check-in: c1fc0a8aa9 user: drh tags: trunk) | |
| 08:18 | Support for a future file format that includes 'short' records. (CVS 2351) (check-in: 173aeb256e user: danielk1977 tags: trunk) | |
|
2005-02-18
| ||
| 01:15 | Fix typos in documentation for pragma short_column_names. Ticket #1130. (CVS 2350) (check-in: fac56fa1e0 user: danielk1977 tags: trunk) | |
|
2005-02-17
| ||
| 00:03 | Compile-time option to limit the size of AUTOINCREMENT rowids to 32-bits. (CVS 2349) (check-in: c5366deaf5 user: drh tags: trunk) | |
|
2005-02-16
| ||
| 23:43 | Clarify that columns are indexed from 0 when using sqlite3_column_XXX() APIs. No code changes. (CVS 2348) (check-in: d5eb25d8d0 user: danielk1977 tags: trunk) | |
| 03:45 | Change to configure.ac contributed by a reader. (CVS 2346) (check-in: 0cd3bf02d2 user: drh tags: trunk) | |
| 03:35 | Patch the command-line error message printing for lemon. Ticket #1120. (CVS 2345) (check-in: 97c7aaf187 user: drh tags: trunk) | |
| 03:27 | Get vacuum working on database that used to have autoincrement tables but where all such tables have been dropped. Ticket #1121. (CVS 2344) (check-in: 8f7c639da0 user: drh tags: trunk) | |
|
2005-02-15
| ||
| 21:36 | Move the special built-in SQL functions used by ALTER TABLE out of func.c and into alter.c. (CVS 2343) (check-in: dbd11a0c58 user: drh tags: trunk) | |
| 20:47 | Split the logic for the ALTER TABLE command off into a separate source code file. (CVS 2342) (check-in: 90d6573c26 user: drh tags: trunk) | |
| 16:23 | Btree checks the autovacuum flag after locking the database file. (CVS 2341) (check-in: 6610188f09 user: drh tags: trunk) | |
| 16:15 | Append the version number to the directory name in source code tarballs. Tickets #793, #855, and #1055. (CVS 2340) (check-in: 138577d0a5 user: drh tags: trunk) | |
| 13:38 | Fix a hyperlink bug on the homepage. (CVS 2338) (check-in: 9fd9d9fbee user: drh tags: trunk) | |
| 13:08 | Version 3.1.2 (CVS 2337) (check-in: e9012d917a user: drh tags: trunk) | |
| 13:07 | Updates to the script that generates the download page for the website. (CVS 2335) (check-in: 363590d37f user: drh tags: trunk) | |
| 12:56 | Update the change log. (CVS 2334) (check-in: 94c3f20e8c user: drh tags: trunk) | |
| 12:51 | Update the homepage prior to releases 2.8.16 and 3.1.2. (CVS 2333) (check-in: 603bbe47dd user: drh tags: trunk) | |
| 03:38 | Ensure a database file is not truncated without an exclusive lock. Fix for ticket #1114. (CVS 2332) (check-in: dcbc983355 user: danielk1977 tags: trunk) | |
| 02:54 | Check that read-only pages are not being modified (disabled by default). (CVS 2331) (check-in: 8514a4feb2 user: danielk1977 tags: trunk) | |
|
2005-02-14
| ||
| 20:48 | Make sure that when a CREATE INDEX fails, it does not leave a residue behind that can corrupt the database. Ticket #1115. (CVS 2330) (check-in: cbed92f397 user: drh tags: trunk) | |
| 06:38 | Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329) (check-in: 41d2214b83 user: danielk1977 tags: trunk) | |
|
2005-02-13
| ||
| 23:34 | Update the version number in preparation for the release of 3.1.2. (CVS 2325) (check-in: f3c51de759 user: drh tags: trunk) | |
|
2005-02-12
| ||
| 08:59 | Fix a problem with sub-queries and the flattening optimization. Also handle an extra case of database corruption. (CVS 2324) (check-in: f7858d8830 user: danielk1977 tags: trunk) | |
| 00:19 | Fix a problem with VACUUM that can lead to database corruption. (CVS 2323) (check-in: 63894baf1b user: drh tags: trunk) | |
|
2005-02-09
| ||
| 07:05 | Return SQLITE_BUSY if the database is locked reading the schema within sqlite_prepare(). Ticket #1106. (CVS 2322) (check-in: c33c02d606 user: danielk1977 tags: trunk) | |
| 03:20 | Add experimental collation_list pragma. (CVS 2321) (check-in: f73a8aa34a user: danielk1977 tags: trunk) | |
| 01:40 | Document SQLITE_DEFAULT_CACHE_SIZE and SQLITE_DEFAULT_TEMP_CACHE_SIZE macros. (CVS 2320) (check-in: ddcea6f889 user: danielk1977 tags: trunk) | |
|
2005-02-08
| ||
| 08:42 | Fix a buggy interaction between "INSERT ... SELECT" processing and optimization (2170). (CVS 2319) (check-in: c54ad21236 user: danielk1977 tags: trunk) | |
| 07:50 | Fix for correlated subqueries where the parent is an aggregate. Ticket #1105. (CVS 2318) (check-in: f0d3ca10c5 user: danielk1977 tags: trunk) | |
|
2005-02-06
| ||
| 02:45 | Add the (highly experimental) omit_readlock pragma that disables the use of readlocks on read-only databases that are connected using ATTACH. (CVS 2317) (check-in: 2155448d21 user: drh tags: trunk) | |
|
2005-02-05
| ||
| 12:48 | Allow expressions (including variables) in LIMIT and OFFSET clauses. Ticket #1096. (CVS 2316) (check-in: 515e5033a5 user: danielk1977 tags: trunk) | |
| 07:33 | Add a numeric version number. Ticket #1097. (CVS 2315) (check-in: a9c33a804d user: danielk1977 tags: trunk) | |
| 06:49 | Detect database corruption in rootpage flags (see also (2313)). (CVS 2314) (check-in: 6d91a1e91b user: danielk1977 tags: trunk) | |
|
2005-02-04
| ||
| 21:13 | Detect and report a subtle case of database file corruption. (CVS 2313) (check-in: 9fc0a5cbf8 user: drh tags: trunk) | |
| 04:07 | Remove code for SQL cursors. (CVS 2312) (check-in: 2eb9087055 user: danielk1977 tags: trunk) | |
|
2005-02-03
| ||
| 01:08 | Get AUTOINCREMENT and VACUUM working together. Ticket #1095. (CVS 2311) (check-in: 332a531d06 user: drh tags: trunk) | |
| 00:42 | Fix the ".dump" command in the shell so that it works with AUTOVACUUM. This is related to ticket #1095. (CVS 2310) (check-in: 76c4a96c5a user: drh tags: trunk) | |
| 00:29 | Make sure the rc variable in OsWrite of os_win.c is always initialized. Also assert that the amt parameter is always greater than zero. Ticket #1094. (CVS 2309) (check-in: 4b399ae779 user: drh tags: trunk) | |
|
2005-02-02
| ||
| 01:13 | Fix a comment in sqlite3.h. No code changes. Ticket #1093. (CVS 2308) (check-in: d1ea2fb70b user: danielk1977 tags: trunk) | |
| 01:10 | Handle "rowid<=X ORDER BY rowid DESC" where X is an integer. Fix for ticket #1092. (CVS 2307) (check-in: 506088796c user: danielk1977 tags: trunk) | |
|
2005-02-01
| ||
| 17:05 | Version 3.1.1 (beta) (CVS 2306) (check-in: 2e1c71c468 user: drh tags: trunk) | |
| 15:57 | Increment the version number to 3.1.1beta. (CVS 2305) (check-in: 076f9868a4 user: drh tags: trunk) | |
| 10:36 | Space analyzer: Format integer results as integers. Also fix the calculation of average-fanout. (CVS 2304) (check-in: 52e473b946 user: danielk1977 tags: trunk) | |
| 10:35 | Have debugging code handle sqliteMalloc(n) where n<0 in the same way as production. (CVS 2303) (check-in: ab85e1d012 user: danielk1977 tags: trunk) | |
| 04:09 | More performance tweaking in the parser. (CVS 2302) (check-in: a3d12726bb user: drh tags: trunk) | |
| 03:46 | Fix an error introduced with (2299). (CVS 2301) (check-in: 22041d5f26 user: danielk1977 tags: trunk) | |
| 03:20 | Lemon optimization: When doing a shift following a reduce that pops one or more elements off the stack, no need to check for stack overflow. (CVS 2300) (check-in: adcd9a3fa2 user: drh tags: trunk) | |
| 03:09 | Avoid allocating a vdbe in sqlite3FinishCoding() if one has not been allocated already. (CVS 2299) (check-in: eaf1866e4d user: danielk1977 tags: trunk) | |
| 02:13 | Change to sqlite3AffinityType() to remove hex constants. (CVS 2298) (check-in: d8b4b0ef13 user: danielk1977 tags: trunk) | |
| 01:40 | Tweaks to the keyword hash generator. Tried to make it a little faster. If nothing else, the keyword hash table is now a little smaller. (CVS 2297) (check-in: 4eca6c05ab user: drh tags: trunk) | |
| 01:21 | Replace sqlite3AffinityType() with a slightly faster version. (CVS 2296) (check-in: abe9f5e81f user: danielk1977 tags: trunk) | |
|
2005-01-31
| ||
| 23:45 | Performance tweaks for sqlite3AffinityType. (CVS 2295) (check-in: 32b926154a user: drh tags: trunk) | |
| 12:56 | Move sqlite3HashNoCase to hash.c. (CVS 2294) (check-in: 5c10ccd8e9 user: danielk1977 tags: trunk) | |
| 12:42 | Assorted minor changes to speed up loading the database schema. (CVS 2293) (check-in: dfbd684a91 user: danielk1977 tags: trunk) | |
|
2005-01-30
| ||
| 22:10 | User-contributed chagnes to tclinstaller so that it supports DESTDIR. (CVS 2292) (check-in: ab8dbcf563 user: drh tags: trunk) | |
| 11:11 | Respect collation sequences in views. Ticket #1088. (CVS 2291) (check-in: 9843c0dd79 user: danielk1977 tags: trunk) | |
| 09:17 | Have the optimization introduced in (2170) deal with OP_NullRow as well as OP_Column and OP_Recno. Fix for #1086. (CVS 2290) (check-in: 356d31e03f user: danielk1977 tags: trunk) | |
|
2005-01-29
| ||
| 09:14 | Update to test files to support builds with OMIT macros defined. (CVS 2289) (check-in: 808e16a7dd user: danielk1977 tags: trunk) | |
| 09:00 | Fix a test bug causing a segfault in bind.test. (CVS 2288) (check-in: a8b921d45e user: danielk1977 tags: trunk) | |
| 08:36 | Update ioerr.test to be more deterministic. (CVS 2287) (check-in: d0b16bae65 user: danielk1977 tags: trunk) | |
| 08:32 | Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) (check-in: b1b50f3158 user: danielk1977 tags: trunk) | |
| 01:54 | Modification to schema.test so that it works with SQLITE_OMIT_TRIGGER and SQLITE_OMIT_UTF16 defined. (CVS 2285) (check-in: 95ecb2745f user: danielk1977 tags: trunk) | |
|
2005-01-28
| ||
| 01:29 | Make sure the #include of "sqliteInt.h" always comes first in C source files. (CVS 2284) (check-in: 522c094f79 user: drh tags: trunk) | |
|
2005-01-27
| ||
| 00:33 | Fix a warning introduced by (2280). (CVS 2283) (check-in: dc1b8106c4 user: danielk1977 tags: trunk) | |
| 00:33 | More changes to improve propagation of SQLITE_CORRUPT errors. (CVS 2282) (check-in: e4b5c16858 user: drh tags: trunk) | |
| 00:30 | Test that it is ok to execute ALTER TABLE immediately after opening a database connection. (CVS 2281) (check-in: 1d5ebb1146 user: danielk1977 tags: trunk) | |
| 00:22 | Have REINDEX handle missing collation sequences correctly. (CVS 2280) (check-in: 1c1904f443 user: danielk1977 tags: trunk) | |
|
2005-01-26
| ||
| 21:55 | Propagate detected database corruption up through the call stack. (CVS 2279) (check-in: 2c54aba5ba user: drh tags: trunk) | |
| 17:47 | An optimization to sqlite3VdbeSerialType(). (CVS 2278) (check-in: db36773830 user: drh tags: trunk) | |
| 10:39 | Add an entry to faq.tcl regarding SQLITE_SCHEMA errors. (CVS 2277) (check-in: 12defe8cd6 user: danielk1977 tags: trunk) | |
| 03:58 | Allow GROUP BY on non-aggregate queries. Ticket #1064 (CVS 2276) (check-in: 0642d3e3d6 user: danielk1977 tags: trunk) | |
|
2005-01-25
| ||
| 04:27 | Prevent collation sequences and user functions from being deleted or changed while SQL statements are executing. (CVS 2275) (check-in: cabab62bc1 user: danielk1977 tags: trunk) | |
|
2005-01-24
| ||
| 23:27 | Clarify documentation of DEFAULT CURRENT_TIME etc. (version 3.1.0 and greater only). (CVS 2274) (check-in: 557eb2ec9d user: danielk1977 tags: trunk) | |
| 13:03 | More test cases to do with invalidating precompiled statements. (CVS 2273) (check-in: b243681a0e user: danielk1977 tags: trunk) | |
| 12:46 | Use the cache with loading a large table in select2-2.0. (CVS 2272) (check-in: bd65b1805c user: drh tags: trunk) | |
| 10:25 | Modifications and bugfixes so that the test suite passes with the TCL statement cache turned on. (CVS 2271) (check-in: d5233e0747 user: danielk1977 tags: trunk) | |
| 01:38 | Flush the TCL statement cache before each lock_status pragma. (CVS 2270) (check-in: 8beae3ff8c user: drh tags: trunk) | |
| 00:28 | Change the TCL interface so that it can cache VMs and reuse them without recompiling. But for now leave the cache turned off by default. (CVS 2269) (check-in: 8db6bfef52 user: drh tags: trunk) | |
|
2005-01-23
| ||
| 23:43 | Modification to shell.c to avoid a compiler warning on some compilers. (CVS 2268) (check-in: 0778383b6f user: danielk1977 tags: trunk) | |
| 22:41 | Minor changes to avoid warnings on some compilers. (CVS 2267) (check-in: 4daf1d1f9d user: danielk1977 tags: trunk) | |
| 19:04 | Fix a bug in change counting that comes up when sqlite3_finalize() is called right after sqlite3_reset(). (CVS 2266) (check-in: 1a64295e05 user: drh tags: trunk) | |
| 13:14 | ATTACH and DETACH cause prepared statements to expire. sqlite3_finalize() can now be called right after sqlite3_reset(). (CVS 2265) (check-in: 6c631b86e5 user: drh tags: trunk) | |
|
2005-01-22
| ||
| 03:39 | Test script changes: Bug fix and cleanup on ioerr tests. Also, don't use TCL "file copy" command on windows. (CVS 2264) (check-in: 764b55adb5 user: danielk1977 tags: trunk) | |
| 03:03 | Add the experimental sqlite3_expired() API. (CVS 2263) (check-in: df648d50c0 user: drh tags: trunk) | |
|
2005-01-21
| ||
| 21:31 | Add <stddef.h> to sqliteInt.h. (CVS 2262) (check-in: fede252d19 user: drh tags: trunk) | |
| 21:22 | More documentation changes. Allow SQLITE_DEFAULT_CACHE_SIZE to set the default cache size for the pager at compile-time. (CVS 2261) (check-in: 2ddb674875 user: drh tags: trunk) | |
| 18:28 | Version 3.1.0 (alpha) (CVS 2260) (check-in: 45094abe38 user: drh tags: trunk) | |
| 18:19 | Documentation updates prior to 3.1.0. (CVS 2259) (check-in: fc4f1f13d0 user: drh tags: trunk) | |
| 17:53 | Initialize the random number generator from /dev/urandom, if available. (CVS 2258) (check-in: aab8e7f8d8 user: drh tags: trunk) | |
| 17:07 | Change to mkopcodeh.awk to accomodate windows systems. (CVS 2257) (check-in: 39786aa894 user: drh tags: trunk) | |
| 17:03 | Update change log for version 3.1.0. (CVS 2256) (check-in: 4d9b858746 user: drh tags: trunk) | |
| 15:52 | Final preparations for the 3.1.0 alpha release. (CVS 2255) (check-in: 17122c7e8e user: drh tags: trunk) | |
| 11:55 | Improve test coverage for minimum feature builds. (CVS 2254) (check-in: 9c4d0e13e8 user: danielk1977 tags: trunk) | |
| 08:13 | Exclude a few more lines of code using OMIT macros. (CVS 2253) (check-in: c6fc49e610 user: danielk1977 tags: trunk) | |
| 04:25 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (but no other OMIT macros) is defined. (CVS 2252) (check-in: d4e19efcef user: danielk1977 tags: trunk) | |
| 03:12 | Modify test scripts to work when SQLITE_OMIT_SUBQUERY (along with other OMIT macros) is defined. (CVS 2251) (check-in: bb0254ab14 user: danielk1977 tags: trunk) | |
| 02:34 | Add a new test file for subqueries. (CVS 2250) (check-in: de8ee3a29e user: drh tags: trunk) | |
| 00:44 | Change the implementation of ALTER TABLE so that it does not use the IN() operattor. (CVS 2249) (check-in: 06887afb32 user: danielk1977 tags: trunk) | |
| 00:22 | Fix a segfault that occurs on a corrupt database. (CVS 2248) (check-in: d1166472fd user: drh tags: trunk) | |
|
2005-01-20
| ||
| 23:23 | Fix comment typo in mkopcodec.awk. (CVS 2247) (check-in: 6177148260 user: drh tags: trunk) | |
| 22:48 | Bug fixes and enhancements entered while on jury recess. (CVS 2246) (check-in: 38401dfbd5 user: drh tags: trunk) | |
| 13:36 | Added the SQLITE_OMIT_SUBQUERY compile-time option and the EXISTS operator. Regression tests are currently failing with an assertion fault. (CVS 2245) (check-in: d30fdf0f2c user: drh tags: trunk) | |
| 13:03 | Remove a few more lines of code when SQLITE_OMIT_** macros are defined. (CVS 2244) (check-in: 417bbba93a user: danielk1977 tags: trunk) | |
| 11:32 | Extend the influence of a couple of SQLITE_OMIT_** macros a little bit. (CVS 2243) (check-in: 5b1a9bf6aa user: danielk1977 tags: trunk) | |
| 05:24 | Changes so that crash.test works when SQLITE_OMIT_PAGER_PRAGMAS is defined. (CVS 2242) (check-in: f0add0a60e user: danielk1977 tags: trunk) | |
| 02:17 | Fix some test scripts so that they work with a minimal build configuration. (CVS 2241) (check-in: d267fb3ca3 user: danielk1977 tags: trunk) | |
| 02:14 | Turn SQLITE_OMIT_CURSOR on by default. (CVS 2240) (check-in: 2d3ab1ab5a user: drh tags: trunk) | |
| 01:51 | Expression generator bug fix. (CVS 2239) (check-in: 39cf97a902 user: drh tags: trunk) | |
| 01:17 | Minor fix for sqlite3_clear_bindings(). (CVS 2238) (check-in: ff5b338cfb user: danielk1977 tags: trunk) | |
| 01:14 | Add the experimental sqlite3_sleep() and sqlite3_clear_bindings() APIs. (CVS 2237) (check-in: 9480209e86 user: danielk1977 tags: trunk) | |
|
2005-01-19
| ||
| 23:24 | Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) (check-in: d8b2a7e091 user: drh tags: trunk) | |
| 03:52 | Another fix along the same lines as (2234) (CVS 2235) (check-in: 27cf83224c user: danielk1977 tags: trunk) | |
| 03:47 | A few test cases were failing on windows due to mandatory locking. Omit them on that platform. (CVS 2234) (check-in: 441316f1af user: danielk1977 tags: trunk) | |
|
2005-01-18
| ||
| 17:40 | Make sure USING and NATURAL work on joins even if the columns are renamed using an AS phrase. Ticket #523. (CVS 2233) (check-in: c06add57bf user: drh tags: trunk) | |
| 17:20 | CREATE TABLE ... AS ... uses short names for columns. Ticket #1036. (CVS 2232) (check-in: b1d4c42d2b user: drh tags: trunk) | |
| 16:02 | Column names coming back from a SELECT are now just the name of the source column without the "table." prefix. In other words, "PRAGMA short_column_names=ON" is now the default. This makes the names of columns behave more like other SQL engines. The old behavior can be restored by setting "PRAGMA short_column_names=OFF". (CVS 2231) (check-in: 9295050af1 user: drh tags: trunk) | |
| 14:45 | Continue refactoring name resolution. Fix for ticket #1047. (CVS 2230) (check-in: 88d4834fec user: drh tags: trunk) | |
| 04:00 | Refinements to the name resolution logic. Change the name of the keywordhash.c file to keywordhash.h. (CVS 2229) (check-in: 0142ae6f00 user: drh tags: trunk) | |
|
2005-01-17
| ||
| 22:08 | Infrastructure changes to handle name resolution differently. This is needed to fix various long-standing problems with column names in joins. It will also make the implementation of correlated subqueries easier. (CVS 2228) (check-in: 4a7534396a user: drh tags: trunk) | |
| 08:57 | Fix a bug reported on the mailing list concerning a conflict between "INSERT INTO ... SELECT" statements and the "SELECT max(x) FROM tbl" optimization. (CVS 2227) (check-in: 5a9da62ae3 user: danielk1977 tags: trunk) | |
| 07:53 | Fix some memory leak problems with corrupt.test and auto-vacuum databases. (CVS 2226) (check-in: 6244252915 user: danielk1977 tags: trunk) | |
| 03:42 | Add incomplete, preliminary drafts of new documentation. (CVS 2225) (check-in: a01159e8cb user: drh tags: trunk) | |
| 03:40 | Fix a memory leak that occurs as a result of an IO error. (CVS 2224) (check-in: 1edfdcbf14 user: danielk1977 tags: trunk) | |
| 02:12 | Change some assert()s that could fail if the database is corrupt to return SQLITE_CORRUPT instead. (CVS 2223) (check-in: 2d58c0afa7 user: danielk1977 tags: trunk) | |
| 01:33 | Have sqlite3pager_get() return SQLITE_CORRUPT for a page number greater than 2^31. (CVS 2222) (check-in: feb49d10e8 user: danielk1977 tags: trunk) | |
|
2005-01-16
| ||
| 23:21 | Turn on quick-balance by default. (CVS 2221) (check-in: d0356dee55 user: drh tags: trunk) | |
| 20:47 | Drop support for MAC OS9. SQLite 3 has never worked for that OS because the developers do not have access to a machine running it and nobody from the community has stepped forward to provide a port. By moving the os_mac.c file into the attic, we make the lack of support official. (CVS 2220) (check-in: de9ad673d0 user: drh tags: trunk) | |
| 11:07 | Changes to make sure tests work when SQLITE_DEFAULT_AUTOVACUUM is defined. (CVS 2219) (check-in: 6237c294d1 user: danielk1977 tags: trunk) | |
| 09:06 | Fixes so that compiling and testing works when SQLITE_OMIT_AUTOVACUUM is defined. (CVS 2218) (check-in: fe548561a0 user: danielk1977 tags: trunk) | |
| 08:00 | Move duplicate code to update pointer-map wrt overflow pages into a function. (CVS 2217) (check-in: a5c2121410 user: danielk1977 tags: trunk) | |
|
2005-01-15
| ||
| 12:45 | Enhance the performance of auto-vacuum databases by reducing the number of pointer-map entries written during tree balancing. Also fix bugs in balance_quick(). (CVS 2216) (check-in: 0ae29538cc user: danielk1977 tags: trunk) | |
| 01:52 | Test coverage improvements. (CVS 2215) (check-in: 92f9d2b2f4 user: drh tags: trunk) | |
| 00:40 | Improved test coverage for update.c. (CVS 2214) (check-in: 3ef95d5fe9 user: drh tags: trunk) | |
| 00:36 | Improved coverage for insert.c. (CVS 2213) (check-in: 997d8afff9 user: drh tags: trunk) | |
|
2005-01-14
| ||
| 22:55 | Add comments to the new balance_quick() routine. (CVS 2212) (check-in: 183c42eac8 user: drh tags: trunk) | |
| 13:50 | Experimental patch to balance() (use -DSQLITE_BALANCE_QUICK). (CVS 2211) (check-in: c550d80c25 user: danielk1977 tags: trunk) | |
| 01:22 | Improved test coverage on insert.c. (CVS 2210) (check-in: c772f75166 user: drh tags: trunk) | |
|
2005-01-13
| ||
| 23:54 | Need SQLITE_MEMDEBUG instead of SQLITE_DEBUG in tclsqlite.c. (CVS 2209) (check-in: 6e905270a9 user: drh tags: trunk) | |
| 23:54 | Fix a bug in lemon that does not effect SQLite. Ticket #1068. (CVS 2208) (check-in: 7113b5ed8d user: drh tags: trunk) | |
| 13:35 | Tidy up malloc.test a bit. (CVS 2207) (check-in: 94cf91cc5d user: danielk1977 tags: trunk) | |
| 11:10 | Fix typo in shell .help. Ticket #1071. (CVS 2206) (check-in: 2c7a1a1698 user: danielk1977 tags: trunk) | |
| 11:07 | Test cases to improve coverage of pager.c. (CVS 2205) (check-in: 0428a14801 user: danielk1977 tags: trunk) | |
| 02:14 | Fixes to 'configure' build system. Also extra coverage for main.c. (CVS 2204) (check-in: 8378455f32 user: danielk1977 tags: trunk) | |
|
2005-01-12
| ||
| 13:04 | Fix a test bug introduce with the previous commit. (CVS 2203) (check-in: 1c19e8bdca user: danielk1977 tags: trunk) | |
| 12:44 | Tests to improve coverage of main.c. (CVS 2202) (check-in: 4e28c82ada user: danielk1977 tags: trunk) | |
| 09:10 | Tests to improve coverage of vdbeaux.c. (CVS 2201) (check-in: 2b3e21ce2e user: danielk1977 tags: trunk) | |
| 07:15 | Tests to improve coverage of vdbemem.c. (CVS 2200) (check-in: 319bb4a906 user: danielk1977 tags: trunk) | |
| 00:08 | Fix a bug in tclsqlite.c. (CVS 2199) (check-in: 50f1e22965 user: drh tags: trunk) | |
|
2005-01-11
| ||
| 18:13 | Fix for ticket #1062: Correctly handle redundant terms in a WHERE clause. (CVS 2198) (check-in: 1bee1bb91d user: drh tags: trunk) | |
| 17:59 | Allow '$' in the middle of identifiers. Ticket #1066. This is an experimental change. It might be backed out at a later date. (CVS 2197) (check-in: 00a352ea79 user: drh tags: trunk) | |
| 17:46 | Test coverage improvements on tokenize.c. (CVS 2196) (check-in: 5767850cca user: drh tags: trunk) | |
| 16:54 | Improved test coverage for vdbeaux.c. (CVS 2195) (check-in: 3f46cd7767 user: drh tags: trunk) | |
| 15:28 | Improved test coverage for util.c. (CVS 2194) (check-in: ad451a2ddc user: drh tags: trunk) | |
| 13:02 | Test cases to improve coverage of vdbe.c. (CVS 2193) (check-in: a6b4572207 user: danielk1977 tags: trunk) | |
| 11:08 | Remove a C++ style comment that went in with the previous commit. (CVS 2192) (check-in: ce8e4e885a user: danielk1977 tags: trunk) | |
| 10:25 | Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2191) (check-in: a37e0108de user: danielk1977 tags: trunk) | |
| 10:25 | Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2190) (check-in: 8ced491588 user: danielk1977 tags: trunk) | |
|
2005-01-10
| ||
| 12:59 | Extra test cases to improve coverage of btree.c (CVS 2189) (check-in: a461988661 user: danielk1977 tags: trunk) | |
| 06:39 | Update some documentation for version 3.1. (CVS 2188) (check-in: 5b7a5a4d69 user: danielk1977 tags: trunk) | |
| 02:48 | Fix an assertion failure due to interaction between the count_changes pragma and triggers. (CVS 2187) (check-in: 6c7bec1b3a user: danielk1977 tags: trunk) | |
|
2005-01-08
| ||
| 18:42 | Tcl interface does as sqlite3 or as sqlite. A compile-time option allows duel linking. Also fix a bug in the pragma change from earlier today. (CVS 2186) (check-in: ad10953799 user: drh tags: trunk) | |
| 15:44 | Fixes to the temp_store_directory pragma. (CVS 2185) (check-in: 0a90eaf398 user: drh tags: trunk) | |
| 15:43 | Fix a comment. (CVS 2184) (check-in: 26fbac8f03 user: drh tags: trunk) | |
| 12:42 | Fix a problem with auto-vacuum databases and the VACUUM command. Also add "pages read" and "pages written" statistics to the pager layer. (CVS 2183) (check-in: fb3bf68d0e user: danielk1977 tags: trunk) | |
| 02:35 | Minor test script changes to allow all.test to run when SQLITE_DEFAULT_AUTOVACUUM=1 is defined. (CVS 2182) (check-in: 5023b1dba2 user: danielk1977 tags: trunk) | |
|
2005-01-07
| ||
| 10:42 | Reset the temp_store_directory each iteration of tests in all.test. (CVS 2181) (check-in: 7373a5d4cf user: danielk1977 tags: trunk) | |
| 08:56 | Fix a read of invalid memory that could occur in btree.c. (CVS 2180) (check-in: 929745c183 user: danielk1977 tags: trunk) | |
| 01:56 | Remove incorrect assert() and add extra option to account for non-standard 'sort' program in some linux versions. (CVS 2179) (check-in: bf14387697 user: danielk1977 tags: trunk) | |
|
2005-01-03
| ||
| 21:28 | add --enable-debug to configure options, controls -DNDEBUG flag (CVS 2178) (check-in: 9d674d1dc0 user: tpoindex tags: trunk) | |
| 18:13 | add comment that table is accessed by primary key (CVS 2177) (check-in: 707690c5f2 user: tpoindex tags: trunk) | |
| 02:26 | Allow GROUP BY on aggregate queries only. Ticket #1039. (CVS 2176) (check-in: 8ef2c644eb user: drh tags: trunk) | |
| 01:33 | Fix typos in comments in test code. (Oops. This check-in also picked up some unrelated changes to documentation.) (CVS 2175) (check-in: 586acc85b1 user: drh tags: trunk) | |
| 01:28 | Fix a typo in a comment. No code changes. Ticket #1052. (CVS 2174) (check-in: 9fb1402f08 user: drh tags: trunk) | |
| 01:27 | Fix comment typos. no code changes. (CVS 2173) (check-in: 4165217e51 user: drh tags: trunk) | |
|
2004-12-25
| ||
| 01:03 | Fix ticket #1046 by removing code and simplifying the query optimizer. Remarkably, this simplification also makes the optimizer do a better job. Ticket #1051 was fixed as a side-effect. (CVS 2172) (check-in: 5fd1f47118 user: drh tags: trunk) | |
|
2004-12-20
| ||
| 19:01 | Add PRAGMA 'temp_store_directory'. Added os_*.c function sqlite3OsIsDirWritable(), split pragma.c changeTempStorage() function into invalidateTempStorage(). (CVS 2171) (check-in: 772e22cbd6 user: tpoindex tags: trunk) | |
|
2004-12-19
| ||
| 00:11 | The optimizer now uses only the index and ignores the table if it can get away with doing so, thus saving a single BTree search per row of result. This could potentially double the speed of certain queries. The code passes all regression tests but new tests to exercise the new functionality are yet to be added. (CVS 2170) (check-in: e5aa489453 user: drh tags: trunk) | |
|
2004-12-18
| ||
| 18:40 | Improvements to the query optimizer. This is a work in progress. (CVS 2169) (check-in: 9b86993ff7 user: drh tags: trunk) | |
|
2004-12-17
| ||
| 20:48 | Fix a C++-ism in the previous change to tclsqlite.c. (CVS 2168) (check-in: b49b8fdd11 user: drh tags: trunk) | |
| 15:41 | Add 'copy' method for tcl interface. Behaves similar to shell .import or COPY statment in 2.x. (CVS 2167) (check-in: a9311d9df0 user: tpoindex tags: trunk) | |
|
2004-12-16
| ||
| 21:09 | Make sure LIMITs are handled correctly on UNION operators. Ticket #1035. (CVS 2166) (check-in: ece0085f86 user: drh tags: trunk) | |
|
2004-12-14
| ||
| 03:34 | Minor code and comment cleanup. (CVS 2165) (check-in: d012628a78 user: drh tags: trunk) | |
|
2004-12-10
| ||
| 18:00 | Factor the test for zName==NULL out of the loop. Ticket #1032. (CVS 2164) (check-in: 7f38f67c7b user: drh tags: trunk) | |
| 17:17 | Fix a problem with the automatic generation of the opcode name table. (CVS 2163) (check-in: 9eefabc92d user: drh tags: trunk) | |
| 03:08 | Back out the USE_TCL_STUBS changes because it breaks the build. I think the strategy needs to be to abandon libtool and use tcl.m4 to figure out how to build our own shared libraries. Ticket #1034. (CVS 2162) (check-in: 7f4679b92e user: drh tags: trunk) | |
| 02:20 | Improvements to the --help option to configure. Ticket #1033. (CVS 2161) (check-in: 3032cc2b88 user: drh tags: trunk) | |
| 02:08 | Add a -DUSE_TCL_STUBS to the standard Makefile. This might help with ticket #1034. Or maybe not. (CVS 2160) (check-in: 4c30c373ef user: drh tags: trunk) | |
|
2004-12-09
| ||
| 18:29 | Enhance sqlite3_bind_parameter_index so that is does not segfault if you call it incorrectly by passing NULL in place of the parameter name. Ticket #1032. (CVS 2159) (check-in: bf81aabff1 user: drh tags: trunk) | |
|
2004-12-07
| ||
| 15:41 | Only evaluate expressions once for UPDATE and INSERT statements that have BEFORE triggers. Fix for ticket #980. (CVS 2158) (check-in: 4852186aca user: drh tags: trunk) | |
| 14:06 | Simplify the trigger logic for DELETE, INSERT, and UPDATE. (CVS 2157) (check-in: 8e164ab277 user: drh tags: trunk) | |
| 12:29 | Remove the unused sqlite3_context.isStep element. (CVS 2156) (check-in: 7b20f2b71f user: drh tags: trunk) | |
| 02:14 | Updates to API documentation and comments in sqlite3.h. (CVS 2155) (check-in: 46584348f3 user: drh tags: trunk) | |
|
2004-12-02
| ||
| 20:17 | Get the build of sqlite3_analyzer working with Makefile.in. (CVS 2154) (check-in: f7415a0d64 user: drh tags: trunk) | |
|
2004-11-27
| ||
| 15:52 | Disable the cursors. "make install" now builds and installs a TCL package for SQLite if TCL is installed on the system. (CVS 2153) (check-in: d75014c299 user: drh tags: trunk) | |
|
2004-11-25
| ||
| 13:50 | The configure script now automatically detects tclConfig.sh and builds the Tcl extension only if tclConfig.sh is present. The Tcl extension can be disabled using --disable-tcl. (CVS 2152) (check-in: 12424bef77 user: drh tags: trunk) | |
|
2004-11-24
| ||
| 01:16 | Fix a memory leak in pager.c. (CVS 2151) (check-in: 0ad4ed87ce user: drh tags: trunk) | |
|
2004-11-23
| ||
| 22:16 | fulltest runs now, but still finds a memory leak. (CVS 2150) (check-in: 5944d51e6c user: drh tags: trunk) | |
| 16:31 | Fix a memory leak in ALTER TABLE. (CVS 2149) (check-in: ba71716ce2 user: danielk1977 tags: trunk) | |
| 15:41 | Add authorization callbacks for REINDEX. (CVS 2148) (check-in: 9f0d744ee4 user: danielk1977 tags: trunk) | |
| 12:24 | Include the 'FOR' keyword in builds that include cursors but not triggers. (CVS 2147) (check-in: 3053d82d71 user: danielk1977 tags: trunk) | |
| 11:16 | Make the test suite pass when SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS is defined. (CVS 2146) (check-in: ff20c623c6 user: danielk1977 tags: trunk) | |
| 10:52 | Ensure the test suite runs with SQLITE_OMIT_PAGER_PRAGMAS defined. (CVS 2145) (check-in: 2d1f0b923d user: danielk1977 tags: trunk) | |
| 10:13 | Have tests pass when SQLITE_OMIT_SCHEMA_PRAGMAS is defined. (CVS 2144) (check-in: 6ccb589bd9 user: danielk1977 tags: trunk) | |
| 09:06 | Fix a bug involving balance_shallow() and the sqlite_master table. (CVS 2143) (check-in: 557be3ff5b user: danielk1977 tags: trunk) | |
| 01:47 | More work on the implementation of cursors, but they are still not functioning. (CVS 2142) (check-in: 8b61d1ae1c user: drh tags: trunk) | |
|
2004-11-22
| ||
| 19:12 | Add initial infrastructure for cursors. In where.c, optimize out clauses of the form "ORDER BY rowid" if a table scan is being performed. Do a reverse table scan if "ORDER BY rowid DESC" is present. (CVS 2141) (check-in: fc8c1393c8 user: drh tags: trunk) | |
| 19:07 | Fix a long-standing bug in btree.c in the sqlite3BtreePrevious() routine. The problem has gone unnoticed before now because it only occurs when you use the OP_Prev opcode on a B+Tree. (CVS 2140) (check-in: 3d2536c479 user: drh tags: trunk) | |
| 15:05 | Fix a couple of extra test-suite problems with SQLITE_OMIT_VIEW. (CVS 2139) (check-in: 894c142d11 user: danielk1977 tags: trunk) | |
| 13:35 | Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: 007be591b7 user: danielk1977 tags: trunk) | |
| 11:51 | Ensure tests pass when SQLITE_OMIT_TRIGGER is defined. (CVS 2137) (check-in: 53894988ac user: danielk1977 tags: trunk) | |
| 10:20 | Fix a test-suite error made in check-in (2132) (CVS 2136) (check-in: 48c7eb7fb9 user: danielk1977 tags: trunk) | |
| 10:02 | Back out changes allowing writes to tables that have open cursors. (CVS 2135) (check-in: ec6b48f4b2 user: danielk1977 tags: trunk) | |
| 10:02 | Back out changes allowing writes to tables that have open cursors. (CVS 2134) (check-in: af635cab8a user: danielk1977 tags: trunk) | |
| 10:02 | Back out changes allowing writes to tables that have open cursors. (CVS 2133) (check-in: 91acd87e52 user: danielk1977 tags: trunk) | |
| 08:43 | Modify test suite to work when SQLITE_OMIT_VIEW is defined. (CVS 2132) (check-in: 711e8d7695 user: danielk1977 tags: trunk) | |
| 05:26 | Have tests pass when SQLITE_OMIT_MEMORYDB is defined. (CVS 2131) (check-in: 9df837c039 user: danielk1977 tags: trunk) | |
| 03:34 | Fix auth.test to work when SQLITE_OMIT_ALTERTABLE is defined. (CVS 2130) (check-in: 27a8379b54 user: danielk1977 tags: trunk) | |
|
2004-11-21
| ||
| 01:02 | AUTOINCREMENT documentation added. Improvements to lang.html. (CVS 2129) (check-in: ac72a1d551 user: drh tags: trunk) | |
|
2004-11-20
| ||
| 21:02 | Fix to the documentation on sqlite3_create_function. Ticket #899. (CVS 2128) (check-in: 4ab1d012f0 user: drh tags: trunk) | |
| 20:44 | Avoid excess heap usage when copying expressions. Ticket #979. (CVS 2127) (check-in: d10560c752 user: drh tags: trunk) | |
| 20:31 | Correct use of usableSize versus pageSize in btree.c. Ticket #1010. (CVS 2125) (check-in: 5a4013ec9c user: drh tags: trunk) | |
| 20:18 | Better error message on an SQLITE_RANGE error. Ticket #991. (CVS 2124) (check-in: accd432e4d user: drh tags: trunk) | |
| 19:55 | Rename source file sqlite.1 as sqlite3.1. Ticket #995. (CVS 2123) (check-in: 297559c6d1 user: drh tags: trunk) | |
| 19:18 | Omit the maximum loop count on the random name chooser in the VACUUM command. Add a comment to explain why this is safe and does not result in an infinite loop. Ticket #1009. (CVS 2122) (check-in: 1241086f23 user: drh tags: trunk) | |
| 19:18 | Rig the sqliteMalloc() routine so that we can make it fail multiple times in a row. Modify the malloc.test procedure to make malloc fail in this way and verify that the failures are still handled correctly. (CVS 2121) (check-in: 519bc9d997 user: drh tags: trunk) | |
| 18:13 | Fix segfaults that might occur after a malloc failure. (CVS 2119) (check-in: 368774487e user: drh tags: trunk) | |
| 08:17 | Documentation for REINDEX and ALTER TABLE commands. (CVS 2118) (check-in: aceaa5f6e9 user: danielk1977 tags: trunk) | |
| 06:05 | Add a documentation page for compilation options. Still some work to go. (CVS 2117) (check-in: 5efa2d2a60 user: danielk1977 tags: trunk) | |
|
2004-11-19
| ||
| 11:59 | Split up the lang.html page into a seperate page for each command. (CVS 2116) (check-in: ea315668e5 user: danielk1977 tags: trunk) | |
| 08:41 | Ensure ALTER TABLE respects the system table convention - "sqlite_*". (CVS 2115) (check-in: f635b6aae6 user: danielk1977 tags: trunk) | |
| 08:02 | Update the sqlite_sequence table when a table is renamed with ALTER_TABLE. (CVS 2114) (check-in: 6e97186880 user: danielk1977 tags: trunk) | |
| 07:07 | When dropping a table, update the sqlite_sequence table first, as auto-vacuum mode may need to move sqlite_sequence when the btree table is dropped. (CVS 2113) (check-in: 0514107bff user: danielk1977 tags: trunk) | |
| 05:14 | Fix bugs in ALTER TABLE related to (a) whitespace in table defn, (b) temp triggers. (CVS 2112) (check-in: 1fd8e835a3 user: danielk1977 tags: trunk) | |
|
2004-11-18
| ||
| 15:44 | Handle triggers correctly in ALTER TABLE. (CVS 2111) (check-in: c61b7de107 user: danielk1977 tags: trunk) | |
| 13:49 | Speed improvement on the LIKE command. (CVS 2110) (check-in: 85d56beb74 user: drh tags: trunk) | |
| 02:10 | Fix an obsolete comment that resulted in incorrect documentation. Ticket #1003. (CVS 2109) (check-in: c93a9e18d2 user: drh tags: trunk) | |
| 02:04 | Clarify the documentation of the sqlite3_create_function API. Ticket #1004. (CVS 2108) (check-in: ae45ad863b user: drh tags: trunk) | |
|
2004-11-17
| ||
| 16:41 | Add the ESCAPE clause to the LIKE operator. Not fully tested yet. (CVS 2107) (check-in: 49268c2b7a user: danielk1977 tags: trunk) | |
| 10:22 | Extra tests and resulting bugfixes for btree cursors. (CVS 2106) (check-in: e1530854c9 user: danielk1977 tags: trunk) | |
|
2004-11-16
| ||
| 23:21 | Clarify the LIMIT clause in the documentation. Ticket #1002. (CVS 2105) (check-in: e05f52d907 user: drh tags: trunk) | |
| 15:50 | Perform deletes in a single pass. (CVS 2104) (check-in: a2e1c35b32 user: danielk1977 tags: trunk) | |
| 04:57 | Allow btree cursors to persist through BtreeDelete() calls. (CVS 2103) (check-in: 6ad5fc8e1a user: danielk1977 tags: trunk) | |
|
2004-11-15
| ||
| 23:42 | Fix a typo in the header comment to the MakeRecord opcode so that the documentation generator will actually see the opcode description. Ticket #1001. (CVS 2102) (check-in: 33c9b647aa user: drh tags: trunk) | |
| 01:40 | Add test cases for escape characters in the GLOB operator. (CVS 2101) (check-in: bb2d9ff881 user: drh tags: trunk) | |
|
2004-11-14
| ||
| 21:56 | The SQLITE_OMIT_UTF16 macro now removes lots of code and all tests still pass. (CVS 2100) (check-in: 98c7a55478 user: drh tags: trunk) | |
| 04:04 | Changes toward reducing code size when SQLITE_OMIT_UTF16 is enabled. (CVS 2099) (check-in: 59a0a8b7ce user: drh tags: trunk) | |
|
2004-11-13
| ||
| 15:59 | More compile-time options for removing components. (CVS 2098) (check-in: dcbc0c22cf user: drh tags: trunk) | |
| 13:19 | Code toward having btree cursors persist when their table is written too. Doesn't work properly yet. (CVS 2097) (check-in: 5eaa18d43f user: danielk1977 tags: trunk) | |
| 03:59 | Fix the keyword generator so that it works with SQLITE_OMIT_ALTERTABLE. (CVS 2096) (check-in: 60ace9985d user: drh tags: trunk) | |
| 03:48 | Autoincrement is now working and has regression tests. (CVS 2095) (check-in: 10c712a219 user: drh tags: trunk) | |
|
2004-11-12
| ||
| 16:12 | Change pragmas schema_cookie and user_cookie to schema_version and user_version. (CVS 2094) (check-in: 5e05831844 user: danielk1977 tags: trunk) | |
| 15:53 | Add authorization callbacks to ALTER TABLE. (CVS 2093) (check-in: c4115aa3a1 user: danielk1977 tags: trunk) | |
| 13:42 | Add the "ALTER TABLE xxx RENAME TO yyy" command. (CVS 2092) (check-in: a1b2cc63e6 user: danielk1977 tags: trunk) | |
| 03:56 | Autoincrement code installed. Simple smoke-testing only. No regression tests developed yet. (CVS 2091) (check-in: 8fde833c81 user: drh tags: trunk) | |
|
2004-11-11
| ||
| 19:32 | Website updates. (CVS 2090) (check-in: 60fb0cef09 user: drh tags: trunk) | |
| 05:10 | Add the schema_cookie and user_cookie pragmas. (CVS 2089) (check-in: d28d1d68e5 user: danielk1977 tags: trunk) | |
| 01:50 | Add documentation for DEFAULT CURRENT_TIME & co. (CVS 2088) (check-in: c85f13f8f2 user: danielk1977 tags: trunk) | |
|
2004-11-10
| ||
| 15:27 | Ensure the test suite can run with either SQLITE_OMIT_AUTOVACUUM or SQLITE_DEFAULT_AUTOVACUUM=1 defined. (CVS 2087) (check-in: 0747b55882 user: danielk1977 tags: trunk) | |
| 12:34 | Fix expr.test so that it works when the date-time functions are compiled out of the library. (CVS 2086) (check-in: 540ce7de1b user: danielk1977 tags: trunk) | |
| 11:55 | Ensure tables cannot be created/dropped when btree cursors are open. (CVS 2085) (check-in: 8e5c2e5df8 user: danielk1977 tags: trunk) | |
| 05:48 | Add user documentation for the "pragma auto_vacuum" command. (CVS 2084) (check-in: fe200eaf37 user: danielk1977 tags: trunk) | |
|
2004-11-09
| ||
| 16:13 | Have "DEFAULT CURRENT_TIME" & co. work even if SQLITE_OMIT_DATETIME_FUNCS is defined. (CVS 2083) (check-in: f81b9c1c02 user: danielk1977 tags: trunk) | |
| 12:44 | Port the "DEFAULT CURRENT_TIME" etc. functionality from an earlier fork of sqlite. (CVS 2082) (check-in: 0d27c8ff48 user: danielk1977 tags: trunk) | |
| 07:42 | Refactor the space-analysis script for readability. (CVS 2081) (check-in: 63f2ee22e2 user: danielk1977 tags: trunk) | |
|
2004-11-08
| ||
| 16:15 | Update the space-analyzer tool to support auto-vacuum databases. (CVS 2080) (check-in: 1cb8086612 user: danielk1977 tags: trunk) | |
| 12:32 | A few more auto-vacuum tests. (CVS 2079) (check-in: 9d4a60bbd6 user: danielk1977 tags: trunk) | |
| 09:51 | Check in the file autovacuum_crash.test that should be part of the previous check-in. (CVS 2078) (check-in: 9d7cd1f732 user: danielk1977 tags: trunk) | |
| 09:26 | Test auto-vacuum mode for crash-proofness. Also fix a bug related to the same. (CVS 2077) (check-in: 839ad771a6 user: danielk1977 tags: trunk) | |
| 07:13 | Auto-vacuum: Account for the page reserved for windows locking (PENDING_BYTE). (CVS 2076) (check-in: d633569869 user: danielk1977 tags: trunk) | |
|
2004-11-07
| ||
| 13:01 | Reindex tests added and bugs fixed. (CVS 2075) (check-in: ad433ec2b6 user: drh tags: trunk) | |
|
2004-11-06
| ||
| 12:26 | Auto-vacuum: Ensure pages to be removed by database truncation are in the journal file. Also fix an sqlite3pager_movepage() bug. (CVS 2074) (check-in: 081676e491 user: danielk1977 tags: trunk) | |
| 00:02 | Compile and pass the quick regression tests with autovacuum disabled. (CVS 2073) (check-in: 89b9026a53 user: drh tags: trunk) | |
|
2004-11-05
| ||
| 23:46 | First cut at a REINDEX command. Basic testing only. No documentation. (CVS 2072) (check-in: 11dba47e61 user: drh tags: trunk) | |
| 22:18 | Use sqlite3NestedParse to implement DROP INDEX. (CVS 2071) (check-in: 0f81aa5b05 user: drh tags: trunk) | |
| 20:58 | Use sqlite3NestedParse to implement CREATE INDEX. (CVS 2070) (check-in: 47d8ebdaad user: drh tags: trunk) | |
| 17:17 | Create table now works with sqlite3NestedParse. This changed uncovered a latent bug in xprintf which is also fixed. (CVS 2069) (check-in: b0506bdd70 user: drh tags: trunk) | |
| 16:37 | Do not truncate a database file until after fsync() has been called on the journal. (CVS 2068) (check-in: cfee7f4a00 user: danielk1977 tags: trunk) | |
| 15:45 | Make auto-vacuum a run-time option (default determined by SQLITE_DEFAULT_AUTOVACUUM macro). (CVS 2067) (check-in: b9d5f007fc user: danielk1977 tags: trunk) | |
| 12:58 | Auto-vacuum bug: Don't set meta(3) to a pointer-map page number when deleting a table. (CVS 2066) (check-in: 44a015b3a3 user: danielk1977 tags: trunk) | |
| 12:27 | Fix allocation of tables in an auto-vacuum database when the required root-page is on the free-list. (CVS 2065) (check-in: 4e2433378e user: danielk1977 tags: trunk) | |
| 09:19 | Don't code an OP_Statement within sqlite3NestedParse(). Also a correction to the UPDATE statement used within destroyRootPage(). (CVS 2064) (check-in: fdcc31f0c6 user: danielk1977 tags: trunk) | |
| 06:02 | When using sqlite3NestedParse() to modify the sqlite_master table, do not code OP_Callback. (CVS 2063) (check-in: 296a298c48 user: danielk1977 tags: trunk) | |
| 05:23 | Another bug fix from two check-ins ago. (CVS 2062) (check-in: c46eef2f6d user: drh tags: trunk) | |
| 05:20 | Fix a bug in the previous check-in. (CVS 2061) (check-in: 9d259d48de user: drh tags: trunk) | |
| 05:10 | More use of sqlite3NestedParse. This version of the code does not work. (CVS 2060) (check-in: ac2d5a605c user: drh tags: trunk) | |
| 03:56 | Begin using sqlite3NestedParse() to generate sections of code. (CVS 2059) (check-in: 2d302931a6 user: drh tags: trunk) | |
| 01:45 | Fix bug introduced with (2057). (CVS 2058) (check-in: aed2e623ec user: danielk1977 tags: trunk) | |
| 01:24 | Pop the value pushed by OP_Destroy if SQLITE_OMIT_AUTOVACUUM is defined. (CVS 2057) (check-in: b0c103340a user: danielk1977 tags: trunk) | |
| 00:43 | Incremental check-in of changes that will ultimately lead to a working autoincrement. (CVS 2056) (check-in: 10c3d88305 user: drh tags: trunk) | |
|
2004-11-04
| ||
| 14:47 | All tests pass when SQLITE_OMIT_INTEGRITY_CHECK is defined. (CVS 2055) (check-in: 158a2d16a8 user: drh tags: trunk) | |
| 14:30 | Support root-page allocation/deallocation in auto-vacuum databases. Still a few problems. (CVS 2054) (check-in: 1da361fae8 user: danielk1977 tags: trunk) | |
| 04:42 | All tests pass even if OMIT_TRIGGER is defined. (CVS 2053) (check-in: c33b3a6137 user: drh tags: trunk) | |
| 04:34 | Fix a #ifdef in util.c. Ticket #984. (CVS 2052) (check-in: da045bd183 user: drh tags: trunk) | |
| 02:57 | Add support for table allocation (not deallocation) in auto-vacuum databases. (CVS 2051) (check-in: 571de52376 user: danielk1977 tags: trunk) | |
|
2004-11-03
| ||
| 16:27 | Update tests to work even if some features of the library are disabled. (CVS 2050) (check-in: b11fc9b3f3 user: drh tags: trunk) | |
| 13:59 | More work on optionally removing unused features at compile-time. (CVS 2049) (check-in: a82980fd70 user: drh tags: trunk) | |
| 11:37 | Auto-vacuum bug: Deallocate pointer-map pages when shrinking a database file. (CVS 2048) (check-in: bec6a65aca user: danielk1977 tags: trunk) | |
| 09:30 | Comment the autovacuum.test script. No code or test-case changes. (CVS 2047) (check-in: 2eacd38620 user: danielk1977 tags: trunk) | |
| 08:44 | Auto-vacuum bug: Correctly manipulate page cache hash-table entries in sqlite3pager_movepage(). (CVS 2046) (check-in: 719c1b7967 user: danielk1977 tags: trunk) | |
| 03:59 | The makefile now runs mkkeywordhash.c. Keywords that are unused are omitted from the keyword hash table. (CVS 2045) (check-in: 007aec1133 user: drh tags: trunk) | |
| 03:52 | Auto-vacuum bugfix: Do not attempt to move a pointer-map page during auto-vacuum. (CVS 2044) (check-in: bd50fbb5fe user: danielk1977 tags: trunk) | |
| 03:01 | Fix an auto-vacuum bug that occurs when a btree cell is promoted to the parent page during a delete. (CVS 2043) (check-in: b7d953e119 user: danielk1977 tags: trunk) | |
|
2004-11-02
| ||
| 18:15 | Fix a problem in the pragma.test script. (CVS 2041) (check-in: a2c9c45c80 user: drh tags: trunk) | |
| 18:05 | Get btree.c to compile with -DNDEBUG=1. (CVS 2040) (check-in: 8378c144c1 user: drh tags: trunk) | |
| 14:40 | Fix an auto-vacuum bug for btree entries that span more than one overflow page. (CVS 2039) (check-in: 40249ed19c user: danielk1977 tags: trunk) | |
| 14:24 | Require that the page size be a power of 2. (CVS 2038) (check-in: c33b34dbe9 user: drh tags: trunk) | |
| 12:56 | Code to auto-vacuum the database if all root pages happen to be in the right place. Not active by default and largely untested. (CVS 2037) (check-in: d12481f09c user: danielk1977 tags: trunk) | |
|
2004-11-01
| ||
| 16:03 | Updates to the support.html page. (CVS 2036) (check-in: 5515accee3 user: drh tags: trunk) | |
|
2004-10-31
| ||
| 16:25 | Add code to create/update the btree 'pointer-map' for auto-vacuum mode. (CVS 2035) (check-in: bebd967f36 user: danielk1977 tags: trunk) | |
| 02:22 | Insert #ifdefs that can optionally remove features at compiletime resulting in a database engine with a smaller footprint. (CVS 2034) (check-in: be661acfa8 user: drh tags: trunk) | |
|
2004-10-30
| ||
| 20:23 | Begin adding the ability to remove unused features at compile-time and still have all the tests pass. (CVS 2033) (check-in: 2aa506ccb0 user: drh tags: trunk) | |
|
2004-10-26
| ||
| 16:34 | Move affinity.html into the attic. (CVS 2032) (check-in: 87a3c668f0 user: drh tags: trunk) | |
| 16:33 | Mark the affinity.html file as obsolete. (CVS 2031) (check-in: 09de96b6b2 user: drh tags: trunk) | |
| 00:08 | Fix a bug in the ".databases" command of the command-line shell. Ticket #973 (CVS 2030) (check-in: 507d8e6f5c user: drh tags: trunk) | |
|
2004-10-25
| ||
| 20:33 | Minor optimizations in the pragma module. (CVS 2029) (check-in: 63efd50a16 user: drh tags: trunk) | |
|
2004-10-23
| ||
| 05:10 | Tighter encoding of the keyword hash table in the tokenizer. (CVS 2028) (check-in: 7b9886f8d4 user: drh tags: trunk) | |
|
2004-10-22
| ||
| 20:29 | Add the experimental and scary pragma "writable_schema". (CVS 2027) (check-in: 39f7870a54 user: drh tags: trunk) | |
| 16:22 | Fix alignment problems in btree and pager and allow page sizes that are not a multiple of 8. (CVS 2026) (check-in: 0539c2d2b8 user: drh tags: trunk) | |
|
2004-10-19
| ||
| 16:40 | Reinsert code deleted by (1998) that we thought was unused but was in fact needed. Fix for ticket #966. (CVS 2025) (check-in: 370ca53950 user: drh tags: trunk) | |
| 01:31 | Fix a typo in the quickstart document. (CVS 2024) (check-in: 55b03c560d user: drh tags: trunk) | |
|
2004-10-18
| ||
| 21:34 | Fix typos in the names of some regression tests. Ticket #962. (CVS 2023) (check-in: 77542beb31 user: drh tags: trunk) | |
|
2004-10-12
| ||
| 02:38 | Fix typo on homepage. Ticket #956. (CVS 2022) (check-in: 552ec6770a user: drh tags: trunk) | |
| 00:56 | Version 3.0.8 (CVS 2021) (check-in: 7dd66d7653 user: drh tags: trunk) | |
| 00:50 | Updates to the README file (CVS 2020) (check-in: d3d0d7a8bb user: drh tags: trunk) | |
|
2004-10-11
| ||
| 22:26 | Increment the version number. Prepare for release of version 3.0.8. (CVS 2019) (check-in: ff04d7d48b user: drh tags: trunk) | |
| 21:49 | Fix typo on the homepage. (CVS 2018) (check-in: 7f190f85e2 user: drh tags: trunk) | |
| 21:48 | Fix typo in the lockingv3.html page on the website. (CVS 2017) (check-in: a31b647727 user: drh tags: trunk) | |
|
2004-10-10
| ||
| 19:11 | The mkopcodeh.awk script removes \r for use with msys. Ticket #954. (CVS 2016) (check-in: c4fb44fd5f user: drh tags: trunk) | |
| 18:00 | Documentation updates (CVS 2015) (check-in: a4546c09d7 user: drh tags: trunk) | |
| 17:24 | Typos and spelling errors in documention. (CVS 2014) (check-in: 16e2ace2db user: drh tags: trunk) | |
|
2004-10-09
| ||
| 15:54 | New links on the common header page of the website. (CVS 2013) (check-in: 6d6246f150 user: drh tags: trunk) | |
|
2004-10-07
| ||
| 22:22 | Sort the output of glob in test script attach2.test. Ticket #948. (CVS 2012) (check-in: 3d04eef9b7 user: drh tags: trunk) | |
| 19:03 | Optimizations to the tokenizer. (CVS 2011) (check-in: e5540ce047 user: drh tags: trunk) | |
| 03:06 | Additional parser optimizations. (CVS 2010) (check-in: 618dee121e user: drh tags: trunk) | |
| 00:32 | In the command-line shell in CSV move, put strings in C-style double-quotes. Ticket #911. (CVS 2009) (check-in: 1376a0bb8d user: drh tags: trunk) | |
|
2004-10-06
| ||
| 15:52 | Fix naming conflict between sqlite.h and sqlite3.h. Ticket #946. (CVS 2007) (check-in: 3037041263 user: drh tags: trunk) | |
| 15:41 | Convert many constants to have type "const". (CVS 2006) (check-in: d790c84c5a user: drh tags: trunk) | |
| 15:03 | Move some work out of the makefiles and into awk scripts in separate files. Ticket #940. (CVS 2005) (check-in: 4d0f29d54c user: drh tags: trunk) | |
| 14:39 | Size optimization in the parser. (CVS 2004) (check-in: 8e2ae24498 user: drh tags: trunk) | |
| 14:39 | Fix the ".import" command of the command-line shell so that it ignores \n and \r at the end of a line. Ticket #939. (CVS 2003) (check-in: dcbf4817a7 user: drh tags: trunk) | |
|
2004-10-05
| ||
| 17:37 | Rearrange memory allocation in sqlite3VdbeMakeReady to try to work around some byte-alignment problems on Sparc. (CVS 2002) (check-in: f623d6e74f user: drh tags: trunk) | |
| 15:42 | Use the database name supplied to table_info() and related pragmas. (CVS 2001) (check-in: 0415af3257 user: drh tags: trunk) | |
| 02:41 | Add support for DEFERRED, IMMEDIATE, and EXCLUSIVE transactions. (CVS 2000) (check-in: 81ff8107ad user: drh tags: trunk) | |
|
2004-10-04
| ||
| 13:38 | More changes to take advantage of the TK_ and OP_ alignments to avoid unnecessary translations. (CVS 1999) (check-in: e8e972ba65 user: drh tags: trunk) | |
| 13:19 | Save about 800 bytes of code space by aligning TK_ and OP_ constants so that we do not have to translate between them. (CVS 1998) (check-in: 4c817e3f29 user: drh tags: trunk) | |
|
2004-10-02
| ||
| 20:38 | Fixes to the OsUnlock() interface. Correctly leave a SHARED lock behind when requested. Honor the error code that OsUnlock() returns. Ticket #913 and #938. (CVS 1997) (check-in: c4697503d0 user: drh tags: trunk) | |
|
2004-10-01
| ||
| 18:21 | make diskfull test work on Windows; see check-in (1994) (CVS 1996) (check-in: 4493e28780 user: dougcurrie tags: trunk) | |
| 14:38 | Additional code to test the SQLITE_FULL return when the disk is full. (CVS 1994) (check-in: 44e56f0bba user: drh tags: trunk) | |
| 03:02 | Fully release exclusive locks in the Unlock primitive of Unix. Ticket #913. (CVS 1993) (check-in: 11a37a74b1 user: drh tags: trunk) | |
| 02:00 | Use type i64 instead of off_t for file offsets since off_t is giving portability problems. Ticket #924. (CVS 1992) (check-in: 8972c004dc user: drh tags: trunk) | |
|
2004-09-30
| ||
| 14:24 | Strict prototype on sqlite3_libversion(). Ticket #936 (CVS 1991) (check-in: 1d3c6f7351 user: drh tags: trunk) | |
| 14:22 | Correctly parser column typenames that contain more than one identifier. Ticket #934. (CVS 1990) (check-in: 85ad18712d user: drh tags: trunk) | |
| 13:43 | Allow functions to be created when there are outstanding VMs. (Ticket #926) Fix problems with sqlite3_errcode(). Add tests for sqlite3_errcode(). (CVS 1989) (check-in: d0f1dc5898 user: drh tags: trunk) | |
|
2004-09-27
| ||
| 13:19 | Comment changes in btree.c. No changes to code. (CVS 1988) (check-in: b15abf984f user: drh tags: trunk) | |
| 12:20 | Bug fix in btree.c in cases where usableSize!=pageSize. Ticket #925. (CVS 1987) (check-in: cb3e12372d user: drh tags: trunk) | |
|
2004-09-25
| ||
| 15:29 | Remove unused CLUSTER keyword from the parser. (CVS 1986) (check-in: 54ee1664aa user: drh tags: trunk) | |
| 15:25 | Optimizations in the tokenizer. (CVS 1985) (check-in: 26898c57cb user: drh tags: trunk) | |
| 14:39 | Code cleanup: get rid of the sqlite3SetNString utility function. (CVS 1984) (check-in: 9ef4c24a9a user: drh tags: trunk) | |
| 13:12 | Code simplifications and size reductions. (CVS 1983) (check-in: cb631a135d user: drh tags: trunk) | |
|
2004-09-24
| ||
| 23:59 | Size optimizations in vdbeapi.c. (CVS 1982) (check-in: b2f3d4bb8e user: drh tags: trunk) | |
| 23:20 | Save a few bytes in utf.c. (CVS 1981) (check-in: 8154d545e8 user: drh tags: trunk) | |
| 22:32 | Optimizations to vdbeaux.c and printf.c (CVS 1980) (check-in: eabc77c99b user: drh tags: trunk) | |
| 19:39 | Improvements to the debugging code. (CVS 1979) (check-in: bdc3bb070f user: drh tags: trunk) | |
| 12:50 | Fix typo in ".help" output from the shell. Ticket #914. (CVS 1978) (check-in: 1ee3a787ad user: drh tags: trunk) | |
| 12:48 | Avoid a segfault in sqlite3_bind_parameter_index when there are unnamed parameters. Ticket #918. (CVS 1977) (check-in: 49f25ddf83 user: drh tags: trunk) | |
| 12:24 | Simplification of the trigger code. (CVS 1976) (check-in: 9fa904d94e user: drh tags: trunk) | |
| 12:24 | Fix for tickets #912 and #922. Problem introduced by check-in (1973). (CVS 1975) (check-in: 9001e2220d user: drh tags: trunk) | |
|
2004-09-20
| ||
| 14:57 | Pthread is now conditionally included in makefile, see ticket #910 (CVS 1974) (check-in: a35e522769 user: dougcurrie tags: trunk) | |
|
2004-09-19
| ||
| 02:15 | Add comments to unused P3 fields of selected instructions when NDEBUG is not defined. This makes VDBE program dumps more readable during debugging. (CVS 1973) (check-in: 4871c77f8f user: drh tags: trunk) | |
| 00:50 | Merge the ListPush and ListPop VDBE opcodes into ContextPush and ContextPop. (CVS 1972) (check-in: eb9b501ad8 user: drh tags: trunk) | |
|
2004-09-18
| ||
| 18:51 | Fix typo on homepage. (CVS 1971) (check-in: 5d3b3a96bc user: drh tags: trunk) | |
| 18:45 | Version 3.0.7 (CVS 1970) (check-in: d82ded9543 user: drh tags: trunk) | |
| 18:00 | Up the version number and prepare documentation files for the 3.0.7 release. (CVS 1969) (check-in: 63e4ed3cc6 user: drh tags: trunk) | |
|
2004-09-17
| ||
| 21:35 | Always include -lpthread on link lines even if it is not needed. (CVS 1968) (check-in: 46a96890f7 user: drh tags: trunk) | |
| 21:07 | Make use of $(libdir) in the Makefile.in. Ticket #904. (CVS 1967) (check-in: 10b5e51733 user: drh tags: trunk) | |
| 20:47 | Create directories using "mkdir -p". Ticket #903. (CVS 1966) (check-in: 02de1cf95e user: drh tags: trunk) | |
| 20:46 | Close stray statements prior to finishing trace.test, to avoid a file descriptor leak. (CVS 1965) (check-in: 8bb0221da8 user: drh tags: trunk) | |