/ File History
Login

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