/ Timeline
Login

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

2017-12-16
19:36
Add the sqlite3_vtab_collation() function, which allows an xBestIndex callback to determine the collation sequence that SQLite will use for a comparison. And the SQLITE_DBCONFIG_FULL_EQP configuration option, which enhances the output of "EXPLAIN QUERY PLAN" so that it includes statements run by triggers. And the code for the sqlite3_expert extension and command line application. check-in: 4c782c9502 user: dan tags: trunk
19:16
Merge latest trunk changes into this branch. Closed-Leaf check-in: d5b597b52a user: dan tags: schemalint
04:37
Add unnecessary initializations to some local variables in the rtree module to suppress false-positive compiler warnings coming out of MSVC. check-in: 64487d658c user: drh tags: trunk
2017-11-29
16:16
Merge latest trunk changes into this branch. check-in: 373fa21bff user: dan tags: schemalint
2017-11-28
20:43
Fix an assertion fault found by OSSFuzz. check-in: 75d699877f user: dan tags: trunk
2017-10-13
16:24
Fix main.mk to name the win32 executable "sqlite3_expert.exe", not "sqlite3_expert". check-in: e38571d518 user: dan tags: schemalint
14:20
Update main.mk to build the sqlite3_expert program with -DSQLITE_THREADSAFE=0 and -DSQLITE_OMIT_LOAD_EXTENSION. To minimize dependencies. check-in: 4c68ad7da4 user: dan tags: schemalint
2017-10-12
20:24
Fix the EXPLAIN processing so that it returns SQLITE_ERROR on an OOM, as it should. check-in: 4ec63ef233 user: drh tags: schemalint
15:28
Add the experimental "sqlite_expert" extension. Used to find index definitions that might help with specified SQL queries. (Later:) Parked on a dead-end branch due to an assertion fault in TH3. We will merge again after the bug is fixed. Closed-Leaf check-in: d1ef9eaba0 user: dan tags: withdrawn
14:13
Update this branch to match latest trunk. check-in: d325da6c50 user: dan tags: schemalint
13:47
The src/shell.c file is now generated from src/shell.c.in, so remove shell.c from version control and update the makefiles to build it automatically. check-in: 36acc0a97f user: drh tags: trunk
2017-10-11
20:26
Merge latest trunk changes with this branch. check-in: 2719cf5c5b user: dan tags: schemalint
20:10
Change some internal details to bring this branch closer to the code on trunk. check-in: 58e42cfd7d user: dan tags: schemalint
12:20
In the speed-check.sh test script, allow an additional test-name argument which becomes the comparison baseline, in place of "trunk". check-in: 0245adffc6 user: drh tags: trunk
2017-05-15
17:56
Merge changes from trunk. check-in: 6e0f64ab5e user: drh tags: schemalint
15:12
Fix the build so that it works again with SQLITE_OMIT_SUBQUERY. check-in: bb0d928158 user: drh tags: trunk
2017-05-04
14:02
Remove the tool/schemalint.tcl script. And related Makefile entries. It is superseded by sqlite3_expert. check-in: 269bf52e27 user: dan tags: schemalint
2017-05-03
13:05
Fix a harmless compiler warning on Windows. check-in: 593e5dd00c user: drh tags: schemalint
12:50
Get sqlite3_expert building on Windows. check-in: d8254047b3 user: drh tags: schemalint
12:15
In sqlite3expert.c, do not copy the schema for virtual tables. Updates to makefiles to make building easier. check-in: da15752dcc user: drh tags: schemalint
2017-05-02
20:42
In the sqlite3_expert command-line tool, allow two-dash options. Do not accept the database name if it begins with "-". check-in: af7d159604 user: drh tags: schemalint
19:45
Merge the latest enhancements from trunk. check-in: a7dcf6a79f user: drh tags: schemalint
18:00
Fix the fts3EvalAverageDocsize() routine so that it returns errors from sqlite3_reset() rather than always returning SQLITE_OK. check-in: 430f539cbb user: drh tags: trunk
2017-05-01
14:25
Update this branch with latest trunk changes. check-in: 11f4761c3a user: dan tags: schemalint
2017-04-29
19:29
Add a single testcase() macro to the subquery processing logic. check-in: 4e1df76e3d user: drh tags: trunk
2017-04-21
19:58
Another minor formatting fix. check-in: 9fa2ce3c2b user: dan tags: schemalint
19:56
Fix formatting errors in the previous commit. check-in: da9a2e5aa9 user: dan tags: schemalint
19:53
Update the README.md file in the ext/expert/ directory. check-in: 3b2ff4e069 user: dan tags: schemalint
2017-04-20
17:35
Merge latest trunk changes into this branch. check-in: b1533bc455 user: dan tags: schemalint
17:03
Avoid creating a temp table in the user database in the sqlite3_expert code. check-in: 4e36699643 user: dan tags: schemalint
16:43
Speed this branch up a bit by filtering before the virtual table layer when sampling user data. Closed-Leaf check-in: 8e57c31340 user: dan tags: schemalint-failure
16:18
Avoid adding INTEGER PRIMARY KEY columns to candidate indexes. check-in: 4577fea5cd user: dan tags: schemalint
16:08
Avoid creating a temp table in the user database in the sqlite3_expert code. Trouble is, this makes sampling for stat1 data much slower. check-in: c62e358243 user: dan tags: schemalint-failure
09:54
Add an option to generate stat1 data based on a subset of the user database table contents to sqlite3_expert. check-in: c69c3e21db user: dan tags: schemalint
2017-04-19
13:25
Further improvements to coverage of fts3 module. check-in: 6b21d0fdeb user: dan tags: trunk
2017-04-18
20:10
Have sqlite3_expert_analyze() populate the sqlite_stat1 table before running queries through the planner for the second time. check-in: a157fcfde5 user: dan tags: schemalint
09:04
Fix sqlite3_expert handling of triggers on views. check-in: ff4976da66 user: dan tags: schemalint
2017-04-17
17:03
Add support for analyzing trigger programs to the sqlite3_expert code. check-in: 159e8022a9 user: dan tags: schemalint
2017-04-15
16:52
Fix problems with handling constraints on the rowid column in sqlite3expert.c. check-in: 2e6308798a user: dan tags: schemalint
15:47
Merge latest trunk changes into this branch. check-in: 2d0c458e01 user: dan tags: schemalint
14:30
Add header comment for sqlite3_vtab_collation(). check-in: d238694ca4 user: dan tags: schemalint
14:16
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. check-in: 0cd75a872c user: dan tags: schemalint
11:53
In the skip-ahead-distinct optimization, fix a bug in the logic that determines when to invoke the optimization based on sqlite_stat1 statistics. check-in: 89f9e4363a user: drh tags: trunk
2017-04-14
19:41
Modify the code in ext/expert/ to use the vtab interface instead of sqlite3_whereinfo_hook(). Remove sqlite3_whereinfo_hook(). check-in: 3bb6585004 user: dan tags: schemalint
2017-04-13
16:19
Update this branch with latest changes from trunk. check-in: 5fcd840cf9 user: dan tags: schemalint
15:51
Reinstate the SQLITE_API qualifier on the sqlite3_delete_database() method in test_delete.c. Accidentally removed by the previous commit. check-in: 59c70108fd user: dan tags: trunk
2017-04-11
19:00
Update this branch with latest trunk changes. check-in: 0f66a09393 user: dan tags: schemalint
18:29
Fix a formatting issue in the output of the sqlite3_expert program. check-in: cc8c358106 user: dan tags: schemalint
18:06
Smaller and faster implementation of exprMightBeIndexed(). check-in: 76cd611d41 user: drh tags: trunk
17:43
Add header comments to the API functions in sqlite3expert.h. Include a list of all candidate indexes in the report output by the sqlite3_expert program. check-in: 0c45c5eb9f user: dan tags: schemalint