SQLite

Timeline
Login

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

200 most recent check-ins using file publish.sh version 72bde067

2005-02-15
13:38
Fix a hyperlink bug on the homepage. (CVS 2338) (check-in: 9fd9d9fb user: drh tags: trunk)
13:08
Version 3.1.2 (CVS 2337) (check-in: e9012d91 user: drh tags: trunk)
13:07
Updates to the script that generates the download page for the website. (CVS 2335) (check-in: 363590d3 user: drh tags: trunk)
12:56
Update the change log. (CVS 2334) (check-in: 94c3f20e user: drh tags: trunk)
12:51
Update the homepage prior to releases 2.8.16 and 3.1.2. (CVS 2333) (check-in: 603bbe47 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: dcbc9833 user: danielk1977 tags: trunk)
02:54
Check that read-only pages are not being modified (disabled by default). (CVS 2331) (check-in: 8514a4fe 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: cbed92f3 user: drh tags: trunk)
06:38
Tighten up the CREATE INDEX syntax accepted by the parser. (CVS 2329) (check-in: 41d2214b 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: f3c51de7 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: f7858d88 user: danielk1977 tags: trunk)
00:19
Fix a problem with VACUUM that can lead to database corruption. (CVS 2323) (check-in: 63894baf 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: c33c02d6 user: danielk1977 tags: trunk)
03:20
Add experimental collation_list pragma. (CVS 2321) (check-in: f73a8aa3 user: danielk1977 tags: trunk)
01:40
Document SQLITE_DEFAULT_CACHE_SIZE and SQLITE_DEFAULT_TEMP_CACHE_SIZE macros. (CVS 2320) (check-in: ddcea6f8 user: danielk1977 tags: trunk)
2005-02-08
08:42
Fix a buggy interaction between "INSERT ... SELECT" processing and optimization (2170). (CVS 2319) (check-in: c54ad212 user: danielk1977 tags: trunk)
07:50
Fix for correlated subqueries where the parent is an aggregate. Ticket #1105. (CVS 2318) (check-in: f0d3ca10 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: 2155448d user: drh tags: trunk)
2005-02-05
12:48
Allow expressions (including variables) in LIMIT and OFFSET clauses. Ticket #1096. (CVS 2316) (check-in: 515e5033 user: danielk1977 tags: trunk)
07:33
Add a numeric version number. Ticket #1097. (CVS 2315) (check-in: a9c33a80 user: danielk1977 tags: trunk)
06:49
Detect database corruption in rootpage flags (see also (2313)). (CVS 2314) (check-in: 6d91a1e9 user: danielk1977 tags: trunk)
2005-02-04
21:13
Detect and report a subtle case of database file corruption. (CVS 2313) (check-in: 9fc0a5cb user: drh tags: trunk)
04:07
Remove code for SQL cursors. (CVS 2312) (check-in: 2eb90870 user: danielk1977 tags: trunk)
2005-02-03
01:08
Get AUTOINCREMENT and VACUUM working together. Ticket #1095. (CVS 2311) (check-in: 332a531d 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: 76c4a96c 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: 4b399ae7 user: drh tags: trunk)
2005-02-02
01:13
Fix a comment in sqlite3.h. No code changes. Ticket #1093. (CVS 2308) (check-in: d1ea2fb7 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: 50608879 user: danielk1977 tags: trunk)
2005-02-01
17:05
Version 3.1.1 (beta) (CVS 2306) (check-in: 2e1c71c4 user: drh tags: trunk)
15:57
Increment the version number to 3.1.1beta. (CVS 2305) (check-in: 076f9868 user: drh tags: trunk)
10:36
Space analyzer: Format integer results as integers. Also fix the calculation of average-fanout. (CVS 2304) (check-in: 52e473b9 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: ab85e1d0 user: danielk1977 tags: trunk)
04:09
More performance tweaking in the parser. (CVS 2302) (check-in: a3d12726 user: drh tags: trunk)
03:46
Fix an error introduced with (2299). (CVS 2301) (check-in: 22041d5f 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: adcd9a3f user: drh tags: trunk)
03:09
Avoid allocating a vdbe in sqlite3FinishCoding() if one has not been allocated already. (CVS 2299) (check-in: eaf1866e user: danielk1977 tags: trunk)
02:13
Change to sqlite3AffinityType() to remove hex constants. (CVS 2298) (check-in: d8b4b0ef 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: 4eca6c05 user: drh tags: trunk)
01:21
Replace sqlite3AffinityType() with a slightly faster version. (CVS 2296) (check-in: abe9f5e8 user: danielk1977 tags: trunk)
2005-01-31
23:45
Performance tweaks for sqlite3AffinityType. (CVS 2295) (check-in: 32b92615 user: drh tags: trunk)
12:56
Move sqlite3HashNoCase to hash.c. (CVS 2294) (check-in: 5c10ccd8 user: danielk1977 tags: trunk)
12:42
Assorted minor changes to speed up loading the database schema. (CVS 2293) (check-in: dfbd684a user: danielk1977 tags: trunk)
2005-01-30
22:10
User-contributed chagnes to tclinstaller so that it supports DESTDIR. (CVS 2292) (check-in: ab8dbcf5 user: drh tags: trunk)
11:11
Respect collation sequences in views. Ticket #1088. (CVS 2291) (check-in: 9843c0dd 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: 356d31e0 user: danielk1977 tags: trunk)
2005-01-29
09:14
Update to test files to support builds with OMIT macros defined. (CVS 2289) (check-in: 808e16a7 user: danielk1977 tags: trunk)
09:00
Fix a test bug causing a segfault in bind.test. (CVS 2288) (check-in: a8b921d4 user: danielk1977 tags: trunk)
08:36
Update ioerr.test to be more deterministic. (CVS 2287) (check-in: d0b16bae user: danielk1977 tags: trunk)
08:32
Modify sub-query handling. Tickets #1083 and #1084. (CVS 2286) (check-in: b1b50f31 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: 95ecb274 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: 522c094f user: drh tags: trunk)
2005-01-27
00:33
Fix a warning introduced by (2280). (CVS 2283) (check-in: dc1b8106 user: danielk1977 tags: trunk)
00:33
More changes to improve propagation of SQLITE_CORRUPT errors. (CVS 2282) (check-in: e4b5c168 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: 1d5ebb11 user: danielk1977 tags: trunk)
00:22
Have REINDEX handle missing collation sequences correctly. (CVS 2280) (check-in: 1c1904f4 user: danielk1977 tags: trunk)
2005-01-26
21:55
Propagate detected database corruption up through the call stack. (CVS 2279) (check-in: 2c54aba5 user: drh tags: trunk)
17:47
An optimization to sqlite3VdbeSerialType(). (CVS 2278) (check-in: db367738 user: drh tags: trunk)
10:39
Add an entry to faq.tcl regarding SQLITE_SCHEMA errors. (CVS 2277) (check-in: 12defe8c user: danielk1977 tags: trunk)
03:58
Allow GROUP BY on non-aggregate queries. Ticket #1064 (CVS 2276) (check-in: 0642d3e3 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: cabab62b 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: 557eb2ec user: danielk1977 tags: trunk)
13:03
More test cases to do with invalidating precompiled statements. (CVS 2273) (check-in: b243681a user: danielk1977 tags: trunk)
12:46
Use the cache with loading a large table in select2-2.0. (CVS 2272) (check-in: bd65b180 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: d5233e07 user: danielk1977 tags: trunk)
01:38
Flush the TCL statement cache before each lock_status pragma. (CVS 2270) (check-in: 8beae3ff 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: 8db6bfef 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: 0778383b user: danielk1977 tags: trunk)
22:41
Minor changes to avoid warnings on some compilers. (CVS 2267) (check-in: 4daf1d1f 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: 1a64295e 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: 6c631b86 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: 764b55ad user: danielk1977 tags: trunk)
03:03
Add the experimental sqlite3_expired() API. (CVS 2263) (check-in: df648d50 user: drh tags: trunk)
2005-01-21
21:31
Add <stddef.h> to sqliteInt.h. (CVS 2262) (check-in: fede252d 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: 2ddb6748 user: drh tags: trunk)
18:28
Version 3.1.0 (alpha) (CVS 2260) (check-in: 45094abe user: drh tags: trunk)
18:19
Documentation updates prior to 3.1.0. (CVS 2259) (check-in: fc4f1f13 user: drh tags: trunk)
17:53
Initialize the random number generator from /dev/urandom, if available. (CVS 2258) (check-in: aab8e7f8 user: drh tags: trunk)
17:07
Change to mkopcodeh.awk to accomodate windows systems. (CVS 2257) (check-in: 39786aa8 user: drh tags: trunk)
17:03
Update change log for version 3.1.0. (CVS 2256) (check-in: 4d9b8587 user: drh tags: trunk)
15:52
Final preparations for the 3.1.0 alpha release. (CVS 2255) (check-in: 17122c7e user: drh tags: trunk)
11:55
Improve test coverage for minimum feature builds. (CVS 2254) (check-in: 9c4d0e13 user: danielk1977 tags: trunk)
08:13
Exclude a few more lines of code using OMIT macros. (CVS 2253) (check-in: c6fc49e6 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: d4e19efc 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: bb0254ab user: danielk1977 tags: trunk)
02:34
Add a new test file for subqueries. (CVS 2250) (check-in: de8ee3a2 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: 06887afb user: danielk1977 tags: trunk)
00:22
Fix a segfault that occurs on a corrupt database. (CVS 2248) (check-in: d1166472 user: drh tags: trunk)
2005-01-20
23:23
Fix comment typo in mkopcodec.awk. (CVS 2247) (check-in: 61771482 user: drh tags: trunk)
22:48
Bug fixes and enhancements entered while on jury recess. (CVS 2246) (check-in: 38401dfb 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: d30fdf0f user: drh tags: trunk)
13:03
Remove a few more lines of code when SQLITE_OMIT_** macros are defined. (CVS 2244) (check-in: 417bbba9 user: danielk1977 tags: trunk)
11:32
Extend the influence of a couple of SQLITE_OMIT_** macros a little bit. (CVS 2243) (check-in: 5b1a9bf6 user: danielk1977 tags: trunk)
05:24
Changes so that crash.test works when SQLITE_OMIT_PAGER_PRAGMAS is defined. (CVS 2242) (check-in: f0add0a6 user: danielk1977 tags: trunk)
02:17
Fix some test scripts so that they work with a minimal build configuration. (CVS 2241) (check-in: d267fb3c user: danielk1977 tags: trunk)
02:14
Turn SQLITE_OMIT_CURSOR on by default. (CVS 2240) (check-in: 2d3ab1ab user: drh tags: trunk)
01:51
Expression generator bug fix. (CVS 2239) (check-in: 39cf97a9 user: drh tags: trunk)
01:17
Minor fix for sqlite3_clear_bindings(). (CVS 2238) (check-in: ff5b338c user: danielk1977 tags: trunk)
01:14
Add the experimental sqlite3_sleep() and sqlite3_clear_bindings() APIs. (CVS 2237) (check-in: 9480209e user: danielk1977 tags: trunk)
2005-01-19
23:24
Continued refactoring of the name resolution logic and query optimizer. (CVS 2236) (check-in: d8b2a7e0 user: drh tags: trunk)
03:52
Another fix along the same lines as (2234) (CVS 2235) (check-in: 27cf8322 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: 441316f1 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: c06add57 user: drh tags: trunk)
17:20
CREATE TABLE ... AS ... uses short names for columns. Ticket #1036. (CVS 2232) (check-in: b1d4c42d 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: 9295050a user: drh tags: trunk)
14:45
Continue refactoring name resolution. Fix for ticket #1047. (CVS 2230) (check-in: 88d4834f 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: 0142ae6f 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: 4a753439 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: 5a9da62a user: danielk1977 tags: trunk)
07:53
Fix some memory leak problems with corrupt.test and auto-vacuum databases. (CVS 2226) (check-in: 62442529 user: danielk1977 tags: trunk)
03:42
Add incomplete, preliminary drafts of new documentation. (CVS 2225) (check-in: a01159e8 user: drh tags: trunk)
03:40
Fix a memory leak that occurs as a result of an IO error. (CVS 2224) (check-in: 1edfdcbf 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: 2d58c0af user: danielk1977 tags: trunk)
01:33
Have sqlite3pager_get() return SQLITE_CORRUPT for a page number greater than 2^31. (CVS 2222) (check-in: feb49d10 user: danielk1977 tags: trunk)
2005-01-16
23:21
Turn on quick-balance by default. (CVS 2221) (check-in: d0356dee 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: de9ad673 user: drh tags: trunk)
11:07
Changes to make sure tests work when SQLITE_DEFAULT_AUTOVACUUM is defined. (CVS 2219) (check-in: 6237c294 user: danielk1977 tags: trunk)
09:06
Fixes so that compiling and testing works when SQLITE_OMIT_AUTOVACUUM is defined. (CVS 2218) (check-in: fe548561 user: danielk1977 tags: trunk)
08:00
Move duplicate code to update pointer-map wrt overflow pages into a function. (CVS 2217) (check-in: a5c21214 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: 0ae29538 user: danielk1977 tags: trunk)
01:52
Test coverage improvements. (CVS 2215) (check-in: 92f9d2b2 user: drh tags: trunk)
00:40
Improved test coverage for update.c. (CVS 2214) (check-in: 3ef95d5f user: drh tags: trunk)
00:36
Improved coverage for insert.c. (CVS 2213) (check-in: 997d8aff user: drh tags: trunk)
2005-01-14
22:55
Add comments to the new balance_quick() routine. (CVS 2212) (check-in: 183c42ea user: drh tags: trunk)
13:50
Experimental patch to balance() (use -DSQLITE_BALANCE_QUICK). (CVS 2211) (check-in: c550d80c user: danielk1977 tags: trunk)
01:22
Improved test coverage on insert.c. (CVS 2210) (check-in: c772f751 user: drh tags: trunk)
2005-01-13
23:54
Need SQLITE_MEMDEBUG instead of SQLITE_DEBUG in tclsqlite.c. (CVS 2209) (check-in: 6e905270 user: drh tags: trunk)
23:54
Fix a bug in lemon that does not effect SQLite. Ticket #1068. (CVS 2208) (check-in: 7113b5ed user: drh tags: trunk)
13:35
Tidy up malloc.test a bit. (CVS 2207) (check-in: 94cf91cc user: danielk1977 tags: trunk)
11:10
Fix typo in shell .help. Ticket #1071. (CVS 2206) (check-in: 2c7a1a16 user: danielk1977 tags: trunk)
11:07
Test cases to improve coverage of pager.c. (CVS 2205) (check-in: 0428a148 user: danielk1977 tags: trunk)
02:14
Fixes to 'configure' build system. Also extra coverage for main.c. (CVS 2204) (check-in: 8378455f user: danielk1977 tags: trunk)
2005-01-12
13:04
Fix a test bug introduce with the previous commit. (CVS 2203) (check-in: 1c19e8bd user: danielk1977 tags: trunk)
12:44
Tests to improve coverage of main.c. (CVS 2202) (check-in: 4e28c82a user: danielk1977 tags: trunk)
09:10
Tests to improve coverage of vdbeaux.c. (CVS 2201) (check-in: 2b3e21ce user: danielk1977 tags: trunk)
07:15
Tests to improve coverage of vdbemem.c. (CVS 2200) (check-in: 319bb4a9 user: danielk1977 tags: trunk)
00:08
Fix a bug in tclsqlite.c. (CVS 2199) (check-in: 50f1e229 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: 1bee1bb9 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: 00a352ea user: drh tags: trunk)
17:46
Test coverage improvements on tokenize.c. (CVS 2196) (check-in: 5767850c user: drh tags: trunk)
16:54
Improved test coverage for vdbeaux.c. (CVS 2195) (check-in: 3f46cd77 user: drh tags: trunk)
15:28
Improved test coverage for util.c. (CVS 2194) (check-in: ad451a2d user: drh tags: trunk)
13:02
Test cases to improve coverage of vdbe.c. (CVS 2193) (check-in: a6b45722 user: danielk1977 tags: trunk)
11:08
Remove a C++ style comment that went in with the previous commit. (CVS 2192) (check-in: ce8e4e88 user: danielk1977 tags: trunk)
10:25
Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2191) (check-in: a37e0108 user: danielk1977 tags: trunk)
10:25
Test cases to improve coverage of btree.c (and minor bugfixes). (CVS 2190) (check-in: 8ced4915 user: danielk1977 tags: trunk)
2005-01-10
12:59
Extra test cases to improve coverage of btree.c (CVS 2189) (check-in: a4619886 user: danielk1977 tags: trunk)
06:39
Update some documentation for version 3.1. (CVS 2188) (check-in: 5b7a5a4d user: danielk1977 tags: trunk)
02:48
Fix an assertion failure due to interaction between the count_changes pragma and triggers. (CVS 2187) (check-in: 6c7bec1b 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: ad109537 user: drh tags: trunk)
15:44
Fixes to the temp_store_directory pragma. (CVS 2185) (check-in: 0a90eaf3 user: drh tags: trunk)
15:43
Fix a comment. (CVS 2184) (check-in: 26fbac8f 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: fb3bf68d 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: 5023b1db 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: 7373a5d4 user: danielk1977 tags: trunk)
08:56
Fix a read of invalid memory that could occur in btree.c. (CVS 2180) (check-in: 929745c1 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: bf143876 user: danielk1977 tags: trunk)
2005-01-03
21:28
add --enable-debug to configure options, controls -DNDEBUG flag (CVS 2178) (check-in: 9d674d1d user: tpoindex tags: trunk)
18:13
add comment that table is accessed by primary key (CVS 2177) (check-in: 707690c5 user: tpoindex tags: trunk)
02:26
Allow GROUP BY on aggregate queries only. Ticket #1039. (CVS 2176) (check-in: 8ef2c644 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: 586acc85 user: drh tags: trunk)
01:28
Fix a typo in a comment. No code changes. Ticket #1052. (CVS 2174) (check-in: 9fb1402f user: drh tags: trunk)
01:27
Fix comment typos. no code changes. (CVS 2173) (check-in: 4165217e 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: 5fd1f471 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: 772e22cb 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: e5aa4894 user: drh tags: trunk)
2004-12-18
18:40
Improvements to the query optimizer. This is a work in progress. (CVS 2169) (check-in: 9b86993f user: drh tags: trunk)
2004-12-17
20:48
Fix a C++-ism in the previous change to tclsqlite.c. (CVS 2168) (check-in: b49b8fdd 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: a9311d9d user: tpoindex tags: trunk)
2004-12-16
21:09
Make sure LIMITs are handled correctly on UNION operators. Ticket #1035. (CVS 2166) (check-in: ece0085f user: drh tags: trunk)
2004-12-14
03:34
Minor code and comment cleanup. (CVS 2165) (check-in: d012628a 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: 7f38f67c user: drh tags: trunk)
17:17
Fix a problem with the automatic generation of the opcode name table. (CVS 2163) (check-in: 9eefabc9 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: 7f4679b9 user: drh tags: trunk)
02:20
Improvements to the --help option to configure. Ticket #1033. (CVS 2161) (check-in: 3032cc2b 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: 4c30c373 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: bf81aabf 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: 4852186a user: drh tags: trunk)
14:06
Simplify the trigger logic for DELETE, INSERT, and UPDATE. (CVS 2157) (check-in: 8e164ab2 user: drh tags: trunk)
12:29
Remove the unused sqlite3_context.isStep element. (CVS 2156) (check-in: 7b20f2b7 user: drh tags: trunk)
02:14
Updates to API documentation and comments in sqlite3.h. (CVS 2155) (check-in: 46584348 user: drh tags: trunk)
2004-12-02
20:17
Get the build of sqlite3_analyzer working with Makefile.in. (CVS 2154) (check-in: f7415a0d 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: d75014c2 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: 12424bef user: drh tags: trunk)
2004-11-24
01:16
Fix a memory leak in pager.c. (CVS 2151) (check-in: 0ad4ed87 user: drh tags: trunk)
2004-11-23
22:16
fulltest runs now, but still finds a memory leak. (CVS 2150) (check-in: 5944d51e user: drh tags: trunk)
16:31
Fix a memory leak in ALTER TABLE. (CVS 2149) (check-in: ba71716c user: danielk1977 tags: trunk)
15:41
Add authorization callbacks for REINDEX. (CVS 2148) (check-in: 9f0d744e user: danielk1977 tags: trunk)
12:24
Include the 'FOR' keyword in builds that include cursors but not triggers. (CVS 2147) (check-in: 3053d82d user: danielk1977 tags: trunk)
11:16
Make the test suite pass when SQLITE_OMIT_SCHEMA_VERSION_PRAGMAS is defined. (CVS 2146) (check-in: ff20c623 user: danielk1977 tags: trunk)
10:52
Ensure the test suite runs with SQLITE_OMIT_PAGER_PRAGMAS defined. (CVS 2145) (check-in: 2d1f0b92 user: danielk1977 tags: trunk)
10:13
Have tests pass when SQLITE_OMIT_SCHEMA_PRAGMAS is defined. (CVS 2144) (check-in: 6ccb589b user: danielk1977 tags: trunk)
09:06
Fix a bug involving balance_shallow() and the sqlite_master table. (CVS 2143) (check-in: 557be3ff user: danielk1977 tags: trunk)
01:47
More work on the implementation of cursors, but they are still not functioning. (CVS 2142) (check-in: 8b61d1ae 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: fc8c1393 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: 3d2536c4 user: drh tags: trunk)
15:05
Fix a couple of extra test-suite problems with SQLITE_OMIT_VIEW. (CVS 2139) (check-in: 894c142d user: danielk1977 tags: trunk)
13:35
Ensure tests pass when SQLITE_OMIT_COMPOUND_SELECT is defined. (CVS 2138) (check-in: 007be591 user: danielk1977 tags: trunk)
11:51
Ensure tests pass when SQLITE_OMIT_TRIGGER is defined. (CVS 2137) (check-in: 53894988 user: danielk1977 tags: trunk)
10:20
Fix a test-suite error made in check-in (2132) (CVS 2136) (check-in: 48c7eb7f user: danielk1977 tags: trunk)
10:02
Back out changes allowing writes to tables that have open cursors. (CVS 2135) (check-in: ec6b48f4 user: danielk1977 tags: trunk)