Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
83 events for the month beginning 2010-04-01 by user drh
Following month ↑|
2010-04-30
| ||
| 22:28 | Merge in changes from the trunk. (check-in: 76bf0eee user: drh tags: wal) | |
| 21:03 | • Fixed ticket [3dbdcdb1]: Assertion fault using indices with redundant columns plus 2 other changes (artifact: 7ab2adf4 user: drh) | |
| 21:03 | Avoid assertion faults in queries using indices with redundant columns. Ticket [3dbdcdb14e7f41]. (check-in: 946e06cd user: drh tags: trunk) | |
| 20:35 | • New ticket [3dbdcdb1] Assertion fault using indices with redundant columns. (artifact: ced410c4 user: drh) | |
| 17:47 | Change the SHM VFS logic in os_unix.c so that it does not hold an exclusive lock n the mapped memory when also holding a CHECKPOINT lock. This improves concurrency between readers and checkpointers. (check-in: 8660cda6 user: drh tags: wal) | |
| 17:28 | Remove some obsolete debugging parameters. (check-in: a012aed4 user: drh tags: wal) | |
| 16:48 | In the debugging output for SHM-LOCK in os_unix.c, use symbolic names for the lock states rather than raw numbers. (check-in: 2afc33de user: drh tags: wal) | |
| 16:12 | Correctly record the fact that the SHM lock reached PENDING if it did so but failed to reach CHECKPOINT. (check-in: d9250e84 user: drh tags: wal) | |
| 15:54 | Fix a couple uninitialized variables in the xShmLock method of the unix VFS. Improved debugging logic for xShmLock. (check-in: 69567c5f user: drh tags: wal) | |
| 14:39 | Separate the concepts of underlying storage size and mapped size in the VFS shared-memory implementation. (check-in: 4cbe49f1 user: drh tags: wal) | |
| 02:13 | The first 6 WAL tests now work. It's a start. (check-in: a92c1851 user: drh tags: wal) | |
|
2010-04-29
| ||
| 22:34 | Refactor wal.c to use the VFS. This check-in compiles and links and works ok as long as you leave WAL turned off, but WAL does not work. (check-in: 62db5fa3 user: drh tags: wal) | |
| 16:40 | Untested implementation of the shared-memory dead-man-switch. (check-in: 70661128 user: drh tags: wal) | |
| 15:17 | Progress towards a VFS that will support WAL. Locking code is in place but is untested. Still no support for the DMS. (check-in: 1bde41cf user: drh tags: wal) | |
|
2010-04-28
| ||
| 17:21 | Changes to the interface design for the xShmLock method of the VFS. (check-in: 348409de user: drh tags: wal) | |
| 14:42 | Rename the sqlite3_log_hook() to sqlite3_wal_hook(). Added comments to wal.h. (check-in: bbc38511 user: drh tags: wal) | |
|
2010-04-27
| ||
| 11:49 | Add the xShmRelease() method to the VFS. The os_unix.c implementation of the shared memory logic is still non-functional. (check-in: ed715b47 user: drh tags: wal) | |
| 01:56 | Merge in recent changes from the trunk (check-in: 7a0ac682 user: drh tags: wal) | |
|
2010-04-26
| ||
| 19:17 | Optimization: Convert an ORDER BY clause into a no-op if the query also contains a GROUP BY clause that will force the same output order. (check-in: ca9d86ba user: drh tags: trunk) | |
| 17:36 | Change the default_cache_size pragma to always store a positive value. (check-in: 36fb2cae user: drh tags: trunk) | |
| 17:30 | Identify the SQLite version meta-value entry in the db-header output of showdb. (check-in: 245d934b user: drh tags: trunk) | |
| 16:47 | Further enhancements to the showdb utility: A page number followed by "b" causes a btree decoding to occur on the page. (check-in: 2ff824e5 user: drh tags: trunk) | |
| 15:44 | Enhancements to the showdb.c utility program. Automatically detect the page size and adjust the display accordingly. Add the "dbheader" display option. (check-in: 23eb408b user: drh tags: trunk) | |
| 00:19 | Change the names of the log.c and log.h source files to wal.c and wal.h. (check-in: 56fe5d76 user: drh tags: wal) | |
| 00:04 | Begin moving WAL-specific I/O into the VFS. This checkin contains VFS infrastructure but it is untested and is not yet hooked up to the WAL. The version number is bumped to 3.7.0 because of the VFS extension. (check-in: f5e615c2 user: drh tags: wal) | |
|
2010-04-25
| ||
| 20:58 | Remove an unreachable branch from the function initialization logic. (check-in: 064d3ddd user: drh tags: trunk) | |
|
2010-04-24
| ||
| 14:02 | When commands such as ALTER TABLE and VACUUM use SQL internally, make sure they use only the built-in functions and not application-defined overrides for those functions. (check-in: 0291ed97 user: drh tags: trunk) | |
|
2010-04-22
| ||
| 12:08 | • Closed ticket [bb1977f6]: Concatenation can create very invalid strings plus 2 other changes (artifact: 53493959 user: drh) | |
|
2010-04-17
| ||
| 16:10 | It is possible for sqlite3.pUnlockConnection to be non-NULL when sqlite3.pBlockingConnection is NULL, as the notify1.test script demonstrates. (Closed-Leaf check-in: 95ff76ef user: drh tags: experimental) | |
| 12:53 | Change sqlite3_step() so that it automatically calls sqlite3_reset() instead of returning SQLITE_MISUSE when invoked on a prepared statement that previously returned any value other than SQLITE_ROW. (check-in: 3e646e3f user: drh tags: trunk) | |
| 12:26 | • Edit [c54e8dad01b0ecaf|c54e8dad]: Change branch background color to "#c0ffc0". Move to branch experimental. Edit check-in comment. Timestamp 2010-04-16 22:05:32. (artifact: 7f0d2b5c user: drh) | |
|
2010-04-15
| ||
| 23:26 | • Fixed ticket [02a8e81d]: LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly plus 2 other changes (artifact: 052b48ef user: drh) | |
| 23:24 | Disable query flattening when the outer query is a compound SELECT and the inner query has a LIMIT clause. Ticket [02a8e81d44]. (check-in: f96782b3 user: drh tags: trunk) | |
| 14:43 | • Ticket [02a8e81d] LIMIT clause on sub-select in FROM clause of a SELECT in a UNION ALL interpreted incorrectly status still Open with 3 other changes (artifact: c271e305 user: drh) | |
| 13:29 | The query planner fix of check-in [33b1f584ef] should have been on the trunk. (check-in: f538d759 user: drh tags: trunk) | |
| 12:36 | Fix a problem in the result set size estimation logic of the query planner - a problem introduced by the two previous changes. (check-in: 33b1f584 user: drh tags: wal) | |
| 02:37 | Bring over the recent query planner enhancements from the trunk. (check-in: 82969f27 user: drh tags: wal) | |
| 01:04 | Further refinements to table order selection on join query planning. (check-in: defaf0d9 user: drh tags: trunk) | |
|
2010-04-14
| ||
| 19:01 | The query planner uses non-indexable WHERE clause terms to reduce the estimated number of output rows, then uses the estimated number of output rows as a tie-breaker when choosing table order. (check-in: b87cb0c2 user: drh tags: trunk) | |
|
2010-04-13
| ||
| 15:30 | Fix an uninitialized variable in readDbPage of pager.c. (check-in: f4e1150f user: drh tags: wal) | |
|
2010-04-12
| ||
| 20:54 | Add e_fts3.test to the set of tests excluded from the inmemory_journal exclusion list, since it does simulated OOM errors which trigger I/O errors and SQLite is unable to recover from I/O errors without a persistent journal. (check-in: e7e7127f user: drh tags: trunk) | |
| 19:44 | Recent changes cause the xSync method of the memory journal implementation to be used, so remove the assert(0). (check-in: 1f2cb940 user: drh tags: trunk) | |
| 19:43 | Clear a global variable in e_fts3.test before it is used. (check-in: ae89dfd2 user: drh tags: trunk) | |
| 19:32 | Remove duplicate secure_delete pragma implemention. (check-in: c15fda14 user: drh tags: wal) | |
| 18:44 | • Edit [51a6139508246986|51a61395]: Edit check-in comment. Timestamp 2010-04-12 17:08:45. (artifact: ac66651e user: drh) | |
| 14:51 | Reset the simulated device in the test harness to its default configuration whenever it is restarted. (check-in: 562d20e6 user: drh tags: trunk) | |
|
2010-04-10
| ||
| 17:52 | Fix issues and clarify the operation of pager_playback_one_page(). A block comment in pager.c identifies 13 invariants on the pager subsystem. Ticket [9d68c883132c8]. (check-in: 09065976 user: drh tags: trunk) | |
|
2010-04-09
| ||
| 23:05 | Add a test case for the OOM-fault corruption issue. Ticket [9d68c883132c8]. (check-in: 0a64a937 user: drh tags: trunk) | |
| 19:20 | • New ticket [9d68c883] Database corruption following OOM fault. (artifact: e44fcd7e user: drh) | |
| 15:34 | Candidate fix for a pager bug associated with sqlite3PagerMovepage(). (check-in: 8c046eb6 user: drh tags: trunk) | |
| 09:14 | Avoid unnecessary calls to sqlite3_step() with null prepared statements while parsing the schema. (check-in: ae04d2d1 user: drh tags: trunk) | |
|
2010-04-08
| ||
| 17:35 | Fix a typo in a comment. No changes to code. (check-in: 332cb551 user: drh tags: trunk) | |
| 17:28 | Fix code coverage problems in where.c. (check-in: b04a5282 user: drh tags: trunk) | |
| 16:30 | Additional automatic index tests. (check-in: 99d8e325 user: drh tags: trunk) | |
| 15:01 | New test cases for automatic indices. New testcase() macros associated with column-used bitmasks. (check-in: e1aa48ac user: drh tags: trunk) | |
| 15:01 | Fix the computation of the number of rows in a table during automatic index generation. (check-in: edeab06a user: drh tags: trunk) | |
| 14:38 | Fix an integer overflow bug in the automatic index logic. The bug was detected by the testcase() macros added in the previous check-in. Also add some more testcase() macros, since this issue points up their importance. (check-in: af97b488 user: drh tags: trunk) | |
| 14:15 | Add testcase() macros to the automatic index logic to insure that boundary cases are tested. (check-in: 72865478 user: drh tags: trunk) | |
| 11:35 | Make sure F_OK, R_OK, and W_OK are defined in test_demovfs.c. Define them manually if they are not. This is necessary to get the module to compile on some systems. (check-in: 7c8afc32 user: drh tags: trunk) | |
| 01:16 | Merge automatic index changes into the trunk. (check-in: bf7b8d86 user: drh tags: trunk) | |
| 00:40 | When constructing automatic indices do not include the same column more than once. (Closed-Leaf check-in: d067d9f7 user: drh tags: experimental) | |
|
2010-04-07
| ||
| 20:32 | Pull over the latest changes from the trunk. (check-in: e388fe8b user: drh tags: experimental) | |
| 20:29 | When rolling back a savepoint to the beginning of the transaction, make sure to initialize the database size in the btree layer correctly even if the database size field of the header is zeroed. (check-in: a3540c6a user: drh tags: trunk) | |
| 19:32 | Add an interface to the SQLITE_STMTSTATUS_AUTOINDEX status information to the TCL bindings. Add some simple automatic index test cases. (check-in: 1f404412 user: drh tags: experimental) | |
| 16:54 | Wrap all automatic index changes inside SQLITE_OMIT_AUTOMATIC_INDEX. Add the automatic_index PRAGMA to turn it on and off. (check-in: a811a47f user: drh tags: experimental) | |
| 14:59 | Make sure that all automatic indices are covering indices. Otherwise, the table and index might be used together in a query but the table could get out of sync with the automatic index through out-of-band changes. (check-in: 23643131 user: drh tags: experimental) | |
| 14:33 | Enhance comments on the SrcList object definition to better explain the operation of the SrcList.a[].colUsed field. No changes to code. (check-in: c0f67ea1 user: drh tags: experimental) | |
| 14:32 | Fix the trace output of the OP_Function opcode to show the correct register numbers. (check-in: 064c283e user: drh tags: experimental) | |
|
2010-04-06
| ||
| 22:33 | Veryquick.test is now working. The SQLITE_STMTSTATUS_AUTOINDEX counter added. (check-in: abbf16e5 user: drh tags: experimental) | |
| 18:51 | Runs quicktest without hitting an assert now. Some tests get unexpected results still and there is a memory leak. (check-in: a8224448 user: drh tags: experimental) | |
| 18:28 | Progress toward getting automatic indices to work. Still failing in corner cases. (check-in: ac6d0fba user: drh tags: experimental) | |
| 15:57 | Automatically generate transient indices for tables in joins that would otherwise have to use a full table scan. (check-in: 1b2a0412 user: drh tags: experimental) | |
|
2010-04-05
| ||
| 15:11 | Minor comment changes to the OP_OpenEphemeral header. No changes to code. (check-in: 8e1d7ef4 user: drh tags: trunk) | |
|
2010-04-03
| ||
| 13:08 | Silently abandon a rollback if the journal has been truncated. (check-in: 7626f6c9 user: drh tags: trunk) | |
|
2010-04-02
| ||
| 13:25 | Check for a failure in the call to sqlite3PagerPagecount() from within sqlite3PagerWrite(). (Error discovered by valgrind.) (check-in: d64d181c user: drh tags: trunk) | |
| 12:55 | Take care to avoid a buffer over-read when adding a KEYINFO structure to the P4 parameter of an opcode. (check-in: 937b931a user: drh tags: trunk) | |
| 12:46 | If the size of the database according to the header is larger than the actual database file size, report that the database is corrupt. (check-in: 8eb1f244 user: drh tags: trunk) | |
| 03:39 | Pager changes for code coverage testing. (check-in: b04a45ea user: drh tags: trunk) | |
|
2010-04-01
| ||
| 18:33 | Disable the corruptE.test script when ENABLE_OVERSIZE_CELL_CHECK is on. (check-in: 1dc4f9fe user: drh tags: trunk) | |
| 16:15 | Zero the filesize-in-header word for bigfile.tcl. Remove bigfile.tcl from the journaltest permutation. (check-in: 63610c71 user: drh tags: trunk) | |
| 13:41 | Do not journal the content of freelist leaf pages. This restores an optimization that was accidently undone by check-in [12f7346c13] on 2009-01-20. (check-in: b1e7a1a6 user: drh tags: trunk) | |
| 02:47 | Remove a NEVER in sqlite3PagerPagecount() that can in fact be true. (check-in: 8f005337 user: drh tags: trunk) | |
| 02:22 | Restore the size information in the BtShared structure when a transaction rolls back. (check-in: 802aeb30 user: drh tags: trunk) | |