SQLite

Timeline
Login

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

87 events for the month beginning 2009-09-01 by user drh

Following month ↑
2009-09-30
16:07 Ticket [e123bd22] POSIX File handles aren't always immediately released on sqlite3_close status still Open with 3 other changes (artifact: 4a094ade user: drh)
2009-09-26
15:14 Closed ticket [58a75d62]: encoding failure plus 3 other changes (artifact: 683a4293 user: drh)
14:40 Added wiki page "Bug Reports" (artifact: 8646127e user: drh)
14:20 Closed ticket [cff1a529]: sqlite3_get_table() returns wrong result when using where clause plus 3 other changes (artifact: 0d93ca47 user: drh)
13:57 Closed ticket [d77ffcd7]: Memory leak on failing INSERT statements on tables with UNIQUE INDEX plus 2 other changes (artifact: 10890730 user: drh) ... 2 similar events omitted.
2009-09-25
10:35 Closed ticket [860d129c]: builds with sqlite 3.6.18 depends on tchsh plus 2 other changes (artifact: 3e93f829 user: drh)
02:01 Closed ticket [f7e3d17a]: Memory accumulate without commit plus 5 other changes (artifact: 690b6b2c user: drh)
01:05 Ticket [3338b3fa] ambiguous column name when using multiple JOIN USING clauses and WHERE clause status still Open with 3 other changes (artifact: 1494b2de user: drh)
2009-09-24
18:42 Fixed ticket [4a03edc4]: Index corruption following aggressive use of ON CONFLICT clause. plus 3 other changes (artifact: cd3aa8c6 user: drh)
14:27
Remove the ALWAYS() added by the previous check-in. It is not needed. (check-in: 36568963 user: drh tags: trunk)
13:48
Comment enhancements. Add an ALWAYS macro in fkey.c to indicate a branch that is always taken. (check-in: d5b714cf user: drh tags: trunk)
12:25 Closed ticket [c9394a56]: Sqlite reading all column data on selects. plus 4 other changes (artifact: 3378c847 user: drh)
00:09
Make sure a transaction is available for rollback whenever a REDUCE conflict resolution occurs and there is the possibility to ABORT. Ticket [4a03edc4c8c] (check-in: f0c56fa9 user: drh tags: trunk)
2009-09-23
19:16 New ticket [4a03edc4] Index corruption following aggressive use of ON CONFLICT clause.. (artifact: 360b4639 user: drh)
15:52 Ticket [702bbe75] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 54f202b4 user: drh)
15:51
Modify the ".dump" command on the CLI so that it always issues a PRAGMA foreign_keys=OFF at the top of the output. (check-in: 0755b9b6 user: drh tags: trunk)
14:45
Change the version number to 3.6.19. Fix a couple of incorrect testcase() macros associated with the new IS and IS NOT operators in expr.c. (check-in: e3b73394 user: drh tags: trunk)
13:42 Ticket [702bbe75] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: ef1b5a65 user: drh)
13:39
Add test cases for the IS and IS NOT operator. (check-in: 101ed58c user: drh tags: trunk)
11:54 Ticket [f51d9501] memset warning with gcc 4.3.3 status still Closed with 1 other change (artifact: 9a6159ee user: drh) ... 1 similar event omitted.
11:22 Closed ticket [98f156c7]: plus 2 other changes (artifact: 586dfe12 user: drh)
03:01
Do not run ON UPDATE actions of a foreign key constraint unless at least one column value really does change. (check-in: 71ac8e28 user: drh tags: trunk)
02:29
Generalize the IS and IS NOT operators so that their right-hand side can be an arbitrary expression and not simple the constant NULL. They work like = and <> except that NULL values compare equal to one another an unequal to everything else. (check-in: 98853f61 user: drh tags: trunk)
2009-09-22
20:08
Factor the UMINUS and UPLUS tokens out of the parser so that the parser tables can go back to using 8-bit values instead of 16-bit values. (check-in: 3fc938c9 user: drh tags: trunk)
19:53
The NO ACTION action really should be no-action and not RESTRICT. (check-in: 55b263fa user: drh tags: trunk)
15:03 Ticket [702bbe75] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 9cb27e4d user: drh)
13:00 Closed ticket [a8b1e82b]: CAST failing for numeric plus 3 other changes (artifact: 6d7d0423 user: drh)
2009-09-21
12:57 Closed ticket [c472df6c]: Segmentation fault by instead of insert triggers plus 3 other changes (artifact: d02c4c22 user: drh)
2009-09-19
14:06 Ticket [56928bd0] Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2 status still Open with 1 other change (artifact: bae6a405 user: drh)
2009-09-17
00:47 Fixed ticket [e25d9ea7]: Cascading delete trigger fails. plus 4 other changes (artifact: df2f80f3 user: drh)
00:41
When coding a trigger, assume that the "oldmask" requires all columns until we know otherwise. That pessimistic assumption assures that all necessary parameters are available on a cascading delete trigger. Ticket [e25d9ea771f] (check-in: 03e464be user: drh tags: trunk)
2009-09-16
21:31 Ticket [e25d9ea7] recursive_triggers=1 failed to work for delete trigger status still Open with 3 other changes (artifact: 60ac7546 user: drh)
12:10 Closed ticket [832b2f3e]: integrity_check error after backup restore plus 2 other changes (artifact: 8a05c5ea user: drh)
2009-09-15
12:30 Closed ticket [127c1c42]: Build error "C compiler cannot create executables" on debian lenny host plus 1 other change (artifact: bcff14c5 user: drh)
00:03 Fixed ticket [a696379c]: Access violation error trying to insert into triggered view plus 3 other changes (artifact: da685e3d user: drh)
2009-09-14
23:47
Make sure sufficient space is allocated for at least one VDBE cursor when autoincrement is used. Ticket [a696379c1f088]. (check-in: 2b2a1ef7 user: drh tags: trunk)
22:28 Ticket [a696379c] Access violation error trying to insert into triggered view status still Open with 1 other change (artifact: 3e27afc2 user: drh) ... 1 similar event omitted.
16:50 Ticket [03b198a2] Getting several warnings when compiling in eVC++ 4 status still Fixed with 1 other change (artifact: b35459b1 user: drh)
15:35 Closed ticket [806f3be2]: Proposal to inline some functions plus 3 other changes (artifact: 33220146 user: drh) ... 2 similar events omitted.
11:47 Ticket [127c1c42] Build error "C compiler cannot create executables" on debian lenny host status still Open with 1 other change (artifact: 79cd2fea user: drh)
2009-09-12
16:29 Ticket [ab7498f2] 54 seconds to sort two(2) rows only when LIKE operator is used in WHERE clause and the query also contains an order-by clause status still Open with 1 other change (artifact: 5a7b4f4b user: drh)
16:29 Closed ticket [8c743979]: SQLite version correction on LIKE operator + ORDER BY bug I reported earlier today (artifact: 19e39615 user: drh) ... 1 similar event omitted.
15:45 Ticket [03b198a2] Getting several warnings when compiling in eVC++ 4 status still Open with 3 other changes (artifact: ae11fec6 user: drh)
15:43 Ticket [ab7498f2] 54 seconds to sort two(2) rows only when LIKE operator is used in WHERE clause and the query also contains an order-by clause status still Open with 4 other changes (artifact: 7b35d5a0 user: drh)
04:06 Fixed ticket [9a502b7a]: datetime function has year 54079 bug plus 4 other changes (artifact: 0e7b45c2 user: drh)
2009-09-11
18:28
Set the execute permission bit on "configure". (check-in: f8c02b2b user: drh tags: trunk)
18:04 Fixed ticket [65bbb65a]: 'configure' file without +x permission in sqlite-3.6.18.tar.gz tarball plus 3 other changes (artifact: f0db3592 user: drh)
17:59
Make sure the (unsupported) configure script in the source tree has execute permission prior to constructing a tarball. Ticket [65bbb65a47ce]. (check-in: 5e0e941f user: drh tags: trunk)
15:41 Edit [b084828a771ec40b|b084828a]: Change background color to "#ffc0d0". Edit check-in comment. Timestamp 2009-09-11 14:05:07. (artifact: c1a0c7b8 user: drh)
14:05
Version 3.6.18 (check-in: b084828a user: drh tags: trunk, release)
11:16 Ticket [6e1086fb] "create table as select" and "pragma *_column_names" status still Open with 3 other changes (artifact: 3e57dcbc user: drh)
2009-09-10
22:30
Omit the mutexIsInit test variable when mutexes are disabled. (check-in: 3ea10434 user: drh tags: trunk)
19:20
Make sure the threadsOverrideEachOthersLocks variable is only referenced by linux systems on a threadsafe compile. (check-in: e9d064bd user: drh tags: trunk)
17:45
Add assert() statement to verify that new mutexes are not allocated when the mutex subsystem is uninitialized. (check-in: 1183c533 user: drh tags: trunk)
12:49 Ticket [92bd6eaf] Suggestion to revise clean rule in main.mk. status still Open with 3 other changes (artifact: d43e9b55 user: drh)
2009-09-09
16:10
Suppress some harmless compiler warnings. (check-in: f0c72a53 user: drh tags: trunk)
15:29
Bug fix in the SQLITE_OPEN_PRIVATECACHE option added a few minutes ago. (check-in: f3a0f23b user: drh tags: trunk)
14:49 Fixed ticket [7d96113f]: SQLite fails to build when TCL isn't installed plus 2 other changes (artifact: 5b8f84d8 user: drh)
14:48
Update the README file to state that TCL is required in order to run the makefiles for SQLite. Ticket [7d96113ff]. (check-in: ba20091a user: drh tags: trunk)
14:31 Closed ticket [4b810759]: In mult-thread that have a problem of updata lost plus 2 other changes (artifact: 0e99c27a user: drh)
14:26 Fixed ticket [9fd0bc36]: Add a new open flag to enable shared cache for a single db connection plus 3 other changes (artifact: afa0825e user: drh)
14:17
Added SQLITE_OPEN_SHAREDCACHE and SQLITE_OPEN_PRIVATECACHE flags as possibilities to sqlite3_open_v2(), to override the global shared cache mode setting. Ticket [9fd0bc36639c15] (check-in: f509eb8b user: drh tags: trunk)
13:18 Closed ticket [f76cabeb]: xBestIndex/xFilter slight interface improvement plus 3 other changes (artifact: 3a27e2e8 user: drh)
12:50 Closed ticket [3350da7d]: Error: malformed database schema - near "VIRTUAL": syntax error plus 2 other changes (artifact: 51c07991 user: drh) ... 1 similar event omitted.
12:41
Increase the size of bitvec objects to 1024 bytes on 64-bit systems. (check-in: f1272b90 user: drh tags: trunk)
2009-09-08
22:15 Ticket [eaa105fe] (...) WHERE col IN (val1) not reflected in xBestIndex status still Open with 6 other changes (artifact: 110a50bd user: drh)
13:40
Additional simplifications in support of structural testing. (check-in: 4ab8c841 user: drh tags: trunk)
02:27
Further simplifications to the VDBE - removing functionality that is no longer used. (check-in: b271e166 user: drh tags: trunk)
01:14
Code simplifications, especially to the pseudo-table logic, and comment improvements. (check-in: 52449a95 user: drh tags: trunk)
2009-09-07
18:14
Add the SQLITE_LIMIT_TRIGGER_DEPTH option to sqlite3_limit(). (check-in: d7dc8b43 user: drh tags: trunk)
16:27 Ticket [e33452c9] Query plan doesn't use existing index status still Open with 4 other changes (artifact: d751e57b user: drh)
2009-09-06
00:56 Closed ticket [cbb5a315]: Concatenating strings should be possible with a plus '+' operator plus 3 other changes (artifact: 617b297f user: drh)
2009-09-03
19:43
Fix a VDBE stack overflow issue with the UPDATE statement. (Leaf check-in: 715cecb8 user: drh tags: branch-3.3.6)
16:23
Add the "unix-wfl" VFS that does whole-file locking in order to help NFS do better cache coherency. (check-in: 2aeab80e user: drh tags: trunk)
01:26 Fixed ticket [2ea2425d]: Assertion fault: Text encoding mismatch on value comparison plus 3 other changes (artifact: f0bfe8a8 user: drh)
01:18
Do not reuse function parameters in subsequent expressions since the function call might have triggered a text encoding change. Fix for ticket [2ea2425d34be]. (check-in: f22e3887 user: drh tags: trunk)
00:53 New ticket [2ea2425d] Assertion fault: Text encoding mismatch on value comparison. (artifact: f4234de9 user: drh)
2009-09-02
19:04
Documentation updates for the version info #defines and C interfaces. (check-in: 69055e9b user: drh tags: trunk)
2009-09-01
15:23 Closed ticket [44a1b817]: Problem with Kaspersky Anti-Virus and SQLite plus 5 other changes (artifact: e7c0f485 user: drh)
Previous month ↓