/ History for ext/expert/sqlite3expert.c
Login

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

History for ext/expert/sqlite3expert.c

2020-09-17
17:01
[2778d9f0] part of check-in [c666c85a] Fix a problem in sqlite-expert causing it to ignore equality constraints on the second or subsequent columns of a multi-column PRIMARY KEY. (check-in: [c666c85a] user: dan branch: trunk, size: 54510)
2020-07-29
16:18
[121eb618] part of check-in [a80ae2c9] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c9] user: drh branch: typos, size: 54438)
2020-06-19
15:24
[b5eae758] part of check-in [7a876209] Extend the refactoring into extensions. Clean up stray newlines. (check-in: [7a876209] user: drh branch: trunk, size: 54438)
2020-05-21
19:13
[ac008c72] part of check-in [0ccea800] Avoid another potential OOB read in sqlite3expert.c. (check-in: [0ccea800] user: dan branch: trunk, size: 54438)
2020-05-15
18:48
[6e59d973] part of check-in [7cf93dc5] Update code in sqlite3expert.c to account for the fact that "-- TRIGGER xyz" VM comments are now omitted for some builds. (check-in: [7cf93dc5] user: dan branch: trunk, size: 54384)
16:19
[fbcf97d9] part of check-in [5e1eb0fa] Fix another build problem for SQLITE_OMIT_VIRTUALTABLE builds. (check-in: [5e1eb0fa] user: dan branch: trunk, size: 54337)
2018-11-05
23:01
[3da865f2] part of check-in [31942b3d] 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. (check-in: [31942b3d] user: drh branch: read-only-shadow, size: 54338)
2018-05-29
14:29
[89b7b59b] part of check-in [ce9b756f] More minor changes to test scripts. (check-in: [ce9b756f] user: dan branch: trunk, size: 54286)
2018-05-02
19:42
[95fdee74] part of check-in [dab5e529] More test case updates. Tests are all running now. (check-in: [dab5e529] user: drh branch: rework-EQP, size: 54247)
2018-01-17
13:15
[1dfa561e] part of check-in [bfbeffab] Fix harmless compiler warnings, mostly unused parameters for UDFs in the CLI. (check-in: [bfbeffab] user: drh branch: trunk, size: 54284)
2018-01-09
18:31
[55ea02e9] part of check-in [f6355970] Fix a potential crash in sqlite3expert.c caused by a missing sqlite3_reset() call. (check-in: [f6355970] user: dan branch: trunk, size: 54111)
14:30
[9f1b0a5e] part of check-in [ba967ad2] Do not attempt to build the code in ext/expert/sqlite3expert.c if SQLITE_OMIT_VIRTUALTABLE is defined. (check-in: [ba967ad2] user: dan branch: trunk, size: 54081)
2018-01-08
17:34
[9d352d86] part of check-in [7a93dd78] Fix problems in the sqlite3expert.c code revealed by -fsanitize. (check-in: [7a93dd78] user: dan branch: trunk, size: 53999)
2017-12-22
00:52
[252f3129] part of check-in [5c1fe666] 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. (check-in: [5c1fe666] user: drh branch: trunk, size: 53976)
2017-12-21
18:23
[be6452d1] part of check-in [fffc7685] 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. (check-in: [fffc7685] user: drh branch: trunk, size: 54005)
2017-05-03
12:50
[6ed4e84a] part of check-in [d8254047] Get sqlite3_expert building on Windows. (check-in: [d8254047] user: drh branch: schemalint, size: 54002)
12:15
[87bac32f] part of check-in [da15752d] In sqlite3expert.c, do not copy the schema for virtual tables. Updates to makefiles to make building easier. (check-in: [da15752d] user: drh branch: schemalint, size: 53973)
2017-04-20
17:35
[4bc1820a] part of check-in [b1533bc4] Merge latest trunk changes into this branch. (check-in: [b1533bc4] user: dan branch: schemalint, size: 54072)
16:43
[fde366d8] part of check-in [8e57c313] Speed this branch up a bit by filtering before the virtual table layer when sampling user data. (check-in: [8e57c313] user: dan branch: schemalint-failure, size: 53789)
16:18
[403b261d] part of check-in [4577fea5] Avoid adding INTEGER PRIMARY KEY columns to candidate indexes. (check-in: [4577fea5] user: dan branch: schemalint, size: 51377)
16:08
[68acd26b] part of check-in [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. (check-in: [c62e3582] user: dan branch: schemalint-failure, size: 54451)
09:54
[af3b336f] part of check-in [c69c3e21] 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 branch: schemalint, size: 51303)
2017-04-18
20:10
[713388c6] part of check-in [a157fcfd] Have sqlite3_expert_analyze() populate the sqlite_stat1 table before running queries through the planner for the second time. (check-in: [a157fcfd] user: dan branch: schemalint, size: 48475)
09:04
[8befe209] part of check-in [ff4976da] Fix sqlite3_expert handling of triggers on views. (check-in: [ff4976da] user: dan branch: schemalint, size: 40602)
2017-04-17
17:03
[f9f41caf] part of check-in [159e8022] Add support for analyzing trigger programs to the sqlite3_expert code. (check-in: [159e8022] user: dan branch: schemalint, size: 40286)
2017-04-15
16:52
[d73a4813] part of check-in [2e630879] Fix problems with handling constraints on the rowid column in sqlite3expert.c. (check-in: [2e630879] user: dan branch: schemalint, size: 35563)
14:16
[d4a0a45b] part of check-in [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. (check-in: [0cd75a87] user: dan branch: schemalint, size: 35495)
2017-04-14
19:41
[9473b011] part of check-in [3bb65850] 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 branch: schemalint, size: 37776)
2017-04-11
17:43
[2b22a5fb] part of check-in [0c45c5eb] 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 branch: schemalint, size: 31702)
2017-04-10
20:00
[8bcb83b3] part of check-in [9318f1b9] Add ext/expert/README.md. (check-in: [9318f1b9] user: dan branch: schemalint, size: 31489)
16:13
[b87f13e9] part of check-in [5dd98317] 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 branch: schemalint, size: 29483)
2017-04-08
18:56
[864ebeba] part of check-in [be0deff9] Rename shell6.test to expert1.test. Have it invoke the sqlite3_expert binary if it is present. (check-in: [be0deff9] user: dan branch: schemalint, size: 29074)
17:41
[c0e3ee75] part of check-in [bf10e68d] Use hash tables instead of in-memory database tables for a few purposes in sqlite3expert.c. (check-in: [bf10e68d] user: dan branch: schemalint, size: 29073)
2017-04-07
20:14
[75ee320c] part of check-in [305e19f9] Refactor code to suggest indexes from the shell tool into an extension in ext/expert. Unfinished. (check-in: [305e19f9] user: dan branch: schemalint, size: 31176) Added