Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for ext/expert/expert1.test
2025-06-13
| ||
11:08 | [c700f0fac9] part of check-in [40a83da503] Further improvements to the EQP text for flex-search. (check-in: [40a83da503] user: drh branch: flex-search, size: 14922) | |
00:50 | [cb17a345a3] part of check-in [680e278c3e] Change the flex-search EQP message to be "SEARCH ... OR SCAN" as this seems less disruptive and more readable. (check-in: [680e278c3e] user: drh branch: flex-search, size: 14910) | |
00:25 | [b753c50cbb] part of check-in [c46feb36b5] Fix test cases on the expert extension. (check-in: [c46feb36b5] user: drh branch: flex-search, size: 14924) | |
2024-10-20
| ||
07:19 | [1d2da66066] part of check-in [7a7162293c] Fix another problem with ".expert" and virtual tables. Forum post 49d6a19ec. (check-in: [7a7162293c] user: dan branch: trunk, size: 14833) | |
2024-10-12
| ||
18:33 | [1fa0201d86] part of check-in [933dfd0618] Ensure that test file ext/expert/expert1.test works with non-fts5 builds. (check-in: [933dfd0618] user: dan branch: expert-vtab-fix, size: 13668) | |
18:00 | [e049c507d3] part of check-in [a201906cd3] Allow the ".expert" command to analyze statements that use built-in virtual tables. (check-in: [a201906cd3] user: dan branch: expert-vtab-fix, size: 13535) | |
2024-09-24
| ||
15:11 | [b10f9e20f6] part of check-in [42bb941584] Fix a memory leak in sqlite3expert.c introduced by [f1d76c86]. (check-in: [42bb941584] user: dan branch: trunk, size: 12176) | |
11:26 | [fd13123932] part of check-in [f1d76c8636] Avoid an error in sqlite3expert if the database has existing indexes on expressions. (check-in: [f1d76c8636] user: dan branch: trunk, size: 11881) | |
2024-08-08
| ||
15:26 | [661f873fd4] part of check-in [123b154ce3] Ensure sqlite3expert.c unregisters any SQL user-functions it registers with the database handle before returning. (check-in: [123b154ce3] user: dan branch: trunk, size: 11825) | |
2024-03-11
| ||
19:33 | [53a749de08] part of check-in [6eae4547d4] Update mdevtest and sdevtest to do shell builds in parallel. And only if one or more of the tcl scripts run requires it. (check-in: [6eae4547d4] user: dan branch: trunk, size: 11616) | |
2023-10-23
| ||
11:41 | [0dd5cb096d] part of check-in [a41b903d0f] Temporarily disable the ext/expert/expert1-6.0 test, which does not work on my configurations. (check-in: [a41b903d0f] user: drh branch: trunk, size: 11596) | |
2023-09-24
| ||
19:38 | [77eaa3efd9] part of check-in [0f6bbb79cb] Add minimal exercise of expert acceptance of UDFs and custom collations. (check-in: [0f6bbb79cb] user: larrybr branch: expert-udfs, size: 11587) | |
2022-08-10
| ||
15:29 | [95b00567ce] part of check-in [5e1b8221c3] Fix handling of columns with names that are SQL keywords in the ".expert" command. (check-in: [5e1b8221c3] user: dan branch: trunk, size: 11295) | |
2021-09-21
| ||
20:03 | [3c642a4e7b] part of check-in [4a3f98ad0d] Fix .expert name collision bug reported at https://sqlite.org/forum/forumpost/05e6f32984561f57?t=h (check-in: [4a3f98ad0d] user: larrybr branch: trunk, size: 11095) | |
2021-03-20
| ||
15:11 | [6703fd7471] part of check-in [50fbd53260] Revise tests cases to align with the new EXPLAIN QUERY PLAN output. (check-in: [50fbd53260] user: drh branch: eqp-improvements, size: 11095) | |
2020-12-11
| ||
14:22 | [63d778d964] part of check-in [c2ae7ba6f8] Fix the expert extension so that it handles generated columns correctly. (check-in: [c2ae7ba6f8] user: dan branch: trunk, size: 11288) | |
2020-09-17
| ||
17:01 | [dba6e752cc] part of check-in [c666c85a43] 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: [c666c85a43] user: dan branch: trunk, size: 10747) | |
2020-03-20
| ||
20:54 | [2e10ff875c] part of check-in [75c85ca32f] Allow "main" to be used to refer to the main database even after SQLITE_DBCONFIG_MAINDBNAME has been used to assign another alias. (check-in: [75c85ca32f] user: dan branch: main-alias-fix, size: 9458) | |
2019-08-21
| ||
17:46 | [e2afc53a27] part of check-in [73e30c2e92] Disable broken test case in expert1.test. (check-in: [73e30c2e92] user: dan branch: nulls-last, size: 9277) | |
2018-12-24
| ||
20:21 | [358e416877] part of check-in [7153552bac] 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: [7153552bac] user: drh branch: reuse-subqueries, size: 9268) | |
2018-06-13
| ||
16:08 | [333d037021] part of check-in [b90c3c16c0] Fix some test case numbers in expert1.test. (check-in: [b90c3c16c0] user: dan branch: trunk, size: 9240) | |
2018-05-29
| ||
14:29 | [baa05800dc] part of check-in [ce9b756f09] More minor changes to test scripts. (check-in: [ce9b756f09] user: dan branch: trunk, size: 9240) | |
2018-05-04
| ||
00:39 | [87e54effda] part of check-in [75ac7b4e4f] Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines associated with the OR-optimization. (check-in: [75ac7b4e4f] user: drh branch: trunk, size: 9257) | |
2018-05-02
| ||
19:42 | [81c8834822] part of check-in [dab5e52948] More test case updates. Tests are all running now. (check-in: [dab5e52948] user: drh branch: rework-EQP, size: 9236) | |
2018-04-24
| ||
16:51 | [00fb672567] part of check-in [8acb42f489] 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: [8acb42f489] user: drh branch: trunk, size: 9386) | |
2018-01-09
| ||
14:30 | [fd21496d8e] part of check-in [ba967ad2e3] Do not attempt to build the code in ext/expert/sqlite3expert.c if SQLITE_OMIT_VIRTUALTABLE is defined. (check-in: [ba967ad2e3] user: dan branch: trunk, size: 9364) | |
2017-12-21
| ||
02:17 | [0c71a3453c] part of check-in [0821bae7af] Add the experimental ".expert" command to the sqlite3.exe shell. (check-in: [0821bae7af] user: drh branch: trunk, size: 9292) | |
2017-12-19
| ||
18:56 | [939265e01b] part of check-in [ad38d2c4f0] Fix crash in sqlite3_vtab_collation() when called for an IS NOT NULL constraint. (check-in: [ad38d2c4f0] user: dan branch: trunk, size: 9033) | |
17:42 | [4ffbecb378] part of check-in [51068dbaea] Experimentally add the SQLite expert functionality to the shell tool. (check-in: [51068dbaea] user: dan branch: expert-in-shell, size: 9148) | |
2017-04-18
| ||
20:10 | [1033e43071] part of check-in [a157fcfde5] Have sqlite3_expert_analyze() populate the sqlite_stat1 table before running queries through the planner for the second time. (check-in: [a157fcfde5] user: dan branch: schemalint, size: 8889) | |
2017-04-17
| ||
17:03 | [6a50a1538d] part of check-in [159e8022a9] Add support for analyzing trigger programs to the sqlite3_expert code. (check-in: [159e8022a9] user: dan branch: schemalint, size: 6537) | |
2017-04-15
| ||
16:52 | [c08c95fd81] part of check-in [2e6308798a] Fix problems with handling constraints on the rowid column in sqlite3expert.c. (check-in: [2e6308798a] user: dan branch: schemalint, size: 6194) | |
2017-04-14
| ||
19:41 | [cd630eda18] part of check-in [3bb6585004] 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 branch: schemalint, size: 5667) | |
2017-04-11
| ||
17:43 | [cc33f9390f] part of check-in [0c45c5eb9f] 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 branch: schemalint, size: 5415) | |
2017-04-10
| ||
20:00 | [d4451ccdca] part of check-in [9318f1b9ed] Add ext/expert/README.md. (check-in: [9318f1b9ed] user: dan branch: schemalint, size: 5343) | |
16:13 | Renamed and modified test/expert1.test → ext/expert/expert1.test. [c1b1405f3a] part of check-in [5dd9831721] 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 branch: schemalint, size: 5279) | |