SQLite

Timeline
Login

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

100 events occurring around 5806925283b88986.

2009-10-14
13:45 Edit [b084828a771ec40b|b084828a]: Timestamp 2009-09-11 14:05:07. Add tag "release". (artifact: 847dedc6 user: drh)
13:43 Edit [c1d499afc50d54b3|c1d499af]: Change background color to "#ffc0d0". Edit check-in comment. Timestamp 2009-10-14 11:33:55. Add tag "release". (artifact: 51ce4d77 user: drh)
11:33
Version 3.6.19 (check-in: c1d499af user: drh tags: trunk, release)
11:15 Ticket [c25aab7e] The ".import" command does not parse CSV correctly. status still Open with 1 other change (artifact: 7466c100 user: anonymous)
2009-10-13
22:47
Update the configure script for version 3.6.19. (check-in: ac19dbc6 user: drh tags: trunk)
19:19 Edit [e0aa50c382a56bb0|e0aa50c3]: Timestamp 2009-10-13 19:19:24. Change user to "shane". (artifact: c66cf6d2 user: drh)
19:19
Fixed warnings with MSVC compile. (check-in: e0aa50c3 user: shane tags: trunk)
18:49
Fix a typo in the test script added for ticket [5ee23731f15]. (check-in: d0f55b5c user: drh tags: trunk)
18:38
Update the TCL wrapper to provide a non-NULL objProc pointer to the Tcl_NRCreateCommand() interface. The TCL gurus say this is needed to support legacy TCL extensions. (check-in: 1b3cfa01 user: drh tags: trunk)
15:44 Fixed ticket [5ee23731]: assert() failure (or invalid error code) caused by opening statement transaction on read-only database with active read statements plus 3 other changes (artifact: b7a954b4 user: drh)
15:42
Add a test case to verify that ticket [5ee23731f15] has been fixed. (check-in: f894ebf8 user: drh tags: trunk)
15:36
When a write transaction fails to being because the database is read-only, fail right away. Do not give the error code an opportunity to be overwritten with SQLITE_OK. Ticket [5ee23731f15]. (check-in: bc110117 user: drh tags: trunk)
15:34 New ticket [5ee23731] assert() failure (or invalid error code) caused by opening statement transaction on read-only database with active read statements. (artifact: dee8fcc8 user: dan)
13:08
Suppress some harmless compiler warnings. (check-in: 5d381daa user: drh tags: trunk)
12:48
Make sure mem3.c releases its mutex on an sqlite3_shutdown() call. (check-in: 16254ad5 user: drh tags: trunk)
10:39
Add further test cases to e_fkey.test. (check-in: c85e5874 user: dan tags: trunk)
2009-10-12
22:30
Add asserts as evidence that all FK constraints are either immediate or deferred. (check-in: 634ef4fc user: drh tags: trunk)
21:22 New ticket [7b61b6c6] insert mode is incorrectly converting text to numbers. (artifact: 7ec8cb6e user: rogerb)
20:01
When processing FK constraints on changes to parent tables, make sure the names of child tables appear correctly in the output of EXPLAIN QUERY PLAN. (check-in: a4ab5215 user: drh tags: trunk)
18:57
Add more test cases to e_fkey.test. (check-in: 5633cb2b user: dan tags: trunk)
16:02
Fix some mappings from e_fkey.test. (check-in: 171c6713 user: dan tags: trunk)
15:25
Update e_fkey.test to match the latest version of foreignkeys.html. (check-in: a2ca9f1a user: dan tags: trunk)
11:27
Extra test cases mapped to statements in foreignkeys.html. (check-in: ffa6207d user: dan tags: trunk)
08:41
Add further test cases to e_fkey.test. (check-in: d61cc0e1 user: dan tags: trunk)
04:26 New ticket [ee19e690] If shell is interrupted while dumping it still produces commit (and invalid dump). (artifact: c283c86d user: rogerb)
04:24 Ticket [ba7fdb56] Page size should auto default to file system block size status still Open with 3 other changes (artifact: 6fbe2d87 user: rogerb)
04:15 New ticket [ac55d88a] H10336 is no longer applicable. (artifact: fed2312b user: rogerb)
04:12 New ticket [4d5c039d] Truncated database not detected well. (artifact: d1730fa4 user: rogerb)
2009-10-11
07:36 Ticket [ee4b2b48] Prepared statement cache status still Open with 4 other changes (artifact: b9ba3cb6 user: rogerb) ... 1 similar event omitted.
06:21 New ticket [beb2dd69] do_meta_command inconsistent return values. (artifact: e428590b user: rogerb)
06:04 New ticket [08595ca4] INTERSECT operator should have higher precedence. (artifact: da23ad28 user: rogerb)
05:44 New ticket [ed2ff2f4] Call progress callback while doing pragma integrity_check. (artifact: 64e43de7 user: rogerb)
05:33 New ticket [2cb66577] Diagnostic message is unintentionally printed in batch mode. (artifact: a3219b56 user: rogerb)
2009-10-10
15:49
Add tests to e_fkey.test. (check-in: 5ec07fee user: dan tags: trunk)
14:29
Update requirement text for sqlite3_open_blob(). Update evidence comment in e_fkey.test to conform to the latest requirement phrasing. (check-in: 89c548ac user: drh tags: trunk)
03:18 New ticket [c060923a] VFS filename truncation issues. (artifact: 2b6ea725 user: rogerb)
2009-10-09
18:16
Add test cases to e_fkey.test. (check-in: e391dfe7 user: dan tags: trunk)
2009-10-08
19:02
Test a couple of the examples in foreignkeys.html. (check-in: a2fb7902 user: dan tags: trunk)
17:42
Add test cases to test file "e_fkey.test". (check-in: 23e0f61a user: dan tags: trunk)
13:42
Fix a problem in the legacy genfkey code to do with column names that require quoting. (check-in: 273ccbf1 user: dan tags: trunk)
11:57
Add tests to test/e_fkey.test. (check-in: 533703d7 user: dan tags: trunk)
11:54 Ticket [ebde3f66] Shared cache has different busy behaviour than non-shared status still Open with 3 other changes (artifact: 63736641 user: drh)
11:23 Ticket [23b21282] Uninformative error message on check constraint failure status still Open with 1 other change (artifact: 79a907ef user: anonymous)
08:15 New ticket [897b96d4] SQLITE_CANTOPEN when using journal_mode=persist and async IO. (artifact: ae7a158a user: dan)
06:59 Ticket [23b21282] Uninformative error message on check constraint failure status still Open with 3 other changes (artifact: 18b14039 user: rogerb)
06:46 New ticket [d8fe6cef] Error return from VFS xUnlock ignored. (artifact: af15aaed user: rogerb)
06:39 New ticket [23b21282] Meangingless error message on check constraint failure. (artifact: addfa3c6 user: rogerb)
06:26 New ticket [ebde3f66] Shared cache has different busy behaviour than non-shared. (artifact: 2a700451 user: rogerb)
06:24
Update triggerC.test to match the change to the way the trigger-recursion limit is handled. (check-in: 58069252 user: dan tags: trunk)
01:43
Fix a segfault that can occur following an OOM fault while renaming a table holding foreign key constraints. (check-in: 33973814 user: drh tags: trunk)
2009-10-07
23:43 Fixed ticket [8550ecca]: findLockInfo uses memcmp on non-zeroed, = assigned struct plus 3 other changes (artifact: 0eeaeb30 user: drh)
23:42
Use memcpy() rather than structure assignment so that memcmp() can later be used for comparison. Ticket [8550ecca70] (check-in: 56f609da user: drh tags: trunk)
22:34 New ticket [8550ecca] findLockInfo uses memcmp on non-zeroed, = assigned struct. (artifact: c15f59e3 user: aswift)
18:41
Add some tests of statements in foreignkeys.html. (check-in: 83828679 user: dan tags: trunk)
16:04
Add a missing OP_Close opcode to VDBE programs that check for FK constraint violations. (check-in: 5caa4a2b user: dan tags: trunk)
13:55 New ticket [94c04eaa] Crash in asyncRead() with large (>2GB) database file. (artifact: 46c84add user: dan)
11:29
Update the header comment for sqlite3_blob_open to note that it is not possible to write to a column that is indexed, part of a primary key or, if foreign key support is enabled, part of a foreign key. (check-in: 2fd487fd user: dan tags: trunk)
10:43
Update header file comments describing the sqlite3_changes and sqlite3_total_changes functions to describe how changes made by foreign key actions are handled. (check-in: 4c342c02 user: dan tags: trunk)
2009-10-06
18:10 Ticket [c25aab7e] The ".import" command does not parse CSV correctly. status still Open with 2 other changes (artifact: 1a724b75 user: rogerb)
14:59
Change tclsqlite.c to use the Tcl_NRxxx() APIs in Tcl versions 8.6 and later. (check-in: e9f72f1d user: dan tags: trunk)
2009-10-05
23:10 New ticket [f9af981d] sqlite3_shutdown documentation needs to mention danger. (artifact: 857d880d user: rogerb)
22:23 Ticket [24666532] Various dump issues status still Open with 3 other changes (artifact: 37405da9 user: rogerb) ... 1 similar event omitted.
18:18 Ticket [0322cd49] create_function_v2 that takes destructor status still Open with 3 other changes (artifact: fe12bfe1 user: rogerb)
18:05 New ticket [1c67bd6c] Shell Control-C (break) handling could be better. (artifact: 4896d7b3 user: rogerb)
05:40
Fix some errors in the guttman versions (disabled by default) of the algorithms in rtree.c. (check-in: 64bad00b user: dan tags: trunk)
04:16 Ticket [6da68f69] tables says you provide a like pattern but it adds % in code status still Open with 3 other changes (artifact: af7ddd7d user: rogerb)
2009-10-04
23:37 New ticket [ba7fdb56] Page size should auto default to file system block size. (artifact: 1ddcd201 user: rogerb)
23:03 New ticket [0322cd49] create_function_v2 that takes destructor. (artifact: 1f590b75 user: rogerb)
22:55 Ticket [4776dee0] Documentation and code about registering functions status still Open with 2 other changes (artifact: 2ab6434e user: rogerb) ... 2 similar events omitted.
20:35 New ticket [89668ca1] shell can support .timer on Windows. (artifact: 66f863a4 user: rogerb)
2009-10-03
23:25 New ticket [1a1790ca] No way to signal an error in collation callback. (artifact: 0210d47e user: rogerb)
07:56 New ticket [6da68f69] tables says you provide a like pattern but it adds % in code. (artifact: 8d9b39b2 user: rogerb)
07:04
Handle an SQLITE_IGNORE returned when requesting authorization to read parent key columns by pretending the parent key columns contain NULL values. (check-in: 3c24df38 user: dan tags: trunk)
04:05 New ticket [8f81455b] fts3GetVarint32 sets random number on error. (artifact: d84ee80c user: rogerb)
02:08 New ticket [bd770b2c] shell doesn't return error exit code on import errors. (artifact: 47ac7ead user: rogerb)
02:02 New ticket [2e047cbe] select DISTINCT performance could be better. (artifact: f967d12b user: rogerb)
2009-10-02
19:54 New ticket [f5cb008a] Shell silently ignores extra parameters. (artifact: f0d1a7a8 user: rogerb)
15:29
Add one more authentication test to fkey2.test to cover an untested branch. (check-in: e4fa8be7 user: dan tags: trunk)
14:23
When inserting a row into a child table, invoke the authorization callback to request permission to read the parent key columns. (check-in: 9842f2d5 user: dan tags: trunk)
06:35
Add a test to check that the incrblob API cannot be used to write to an IPK column. Also a comment to explain why the incrblob code does not need to check if a column is part of a parent key before writing to it. (check-in: dca2a7f6 user: dan tags: trunk)
2009-10-01
17:13
Add test cases to cover the branches added by the previous commit. (check-in: aaa005b6 user: dan tags: trunk)
16:09
If an update does not modify any child or parent key columns, omit foreign key processing for the statement. (check-in: edff3500 user: dan tags: trunk)
07:27 Ticket [2fd50fa6] cygwin-1.7 issues: winFullPathname and tempname status still Open with 4 other changes (artifact: 07b92392 user: rogerb)
07:23 New ticket [43d2aa29] H13015 needs to be completed. (artifact: ac8d312a user: rogerb)
07:17 New ticket [3211d778] replace function works on blobs. (artifact: b3d4e9eb user: rogerb)
07:07 New ticket [8440a8e2] LENGTH & QUOTE stop at first zero. (artifact: 7a9cbc2f user: rogerb)
06:47 Ticket [19b44e35] sqlite3_bind_text inconsistent with NULL pointers, zero length etc status still Open with 3 other changes (artifact: 4fc1eaf9 user: rogerb) ... 1 similar event omitted.
06:31 New ticket [72adc99d] shell mode insert doesn't output blobs as blobs. (artifact: 7fb1b8cb user: rogerb)
04:35
Add tests to check that FK support interacts with count-changes correctly. (check-in: 5b836615 user: dan tags: trunk)
02:05 Ticket [e063139e] Download .zip excludes shell but .tar includes it status still Open with 1 other change (artifact: 053b43a0 user: rogerb)
02:04 Ticket [f12a9eee] Shell command argument parsing is lax status still Open with 3 other changes (artifact: 8d0a5cd2 user: rogerb)
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)
09:01 Ticket [e063139e] Download .zip excludes shell but .tar includes it status still Open with 3 other changes (artifact: 4bd0b350 user: rogerb) ... 1 similar event omitted.
08:55 New ticket [e123bd22] POSIX File handles aren't always immediately released on sqlite3_close. (artifact: cad71b4d user: rogerb)