Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
50 descendants of 0857c48e02a76490
|
2017-12-21
| ||
| 21:02 | Add the ".eqp trigger" option to the ".eqp" command in the command-line shell. Implemented using the new SQLITE_DBCONFIG_TRIGGER_EQP control. (check-in: 2c51644a12 user: drh tags: trunk) | |
| 18:55 | Add the ".expert" command to the shell tool's ".help" output. (check-in: fc6193af5d user: dan tags: trunk) | |
| 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. (check-in: fffc7685d1 user: drh tags: trunk) | |
| 14:46 | Add the SQLITE_DBCONFIG_MAX preprocessor macro which will always be equal to the largest SQLITE_DECONFIG value. (check-in: 95d4103348 user: drh tags: trunk) | |
| 02:17 | Add the experimental ".expert" command to the sqlite3.exe shell. (check-in: 0821bae7af user: drh tags: trunk) | |
|
2017-12-20
| ||
| 23:46 | Lowercase local variable names in the SHA3 extension in order to avoid collisions with macros in termios.h. (check-in: 3ec7371161 user: drh tags: trunk) | |
|
2017-12-19
| ||
| 18:56 | Fix crash in sqlite3_vtab_collation() when called for an IS NOT NULL constraint. (check-in: ad38d2c4f0 user: dan tags: trunk) | |
| 17:42 | Experimentally add the SQLite expert functionality to the shell tool. (Closed-Leaf check-in: 51068dbaea user: dan tags: expert-in-shell) | |
|
2017-12-16
| ||
| 20:20 | Add an experimental location(X) SQL function that attempt to return the location of the payload within the database for the record that contains column X. location(X) returns NULL if X is not an ordinary table column or if SQLite cannot figure out the location because it is using a covering index. (check-in: 51be955816 user: drh tags: location-function) | |
| 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) | |
|
2017-11-29
| ||
| 16:16 | Merge latest trunk changes into this branch. (check-in: 373fa21bff user: dan tags: schemalint) | |
|
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) | |
|
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) | |
|
2017-05-15
| ||
| 17:56 | Merge changes from trunk. (check-in: 6e0f64ab5e user: drh tags: schemalint) | |
|
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) | |
|
2017-05-01
| ||
| 14:25 | Update this branch with latest trunk changes. (check-in: 11f4761c3a user: dan tags: schemalint) | |
|
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-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) | |
|
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) | |
|
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) | |
| 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) | |
|
2017-04-10
| ||
| 20:00 | Add ext/expert/README.md. (check-in: 9318f1b9ed 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: 5dd9831721 user: dan tags: schemalint) | |
|
2017-04-09
| ||
| 08:38 | Fix the -file option on the sqlite3_expert program. (check-in: 0857c48e02 user: dan tags: schemalint) | |