SQLite

Timeline
Login

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

100 events occurring around e4eb227b14e4bfcb.

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)
08:45 New ticket [35c54c87] Some os win symbols should be declared static. (artifact: e01d2e6b user: rogerb)
08:11
Remove unreachable branches from fkey.c. Add a few tests to cover the remaining branches. (check-in: 0a0a17d8 user: dan tags: trunk)
04:28
Change a couple of comments to use "SQLITE_MUTEX_OMIT" instead of OMIT_MUTEX. (check-in: b733e939 user: dan tags: trunk)
2009-09-29
18:26 Closed ticket [668fe226]: pragma table_info doesn't accept database names plus 2 other changes (artifact: 8a03db8f user: rogerb)
16:38
Use the affinity and collation sequence associated with the parent key when finding child table rows to apply a foreign key action to. (check-in: 9a4b7ec2 user: dan tags: trunk)
15:41
Check that a unique index uses the default collation sequences for each column before using it as part of a foreign key constraint operation. (check-in: 64154174 user: dan tags: trunk)
11:58 Ticket [668fe226] pragma table_info doesn't accept database names status still Open with 3 other changes (artifact: dec53170 user: ralfjunker)
11:28
Remove an unused variable from fkey.c. (check-in: 582bd768 user: dan tags: trunk)
09:25 New ticket [668fe226] pragma table_info doesn't accept database names. (artifact: bdb4713b user: rogerb)
07:35 New ticket [dc3a6e5b] Shell doesn't htmlify column headers. (artifact: faa7bbfe user: rogerb)
06:33
Various fixes so that "make test" works with OMIT_FOREIGN_KEY, OMIT_TRIGGER and OMIT_ALTER_TABLE. (check-in: e4eb227b user: dan tags: trunk)
04:17 Ticket [eb620916] Shell doesn't print header if multiple statements on one line status still Open with 3 other changes (artifact: cc4a5b28 user: rogerb)
03:58 New ticket [f12a9eee] Shell command argument parsing is lax. (artifact: a4c95c9f user: rogerb)
03:33 New ticket [eb620916] Shell doesn't print header if multiple statements on one line. (artifact: 6438035f user: rogerb)
2009-09-28
18:52
Ignore foreign key mismatch errors while compiling DROP TABLE commands. (check-in: 5b4d4637 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: 8353808c user: dan tags: trunk)
11:54
Fix some foreign key constraint related problems that occur when a row refers to itself. (check-in: 9e503e2d user: dan tags: trunk)
05:32 New ticket [7d32c69b] sqlite3LoadExtension truncates file names. (artifact: 5e9b7187 user: rogerb)
05:05 New ticket [0b803bff] Return (error code) of xCurrentTime is always ignored. (artifact: c4d1bfb5 user: rogerb)
05:02 New ticket [20f9d4fb] sqlite3_overload_function ignores errors. (artifact: e2015031 user: rogerb)
04:58 New ticket [62359d65] xGetLastError should be dumped. (artifact: 148039b2 user: rogerb)
04:49 New ticket [efeeb90f] error messages should be per-thread not global. (artifact: 0abb0211 user: rogerb)
2009-09-27
01:18 Changes to wiki page "Bug Reports" (artifact: 1f0f337b 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: b4a10c39 user: dan tags: trunk)
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.
10:28 New ticket [cff1a529] sqlite3_get_table() returns wrong result when using where clause. (artifact: 504f4a73 user: anonymous)
10:16 Ticket [d77ffcd7] Memory leak on failing INSERT statements on tables with UNIQUE INDEX status still Open with 1 other change (artifact: d8074b88 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: 519144ac user: dan tags: trunk)
15:48 New ticket [58a75d62] encoding failure. (artifact: 4b0b5f55 user: anonymous)
12:00
Fix comments in fkey2.c to reflect the immediate-constraint-counter approach. (check-in: 9fd54b0a 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: 353b1b18 user: dan tags: trunk)
10:35 Closed ticket [860d129c]: builds with sqlite 3.6.18 depends on tchsh plus 2 other changes (artifact: 3e93f829 user: drh) ... 2 similar events omitted.
02:01 Closed ticket [f7e3d17a]: Memory accumulate without commit plus 5 other changes (artifact: 690b6b2c user: drh) ... 2 similar events omitted.
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) ... 1 similar event omitted.
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)
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: 76e8e74b 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: beb2094f user: dan tags: trunk)
16:48 Ticket [702bbe75] Invalid VDBE program built if ORDER BY used status still Open with 1 other change (artifact: c10814b9 user: anonymous)
15:16
Fix a problem in fkey.c when a child key is the IPK of its table. (check-in: 8a000a8a user: dan tags: trunk)
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) ... 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: 3f40c142 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: ce554a39 user: dan tags: trunk)
09:05
Remove unused parameter from sqlite3CodeRowTrigger(). Fix header comments for this function and CodeRowTriggerDirect(). (check-in: 0443f7c9 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: f0c56fa9 user: drh tags: trunk)