/ Timeline
Login

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

57 check-ins using file test/pagerfault.test version 84c6a4fc

2012-08-25
00:49
Backport check-in [62678be3df35cd]: When the same index is used for all OR-terms in a WHERE clause, then try to use that index as a covering index. Leaf check-in: 865dfcba user: drh tags: branch-3.7.2
2011-10-25
21:18
Cherrypick the [3513bf6ee090d9] so that the sqlite_source_id() function works correctly even with newer versions of Fossil check-in: 89d63a0e user: drh tags: branch-3.7.2
20:36
Cherrypick changes [53f5cfe115] and [1f7ef0af8d] in order to fix an issue with DISTINCT check-in: 14bc58ca user: drh tags: branch-3.7.2
2011-08-26
18:28
Veryquick and min.rc tests now passing. Closed-Leaf check-in: a7e18468 user: drh tags: stat3-3.7.2
18:04
Merge the branch-3.7.2 changes into the stat3-3.7.2 subbranch. Also fix some test script issues. check-in: a42db19d user: drh tags: stat3-3.7.2
17:17
Cherrypick the recursion fix to test_vfs.c from [065e5a5ea4f82]. Also fix the nan.test module to handle upper/lower case changes in TCL. check-in: 41b5f869 user: drh tags: branch-3.7.2
15:51
Get stat3 working after import from trunk-based the stat3-enhancement branch. There is still a problem in the wal2 test. check-in: 01cc4ff6 user: drh tags: stat3-3.7.2
13:52
Merge branches branch-3.7.2 and stat3-enhancement into a new branch for testing purposes. check-in: 0df04f92 user: drh tags: stat3-3.7.2
2011-07-13
18:53
Cherrypicked from trunk: Do not try to use STAT2 for row estimates if the index is unique or nearly so. check-in: d55b64ef user: drh tags: branch-3.7.2
2011-07-12
14:48
Cherrypick change [9f14fa56ba] (the fix for [54844eea3f]) from the trunk. check-in: 7afb2354 user: dan tags: branch-3.7.2
2011-07-02
15:42
Cherrypick change [27c65d4d9c] into the 3.7.2 branch. check-in: 9bbcd8c0 user: dan tags: branch-3.7.2
13:34
Cherrypick [45e581bff7] into the 3.7.2 branch. check-in: c593792c user: dan tags: branch-3.7.2
2011-05-01
22:57
Backport check-ins [0900e35348f4b9bf3] and [4fead8e714c7e50] to the 3.7.2 branch. These check-ins provide hints to the btree layer for when it is possible to use a hash table rather than a btree to implement an index. The SQLite BTree layer does not use these hints, but alternative btree layers might. check-in: 7155e6f3 user: drh tags: branch-3.7.2
2011-04-15
15:18
Backport check-in [9f9f32882501ac9] to provide EXPLAIN QUERY PLAN output for the count(*) optimization. Also backport check-in [a8761a9128de945aa] to prevent unordered indices from being used on a full table scan. The first backport was necessary in order to test the second. check-in: 8d924e16 user: drh tags: branch-3.7.2
2011-04-09
03:30
Back port the unordered-index-hack to the 3.7.2 branch. check-in: 80353020 user: drh tags: branch-3.7.2
2011-04-08
23:36
Backport test cases from trunk that seek to prove that the IS NOT NULL query optimization is working. check-in: 9eff4702 user: drh tags: branch-3.7.2
23:05
Make sure the query planner is able to correctly analyze NULL value samples in the sqlite_stat2 table. This is a backport of changes from check-in [f73a167b434f] check-in: 1d637889 user: drh tags: branch-3.7.2
23:04
Make sure the left-hand side of the IS NOT NULL operator is a simple column and not a general expression before applying the IS NOT NULL optimization. This is a backport of check-in [543f75a6abe3]. check-in: e8177e01 user: drh tags: branch-3.7.2
2011-03-31
18:36
Provide hints to the btree layer Next and Previous primitives to let them know if they can be no-ops if the underlying index is unique. check-in: a5aae174 user: drh tags: branch-3.7.2
2011-03-17
01:53
Backport the "x IS NULL" query planner enhancement of [2353176811f] to the 3.7.2 branch. check-in: 68daf20d user: drh tags: branch-3.7.2
2011-03-12
05:55
Backport the SQLITE_OMIT_UNIQUE_ENFORCEMENT change from check-in [b86999436e] on the trunk. check-in: 668b91db user: shaneh tags: branch-3.7.2
2011-03-09
22:09
Backport the OP_Next and OP_Prev for UNIQUE indices patch from checkin [f000c9b2b7] on the trunk. check-in: 2d55234e user: drh tags: branch-3.7.2
2011-03-04
01:23
Backport the query planner enhancement of [952f5e8c69904] to the 3.7.2 branch. check-in: 440d9956 user: drh tags: branch-3.7.2
2011-02-12
14:23
Fix the expected output on tests so that it corresponds to the new query planner results. All of veryquick.test is now passing with SQLITE_ENABLE_STAT2. check-in: f2a8b5cc user: drh tags: branch-3.7.2
05:34
Fix problems in the backport, reducing the number of errors in the TCL tests to just a few dozen. Most of the remaining errors seem to be real and desirable changes of behavior. check-in: 9d2b0af2 user: drh tags: branch-3.7.2
01:59
This is the beginning of an attempt to backport recent query planner enhancements to version 3.7.2. The code in this version builds and runs and seems to give correct answers, but it generates suboptimal query plans and hence many of the test cases fail. The test script gives up after 1000 errors. check-in: e72cf118 user: drh tags: branch-3.7.2
2011-01-05
13:07
Cherrypick the WAL error logging from the pre-3.7.5 line into a branch for version 3.7.2. Include the sqlite3_vsnprintf() interface. This checkin is intended for debugging and not for release. Leaf check-in: 6549e767 user: drh tags: wal-trace-372
2010-08-30
15:43
Add tests (and associated fixes) to restore coverage of rtree.c. check-in: b06f4695 user: dan tags: trunk
15:02
Remove the sqlite3BtreeFactory() wrapper routine. All modules now call sqlite3BtreeOpen() directly. check-in: 0900e353 user: drh tags: trunk
11:34
Add file sqlite3rtree.h. check-in: e1d9ffce user: dan tags: trunk
01:17
Updates to comments on the VDBE opcodes. check-in: 49c05b4e user: drh tags: trunk
2010-08-28
19:09
Fix problem with func3.test. check-in: aec52959 user: dan tags: trunk
18:58
Add code to allow user-defined searches of r-tree tables. Still largely untested. check-in: 782ca3b7 user: dan tags: trunk
2010-08-27
18:44
Make sqlite3_create_function() a special case of sqlite3_create_function_v2() in order reduce the number of code paths and simplify testing. check-in: 4758d86d user: drh tags: trunk
17:48
Add the sqlite3_create_function_v2() API, a version of create_function that allows a destructor to be specified. check-in: 9a724dfb user: dan tags: trunk
17:16
Refactor the implementation of the scratch memory allocator. Add the SQLITE_TESTCTRL_SCRATCHMALLOC interface to facilitate testing. check-in: a3475ddf user: drh tags: trunk
12:21
Remove unnecessary code from malloc.c. Enhance pcache1.c so that is tries to reuse existing pages, rather than create new pages, when SQLite is under memory pressure. "Memory pressure" means that SQLITE_CONFIG_PAGECACHE memory is nearly exhausted or sqlite3_soft_heap_limit() has been reached. check-in: 51049479 user: drh tags: trunk
11:19
Further tests for CAST in e_expr.test. check-in: 9616df8c user: dan tags: trunk
2010-08-26
19:05
Add tests for CAST expressions to e_expr.test. More to come. check-in: ba6119d1 user: dan tags: trunk
16:46
Add EXTERN macros before entry points in tclsqlite.c. These EXTERN macros were inexplicably removed by [1f680cb37584baa106cee05] a few days ago. check-in: 8b2cf9d4 user: drh tags: trunk
14:15
Fix a couple of memory leaks in r-tree that can occur following an OOM condition. check-in: 1975a27c user: dan tags: trunk
11:27
Remove unreachable condition from rtree.c. check-in: 90f40cd3 user: dan tags: trunk
07:59
Improve coverage of rtree.c some more. check-in: bee1959d user: dan tags: trunk
05:23
Simplification of changes for SQLITE_OMIT_WAL support in pager.c. check-in: afb2484c user: shaneh tags: trunk
2010-08-25
20:35
Reinstate the "sqlite" alias for backwards compatibility (but leave it undocumented) but remove the PackageProvide for "sqlite". check-in: 699cc6b4 user: drh tags: trunk
19:39
Disable the legacy "sqlite" command in the TCL interface. Provide only the "sqlite3" command. check-in: 909b3d88 user: drh tags: trunk
19:04
Further test coverage improvements for rtree.c. check-in: 05f6c1ae user: dan tags: trunk
17:53
Test cases to improve coverage of rtree module. Fixes associated with the same. check-in: 865cec04 user: dan tags: trunk
2010-08-24
20:46
Replicate asserts on unixOpen() to winOpen() in os_win.c. check-in: 40526d83 user: shaneh tags: trunk
18:35
Changes to support building with SQLITE_OMIT_WAL. check-in: d1ed743b user: shaneh tags: trunk
18:07
Change sqlite3_open_v2() to return SQLITE_MISUSE if the combination of bits in the flags parameter is invalid. The documentation says the behavior in this situation is undefined - the documentation is unaltered by this code change. check-in: 5e8101c5 user: drh tags: trunk
18:06
Comment enhancements and typo fixes in pcache1.c. check-in: c2dc39c0 user: drh tags: trunk
16:59
Fixes to allow fts3 tables to be renamed mid-transaction. check-in: d1c87532 user: dan tags: trunk
13:11
Add tests to e_expr.test. check-in: 5c1c694e user: dan tags: trunk
01:49
The R-tree module should not assume that its shadow tables are consistent. If a problem is found in a shadow table, return SQLITE_CORRUPT. check-in: 7f2f71cc user: drh tags: trunk
00:40
Version 3.7.2 check-in: 42537b60 user: drh tags: trunk, release, version-3.7.2
2010-08-23
18:19
Fixes for the SQLITE_CHECK_PAGES debugging feature. check-in: 21a1e596 user: dan tags: trunk