SQLite

Timeline
Login

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

100 events occurring around 2d544bd53d0fb963.

2009-09-29
03:33 New ticket [eb620916be] Shell doesn't print header if multiple statements on one line. (artifact: 6438035f67 user: rogerb)
2009-09-28
18:52
Ignore foreign key mismatch errors while compiling DROP TABLE commands. (check-in: 5b4d46374a user: dan tags: trunk)
14:49
Fix the DROP TABLE command so that it cannot be used to bypass foreign key constraints (if foreign key support is enabled). (check-in: 8353808c9e user: dan tags: trunk)
11:54
Fix some foreign key constraint related problems that occur when a row refers to itself. (check-in: 9e503e2d04 user: dan tags: trunk)
05:32 New ticket [7d32c69b50] sqlite3LoadExtension truncates file names. (artifact: 5e9b718726 user: rogerb)
05:05 New ticket [0b803bff85] Return (error code) of xCurrentTime is always ignored. (artifact: c4d1bfb5d6 user: rogerb)
05:02 New ticket [20f9d4fbbf] sqlite3_overload_function ignores errors. (artifact: e201503146 user: rogerb)
04:58 New ticket [62359d6511] xGetLastError should be dumped. (artifact: 148039b239 user: rogerb)
04:49 New ticket [efeeb90f2a] error messages should be per-thread not global. (artifact: 0abb02116e user: rogerb)
2009-09-27
01:18 Changes to wiki page "Bug Reports" (artifact: 1f0f337b6d user: rogerb)
2009-09-26
17:51
When ALTER TABLE RENAME TO is used to change the name of a table that is the parent table of a foreign key constraint, modify that foreign key constraint to use the new table name. (check-in: b4a10c39e7 user: dan tags: trunk)
15:14 Closed ticket [58a75d62e0]: encoding failure plus 3 other changes (artifact: 683a429351 user: drh)
14:40 Added wiki page "Bug Reports" (artifact: 8646127e8b user: drh)
14:20 Closed ticket [cff1a52937]: sqlite3_get_table() returns wrong result when using where clause plus 3 other changes (artifact: 0d93ca4736 user: drh)
13:57 Closed ticket [d77ffcd7a5]: Memory leak on failing INSERT statements on tables with UNIQUE INDEX plus 2 other changes (artifact: 10890730d0 user: drh) ... 2 similar events omitted.
10:28 New ticket [cff1a52937] sqlite3_get_table() returns wrong result when using where clause. (artifact: 504f4a7388 user: anonymous)
10:16 Ticket [d77ffcd7a5] Memory leak on failing INSERT statements on tables with UNIQUE INDEX status still Open with 1 other change (artifact: d8074b889f user: anonymous) ... 4 similar events omitted.
2009-09-25
17:03
Avoid checking if an insert or delete has "fixed" an outstanding FK constraint violation if the constraint counter indicates that the database contains no such violations. (check-in: 519144ac43 user: dan tags: trunk)
15:48 New ticket [58a75d62e0] encoding failure. (artifact: 4b0b5f55b9 user: anonymous)
12:00
Fix comments in fkey2.c to reflect the immediate-constraint-counter approach. (check-in: 9fd54b0aa7 user: dan tags: trunk)
11:26
Prevent ALTER TABLE from being used to add a column with a REFERENCES clause and a non-NULL default value while foreign key support is enabled. (check-in: 353b1b1825 user: dan tags: trunk)
10:35 Closed ticket [860d129c15]: builds with sqlite 3.6.18 depends on tchsh plus 2 other changes (artifact: 3e93f82920 user: drh) ... 2 similar events omitted.
02:01 Closed ticket [f7e3d17a34]: Memory accumulate without commit plus 5 other changes (artifact: 690b6b2cde user: drh) ... 2 similar events omitted.
01:05 Ticket [3338b3fa19] ambiguous column name when using multiple JOIN USING clauses and WHERE clause status still Open with 3 other changes (artifact: 1494b2de35 user: drh) ... 1 similar event omitted.
2009-09-24
18:42 Fixed ticket [4a03edc4c8]: Index corruption following aggressive use of ON CONFLICT clause. plus 3 other changes (artifact: cd3aa8c601 user: drh)
18:19
Fixes and test cases to make sure the affinity and collation sequence associated with the parent key is used when comparing it with a child key value. (check-in: 76e8e74b49 user: dan tags: trunk)
16:52
Fix a bug in the code for REPLACE conflict handling on IPK columns when there are no indexes on the table. Triggers and foreign key processing were being bypassed. (check-in: beb2094f94 user: dan tags: trunk)
16:48 Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: c10814b9eb user: anonymous)
15:16
Fix a problem in fkey.c when a child key is the IPK of its table. (check-in: 8a000a8aae user: dan tags: trunk)
14:27
Remove the ALWAYS() added by the previous check-in. It is not needed. (check-in: 3656896335 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: d5b714cfff user: drh tags: trunk)
12:25 Closed ticket [c9394a56c7]: Sqlite reading all column data on selects. plus 4 other changes (artifact: 3378c8472e user: drh) ... 1 similar event omitted.
11:31
Ensure foreign key related processing takes place when rows are deleted from the database by REPLACE conflict handling. (check-in: 3f40c142c8 user: dan tags: trunk)
10:42
Use sqlite3FkOldmask() in delete.c instead of assuming that foreign key constraints always require all columns of the deleted row to be stored in registers. (check-in: ce554a3934 user: dan tags: trunk)
09:05
Remove unused parameter from sqlite3CodeRowTrigger(). Fix header comments for this function and CodeRowTriggerDirect(). (check-in: 0443f7c911 user: dan tags: trunk)
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: f0c56fa90d user: drh tags: trunk)
2009-09-23
19:16 New ticket [4a03edc4c8] Index corruption following aggressive use of ON CONFLICT clause.. (artifact: 360b463978 user: drh)
18:49
More fkey tests. (check-in: 2d544bd53d user: shane tags: trunk)
18:07
Fix a problem with FK constraints that implicitly map to a composite primary key. (check-in: e0a48d5311 user: dan tags: trunk)
17:31
Fix a problem in the fkey_malloc.test script. (check-in: 0ce1efa460 user: dan tags: trunk)
17:30
Do not check immediate foreign key constraints until the end of the statement. This matches the postgres behaviour. (check-in: 1a32149cc3 user: dan tags: trunk)
15:52 Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 54f202b46a 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: 0755b9b697 user: drh tags: trunk)
15:41 Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 58649bce9e user: anonymous)
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: e3b73394bf user: drh tags: trunk)
13:59
Disallow using the implicit rowid column as the parent key of an FK constraint. (check-in: a5f7e71f42 user: dan tags: trunk)
13:42 Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: ef1b5a65fd user: drh)
13:39
Add test cases for the IS and IS NOT operator. (check-in: 101ed58cf4 user: drh tags: trunk)
12:06
Add extra tests for foreign key support. (check-in: 7d086afe69 user: dan tags: trunk)
11:54 Ticket [f51d950180] memset warning with gcc 4.3.3 status still Closed with 1 other change (artifact: 9a6159ee36 user: drh) ... 1 similar event omitted.
11:22 Closed ticket [98f156c79b]: plus 2 other changes (artifact: 586dfe12cd user: drh)
08:43
Add missing comments to fkey.c. Also, change the terminology used for comments and names in fkey.c from "referenced/referencing" to "parent/child". This is arguably less correct, but is easier to follow. (check-in: 540c2d18e1 user: dan tags: trunk)
08:32 New ticket [f51d950180] memset warning with gcc 4.3.3. (artifact: ac551f6db0 user: anonymous)
07:39 New ticket [98f156c79b] . (artifact: 98fde03230 user: anonymous)
04:12 Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 8b058ffd3e user: anonymous)
03:01
Do not run ON UPDATE actions of a foreign key constraint unless at least one column value really does change. (check-in: 71ac8e28e5 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: 98853f6104 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: 3fc938c961 user: drh tags: trunk)
19:53
The NO ACTION action really should be no-action and not RESTRICT. (check-in: 55b263fa2b user: drh tags: trunk)
19:47 Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 6d6ea85086 user: anonymous)
16:55
Fix another OOM related problem in fkey.c. (check-in: e2bc51bc61 user: dan tags: trunk)
16:08
Fix a problem with ON DELETE SET DEFAULT actions. (check-in: 9406995055 user: dan tags: trunk)
15:53
Fix an OOM related crash in fkey.c. (check-in: 635d6a775a user: dan tags: trunk)
15:03 Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: 9cb27e4dcb user: drh) ... 1 similar event omitted.
13:32 Closed ticket [0bc616a2c8]: In wince 6.0, I can not compile sqlite. plus 4 other changes (artifact: 160f84c79e user: shane)
13:25
Allow specific exclusion of localtime_s() usage on Windows. (check-in: 216bcda7d2 user: shane tags: trunk)
13:10 Ticket [702bbe755b] Invalid VDBE program built if ORDER BY used status still Open with 3 other changes (artifact: 9c25e7f5fe user: anonymous) ... 1 similar event omitted.
13:00 Closed ticket [a8b1e82b8f]: CAST failing for numeric plus 3 other changes (artifact: 6d7d04236c user: drh) ... 1 similar event omitted.
07:13
Fix compilation errors when OMIT_FOREIGN_KEY is defined. (check-in: c447cb37d6 user: dan tags: trunk)
2009-09-21
18:56
Fix a problem with foreign key constraints that map from and IPK column. (check-in: 8412905262 user: dan tags: trunk)
16:34 Closed ticket [56928bd084]: Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2 plus 2 other changes (artifact: 73b70a0ee2 user: dan)
16:34
Fix compilation with both OMIT_UTF16 and ENABLE_STAT2 defined. Ticket [56928bd084]. (check-in: cd850d49a1 user: dan tags: trunk)
16:14 Ticket [c472df6c1c] Segmentation fault by instead of insert triggers status still Closed with 1 other change (artifact: 3b35f10062 user: dan)
16:08 Closed ticket [1ff6d29030]: Compile fails with SQLITE_OMIT_TRIGGER plus 2 other changes (artifact: e3a1dc15d4 user: dan)
16:06
Fix compilation with OMIT_TRIGGER defined. Ticket [1ff6d29030]. (check-in: fb6ceed388 user: dan tags: trunk)
13:18 Ticket [c472df6c1c] Segmentation fault by instead of insert triggers status still Closed with 1 other change (artifact: c0e263ac7d user: anonymous) ... 2 similar events omitted.
2009-09-20
08:02 Ticket [1ff6d29030] Compile fails with SQLITE_OMIT_TRIGGER status still Open with 4 other changes (artifact: fbfe47f8cb user: anonymous)
2009-09-19
17:59
Add fkey.c to the autoconf and amalgamation build systems. (check-in: aab7a4b3c9 user: dan tags: trunk)
17:00
Check in implementation of foreign key constraints. (check-in: d5d3998118 user: dan tags: trunk)
14:06 Ticket [56928bd084] Cannot compile with SQLITE_OMIT_UTF16 and SQLITE_ENABLE_STAT2 status still Open with 1 other change (artifact: bae6a405db user: drh)
09:30 New ticket [aad47726e9] Generator of sqlite3UpperToLower[] and sqlite3CtypeMap[] for single lang. (artifact: 92cd2993b0 user: anonymous)
09:03 New ticket [0bc616a2c8] In wince 6.0, I can not compile sqlite.. (artifact: 40ad5afe9f user: anonymous)