SQLite

Timeline
Login

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

61 events for the month beginning 2012-11-01

Following month ↑
2012-11-29
14:27 Closed ticket [f46ca03b]: The order of two operations in asyncLock() plus 6 other changes (artifact: d357b734 user: drh)
14:26
Mark the "async" module as deprecated as its functionality has been superceded by WAL mode. This closes ticket [f46ca03b55ae0e] (check-in: 3d548db7 user: drh tags: trunk)
08:31 New ticket [f46ca03b] The order of two operations in asyncLock(). (artifact: e93ae3ff user: anonymous)
2012-11-27
21:56
Update the sessions branch to include the SQLLOG enhancement, the SQLITE_IOERR_DELETE_NOENT fix, and a fix for the number-of-documents bug in FTS4. (check-in: ba8d08b6 user: drh tags: sessions)
21:22
Add the SQLLOG capability to trunk. (check-in: f0843f88 user: drh tags: trunk)
21:12
Improved detection of file-does-not-exist in winDelete. (check-in: 92e9b5bc user: drh tags: trunk)
16:39
Get SQLLOG working on windows. Fix a couple of compiler warnings. (Closed-Leaf check-in: b3809c93 user: drh tags: sqllog)
15:57 Edit [e38fb02d5ea5daa6|e38fb02d]: Edit check-in comment. (artifact: 7b74306f user: dan)
15:56
Fix a problem causing the "number-of-documents" field maintained by FTS4 to be set incorrectly by REPLACE queries. (check-in: e38fb02d user: dan tags: trunk)
10:56
Fix problems in test_sqllog.c. Clarify the experimental SQLITE_CONFIG_SQLLOG interface. Handle at least the more likely error conditions in test_sqllog.c. (check-in: 429c5b20 user: dan tags: sqllog)
2012-11-26
19:50
Add an option to register global hooks used for logging all SQL executed by an application. (check-in: cd501bbc user: dan tags: sqllog)
2012-11-21
15:52 New ticket [01b785ee] sqlite3.exe - wrong parameter charset. (artifact: ea4253ed user: anonymous)
02:10
In winDelete, determine that a file does not exist by checking for a last error of ERROR_FILE_NOT_FOUND or ERROR_PATH_NOT_FOUND. (Closed-Leaf check-in: 692ad3c0 user: mistachkin tags: winNotFound)
2012-11-20
15:06
Have the windows implementation of xDelete return SQLITE_IOERR_DELETE_NOENT if the file to be deleted does not exist. The unix implementation was previously modified to behave this way. The current changes simply brings the two implementations into alignment. (check-in: d4c36d49 user: drh tags: trunk)
2012-11-13
12:14 Ticket [5eaa61ea] sigbus on disk ful in WAL mode status still Fixed with 1 other change (artifact: b463520a user: anonymous) ... 1 similar event omitted.
11:16
Strive to use posix_fallocate() rather than ftruncate() when posix_fallocate() is available. Ticket [5eaa61ea18]. (check-in: 29980b08 user: drh tags: trunk)
11:08
Use preprocessor macros to automatically detect whether or not posix_allocate() is available. (It is generally available on Linux but not on Mac.) Ticket [5eaa61ea1881040b17449ca043b6f8fd9ca55dc3] (Closed-Leaf check-in: 597333f1 user: drh tags: tkt-5eaa61ea18)
10:54
When available, use posix_fallocate() rather than ftruncate() to allocate space for mmap()ed -shm files, since posix_fallocate() gives an error if no disk space is available whereas ftruncate() is silent and leaves the system vulnerable to a SIGBUS upon first write to the mmap()ed region. Ticket [5eaa61ea1881040b17449ca043b6f8fd9ca55dc3] (check-in: 35625961 user: drh tags: tkt-5eaa61ea18)
10:34 Ticket [5eaa61ea] sigbus on disk ful in WAL mode status still Open with 1 other change (artifact: f3ef76a5 user: drh) ... 5 similar events omitted.
2012-11-10
01:27
Merge the latest changes from trunk: chiefly the outer/inner loop query optimizer scoring enhancement and the INSTR() function. (check-in: 2993ca20 user: drh tags: sessions)
2012-11-09
21:40
Only log unlink() errors if the error is something other than SQLITE_IOERR_DELETE_NOENT. The error is still reported up the stack, it is simply not added to the sqlite3_log(). (check-in: 5a3b07f0 user: drh tags: trunk)
20:17
Change os_unix.c to propagate ENOENT errors back to sqlite as SQLITE_IOERR_DELETE_NOENT. Have SQLite ignore these where they are benign and propagate them back to the caller where they may indicate a file-system malfunction of some description. (check-in: bed9c172 user: dan tags: trunk)
18:32
Take into account the cost of inner loops when selecting which table of a join to use for the next outer loop. (check-in: 3f87f459 user: drh tags: trunk)
18:22
Disable the table selection rule that tried to prevent full table scans from migrating to the outer loop unless they were optimal. The new scaling of outer-loop costs by cost of inner loops obviates the need for that step. And, in fact, that step causes problems with the new inner-loop cost accounting. (Closed-Leaf check-in: 51bfd63b user: drh tags: inner-loop-cost)
17:59
Try to take into account the cost of inner loops when selecting which table of a join to use for the outer loop. (check-in: 94255634 user: drh tags: inner-loop-cost)
2012-11-06
20:39
Adjust the SQLITE_DBSTATUS_STMT_USED calculation to take the modified usage of sqlite3VdbeClearObject() into account. (check-in: 82eb7ead user: mistachkin tags: trunk)
18:41
In test_quota.c, provide a work-around for the missing _chsize_s() function in mingw. (check-in: 6b4979e8 user: drh tags: trunk)
10:11 Edit [0620285da63ed227|0620285d]: Mark "Closed". (artifact: dcbdf62f user: mistachkin)
10:11 Edit [b8d5359bb7be9cf7|b8d5359b]: Mark "Closed". (artifact: 7c2e951f user: mistachkin)
2012-11-05
16:36 Edit [a499ae3835ed7f15|a499ae38]: Mark "Closed". (artifact: 92af1a1b user: drh)
16:36
Merge the omit-wal-fix branch into branch-3.7.9 where it belongs, and in so doing get branch-3.7.9 working with SQLITE_OMIT_WAL. (check-in: 03919517 user: drh tags: branch-3.7.9)
16:25 Edit [585e2070eef3bc27|585e2070]: Mark "Closed". (artifact: 95a7b7be user: drh)
16:25 Edit [5023a7adcac2022a|5023a7ad]: Mark "Closed". (artifact: 089905c0 user: drh)
13:52 Edit [49ccae964f3a8ae5|49ccae96]: Mark "Closed". (artifact: 097cd3d5 user: drh)
13:51
Add the INSTR() SQL function. (check-in: a4c181cb user: drh tags: trunk)
13:51 Edit [51a6a797e1d61c43|51a6a797]: Mark "Closed". (artifact: 56ece7f5 user: drh)
13:49 Edit [82b6aa77c8d8de4c|82b6aa77]: Mark "Closed". (artifact: 39dd63e8 user: drh)
13:49 Edit [8314fd6078a3a71a|8314fd60]: Mark "Closed". (artifact: b1b61eef user: drh)
13:49 Edit [98b633717a1c9a08|98b63371]: Mark "Closed". (artifact: e0a837bd user: drh)
13:48 Edit [62ebfa747635a559|62ebfa74]: Mark "Closed". (artifact: 46befb55 user: drh)
13:45 Edit [698b2a28004a9a2f|698b2a28]: Mark "Closed". (artifact: e4f044b6 user: drh)
13:45 Edit [f7c5abe8739090db|f7c5abe8]: Mark "Closed". (artifact: 04399cb2 user: drh)
13:44 Edit [43e474d3e9364e6e|43e474d3]: Mark "Closed". (artifact: ac2d95ed user: drh)
13:44 Edit [f83aa0de8470748b|f83aa0de]: Mark "Closed". (artifact: dd22f592 user: drh)
2012-11-02
23:55 Fixed ticket [bfbf38e5]: Segfault on a nested join plus 1 other change (artifact: 4bea13ec user: drh) ... 1 similar event omitted.
23:42
Merge the fix for ticket [bfbf38e5e9956ac6] into trunk. (check-in: 4f7dfc32 user: drh tags: trunk)
19:08
Adding test cases for ticket [bfbf38e5e9956a] (Closed-Leaf check-in: 62ebfa74 user: drh tags: ticket-bfbf38e5e9)
18:48
Proposed fix for ticket [bfbf38e5e9]. (check-in: 18ae030d user: drh tags: ticket-bfbf38e5e9)
18:24
Fix an out-of-date comment. No changes to code. (check-in: 10cc12b1 user: drh tags: trunk)
15:14 Ticket [bfbf38e5] Segfault on a nested join status still Open with 1 other change (artifact: cabcf4a3 user: drh) ... 4 similar events omitted.
Previous month ↓