/ Timeline
Login

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

98 check-ins that include changes to files matching 'ext/expert/*'

2019-09-16
12:35
Merge all recent trunk enhancements into the reuse-schema branch. Leaf check-in: 27eb2236 user: drh tags: reuse-schema
12:29
Bring the begin-concurrent-pnu-wal2 branch up to date with all the latest enhancements on trunk. Leaf check-in: 15593bf3 user: drh tags: begin-concurrent-pnu-wal2
12:23
Merge recent trunk enhancements into the wal2 branch. Leaf check-in: da8bc974 user: drh tags: wal2
12:17
Merge recent trunk enhancements into the begin-concurrent-pnu branch. Leaf check-in: 54930b7e user: drh tags: begin-concurrent-pnu
12:08
Merge recent trunk enhancements into the begin-concurrent branch. Leaf check-in: 93b9ef3f user: drh tags: begin-concurrent
12:02
Merge the latest changes from trunk into the apple-osx branch. Leaf check-in: a95191de user: drh tags: apple-osx
2019-08-27
19:59
Add support for "ORDER BY ... NULLS FIRST" and "ORDER BY ... NULLS LAST". Use this to fix ticket [f8a7060e]. check-in: 94085fb3 user: dan tags: trunk
2019-08-21
17:46
Disable broken test case in expert1.test. check-in: 73e30c2e user: dan tags: nulls-last
2019-03-08
15:30
Merge all the latest enhancements from trunk. check-in: 667cce3d user: drh tags: begin-concurrent-pnu
2019-02-05
19:51
Merge latest trunk into this branch. check-in: c089cc4f user: dan tags: reuse-schema
2019-01-17
15:47
Sync up with the latest enhancements on trunk. check-in: 475a179a user: drh tags: apple-osx
2019-01-02
19:46
Merge changes from begin-concurrent-wal2. Also modify the unix-excl shm-locks on this branch so that it is not an error to attempt to release an EXCLUSIVE lock that is not held. check-in: 86685679 user: dan tags: begin-concurrent-pnu-wal2
16:30
Merge latest wal2 changes into this branch. check-in: c31eeb3c user: dan tags: begin-concurrent-wal2
16:15
Merge latest trunk changes into this branch. check-in: 87ef68f9 user: dan tags: wal2
16:08
Merge latest trunk changes into this branch. check-in: 5bf212f1 user: dan tags: begin-concurrent
2018-12-31
20:39
Additional steps to help ensure that scalar subqueries are only evaluated once even if they are used in multiple places within the query. This fixes a performance regression reported on the mailing list and caused by check-in [531eca6104e41e43] which was a fix for ticket [787fa716be3a7f650c]. Think of this check-in as an improved fix for that ticket. check-in: e1303193 user: drh tags: trunk
2018-12-24
20:21
Improvements to EXPLAIN QUERY PLAN formatting. The MULTI-INDEX OR now shows a separate "INDEX" subtree for each index. SCALAR SUBQUERY entries provide a subquery number that is related back to the .selecttrace output. check-in: 7153552b user: drh tags: reuse-subqueries
2018-12-01
20:14
Sync this branch with the latest trunk. check-in: 7a44fa5a user: dan tags: wal2
2018-11-26
07:34
Merge latest begin-concurrent changes into this branch. check-in: 76608f75 user: dan tags: begin-concurrent-pnu
07:21
Merge latest trunk changes into this branch. check-in: 28a615a2 user: dan tags: begin-concurrent
2018-11-17
18:45
Merge latest trunk changes into this branch. check-in: 9fdd1868 user: dan tags: reuse-schema1
2018-11-10
20:07
Merge the read-only shadow table and defensive mode enhancments from trunk. check-in: 977fc44e user: drh tags: apple-osx
18:23
Add support for read-only shadow tables on virtual tables. Added the SQLITE_DEFAULT_DEFENSIVE compile-time option that can put SQLite in defensive mode by default. check-in: 9c685171 user: drh tags: trunk
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. check-in: 31942b3d user: drh tags: read-only-shadow
2018-10-09
22:50
Merge changes for the 3.25.0 release. check-in: ddf6a54e user: drh tags: apple-osx
2018-10-08
18:58
Merge latest trunk changes into this branch. check-in: 2ac72114 user: dan tags: reuse-schema
2018-08-23
14:54
Merge enhancements from trunk. check-in: c446c884 user: drh tags: rtree-geopoly
2018-07-10
15:48
Merge begin-concurrent changes into this branch. check-in: af17432e user: dan tags: begin-concurrent-pnu
15:45
Merge latest trunk changes into this branch. check-in: e9a3e864 user: dan tags: begin-concurrent
2018-06-14
14:30
Merge latest trunk changes into this branch. check-in: 5cf5f180 user: dan tags: exp-window-functions
2018-06-13
16:08
Fix some test case numbers in expert1.test. check-in: b90c3c16 user: dan tags: trunk
2018-06-06
17:12
Merge the 3.24.0 changes plus a few subsequent enhancements. check-in: be7004a9 user: drh tags: begin-concurrent-pnu
17:03
Merge changes from trunk, including all the 3.24.0 changes plus some later enhancements. check-in: d7299bfe user: drh tags: begin-concurrent
2018-06-04
14:10
Merge changes from trunk. check-in: 95fbac39 user: drh tags: apple-osx
08:28
Merge latest trunk changes into this branch. check-in: 83d6416a user: dan tags: exp-window-functions
2018-05-29
14:29
More minor changes to test scripts. check-in: ce9b756f user: dan tags: trunk
2018-05-15
11:55
Merge latest trunk changes into this branch. check-in: 72f39efa user: dan tags: begin-concurrent-pnu
11:45
Merge latest trunk changes with this branch. check-in: ae86cf60 user: dan tags: begin-concurrent
2018-05-04
19:33
Merge recent enhancements from trunk. check-in: e17bca2c user: drh tags: apple-osx
19:18
Merge enhancements from trunk. check-in: 9650f71b user: drh tags: cell-overwrite-prototype
00:39
Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines associated with the OR-optimization. check-in: 75ac7b4e user: drh tags: trunk
2018-05-03
19:56
Overhaul of EXPLAIN QUERY PLAN. The output is now in the form of a tree. More details of the query plan are shown, and what is shown is truer to what actually happens. check-in: ff01bbda user: drh tags: trunk
2018-05-02
19:42
More test case updates. Tests are all running now. check-in: dab5e529 user: drh tags: rework-EQP
2018-04-24
19:22
Update this branch with latest changes from trunk. check-in: 2d8d13e4 user: dan tags: begin-concurrent-pnu
19:21
Merge latest trunk changes into this branch. check-in: b27bd799 user: dan tags: begin-concurrent
16:51
Update the expert extension test cases to account for the fact that EXPLAIN QUERY PLAN now shows the start of each trigger in its output. check-in: 8acb42f4 user: drh tags: trunk
2018-03-28
15:41
Update this branch with latest trunk changes. check-in: df52e89f user: dan tags: server-process-edition
2018-03-20
14:00
Merge all recent trunk enchancements, and especially the autoincrement write reduction fix. check-in: 25790049 user: drh tags: begin-concurrent-pnu
13:52
Merge all recent enhancements from trunk. check-in: b0c2f760 user: drh tags: begin-concurrent
2018-03-14
17:17
Merge the latest enhancements from trunk. check-in: a658f80c user: drh tags: apple-osx
2018-03-07
15:19
Fix various compilation issues seen with MSVC. check-in: d6fa9389 user: mistachkin tags: trunk
14:42
Fix utility compilation issues with MSVC. check-in: 5bd5a798 user: mistachkin tags: msvcFixes
2018-03-02
18:26
Merge latest changes from begin-concurrent into this branch. check-in: 8ade94ba user: dan tags: begin-concurrent-pnu
17:40
Merge latest trunk changes into this branch. check-in: 36801eff user: dan tags: begin-concurrent
2018-01-24
15:02
Merge changes from trunk. check-in: 6ef3de81 user: drh tags: memdb
2018-01-22
19:04
Merge all version-3.22.0 changes. check-in: 27e20d69 user: drh tags: apple-osx
2018-01-17
13:15
Fix harmless compiler warnings, mostly unused parameters for UDFs in the CLI. check-in: bfbeffab user: drh tags: trunk
2018-01-15
21:59
Merge the enhancements associated with the first 3.22.0 beta. check-in: c9d2ec51 user: drh tags: apple-osx
2018-01-09
18:31
Fix a potential crash in sqlite3expert.c caused by a missing sqlite3_reset() call. check-in: f6355970 user: dan tags: trunk
14:30
Do not attempt to build the code in ext/expert/sqlite3expert.c if SQLITE_OMIT_VIRTUALTABLE is defined. check-in: ba967ad2 user: dan tags: trunk
2018-01-08
17:34
Fix problems in the sqlite3expert.c code revealed by -fsanitize. check-in: 7a93dd78 user: dan tags: trunk
2017-12-29
13:35
Merge recent enhancements from trunk. check-in: 6251e438 user: drh tags: location-function
2017-12-23
18:40
Merge recent enhancements from trunk. check-in: edceaccd user: drh tags: appendvfs
18:34
Merge enhancements from trunk. check-in: 150f07fe user: drh tags: sqlar-shell-support
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. check-in: 5c1fe666 user: drh tags: trunk
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. check-in: fffc7685 user: drh tags: trunk
02:17
Add the experimental ".expert" command to the sqlite3.exe shell. check-in: 0821bae7 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: ad38d2c4 user: dan tags: trunk
17:42
Experimentally add the SQLite expert functionality to the shell tool. Closed-Leaf check-in: 51068dba user: dan tags: expert-in-shell
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
2017-10-12
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
2017-05-03
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
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-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
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
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-11
18:29
Fix a formatting issue in the output of the sqlite3_expert program. check-in: cc8c3581 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: 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
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
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