/ Timeline
Login

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

100 check-ins occurring around 2010-09-29.

2010-10-21
02:05
Fix the query planner so that it uses the multi-index OR-clause solution if that is the lowest cost estimate. A prior bug cause the multi-index solution to be ignored in some circumstances. check-in: 28ba6255 user: drh tags: trunk
2010-10-20
18:56
Updates to FTS4 to improve performance and make more accurate cost estimates for prefix terms. check-in: d0a450ce user: dan tags: experimental
2010-10-19
14:08
Experimental changes to fts4 to try to selectively avoid loading very large doclists. check-in: 5ae0ba44 user: dan tags: experimental
2010-10-15
14:45
Cherry-pick the change at [2d4505510032bf9] into the 3.6.1 branch. check-in: ecb1419e user: drh tags: branch-3.6.1
2010-10-14
01:17
Avoid taking locks on unused database connections when committing a read transaction. check-in: c0ee614f user: drh tags: trunk
01:16
Check-in [d3c95e3a4e08d0] was incorrect. This is the correct fix for sqlit3_bind_blob(). Ticket [860399cc408f2dd5f4] check-in: ea8c2f5f user: drh tags: trunk
2010-10-12
02:13
Fix the sqlite3_bind_blob() interface (and its kin) so that the destructor is invoked if the binding fails. Ticket [860399cc408f2dd5f41aed44b] Update the documentation to explain which interfaces invoke their destructors on failure and which do not. check-in: d3c95e3a user: drh tags: trunk
2010-10-11
17:58
Make sure the sqlite3_create_collation() interfaces always return an error code if they fail. Ticket [a04e42a3fcacaffa3133436]. check-in: 6464276e user: drh tags: trunk
17:57
Further changes to extension loading to support compile-time options. check-in: f818fb6f user: drh tags: trunk
13:12
Make APIs added since version 3.6.0 accessible to loadable extensions. check-in: 76c64a35 user: drh tags: trunk
2010-10-08
16:09
Add tests to e_createtable.test. check-in: 38bec827 user: dan tags: trunk
02:34
Version 3.7.3 check-in: 26778480 user: drh tags: trunk, release
2010-10-07
13:29
Update the CLI test script to expect a version number of 3.7.3. check-in: e55ada89 user: drh tags: trunk
2010-10-06
20:25
Update the configure script and Makefile so that they work with 3.7.3. check-in: 97b63a11 user: drh tags: trunk
18:55
Fix long-standing bugs with the handling of LIMIT clausing in compound SELECT statements with FROM clause subqueries. Ticket [38cb5df375078d3f9]. check-in: b0450120 user: drh tags: trunk
16:42
Fix minor test suite problems causing errors on OSX. check-in: 759c954f user: dan tags: trunk
09:57
Fix a bug in test code that was causing a valgrind error. No changes to production code. check-in: f29da7be user: dan tags: trunk
2010-10-05
18:22
Do not embedded #if inside an assert() statement. Fix for check-in [dca8763872a] check-in: d7d4a94f user: drh tags: trunk
17:02
Have the pager change to at least WRITER_CACHEMOD state before marking any pages as dirty (instead of immediately after). Otherwise, if an error occurs, the pager may be left in WRITER_LOCKED state with dirty pages in the cache. check-in: 471a4efb user: dan tags: trunk
15:41
If walLockExclusive() fails for reasons other than SQLITE_BUSY inside of walRestartLog() then propagate that error back up to the application. check-in: 04dcba6b user: drh tags: trunk
12:05
Avoid all memory allocation (and hence the possiblitity of OOM failure) in sqlite3_value_double() and sqlite3_column_double(). check-in: 4afdf970 user: drh tags: trunk
11:33
Fix an assert() failing on OSX. check-in: dca87638 user: dan tags: trunk
08:13
Prevent backcompat.test from mistaking directories for binary executables. check-in: 717a1e50 user: dan tags: trunk
2010-10-04
23:55
Fix a performance regression (relative to version 3.6.23.1) caused by the query planner taking into account non-indexable WHERE clause terms to select the outermost join loops when it should be selecting tables for the outermost loop that do not benefit from being in an inner loop. check-in: ece641eb user: drh tags: trunk
16:06
Fix a couple of test script problems. check-in: dd106901 user: dan tags: trunk
15:47
Fix memsubsys1.test so that it works with TEMP_STORE>=2. check-in: 8ad88ee0 user: dan tags: trunk
14:11
Warning cleanup from MSVC. check-in: cde62657 user: shaneh tags: trunk
11:01
Fix broken evidence marks in e_expr.test. check-in: 37ff94ce user: dan tags: trunk
10:45
Add tests for table-constraints to e_createtable.test. check-in: 70f51187 user: dan tags: trunk
2010-10-02
01:01
Backport the very lastest R-Tree in order to take advantage of its enhanced robustness to corrupt databases. Leaf check-in: 29a681dd user: drh tags: apple-osx-3623
01:00
Fix the amalgamation builder so that it works with the rtree updates of the prior check-in. Leaf check-in: 265b0b29 user: drh tags: branch-3.6.23
2010-10-01
20:45
Backport the RTree implementation from the trunk into the 3.6.23 branch. The code for the application-defined query boxes is still present but is disabled. The reason for this backport is to take advantage of recent enhancements to robustness to database corruption. check-in: 854b23c1 user: drh tags: branch-3.6.23
19:04
Add tests for CHECK and UNIQUE constraints to e_createtable.test. check-in: fb8db558 user: dan tags: trunk
17:23
Add #ifndef USE_SYSTEM_SQLITE...#endif around the bundled SQLite library for the TCL bindings. check-in: 8d85584a user: drh tags: trunk
15:11
Not true: For a zeroblob, the Mem.z pointer can be null: The Mem.z pointer can never been NULL for a string or blob, even a zero-length string or blob. Assert this fact. Closed-Leaf check-in: efda3104 user: drh tags: mistake
13:28
Updates to the showjournal.c utility in order to bring it up to version 3. check-in: fa97d895 user: drh tags: trunk
2010-09-30
20:33
Merge experimental into trunk: Refactor the text-to-numeric conversion routines to work without zero-terminators and in UTF16 as well as UTF8. Avoid invalidating strings with doing affinity conversions. check-in: 07ee080e user: drh tags: trunk
20:11
Fix some matching issues in enc4.test affected by TCL versions. Closed-Leaf check-in: dd6d61a9 user: shaneh tags: experimental
18:43
Add further tests to e_createtable.test. check-in: 0a4528d6 user: dan tags: trunk
18:30
Fix memory leak in enc4.test script. check-in: bfc294ae user: shaneh tags: experimental
18:19
Additional encoding tests. check-in: c7f93636 user: shaneh tags: experimental
18:12
Remove unnecessary calls to memAboutToChange() in vdbe.c. An affinity change no longer invalidates shallow copies. check-in: afb0fd0b user: drh tags: experimental
17:33
Do correct affinity transformations on floating point values which have a decimal point at the beginning or end of the mantissa. Ticket [3998683a16a7076e08f5]. check-in: ca154f97 user: drh tags: experimental
16:51
Changes to remove sqlite3FitsIn64Bits(). check-in: 43fef1ca user: shaneh tags: experimental
14:48
Fix the handling of default values for ALTER TABLE ADD COLUMN columns so that is able to deal with negative numbers, including large negative numbers. Ticket [8454a207b9fd2243c4] check-in: ce6cc16e user: drh tags: experimental
00:50
Rework the text to numeric conversion routines so that they work with either UTF8 or UTF16 and do not require a NULL terminator. This allowed text to numeric conversion without reallocating the string. check-in: 14eed3a0 user: drh tags: experimental
2010-09-29
23:09
Add tests for "CREATE TABLE ... AS SELECT ..." statements to e_createtable.test. check-in: 1ef0dc93 user: dan tags: trunk
18:26
Add test cases to e_createtable.test. check-in: f34dc54d user: dan tags: trunk
07:16
Fix some problems that can occur if a trigger has the same name as another database object. check-in: 655991ec user: dan tags: trunk
01:54
Updates to sqlite3_finalize() documentation. check-in: 8c5994cf user: drh tags: trunk
2010-09-28
20:26
Simplify the test that determines if the name of a new table collides with a prior index name. check-in: 3f30f00a user: drh tags: trunk
17:37
Merge accidental fork. check-in: 33c8b9c7 user: drh tags: trunk
17:34
Add tests to e_createtable.test. Allow a table to be created if there is an index of the same name in a different attached database. check-in: 6251e587 user: dan tags: trunk
17:34
Get ANALYZE working again with -DSQLITE_ENABLE_STAT2 and virtual tables. check-in: b7a26427 user: drh tags: trunk
15:55
Disallow statements of the form "CREATE TEMP TABLE main.t1 ...". check-in: dd1b34ba user: dan tags: trunk
15:25
Updates to e_vacuum.test so that it works when SQLITE_DEFAULT_AUTOVACUUM=1 is set. check-in: 890816c5 user: drh tags: trunk
14:26
Fix several harmless compiler warnings. check-in: 7be03ecc user: drh tags: trunk
14:11
Fix an incompatibility with OMIT_VIRTUALTABLE in e_vacuum.test. check-in: 7d0b881a user: dan tags: trunk
13:12
Updates to the sqlite3_get_table() documentation. check-in: c7aa238c user: drh tags: trunk
07:24
Update the version number to 3.7.3 in preparation for the next release. check-in: 88108fff user: drh tags: trunk
07:14
Merge fixes for ticket [b351d95f9cd5ef17e9d9dbae18f5ca8611190001] into the trunk. check-in: 1f7ef0af user: drh tags: trunk
07:11
Replace some unreachable branch instructions with assert() statements. Closed-Leaf check-in: 88b84bf1 user: drh tags: bug-b351d95f9c
06:00
Tweaks to help facilitate structural test coverage. check-in: ff49a5f0 user: drh tags: bug-b351d95f9c
04:14
Test case and fix for the specific failure of ticket [b351d95f9cd5ef17e9d9dbae]. check-in: 57789cfe user: drh tags: bug-b351d95f9c
03:55
Use OP_Copy rather than OP_SCopy at one point in aggregate processing where it is needed to avoid shallow-copy misuse. check-in: a5eefd52 user: drh tags: bug-b351d95f9c
00:25
Continuing work toward detecting and fixing shallow-copy misuse. check-in: d0342f4b user: drh tags: bug-b351d95f9c
2010-09-27
21:09
Add assert() statements that fail when a shallow copy is accessed after the original has been modified. These assert() statements should detect the kinds of subtle SCopy bugs such as caused the fault in ticket [b351d95f9cd5ef17e9d9dbae18f]. check-in: 8b8e1732 user: drh tags: bug-b351d95f9c
18:14
Simplifications to the expression code generator. Remove about 80 lines of older and obsolete code. check-in: 53f5cfe1 user: drh tags: trunk
2010-09-25
22:32
Enhance the ANALYZE command so that it gathers statistics in the sqlite_stat1 table even for tables that are empty or have no indices. check-in: a7645d29 user: drh tags: trunk
17:29
Add new file e_createtable.test. check-in: 20e16fef user: dan tags: trunk
14:13
Do not call gethostuuid() on MacOS 10.4 and earlier, since it is not supported there. check-in: 44deaaef user: drh tags: trunk
07:51
Add tests to file e_reindex.test. check-in: eec7dc91 user: dan tags: trunk
2010-09-24
19:14
Modify some evidence tags to match updated gifs. check-in: f44de500 user: dan tags: trunk
18:08
Merge experimental branch back into trunk. check-in: 83ecec5d user: dan tags: trunk
18:04
Add new file e_vacuum.test. Move part of e_select.test into e_select2.test. Closed-Leaf check-in: 30801892 user: dan
09:32
Add experimental branch disallowing VACUUM when there are one or more active SQL statements. check-in: c1ebcacd user: dan tags: experimental
08:00
Modify testable statement ids in a few test files to account for recent docsrc changes. check-in: 7893e525 user: dan tags: trunk
2010-09-23
18:47
Add tests to e_delete.test. check-in: fab3b383 user: dan tags: trunk
2010-09-22
19:06
Further tests and changes to make the r-tree module more robust. check-in: 7ff3574b user: dan tags: trunk
14:19
Add new file rtreeA.test, to test that the r-tree extension doesn't crash if it encounters a corrupt or inconsistent database. check-in: 68a305fd user: dan tags: trunk
2010-09-21
19:00
Add new file e_delete.test. check-in: 14e8659e user: dan tags: trunk
16:59
Add tests to e_update.test. check-in: 528f71e2 user: dan tags: trunk
2010-09-20
19:17
Add test file e_update.test. check-in: 03985ed4 user: dan tags: trunk
14:55
Changes to test scripts to work with SQLITE_TEMP_STORE=2. check-in: ba8ca9c9 user: dan tags: trunk
14:05
Add further tests to e_insert.test. check-in: eb3d0d8b user: dan tags: trunk
08:47
Add a test case to verify that bug [313723c356] has been fixed. check-in: 4ea134a8 user: dan tags: trunk
2010-09-18
19:36
Make sure the pager cache is cleared if there is any difficulty starting a new read transaction in WAL mode. Ticket [313723c356483eff2a4c4bdd2c]. check-in: e14ef0e8 user: drh tags: trunk
19:00
Add new test file e_insert.test. check-in: 8023a309 user: dan tags: trunk
15:15
Fix a couple of stale evidence marks in e_select.test. check-in: 14227724 user: dan tags: trunk
15:03
Add tests to e_select.test. check-in: 0ee9e755 user: dan tags: trunk
2010-09-17
22:39
Clarifications to the sqlite3_auto_extension() documentation. check-in: ca96e0df user: drh tags: trunk
19:45
Updates to the documentation for sqlite3_create_collation(). check-in: 3df7715a user: drh tags: trunk
19:04
Add tests for some syntax diagrams in lang_select.html. check-in: 2254e93b user: dan tags: trunk
17:10
Remove additional occurrences of <ctype.h> from FTS2. check-in: ee52589c user: drh tags: trunk
16:01
Add new test file fts3shared.test to test the previous change. check-in: a207f744 user: dan tags: trunk
15:28
Have all FTS3 queries obtain a read or write table-lock at the shared-cache level before doing anything else. check-in: 018e82c7 user: dan tags: trunk
01:07
Completely remove all trace of ctype.h from FTS2. check-in: 87684566 user: drh tags: trunk
2010-09-16
23:18
Fix a comment typo in memjournal.c check-in: 9b272ed4 user: drh tags: trunk
19:49
Updates to the requirements on the sqlite3_create_function() family of interfaces. check-in: f03c6089 user: drh tags: trunk
18:51
Add tests for ORDER BY, LIMIT and OFFSET clauses to e_select.test. check-in: 7c989db5 user: dan tags: trunk