Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
84 check-ins using file test/pager1.test version 6922029d
|
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-24
| ||
| 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) | |
| 17:09 | Update the version number in preparation for the 3.7.2 release. (check-in: 77889510 user: drh tags: trunk) | |
| 15:41 | Fix for ticket [5e10420e8d]. (check-in: 255f1eef user: dan tags: trunk) | |
| 15:26 | Update the "showdb" debug utility to handle 64K pages and with extra options to decode the freelist structure. (check-in: 1070918e user: drh tags: trunk) | |
| 01:25 | Version 3.7.1 (check-in: 3613b069 user: drh tags: trunk, release) | |
|
2010-08-21
| ||
| 15:51 | Add some tests to e_expr.test and pagerfault.test. No code changes. (check-in: 44de3cab user: dan tags: trunk) | |
| 15:09 | Fix the ptrmapPageno() routine so that it works correctly for an input of 1. (check-in: 699a9bf2 user: drh tags: trunk) | |
|
2010-08-20
| ||
| 15:32 | Do not allow a backup to change the page size if a codec is in use. (check-in: 5523ecd3 user: drh tags: trunk) | |
| 12:43 | Fix typo in backcompat.test. (check-in: 6a0cbb27 user: dan tags: trunk) | |
| 12:34 | Merge leaf created by accident. (check-in: 1f680cb3 user: dan tags: trunk) | |
| 12:31 | Avoid assuming that the user has "." in their path when running multi-process tests. (check-in: daa5d461 user: dan tags: trunk) | |
| 10:28 | Do not attempt run backwards compatibility tests if no historical "testfixture" binaries are available. (check-in: 40e11aab user: drh tags: trunk) | |
| 09:53 | Disable the MEMSYS2 auxiliary routines if MEMSYS2 is changed to an alternative memory allocator using SQLITE_CONFIG_MALLOC. (check-in: 541dd3b8 user: drh tags: trunk) | |
| 09:14 | Fix the sqlite3_release_memory() interface so that it does not attempt to free SQLITE_CONFIG_PAGECACHE memory. (check-in: 0426cd62 user: drh tags: trunk) | |
|
2010-08-19
| ||
| 18:05 | Adjust filename globbing in backcompat.test for Windows. (check-in: b0f47963 user: shaneh tags: trunk) | |
| 17:16 | Fix backcompat.test so that it works with windows mandatory locking. (check-in: 8d05f66d user: dan tags: trunk) | |
| 15:48 | Add tests for WAL mode to test/backcompat.test. (check-in: 7999910e user: dan tags: trunk) | |
| 15:12 | Merge two leaves. (check-in: b03091fc user: dan tags: trunk) | |
| 15:11 | Modify the code for reading hot-journal files so that it can handle journals generated by versions 3.5.7 and earlier. (check-in: b9170f29 user: dan tags: trunk) | |
| 14:41 | Fix typo in TCL stubs support for configure in Makefile.in (check-in: 4c7ad73d user: shaneh tags: trunk) | |
| 14:22 | Remove a NEVER from balance_quick() that can occur in WAL mode on a corrupt database file. (check-in: b273891a user: drh tags: trunk) | |
| 11:05 | Add new test script backcompat.test, for testing database/journal/wal file compatibility against previous versions. (check-in: 8804f498 user: dan tags: trunk) | |
|
2010-08-18
| ||
| 21:19 | Fix two asserts in the btree logic so that they work correctly even for maximum-size index entries for 32K and 64K pages. (check-in: e127192d user: drh tags: trunk) | |
| 17:16 | Updated tests for CLI. Added some basic tests for the .import command. (check-in: d46567e5 user: shaneh tags: trunk) | |
| 15:25 | Disable the SQLITE_MAX_PAGE_SIZE compile time option (it is now always set to 65536). Fix some other problems in test files. (check-in: 56cc883d user: dan tags: trunk) | |
| 14:54 | Fix issue with wal.test on Windows. (check-in: 3497f54a user: shaneh tags: trunk) | |
| 02:28 | Fix some compiler warnings in the MSVC build. (check-in: 1f5662b7 user: shaneh tags: trunk) | |
|
2010-08-17
| ||
| 19:49 | Remove a NEVER() that is actually reachable. (check-in: acb171d4 user: drh tags: trunk) | |
| 19:40 | Suppress harmless compiler warning. (check-in: 3f8c068a user: drh tags: trunk) | |
| 19:34 | Return an error when parsing "?NNN" if NNN is so large it cannot be stored as a 32-bit int. (check-in: fc9014be user: dan tags: trunk) | |
| 18:37 | It is no longer possible to reach pagerStress() while in the error state, so put a NEVER() around the error state test of that routine. (check-in: d7ed4634 user: drh tags: trunk) | |
| 18:15 | If an SQLITE_FULL error occurs during rollback or journal finalization, treat it in the same way as SQLITE_IOERR (i.e. require that the pager internals be completely reset before it is next read from or written to). (check-in: 8ac18523 user: dan tags: trunk) | |
| 17:25 | Changes to pager for improved testability. (check-in: 61c64b3a user: drh tags: trunk) | |
| 16:06 | Add tests for the BETWEEN operator to e_expr.test. (check-in: ced6a348 user: dan tags: trunk) | |
| 14:52 | Invoke sqlite3_log() whenever one or more frames are recovered from a WAL file. (check-in: e05089aa user: dan tags: trunk) | |
| 05:55 | Fix some non-ANSI C code in test_demovfs.c. Also change the same file so that attempting to delete a file that does not exist does not return an error. (check-in: 07570ce3 user: dan tags: trunk) | |
|
2010-08-16
| ||
| 20:02 | Remove an superfluous branch from pager.c. (check-in: 4271a95c user: drh tags: trunk) | |
| 19:23 | Add tests for different page sizes to wal.test. Including 64K pages. (check-in: d95bcc05 user: dan tags: trunk) | |
| 18:26 | Add test cases designed to exercise all syntax diagram paths in lang_expr.html (check-in: d4a26bb6 user: dan tags: trunk) | |
| 16:31 | Fix a typo in a comment in wal.c. No code changes. (check-in: d854a3d4 user: drh tags: trunk) | |
| 14:18 | Add ALWAYS() macros in wal.c to cover branches that are no longer reachable following the pager refactoring. (check-in: 24f24c92 user: drh tags: trunk) | |
|
2010-08-14
| ||
| 21:21 | Adjustments for better 64K page size handling. (check-in: faf1974e user: drh tags: trunk) | |
| 18:32 | Add test case to e_expr.test. (check-in: db9539f2 user: dan tags: trunk) | |
| 17:12 | Change sqlite3PagerPagecount() to return void, since the return value was always SQLITE_OK and was never used. (check-in: 7dd78eb7 user: drh tags: trunk) | |
| 16:02 | Minor simplifications to btree.c in support of full-coverage testing. (check-in: 364df6c7 user: drh tags: trunk) | |
| 12:42 | Tweaks to comments in pager.c. Fix two compiler warnings. (check-in: 68a49f7f user: drh tags: trunk) | |
| 12:25 | Add test cases to e_expr.test. (check-in: d8bbab78 user: dan tags: trunk) | |
| 05:04 | Test that it is possible to drop a trigger while there are active statements belonging to the same connection. (check-in: d4ec61e2 user: dan tags: trunk) | |
|
2010-08-13
| ||
| 18:41 | Add tests to test file e_expr.test. (check-in: 3fd1059e user: dan tags: trunk) | |
| 16:38 | Do not apply the flattening optimization if the sub-query is DISTINCT. Fix for [e4b8a2ba6e]. (check-in: 497aafd8 user: dan tags: trunk) | |
|
2010-08-12
| ||
| 16:36 | If an error occurs in PagerSetPagesize(), set the output variable to the unmodified page-size before returning. (check-in: 02def8f9 user: dan tags: trunk) | |