SQLite
Timeline
Not logged in

20 timeline items occurring around 2012-12-14.

2012-12-17
18:43
[57d47423a6] "PRAGMA foreign_key_check" with no argument checks the foreign keys on all tables. (user: drh, tags: foreign-key-check)
18:05
[603b695bf0] Fix an issue with child keys that are not INTEGER PRIMARY KEY referencing INTEGER PRIMARY KEY in the parent. (user: drh, tags: foreign-key-check)
16:46
[01c980e9bb] Prototype for PRAGMA that checks all foreign key constraints on a table. (user: drh, tags: foreign-key-check)
2012-12-15
14:33 • Ticket [5eaa61ea18] sigbus on disk ful in WAL mode status still Open with 5 other changes (user: drh) ... 1 similar event omitted.
2012-12-14
17:55 • Edit d2fb7619b063b329: Marked "Closed". (user: drh)
17:54
[3d65c70343] Optimize IN operators in the WHERE clause of queries using virtual tables. (user: drh, tags: trunk)
17:48
[d2fb7619b0] Closed-Leaf: Remove an unreachable branch. Improvements to comments. (user: drh, tags: vtab-IN-opt)
15:54
[6d507e4de9] Merge in all the trunk changes that have occurred since this branch was opened. (user: drh, tags: vtab-IN-opt)
15:36
[d6e045f89c] Fix the virtual table IN optimizer so that it work even if the virtual table implementation leaves the sqlite3_index_info.aConstraintUsage[].omit flag clear for an equality constraint that it intends to use. (user: drh, tags: vtab-IN-opt)

2012-12-13
18:57
[52e755943f] Generalize the min/max optimization so that if an appropriate index exists, the index it can be used by any aggregate query that contains only a single max() or min() and does not contain a GROUP BY clause. (user: drh, tags: trunk)
18:51
[8bcf5f51d8] Increase the version number to 3.7.16 in advance of adding new features for the next release. (user: drh, tags: trunk)
16:37
[7280e14cd8] Closed-Leaf: Attempt to further generalize the min/max optimization so that, if an appropriate index exists, it can be used by any aggregate query that contains only a single aggregate of the form max(colname) or min(colname) and does not contain a GROUP BY clause. (user: dan, tags: minmax-opt)
2012-12-12
14:30
[120c82d56e] Allow the error message from "PRAGMA integrity_check" to be longer than 20,000 bytes. (user: drh, tags: trunk)
13:36
[cd0b37c526] Version 3.7.15 (user: dan, tags: trunk, release, version-3.7.15)
2012-12-11
19:40
[81d9ee0f0d] Update requirements marks and test cases for multi-VALUE INSERT and to fix typos in requirements text. (user: drh, tags: trunk)
19:10
[e38adb60a7] Fix a typo in a comment that is used to generate documentation. No changes to code. (user: drh, tags: trunk)
18:36 • Edit cdbfa664839a4095: Marked "Closed". (user: drh)
18:36 • Edit 0c31a46801746191: Marked "Closed". (user: drh)
2012-12-10
22:19
[bd7aeeb691] When an arithmetic operation with two integer operands must give a floating-point answer due to overflow, make sure the answer is not rounded back to integer by affinity. (user: drh, tags: trunk)