Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
91 check-ins related to "schemalint"
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: 4c782c95 user: dan tags: trunk) | |
19:16 | Merge latest trunk changes into this branch. (Closed-Leaf check-in: d5b597b5 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: 64487d65 user: drh tags: trunk) | |
2017-11-29
| ||
16:16 | Merge latest trunk changes into this branch. (check-in: 373fa21b user: dan tags: schemalint) | |
2017-11-28
| ||
20:43 | Fix an assertion fault found by OSSFuzz. (check-in: 75d69987 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: e38571d5 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: 4c68ad7d 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: 4ec63ef2 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: d1ef9eab user: dan tags: withdrawn) | |
14:13 | Update this branch to match latest trunk. (check-in: d325da6c 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: 36acc0a9 user: drh tags: trunk) | |
2017-10-11
| ||
20:26 | Merge latest trunk changes with this branch. (check-in: 2719cf5c user: dan tags: schemalint) | |
20:10 | Change some internal details to bring this branch closer to the code on trunk. (check-in: 58e42cfd 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: 0245adff user: drh tags: trunk) | |
2017-05-15
| ||
17:56 | Merge changes from trunk. (check-in: 6e0f64ab user: drh tags: schemalint) | |
15:12 | Fix the build so that it works again with SQLITE_OMIT_SUBQUERY. (check-in: bb0d9281 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: 269bf52e user: dan tags: schemalint) | |
2017-05-03
| ||
13:05 | Fix a harmless compiler warning on Windows. (check-in: 593e5dd0 user: drh tags: schemalint) | |
12:50 | Get sqlite3_expert building on Windows. (check-in: d8254047 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: da15752d 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: af7d1596 user: drh tags: schemalint) | |
19:45 | Merge the latest enhancements from trunk. (check-in: a7dcf6a7 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: 430f539c user: drh tags: trunk) | |
2017-05-01
| ||
14:25 | Update this branch with latest trunk changes. (check-in: 11f4761c user: dan tags: schemalint) | |
2017-04-29
| ||
19:29 | Add a single testcase() macro to the subquery processing logic. (check-in: 4e1df76e user: drh tags: trunk) | |
2017-04-21
| ||
19:58 | Another minor formatting fix. (check-in: 9fa2ce3c user: dan tags: schemalint) | |
19:56 | Fix formatting errors in the previous commit. (check-in: da9a2e5a user: dan tags: schemalint) | |
19:53 | Update the README.md file in the ext/expert/ directory. (check-in: 3b2ff4e0 user: dan tags: schemalint) | |
2017-04-20
| ||
17:35 | Merge latest trunk changes into this branch. (check-in: b1533bc4 user: dan tags: schemalint) | |
17:03 | Avoid creating a temp table in the user database in the sqlite3_expert code. (check-in: 4e366996 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: 8e57c313 user: dan tags: schemalint-failure) | |
16:18 | Avoid adding INTEGER PRIMARY KEY columns to candidate indexes. (check-in: 4577fea5 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: c62e3582 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: c69c3e21 user: dan tags: schemalint) | |
2017-04-19
| ||
13:25 | Further improvements to coverage of fts3 module. (check-in: 6b21d0fd 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: a157fcfd user: dan tags: schemalint) | |
09:04 | Fix sqlite3_expert handling of triggers on views. (check-in: ff4976da user: dan tags: schemalint) | |
2017-04-17
| ||
17:03 | Add support for analyzing trigger programs to the sqlite3_expert code. (check-in: 159e8022 user: dan tags: schemalint) | |
2017-04-15
| ||
16:52 | Fix problems with handling constraints on the rowid column in sqlite3expert.c. (check-in: 2e630879 user: dan tags: schemalint) | |
15:47 | Merge latest trunk changes into this branch. (check-in: 2d0c458e user: dan tags: schemalint) | |
14:30 | Add header comment for sqlite3_vtab_collation(). (check-in: d238694c 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: 0cd75a87 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: 89f9e436 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: 3bb65850 user: dan tags: schemalint) | |
2017-04-13
| ||
16:19 | Update this branch with latest changes from trunk. (check-in: 5fcd840c 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: 59c70108 user: dan tags: trunk) | |
2017-04-11
| ||
19:00 | Update this branch with latest trunk changes. (check-in: 0f66a093 user: dan tags: schemalint) | |
18:29 | Fix a formatting issue in the output of the sqlite3_expert program. (check-in: cc8c3581 user: dan tags: schemalint) | |
18:06 | Smaller and faster implementation of exprMightBeIndexed(). (check-in: 76cd611d 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: 0c45c5eb user: dan tags: schemalint) | |
2017-04-10
| ||
20:00 | Add ext/expert/README.md. (check-in: 9318f1b9 user: dan tags: schemalint) | |
16:13 | Changes to allow the code in sqlite3expert.c to be tested directly (via the API in sqlite3expert.h) instead of by invoking the sqlite3_expert application. Fix memory leaks and other problems. (check-in: 5dd98317 user: dan tags: schemalint) | |
2017-04-09
| ||
08:38 | Fix the -file option on the sqlite3_expert program. (check-in: 0857c48e user: dan tags: schemalint) | |
2017-04-08
| ||
19:00 | Merge latest trunk with this branch. (check-in: e051e8f2 user: dan tags: schemalint) | |
18:56 | Rename shell6.test to expert1.test. Have it invoke the sqlite3_expert binary if it is present. (check-in: be0deff9 user: dan tags: schemalint) | |
18:18 | Disallow leading zeros on numeric constants in JSON. Fix for ticket [b93be8729a895a528e2] (check-in: 204e72f0 user: drh tags: trunk) | |
17:41 | Use hash tables instead of in-memory database tables for a few purposes in sqlite3expert.c. (check-in: bf10e68d user: dan tags: schemalint) | |
2017-04-07
| ||
20:14 | Refactor code to suggest indexes from the shell tool into an extension in ext/expert. Unfinished. (check-in: 305e19f9 user: dan tags: schemalint) | |
2017-04-06
| ||
18:44 | Changes to allow indexes to be recommended for queries on SQL views. (check-in: 0884ff1d user: dan tags: schemalint) | |
2017-04-04
| ||
17:50 | Add some support for OR terms to sqlite3_whereinfo_hook(). (check-in: 5cd07000 user: dan tags: schemalint) | |
04:23 | Add the sqlite3_whereinfo_hook() API - an experimental API replacing the DBCONFIG_WHEREINFO hack on this branch. (check-in: a54aef35 user: dan tags: schemalint) | |
2017-03-31
| ||
11:20 | Merge latest trunk into this branch. (check-in: cb721d0b user: dan tags: schemalint) | |
08:00 | Update shell6.test to account for the fact that tests are now run in a separate directory. (check-in: 1e3622de user: dan tags: schemalint) | |
2017-03-30
| ||
17:13 | Declare the Lemon-generated parser object as itself. (Duh) (check-in: c8000e94 user: drh tags: trunk) | |
2016-03-15
| ||
09:42 | Update this branch with latest trunk changes. (check-in: 249cd361 user: dan tags: schemalint) | |
2016-03-14
| ||
21:26 | Fix the permutations.test script so that it works again. (check-in: 9f194f90 user: drh tags: trunk) | |
2016-03-09
| ||
08:08 | Merge latest trunk changes with this branch. (check-in: 59caca43 user: dan tags: schemalint) | |
08:07 | Fix a problem in the schemalint code that comes up when a sub-query uses one or more of the same tables as its parent. (check-in: fc18cc92 user: dan tags: schemalint) | |
04:17 | Simplifications to the memjournal.c logic to facilitate testing. (check-in: 8baa2c2c user: drh tags: trunk) | |
2016-02-22
| ||
19:51 | Add test script shell6.test, containing tests for schemalint. (check-in: 0b734065 user: dan tags: schemalint) | |
2016-02-19
| ||
07:53 | Fix a couple of bugs in the schemalint code. (check-in: 02fbf699 user: dan tags: schemalint) | |
2016-02-18
| ||
19:10 | Have the schemalint output distinguish between existing and recommended indexes. (check-in: 4ab3df25 user: dan tags: schemalint) | |
2016-02-17
| ||
20:06 | Schemalint changes: Avoid creating candidate indexes if a compatible index exists. Do not quote identifiers that do not require it. (check-in: cf0f7eeb user: dan tags: schemalint) | |
2016-02-16
| ||
18:37 | Fix further issues in schemalint. (check-in: 73a7f010 user: dan tags: schemalint) | |
2016-02-15
| ||
20:12 | Progress towards integrating schemalint into the shell tool. Some cases work now. (check-in: 58d4cf26 user: dan tags: schemalint) | |
2016-02-11
| ||
21:01 | Experimental integration of schemalint functionality with the shell tool. Does not work yet. (check-in: ed49f297 user: dan tags: schemalint) | |
2016-02-09
| ||
15:10 | Merge latest trunk changes with this branch. (check-in: 1a4182ee user: dan tags: schemalint) | |
02:12 | Make sure every co-routines has its own set of temporary registers and does not share temporaries, since a co-routine might expect the content of a temporary register to be preserved across an OP_Yield. Proposed fix for ticket [d06a25c84454a]. (check-in: ca72be86 user: drh tags: trunk) | |
2016-01-22
| ||
14:46 | Merge latest trunk changes into this branch. (check-in: 9341491c user: dan tags: schemalint) | |
14:44 | Fix handling of transitive constraints in schemalint.tcl. (check-in: 44edc1aa user: dan tags: schemalint) | |
14:32 | Update the schemalint.tcl script so that the argument to a -select option may be either an SQL statement or the name of a file containing an SQL statement (check-in: d4e37767 user: dan tags: schemalint) | |
04:22 | Enable FTS4 when building the shell with the MSVC makefile. (check-in: e4c07df5 user: mistachkin tags: trunk) | |
2015-11-30
| ||
19:16 | Add a rule to main.mk to build the schemalint.tcl script into an executable. Similar to the way the sqlite3_analyzer executable is built. (check-in: b8251065 user: dan tags: schemalint) | |
18:17 | Fix the schemalint.tcl script to handle identifiers that require quoting. (check-in: 451e0faf user: dan tags: schemalint) | |
2015-11-23
| ||
18:28 | In the CREATE INDEX statements output by schemalint.tcl, avoid declaring an explicit collation sequence that is the same as the column's default. (check-in: d3aa067c user: dan tags: schemalint) | |
17:14 | Merge latest trunk changes with this branch. (check-in: 8f1ef090 user: dan tags: schemalint) | |
17:10 | Fix ORDER BY handling in the schemalint.tcl script. Add internal self-tests to the same script. (check-in: b8f277c9 user: dan tags: schemalint) | |
2015-11-21
| ||
19:43 | Fix an obscure memory leak found by libfuzzer that may occur under some circumstances if expanding a "*" expression causes a SELECT to return more than 32767 columns. (check-in: 60de5f23 user: dan tags: trunk) | |
2015-11-20
| ||
20:55 | Add support for ORDER BY clauses to schemalint.tcl. (check-in: 93bdf70e user: dan tags: schemalint) | |
2015-11-11
| ||
18:08 | Add a hack to debug out a description of the WHERE clause of a SELECT (or other) statement. Use this in script tool/schemalint.tcl to automatically recommend indexes that might speed up specific queries. (check-in: c6fa01c2 user: dan tags: schemalint) | |
15:28 | Improvements to the SQLITE_CONFIG_PAGECACHE documentation. Enhance the command-line shell to be able to take advantage of the full range of SQLITE_CONFIG_PAGECACHE capabilities, such as setting pMem==NULL and N<0. (check-in: 2518d5c9 user: drh tags: trunk) | |