Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
112 events for the month beginning 2010-07-01 by user drh
Following month ↑|
2010-07-31
| ||
| 20:55 | • Fixed ticket [ce7c133e]: Foreign key constraint fails when it should succeed. (artifact: 7b3f9b14 user: drh) | |
|
2010-07-30
| ||
| 18:40 | If a database becomes corrupted such that an index is out of sync with its table, make sure the corruption is detected and reported back. Do not assume that indices always contain rowids for valid table rows. (check-in: 83395a3d user: drh tags: trunk) | |
| 16:54 | Fix typos in comments. No code or logic changes. (check-in: 15c294ca user: drh tags: trunk) | |
| 16:44 | Remove a test from sqlite3PagerCommitPhaseOne which is now always true after the multi-file transaction fix. (check-in: 6758f6a8 user: drh tags: trunk) | |
| 11:37 | • Fixed ticket [f3e5abed]: Problems retrying COMMIT after SQLITE_BUSY on multi-file transaction plus 2 other changes (artifact: d07c2800 user: drh) | |
| 11:20 | Cherry-pick the multi-file transaction fix for ticket [f3e5abed55] out of the experimental branch. (check-in: 40f7f0a5 user: drh tags: trunk) | |
| 00:31 | Updates to the README.txt file for ICU. (check-in: d37443d3 user: drh tags: trunk) | |
|
2010-07-29
| ||
| 10:13 | Unconditionally include the pTmpSpace size in the estimate of the pager memory used. (check-in: 4b97f864 user: drh tags: trunk) | |
| 10:08 | • Fixed ticket [c43940c4]: sqlite3_profile gives milliseconds (was nanoseconds in earlier releases) plus 1 other change (artifact: 057fea73 user: drh) | |
| 10:07 | Change the profile timer units back to nanoseconds and update the sqlite3_profile() documentation. Ticket [c43940c49b74c70a69] (check-in: 7783b98a user: drh tags: trunk) | |
| 01:55 | • Fixed ticket [ce7c133e]: Foreign key constraint fails when it should succeed. plus 1 other change (artifact: b3a12114 user: drh) ... 1 similar event omitted. | |
| 01:50 | Correct handling of compound foreign key constraints that include the integer primary key as one of the columns. Ticket [ce7c133ea6cc9ccdc1] (check-in: 53902f7d user: drh tags: trunk) | |
|
2010-07-28
| ||
| 20:57 | • New ticket [ce7c133e] Foreign key constraint fails when it should succeed.. (artifact: 4202cdf3 user: drh) | |
| 19:17 | Get SQLITE_OMIT_VIRTUALTABLE working again after being broken by recent changes. (check-in: 33b1e862 user: drh tags: trunk) | |
| 18:51 | Fix the dbstatus.test script so that it works correctly on 64-bit machines. (check-in: a3401d9e user: drh tags: trunk) | |
| 17:36 | Improve the accuracy of the Pager heap usage estimate. (check-in: ae89777e user: drh tags: trunk) | |
| 17:16 | Adjust the shell test script "shell4.test" to account for changes in the ".stat on" display format from the previous checkin. (check-in: 2f2fa7dd user: drh tags: trunk) | |
| 17:01 | Record the pcache allocation size statistics even for pcache overflow allocations. Adjust the wording on one of the stat output lines in the shell. (check-in: f9adf66a user: drh tags: trunk) | |
| 15:52 | Lookaside memory is not used to store schemas. Change the SQLITE_DBSATUS_SCHEMA_USED documentation to reflect this fact. (check-in: 07abfd52 user: drh tags: trunk) | |
| 15:49 | Add documentation for the SQLITE_STATUS_MALLOC_COUNT parameter to sqlite3_status(). (check-in: dbfbdb60 user: drh tags: trunk) | |
| 02:53 | • Fixed ticket [8011086c]: Query planner creates unnecessary and expensive automatic index plus 2 other changes (artifact: b5dd6bce user: drh) | |
| 02:53 | Do not allow automatic indices for the RHS of IN expressions which are not correlated subqueries. Ticket [8011086c85c6c404014c9] (check-in: 267492d3 user: drh tags: trunk) | |
| 00:33 | • New ticket [8011086c] Query planner creates unnecessary and expensive automatic index. (artifact: 333f2a70 user: drh) | |
|
2010-07-27
| ||
| 16:42 | Update the makefiles to prefer TCL version 8.5 instead of 8.4. (check-in: 8118de2a user: drh tags: trunk) | |
|
2010-07-26
| ||
| 19:09 | Fix a bug in the SQLITE_STATUS_MALLOC_COUNT counter. Add an ALWAYS() around a condition in the SQLITE_DBSTATUS_SCHEMA_USED logic that is always true. (check-in: 6df081ad user: drh tags: trunk) | |
| 18:43 | Add the SQLITE_STATUS_MALLOC_COUNT option for sqlite3_status(). (check-in: 8f8e442b user: drh tags: trunk) | |
| 16:40 | Increase the version number to 3.7.1 due to the API enhancement of the previous check-in. (check-in: 1d7571e4 user: drh tags: trunk) | |
| 16:25 | • Edit [548bf3f7d7b962d3|548bf3f7]: Mark "Closed". Edit check-in comment. Timestamp 2010-07-25 02:39:07. (artifact: 40b37362 user: drh) | |
| 16:24 | Add support for SQLITE_DBSTATUS_SCHEMA_USED and SQLITE_DBSTATUS_STMT_USED to the trunk. (check-in: 008368b2 user: drh tags: trunk) | |
| 15:57 | • Edit [e327ef37faec52ce|e327ef37]: Edit check-in comment. Timestamp 2010-07-26 15:57:02. (artifact: b93607ad user: drh) | |
| 14:20 | Further fixes to the P4_MEM size measurement logic. (check-in: 934cda29 user: drh tags: experimental) | |
| 13:58 | Fix an issue with P4_MEM and the schema size measurement logic. Also fix a compiler warning. (check-in: 8166f338 user: drh tags: experimental) | |
| 12:38 | Make sure sqlite3_free() is not called for P4_MPRINTF during a size measurement. (check-in: 56f11f88 user: drh tags: experimental) | |
| 11:59 | Update comments to better documentation the new memory measurement functions. (check-in: 620bad03 user: drh tags: experimental) | |
| 11:08 | • Edit [629e38a8c9e31111|629e38a8]: Change branch background color to "#c0ffc0". Edit check-in comment. Timestamp 2010-07-26 11:07:21. (artifact: fbca0b4e user: drh) | |
| 11:07 | Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and all memory from sqlite3_malloc() is freed by sqlite3_free(). (check-in: 629e38a8 user: drh tags: experimental) | |
|
2010-07-25
| ||
| 02:39 | Fixes to prior checkins so that they compile and run even if SQLITE_MEMDEBUG is not defined. (Closed-Leaf check-in: 548bf3f7 user: drh tags: malloc-enhancement) | |
| 02:12 | Further examples of using automatic deallocation to replace "delete" methods. (check-in: da2f62c5 user: drh tags: malloc-enhancement) | |
|
2010-07-24
| ||
| 19:08 | Additional malloc sanity changes. Use sqlite3MemLink() on Index.zColAff and Table.zColAff as a proof of concept. (check-in: e5ecb159 user: drh tags: malloc-enhancement) | |
| 18:25 | Add infrastructure to support a hierarchy of memory allocations with automatic deallocation of substructure. (check-in: 48ef221c user: drh tags: malloc-enhancement) | |
| 16:34 | Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and all memory from sqlite3_malloc() is freed by sqlite3_free(). (check-in: ac1f37a6 user: drh tags: malloc-enhancement) | |
|
2010-07-23
| ||
| 22:26 | Fix a typo in the OS/2 vfs code. (check-in: a6bb2108 user: drh tags: trunk) | |
| 17:32 | Strenghten an assert() in malloc.c that helps to ensure that allocated memory is freed by the appropriate routine. (check-in: 80db61ac user: drh tags: trunk) | |
| 17:06 | Remove additional traces (mostly in comments) of the Table.dbMem field. (check-in: 5c58f44a user: drh tags: trunk) | |
|
2010-07-22
| ||
| 22:40 | Add evidence marks to the where.c source file. Comment only - no code changes. (check-in: f3f9e8e5 user: drh tags: trunk) | |
| 17:50 | • Fixed ticket [47110204]: should use collate nocase index even if column isn't declared nocase plus 1 other change (artifact: b9e1ea8e user: drh) | |
| 17:49 | Enhance the LIKE/GLOB query optimization so that it works as long as there is an index with the appropriate collating sequence and even if the default collating sequence of the column is different. Ticket [4711020446da7d93d99]. (check-in: 9f932655 user: drh tags: trunk) | |
| 12:34 | • Fixed ticket [e0901835]: like should use index when pattern has no wildcard plus 1 other change (artifact: e78b5e56 user: drh) | |
| 12:33 | Try to optimize LIKE and GLOB operators when RHS contains no wildcard. Ticket [e090183531fc274747] (check-in: 613a87d6 user: drh tags: trunk) | |
| 11:40 | Tweaks to the virtual table documentation contained in comments of sqlite3.h. No changes to actual code. (check-in: f5866d47 user: drh tags: trunk) | |
| 00:13 | • Edit [b36b105eab6fd319|b36b105e]: Change background color to "#ffc0d0". Edit check-in comment. Timestamp 2010-07-21 16:16:28. Add tag "release". (artifact: 144759b5 user: drh) | |
|
2010-07-21
| ||
| 22:22 | • Ticket [e0901835] like should use index when pattern has no wildcard status still Open with 3 other changes (artifact: 7a237684 user: drh) | |
| 22:21 | • Ticket [47110204] should use collate nocase index even if column isn't declared nocase status still Open with 3 other changes (artifact: 92b593d2 user: drh) | |
| 16:16 | Version 3.7.0 (check-in: b36b105e user: drh tags: trunk, release) | |
|
2010-07-19
| ||
| 15:01 | Update the CLI test scripts for version 3.7.0. (check-in: 92fe70da user: drh tags: trunk) | |
| 02:30 | Fix a parser bug that was causing the relative precedence of LIKE and < operators to be incorrect. (check-in: 3e5975aa user: drh tags: trunk) | |
| 01:52 | Improvements to the formatting of parse.out file from Lemon. Add the -r option to Lemon to disable the state sorting, making debugging easier. (check-in: a2eaf829 user: drh tags: trunk) | |
|
2010-07-18
| ||
| 11:35 | Add the -p option to lemon to cause conflicts resolved by precedence rules to appear in the parse.out file. (check-in: fb6a59b0 user: drh tags: trunk) | |
|
2010-07-15
| ||
| 18:38 | Previous check-in [534aab837e] accidently reverted some changes from [a121cd80c5]. This check-in restores those changes. (check-in: abff795f user: drh tags: trunk) | |
| 18:32 | Optionally support shared-memory in /dev/shm or other tmpfs directory using an unsupported compile-time option. (check-in: 534aab83 user: drh tags: trunk) | |
|
2010-07-14
| ||
| 20:51 | Fix a typo in a comment in os_unix.c. (check-in: e1e73125 user: drh tags: trunk) | |
| 20:23 | The expression list on the RHS of an IN operator can no longer be empty because an empty expression list is now optimized out by changes in check-in [c288ac644d0bf]. Therefore add ALWAYS() macros around tests for the expression list being non-empty. (check-in: fd130ae5 user: drh tags: trunk) | |
| 19:31 | Additional test cases and evidence marks for the empty RHS bug on the IN operator - ticket [80e031a00f45dca877] (check-in: 6851c517 user: drh tags: trunk) | |
| 18:24 | • Fixed ticket [80e031a0]: Result of IN should never be NULL if the RHS is empty plus 2 other changes (artifact: db629242 user: drh) | |
| 18:24 | Make the result of an IN or NOT IN expression with an empty set on the right-hand side always either false or true, respectively, even if the left-hand side is NULL. Ticket [80e031a00f45dc] (check-in: c288ac64 user: drh tags: trunk) | |
| 15:48 | • New ticket [80e031a0] Result of IN should never be NULL if the RHS is empty. (artifact: 9ad81785 user: drh) | |
| 01:45 | Fix the unix driver to return an I/O error if unlink fails for any reason other than the file not existing in the first place. (check-in: 90d73c66 user: drh tags: trunk) | |
| 00:23 | • Edit [c2d27cf51d33e6f3|c2d27cf5]: Mark "Closed". Timestamp 2010-07-14 00:14:31. (artifact: f1d1cd31 user: drh) | |
| 00:22 | Remove the xShmOpen method from the VFS. Shared-memory is opened automatically by a call to xShmMap. Rename the xShmClose method to xShmUnmap. (check-in: 2b68e502 user: drh tags: trunk) | |
| 00:14 | Change the name of the xShmClose VFS method to xShmUnmap, everywhere. (Closed-Leaf check-in: c2d27cf5 user: drh tags: experimental) | |
|
2010-07-13
| ||
| 23:41 | Tweaks to the new shared-memory interface design - mostly comment changes. (check-in: 6336de7a user: drh tags: experimental) | |
| 14:49 | • Edit [3d4bb65f10ed0297|3d4bb65f]: Change branch background color to "#c0ffc0". Edit check-in comment. Timestamp 2010-07-13 14:48:27. (artifact: f3f4fff7 user: drh) | |
| 14:49 | • Edit [52577bb5e723d8de|52577bb5]: Timestamp 2010-07-13 14:33:49. (artifact: 655f390b user: drh) | |
| 14:48 | Improved documentation for the SQLITE_ACCESS_* constants that are used with the xAccess() method of the VFS. (check-in: 3d4bb65f user: drh tags: experimental) | |
| 14:35 | • Edit [52577bb5e723d8de|52577bb5]: Timestamp 2010-07-13 14:33:49. (artifact: 6f4ca669 user: drh) | |
|
2010-07-12
| ||
| 16:47 | Fix makefiles so that they build sqlite3_analyzer again. Tweaks to comments in test_stat.c. Fix tclsqlite.c to build the sqlite3_analyzer again. (check-in: e6cd1545 user: drh tags: trunk) | |
|
2010-07-09
| ||
| 03:19 | Reformat WAL code for clearer presentation. Update comments for correctness. Add checks to ensure that corruption in shared-memory does not result in an infinite loop. (check-in: 40eaada7 user: drh tags: trunk) | |
|
2010-07-08
| ||
| 19:20 | • Edit [bcdddba4f011cf00|bcdddba4]: Edit check-in comment. Timestamp 2010-07-08 19:19:51. (artifact: 2e0de1a9 user: drh) | |
| 19:19 | Replace code that became unreachable due to the journal_mode simplification with an assert(). (check-in: bcdddba4 user: drh tags: trunk) | |
| 17:40 | Change the journal_mode pragma to remove the "default journal mode" concept. The journal_mode pragma only effects currently attached databases and does not change the behavior of future attachments. (check-in: e396184c user: drh tags: trunk) | |
| 17:22 | • Edit [8a5811ea80e8415f|8a5811ea]: Change branch background color to "#c0ffc0". Timestamp 2010-07-08 16:30:44. (artifact: 9bbd9dd8 user: drh) | |
|
2010-07-07
| ||
| 21:06 | Make the initial salt values in the WAL header random values, not zero. (check-in: baa5eddd user: drh tags: trunk) | |
| 20:38 | Add the write-ahead log viewer/debugger tool to the tools/ folder. (check-in: 0e4bd446 user: drh tags: trunk) | |
| 14:40 | Remove two more testcase() macros that require 4GiB WAL files to hit. (check-in: 16e18f27 user: drh tags: trunk) | |
| 14:35 | Remove a testcase() macro that would require a 4GiB WAL to reach. (check-in: 15f9c271 user: drh tags: trunk) | |
| 14:33 | Fix a compiler warning in PRAGMA journal_mode. (check-in: d94269e6 user: drh tags: trunk) | |
| 14:19 | Avoid the need for a NEVER() from pager_write_pagelist() by passing in pPager as an extra parameter. (check-in: b3179379 user: drh tags: trunk) | |
| 14:00 | Merge together the accident fork. (check-in: cdcf08cb user: drh tags: trunk) | |
| 13:43 | Add testcase macros to ensure that large-file cases are tested in WAL. (check-in: 8156b57a user: drh tags: trunk) | |
| 01:52 | Remote the SQLITE_OMIT_GLOBALRECOVER macro - it is subsumed by SQLITE_OMIT_DEPRECATED. Add support to sqlite3_compileoption_used() for SQLITE_OMIT_WAL. (check-in: 21a2db90 user: drh tags: trunk) | |
|
2010-07-06
| ||
| 09:29 | Reorder variable declarations in the previous check-in to avoid putting code before declarations when not testing. (check-in: d1fe8ab4 user: drh tags: trunk) | |
|
2010-07-05
| ||
| 21:00 | Modify the VFS xAccess() method on winNT so that it returns false for an exists test of a zero-length file. This makes the windows VFS work the same as the unix VFS. (check-in: ec35f254 user: drh tags: trunk) | |
| 17:43 | When rolling back page 1 from a journal, restore the "nReserve" setting in case it has been corrupted by a prior crash. (check-in: c0d124da user: drh tags: trunk) | |
|
2010-07-03
| ||
| 17:13 | Remove the unused xRename() method from the sqlite3_vfs object. Add better documentation on the xCurrentTimeInt64() method. (check-in: 51ec0e54 user: drh tags: trunk) | |
| 15:47 | • Edit [48bf309391c32e78|48bf3093]: Edit check-in comment. Timestamp 2010-07-03 12:31:35. (artifact: 23434fad user: drh) | |
| 14:39 | • Edit [7cbe175a69738499|7cbe175a]: Edit check-in comment. Timestamp 2010-07-03 12:26:33. (artifact: 7b4ab877 user: drh) | |
| 14:19 | • Edit [708338773919fa02|70833877]: Change branch background color to "#c0c0c0". Timestamp 2010-07-02 17:05:03. (artifact: 1030d2c6 user: drh) | |
| 13:49 | • Edit [78fc35ff4b01d4a5|78fc35ff]: Mark "Closed". Timestamp 2010-07-03 13:45:53. (artifact: fe9e48c1 user: drh) | |
| 13:49 | • Edit [7cbe175a69738499|7cbe175a]: Edit check-in comment. Timestamp 2010-07-03 12:26:33. (artifact: bf075090 user: drh) | |
| 12:31 | Cherry-pick the correct changes out of the recent "mistake" branch while omitting the bugs. (check-in: 48bf3093 user: drh tags: trunk) | |
| 12:29 | • Edit [708338773919fa02|70833877]: Change branch background color to "#ffc0d0". Move to branch mistake. Timestamp 2010-07-02 17:05:03. (artifact: 554049e2 user: drh) | |
| 12:26 | Remove dead code from the pager. (check-in: 7cbe175a user: drh tags: mistake) | |
| 12:00 | Print the SQLite source_id() string when running speed tests. (check-in: 6d7640ed user: drh tags: mistake) | |
| 01:44 | Fix a buffer overrun in the where.c. Problem detected by valgrind. (check-in: 15bb6233 user: drh tags: mistake) | |
|
2010-07-02
| ||
| 19:36 | Omit the OP_JournalMode opcode from the VDBE when SQLITE_OMIT_PRAGMA is defined. (check-in: 565ff65c user: drh tags: mistake) | |
| 18:44 | Take out the incomplete initializer on the constant "dummy" in sqlite3VdbeGetOp(). Add a comment that the MSVC warning there should be ignored. (check-in: 452ccaa9 user: drh tags: mistake) | |
| 17:10 | Fix compiler warnings in the proxy locking code. (check-in: 26c7689c user: drh tags: mistake) | |
| 17:07 | Remove a couple of C++ style comments from pager.c. (check-in: 4f12e8eb user: drh tags: mistake) | |
| 15:35 | Remove an unused call to sqlite3PageBegin() from pager_write(). Replace it with an assert(). (check-in: 01c12782 user: drh tags: trunk) | |
| 01:18 | Add a NEVER to sqlite3PagerCommitPhaseTwo() because it is now no longer possible to invoke that function without holding a RESERVED lock. (check-in: 6ae76172 user: drh tags: trunk) | |
|
2010-07-01
| ||
| 19:45 | If you delete a database file but not its *-wal file, then open the database (thus creating a new empty database file) the *-wal file is automatically deleted. (check-in: 95c69dfb user: drh tags: trunk) | |