Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of ext/expert/sqlite3expert.c
|
2018-11-05
| ||
| 23:01 | Initial code to make shadow tables read-only to ordinary SQL. The now xShadowName method is added to the sqlite3_module object and is used to identify potential shadow tables. The SQLITE_PREPARE_SHADOW argument to sqlite3_prepare_v3() is defined. It is designed to permit writing to shadow tables, but is currently an unused placeholder. file: [3da865f2] check-in: [31942b3d] user: drh branch: read-only-shadow, size: 54338 | |
|
2018-05-29
| ||
| 14:29 | More minor changes to test scripts. file: [89b7b59b] check-in: [ce9b756f] user: dan branch: trunk, size: 54286 | |
|
2018-05-02
| ||
| 19:42 | More test case updates. Tests are all running now. file: [95fdee74] check-in: [dab5e529] user: drh branch: rework-EQP, size: 54247 | |
|
2018-01-17
| ||
| 13:15 | Fix harmless compiler warnings, mostly unused parameters for UDFs in the CLI. file: [1dfa561e] check-in: [bfbeffab] user: drh branch: trunk, size: 54284 | |
|
2018-01-09
| ||
| 18:31 | Fix a potential crash in sqlite3expert.c caused by a missing sqlite3_reset() call. file: [55ea02e9] check-in: [f6355970] user: dan branch: trunk, size: 54111 | |
| 14:30 | Do not attempt to build the code in ext/expert/sqlite3expert.c if SQLITE_OMIT_VIRTUALTABLE is defined. file: [9f1b0a5e] check-in: [ba967ad2] user: dan branch: trunk, size: 54081 | |
|
2018-01-08
| ||
| 17:34 | Fix problems in the sqlite3expert.c code revealed by -fsanitize. file: [9d352d86] check-in: [7a93dd78] user: dan branch: trunk, size: 53999 | |
|
2017-12-22
| ||
| 00:52 | Modify the new sqlite3_vtab_collation() interface so that it takes a pointer to the sqlite3_index_info object passed into xBestIndex rather than an sqlite3 connection pointer, which the xBestIndex method might not have access to. file: [252f3129] check-in: [5c1fe666] user: drh branch: trunk, size: 53976 | |
|
2017-12-21
| ||
| 18:23 | Change the name of SQLITE_DBCONFIG_FULL_EQP to be SQLITE_DBCONFIG_TRIGGER_EQP (which we can do without breaking compatibility because the former name has not yet appeared in an official release) and streamline its implementation. file: [be6452d1] check-in: [fffc7685] user: drh branch: trunk, size: 54005 | |
|
2017-05-03
| ||
| 12:50 | Get sqlite3_expert building on Windows. file: [6ed4e84a] check-in: [d8254047] user: drh branch: schemalint, size: 54002 | |
| 12:15 | In sqlite3expert.c, do not copy the schema for virtual tables. Updates to makefiles to make building easier. file: [87bac32f] check-in: [da15752d] user: drh branch: schemalint, size: 53973 | |
|
2017-04-20
| ||
| 17:35 | Merge latest trunk changes into this branch. file: [4bc1820a] check-in: [b1533bc4] user: dan branch: schemalint, size: 54072 | |
| 16:43 | Speed this branch up a bit by filtering before the virtual table layer when sampling user data. file: [fde366d8] check-in: [8e57c313] user: dan branch: schemalint-failure, size: 53789 | |
| 16:18 | Avoid adding INTEGER PRIMARY KEY columns to candidate indexes. file: [403b261d] check-in: [4577fea5] user: dan branch: schemalint, size: 51377 | |
| 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. file: [68acd26b] check-in: [c62e3582] user: dan branch: schemalint-failure, size: 54451 | |
| 09:54 | Add an option to generate stat1 data based on a subset of the user database table contents to sqlite3_expert. file: [af3b336f] check-in: [c69c3e21] user: dan branch: schemalint, size: 51303 | |
|
2017-04-18
| ||
| 20:10 | Have sqlite3_expert_analyze() populate the sqlite_stat1 table before running queries through the planner for the second time. file: [713388c6] check-in: [a157fcfd] user: dan branch: schemalint, size: 48475 | |
| 09:04 | Fix sqlite3_expert handling of triggers on views. file: [8befe209] check-in: [ff4976da] user: dan branch: schemalint, size: 40602 | |
|
2017-04-17
| ||
| 17:03 | Add support for analyzing trigger programs to the sqlite3_expert code. file: [f9f41caf] check-in: [159e8022] user: dan branch: schemalint, size: 40286 | |
|
2017-04-15
| ||
| 16:52 | Fix problems with handling constraints on the rowid column in sqlite3expert.c. file: [d73a4813] check-in: [2e630879] user: dan branch: schemalint, size: 35563 | |
| 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. file: [d4a0a45b] check-in: [0cd75a87] user: dan branch: schemalint, size: 35495 | |
|
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(). file: [9473b011] check-in: [3bb65850] user: dan branch: schemalint, size: 37776 | |
|
2017-04-11
| ||
| 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. file: [2b22a5fb] check-in: [0c45c5eb] user: dan branch: schemalint, size: 31702 | |
|
2017-04-10
| ||
| 20:00 | Add ext/expert/README.md. file: [8bcb83b3] check-in: [9318f1b9] user: dan branch: schemalint, size: 31489 | |
| 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. file: [b87f13e9] check-in: [5dd98317] user: dan branch: schemalint, size: 29483 | |
|
2017-04-08
| ||
| 18:56 | Rename shell6.test to expert1.test. Have it invoke the sqlite3_expert binary if it is present. file: [864ebeba] check-in: [be0deff9] user: dan branch: schemalint, size: 29074 | |
| 17:41 | Use hash tables instead of in-memory database tables for a few purposes in sqlite3expert.c. file: [c0e3ee75] check-in: [bf10e68d] user: dan branch: schemalint, size: 29073 | |
|
2017-04-07
| ||
| 20:14 | Refactor code to suggest indexes from the shell tool into an extension in ext/expert. Unfinished. file: [75ee320c] check-in: [305e19f9] user: dan branch: schemalint, size: 31176 Added | |