Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
58 events for the month beginning 2009-02-01 by user drh
Following month ↑|
2009-02-25
| ||
| 19:07 | Move the new genfkey shell command out from within #ifdef _WIN32_ (CVS 6327) (check-in: 48ee0e47 user: drh tags: trunk) | |
|
2009-02-24
| ||
| 19:21 | Additional commands and another procedure name changes for clarity of presentation. No logic changes. (CVS 6323) (check-in: 91d9d51e user: drh tags: trunk) | |
| 18:57 | Changes to comments and functions/procedure names for clarification. No changes to logic. (CVS 6322) (check-in: b99c1815 user: drh tags: trunk) | |
| 16:18 | Enhanced comments on table locking logic as it relates to preparing new statements. Added assert() and testcase() but no other changes to code. (CVS 6319) (check-in: 4a12f5b8 user: drh tags: trunk) | |
|
2009-02-23
| ||
| 16:52 | Add the reverse_unordered_selects pragma. (CVS 6314) (check-in: bc078e00 user: drh tags: trunk) | |
|
2009-02-21
| ||
| 22:38 | The sqlite3.def file is automatically generated and is not suppose to be part of the source code repository. So it is hereby removed. Ticket #3671. (CVS 6312) (check-in: 5dcda154 user: drh tags: trunk) | |
|
2009-02-20
| ||
| 03:55 | Add a count parameter to the OP_Variable opcode and use it to simplify prepared statements that copy consecutive unnamed parameters into consecutive registers (a common case). (CVS 6309) (check-in: 48b77b04 user: drh tags: trunk) | |
| 03:02 | Add the OP_HaltIfNull opcode and use it to simplify prepared statements for INSERTs and UPDATEs of tables with NOT NULL columns. (CVS 6308) (check-in: feccad8d user: drh tags: trunk) | |
| 01:28 | Reuse space left-over opcode space at the end of the VDBE opcode array to store memory cells, VDBE cursors, and other content needed by the VDBE. This reduces the memory required by a prepared statement. (CVS 6307) (check-in: 58a18092 user: drh tags: trunk) | |
|
2009-02-19
| ||
| 20:50 | Remove code in malloc.c that was already commented out using #if 0. (CVS 6306) (check-in: e1ad757e user: drh tags: trunk) | |
|
2009-02-18
| ||
| 20:31 | Make sure the auto_vacuum=INCREMENTAL setting is preserved across a VACUUM. Ticket #3663. (CVS 6304) (check-in: ded04f12 user: drh tags: trunk) | |
| 18:37 | Move the text of C-API requirements out of the sqlite.h.in source file and into separate files in the "docsrc" CM system. Comment changes only - no changes to code. (CVS 6303) (check-in: 419eb48b user: drh tags: trunk) | |
| 12:25 | Fix the amalgamation builder to mark sqlite3PagerBackupPtr as private. Ticket #3662. (CVS 6302) (check-in: fb281950 user: drh tags: trunk) | |
| 00:00 | Version 3.6.11 (CVS 6299) (check-in: 6abd630c user: drh tags: trunk, release) | |
|
2009-02-17
| ||
| 18:37 | Add tests to double-check that nothing within SQLite ever tries to allocate amounts of memory that are close to the maximum signed integer, leading to an integer overflow within malloc(). This is not currently a problem. The extra tests just insure it never becomes a problem. (CVS 6298) (check-in: f6ba7bb9 user: drh tags: trunk) | |
| 16:17 | Make sure result variables are initialized or unused following a failure of the xFullPathname VFS interface. Problem detected by valgrind. (CVS 6295) (check-in: 59a47551 user: drh tags: trunk) | |
|
2009-02-16
| ||
| 16:23 | Fix a compiler warning in backup.c. (CVS 6293) (check-in: 82222fbf user: drh tags: trunk) | |
|
2009-02-13
| ||
| 16:59 | Make sure OOM errors in the ANALYSIS loader get reported back out to high-level layers. Strange behavior can result otherwise. (CVS 6292) (check-in: 88a6355c user: drh tags: trunk) | |
| 03:43 | Correctly handle attempts to add a UNIQUE or PRIMARY KEY column using the ALTER TABLE statement. Ticket #3651. (CVS 6291) (check-in: dd179ff2 user: drh tags: trunk) | |
|
2009-02-12
| ||
| 17:07 | Add additional cross-references from API documentation to other documents. Comment changes only; no changes to code. (CVS 6290) (check-in: 97203a0a user: drh tags: trunk) | |
| 17:06 | Update thread tests to clear the sqlite_open_file_count counter at the end. This counter is not threadsafe and can end up with an invalid value at the end of the thread tests. (CVS 6289) (check-in: 8c4d71a1 user: drh tags: trunk) | |
|
2009-02-11
| ||
| 15:23 | Continuing documentation refinements. Comment changes only. (CVS 6284) (check-in: 83e83084 user: drh tags: trunk) | |
| 15:04 | Add hyperlinks from sqlite3_limit() documention to the limits.html page. Comment changes only - no changes to code. (CVS 6282) (check-in: f0189ec8 user: drh tags: trunk) | |
|
2009-02-10
| ||
| 13:41 | Create links from backup API documentation to the backup application note. Comment changes only - no changes to code. (CVS 6275) (check-in: 85de23fb user: drh tags: trunk) | |
|
2009-02-09
| ||
| 17:34 | Add assert() statements to os_unix.c which fire if there is a read or write for the locking region of a database file. (CVS 6270) (check-in: 93e792ff user: drh tags: trunk) | |
| 13:19 | Better error message when DISTINCT is used on an aggregate function that takes two or more arguments. Ticket #3641. (CVS 6269) (check-in: e20bf384 user: drh tags: trunk) | |
|
2009-02-05
| ||
| 17:00 | Fix a test case that was still using the old pending_byte mechanism. (CVS 6265) (check-in: 08ec4f2c user: drh tags: trunk) | |
| 16:53 | Fix the declaration of sqlite3PendingByte so that it works with the amalgamation. (CVS 6264) (check-in: 193c871f user: drh tags: trunk) | |
| 16:31 | Make the pending byte adjustable via sqlite3_test_control() on all builds, not just on test builds. (CVS 6263) (check-in: e8f192e2 user: drh tags: trunk) | |
|
2009-02-04
| ||
| 22:46 | Add "backup" and "restore" methods to the TCL interfaces and test cases to exercise those methods. (CVS 6260) (check-in: e420a3ce user: drh tags: trunk) | |
| 20:55 | Add ".backup" and ".restore" commands to the CLI - implemented using the new backup API. (CVS 6259) (check-in: 003e1d62 user: drh tags: trunk) | |
| 20:08 | Increase the version number to 3.6.11. (CVS 6258) (check-in: 0882a028 user: drh tags: trunk) | |
| 19:16 | If the truncate operation fails in journalmode=TRUNCATE, do not fall back to overwriting the journal header with zeros. Simply fail the operation. (CVS 6257) (check-in: d4af60e5 user: drh tags: trunk) | |
| 17:40 | Simplify wording of backup API error message. Decapitalize some other error messages. (CVS 6256) (check-in: f92405af user: drh tags: trunk) | |
| 16:56 | The sqlite3_backup_init() interface must lock the destination in case it needs to change the error message. (CVS 6255) (check-in: 572378d3 user: drh tags: trunk) | |
|
2009-02-03
| ||
| 22:51 | Correction to check-ins (6246) and (6247): The backup object might not hold a valid destination connection pointer. Also, do not reset the page cache when establishing a read-lock while there is a persistent or truncated journal, only if there is a journal that really needs to rollback. Otherwise backups always reset whenever the source database file is read. (CVS 6248) (check-in: 7f827ba9 user: drh tags: trunk) | |
| 22:17 | A backup must clear the internal schema of the destination database so that the schema will be reloaded for the next sqlite3_prepare() (CVS 6247) (check-in: 76f23a43 user: drh tags: trunk) | |
| 21:13 | Must hold mutex on the destination during backups. Add documentation to warn programmers that attempting to use the destination connection during a backup can lead to deadlock. (CVS 6246) (check-in: 5f6c06b9 user: drh tags: trunk) | |
| 18:47 | More adjustments to the backup API documentation. No changes to code. (CVS 6243) (check-in: ca650879 user: drh tags: trunk) | |
| 18:25 | Tweaks to the backup API documentation contained in comments. No changes to code. (CVS 6242) (check-in: 6298bcca user: drh tags: trunk) | |
| 16:25 | Fix the sqlite3_mprintf_long test command (added by check-in (6224) in order to address ticket #3621) so that it works on systems with sizeof(int)==4 and sizeof(long)==8. (CVS 6240) (check-in: 2e45c2a8 user: drh tags: trunk) | |
| 15:50 | Remove several compiler warnings. (CVS 6239) (check-in: 85e9196d user: drh tags: trunk) | |
| 15:39 | Remove the text of the sqlite3VdbeMemSanity() routine, which was already commented out. (CVS 6238) (check-in: a3c26077 user: drh tags: trunk) | |
| 15:27 | Check at the write() call to work around the msdos bug in OSX actually succeeds and throw an error if it does not. #ifdef out the work-around for all platforms other than OSX. Ticket #3633. (CVS 6237) (check-in: b054b569 user: drh tags: trunk) | |
| 13:51 | Add a special rule to the amalgamation generator to deal with the sqlite3OsDlSym function. Ticket #3631. (CVS 6236) (check-in: 876f874c user: drh tags: trunk) | |
| 13:19 | Fix a problem in check-in (6226) which could cause an assertion fault following a malloc failure. The prior check-in was for ticket #3624. (CVS 6235) (check-in: 1ffe44e9 user: drh tags: trunk) | |
| 13:10 | Check-in (6230) introduced a bugs in SUBSTR() which was caught by the fuzz tester. Fixed by this check-in. Related to ticket #3628. (CVS 6234) (check-in: cd2e7f6c user: drh tags: trunk) | |
|
2009-02-02
| ||
| 21:57 | Make group_concat() a 1- or 2-value function, as the documentation says it should be. Use the md5sum() function to verify ticket #3179, not group_concat(). This undoes the ill-advised group_concat() change of check-in (5233). (CVS 6233) (check-in: f2ae82c4 user: drh tags: trunk) | |
| 18:03 | Omit the TEMP keyword from the schema of TEMP tables created using CREATE TEMP TABLE AS SELECT ..... Ticket #3630. (CVS 6232) (check-in: 3b0a2554 user: drh tags: trunk) | |
| 17:30 | Minor simplifications to SQL function implementations. (CVS 6231) (check-in: 92e5c27f user: drh tags: trunk) | |
| 16:32 | Update the SUBSTR function so that works consistently when the 2nd parameter is 0. Ticket #3628. (CVS 6230) (check-in: 5fc125d3 user: drh tags: trunk) | |
| 01:50 | Restrict the RANDOM() function to have zero arguments. Ticket #3627. (CVS 6229) (check-in: b8b546b6 user: drh tags: trunk) | |
|
2009-02-01
| ||
| 19:42 | Fix SUBSTR() so that it returns NULL if any argument is NULL. Ticket #3626. (CVS 6228) (check-in: 779fce82 user: drh tags: trunk) | |
| 19:23 | Fix the SUBSTR() function so that when the 3rd argument is negative, it counts backwards from the selected start point. Ticket #3625. (CVS 6227) (check-in: 2217339b user: drh tags: trunk) | |
| 18:08 | Change the replace() function to return a copy of its first argument when the 2nd argument is an empty string. Ticket #3624. (CVS 6226) (check-in: ffebf10f user: drh tags: trunk) | |
| 00:29 | Adjust comments in vdbe.c to use OP_MakeRecord instead of the obsolete OP_MakeIdxRec. Ticket #3619. (CVS 6225) (check-in: 0d2abbbf user: drh tags: trunk) | |
| 00:21 | Add a new test command, sqlite3_mprintf_long, for testing the behavior of "long integer" printf formatting. Ticket #3621. (CVS 6224) (check-in: 3ba1a17b user: drh tags: trunk) | |
| 00:00 | Make the TO keyword available even if SQLITE_OMIT_ALTERTABLE is defined. Ticket #3622. (CVS 6223) (check-in: 3890985c user: drh tags: trunk) | |