SQLite

All files named ”ext/expert/expert1.test”
Login

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)