SQLite
Timeline
Not logged in

50 most recent timeline items

2017-04-26
04:32
[304689f8] Leaf: Fix a subtle bug in Lemon discovered and reported on the mailing list by Kelvin Sherlock, who also suggested the correct fix. (user: drh, tags: trunk)
2017-04-24
16:14
[031feebc] Leaf: Bring in all the latest enhancements from trunk. (user: drh, tags: apple-osx)
14:57 • Closed ticket [61fe9745]: Duplicate result using an IN operator in the WHERE clause plus 6 other changes (user: dan)
14:16
[1c1b0862] When building an ephemeral table of integers, do not assume that the table does not already contain N if the insert cursor points to N-1. Fix for ticket [61fe9745]. (user: dan, tags: trunk)
13:49 • New ticket [61fe9745] Duplicate result using an IN operator in the WHERE clause. (user: drh)
2017-04-22
00:20
[e39769f4] Fix an assertion fault found by OSSFuzz. (user: drh, tags: trunk)
2017-04-21
19:58
[9fa2ce3c] Leaf: Another minor formatting fix. (user: dan, tags: schemalint)
19:56
[da9a2e5a] Fix formatting errors in the previous commit. (user: dan, tags: schemalint)
19:53
[3b2ff4e0] Update the README.md file in the ext/expert/ directory. (user: dan, tags: schemalint)
17:03
[bdc50d8d] Remove a NEVER macro for a condition that may be true as of [a47efb7c]. Problem reported by OSSFuzz. (user: dan, tags: trunk)
16:04
[840042cb] Fix an FTS5 bug that could cause a prefix-query without a prefix-index on a database that contains delete-markers to return extra, non-matching, rows. (user: dan, tags: trunk)
2017-04-20
17:35
[b1533bc4] Merge latest trunk changes into this branch. (user: dan, tags: schemalint)
17:03 • Edit [8e57c31340dd9ffc|8e57c313]: Mark "Closed". (user: dan)
17:03
[4e366996] Avoid creating a temp table in the user database in the sqlite3_expert code. (user: dan, tags: schemalint)
16:43
[8e57c313] Closed-Leaf: Speed this branch up a bit by filtering before the virtual table layer when sampling user data. (user: dan, tags: schemalint-failure)
16:42 • Edit [c62e358243d96cb3|c62e3582]: Remove the "Closed" mark. (user: dan)
16:18
[4577fea5] Avoid adding INTEGER PRIMARY KEY columns to candidate indexes. (user: dan, tags: schemalint)
16:08 • Edit [c62e358243d96cb3|c62e3582]: Mark "Closed". (user: dan)
16:08
[c62e3582] Avoid creating a temp table in the user database in the sqlite3_expert code. Trouble is, this makes sampling for stat1 data much slower. (user: dan, tags: schemalint-failure)
09:54
[c69c3e21] Add an option to generate stat1 data based on a subset of the user database table contents to sqlite3_expert. (user: dan, tags: schemalint)
2017-04-19
13:25
[6b21d0fd] Further improvements to coverage of fts3 module. (user: dan, tags: trunk)
07:33
[ea8a0d2c] Further modifications and test cases to improve test coverage of fts3. (user: dan, tags: trunk)
2017-04-18
20:10
[a157fcfd] Have sqlite3_expert_analyze() populate the sqlite_stat1 table before running queries through the planner for the second time. (user: dan, tags: schemalint)
13:50
[dc2a4802] Use sqlite3_table_column_metadata() instead of a SELECT statement to check for the existence of a %_stat table in fts3. This leads to smaller and easier to test code. (user: dan, tags: trunk)
11:20
[41c27bc0] Improved optimizations of views as the right operand of a LEFT JOIN. (user: drh, tags: trunk)
09:04
[ff4976da] Fix sqlite3_expert handling of triggers on views. (user: dan, tags: schemalint)
05:49
[e47fdb49] Refactor the fts3ColumnMethod() function so that all branches can be covered. (user: dan, tags: trunk)
2017-04-17
23:23
[56845256] Defer checking for null in the comparison operators, since that is an uncommon case. (user: drh, tags: trunk)
20:50
[e698db19] Do not allow a Mem object to be both NULL and some other type at the same time. (user: drh, tags: trunk)
18:42
[69f51f83] Consolidate two branches of code in the "PRAGMA foreign_key_check" implementation. (user: dan, tags: trunk)
18:06 • Edit [690870bd7b2e607b|690870bd]: Edit check-in comment. (user: dan)
18:02
[690870bd] Fix a problem in "PRAGMA foreign_key_check" in handling a WITHOUT ROWID child table with an INTEGER PRIMARY KEY parent key. Also, if an FK violation is detected in a WITHOUT ROWID child table, do not try to read and return the rowid. The second column returned by "PRAGMA foreign_key_check" in this case (WITHOUT ROWID child table) is now always set to NULL. (user: dan, tags: trunk)
17:03
[159e8022] Add support for analyzing trigger programs to the sqlite3_expert code. (user: dan, tags: schemalint)
16:07
[352413ee] Further improvements to test coverage in fts3. (user: dan, tags: trunk)
13:38
[1a08a836] Improve coverage of code in fts3. (user: dan, tags: trunk)
13:18
[f508aff8] Fix the ".column" output mode in the command-line shell so that it correctly counts and formats multi-byte UTF characters. (user: drh, tags: trunk)
2017-04-16
22:41
[90015df3] In the showwal command-line tool, for unix builds, if the auxiliary argument is of the form "Ntruncate" where "N" is a frame number, then truncate the WAL file after the N-th frame. (user: drh, tags: trunk)
22:08
[d7b9813c] Add the anycollseq.c loadable extension in etc/misc (user: drh, tags: trunk)
2017-04-15
16:52
[2e630879] Fix problems with handling constraints on the rowid column in sqlite3expert.c. (user: dan, tags: schemalint)
15:47
[2d0c458e] Merge latest trunk changes into this branch. (user: dan, tags: schemalint)
14:30
[d238694c] Add header comment for sqlite3_vtab_collation(). (user: dan, tags: schemalint)
14:16
[0cd75a87] Fix memory leaks in the code on this branch. Make use of the sqlite3_index_constraint.usage field. Do not try to handle ORDER BY terms with explicit COLLATE clauses - they don't get passed to the vtab layer anyway. (user: dan, tags: schemalint)
11:53
[89f9e436] In the skip-ahead-distinct optimization, fix a bug in the logic that determines when to invoke the optimization based on sqlite_stat1 statistics. (user: drh, tags: trunk)
2017-04-14
22:41
[e50fd489] Closed-Leaf: Fix to the decision logic for when to use the skip-ahead-distinct optimization. (user: drh, tags: skip-ahead-distinct)
22:40 • Edit [1aa0ea8db7580aff|1aa0ea8d]: Remove the "Closed" mark. (user: drh)
21:44 • Edit [a53799059d4ece24|a5379905]: Edit check-in comment. (user: drh)
19:46
[d78355c8] Remove end-of-line whitespace from lemon.c. (user: drh, tags: trunk)
19:44
[a5379905] Fix some left-over K&R-C constructs in lemon.c. No changes to the core. (user: drh, tags: trunk)
19:41
[3bb65850] Modify the code in ext/expert/ to use the vtab interface instead of sqlite3_whereinfo_hook(). Remove sqlite3_whereinfo_hook(). (user: dan, tags: schemalint)
19:03
[3a5860d8] Closed-Leaf: Add the TK_IF_NULL_ROW opcode to deal with non-NULL result columns in the result set of a view or subquery on the RHS of a LEFT JOIN that gets flattened. (user: drh, tags: left-join-view)