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

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

History for ext/expert/expert1.test

2020-09-17
17:01
[dba6e752] 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: 10747)
2020-03-20
20:54
[2e10ff87] part of check-in [75c85ca3] 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: [75c85ca3] user: dan branch: main-alias-fix, size: 9458)
2019-08-21
17:46
[e2afc53a] part of check-in [73e30c2e] Disable broken test case in expert1.test. (check-in: [73e30c2e] user: dan branch: nulls-last, size: 9277)
2018-12-24
20:21
[358e4168] part of check-in [7153552b] 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 branch: reuse-subqueries, size: 9268)
2018-06-13
16:08
[333d0370] part of check-in [b90c3c16] Fix some test case numbers in expert1.test. (check-in: [b90c3c16] user: dan branch: trunk, size: 9240)
2018-05-29
14:29
[baa05800] part of check-in [ce9b756f] More minor changes to test scripts. (check-in: [ce9b756f] user: dan branch: trunk, size: 9240)
2018-05-04
00:39
[87e54eff] part of check-in [75ac7b4e] Make a separate limb in the EXPLAIN QUERY PLAN output for the various lines associated with the OR-optimization. (check-in: [75ac7b4e] user: drh branch: trunk, size: 9257)
2018-05-02
19:42
[81c88348] part of check-in [dab5e529] More test case updates. Tests are all running now. (check-in: [dab5e529] user: drh branch: rework-EQP, size: 9236)
2018-04-24
16:51
[00fb6725] part of check-in [8acb42f4] 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 branch: trunk, size: 9386)
2018-01-09
14:30
[fd21496d] 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: 9364)
2017-12-21
02:17
[0c71a345] part of check-in [0821bae7] Add the experimental ".expert" command to the sqlite3.exe shell. (check-in: [0821bae7] user: drh branch: trunk, size: 9292)
2017-12-19
18:56
[939265e0] part of check-in [ad38d2c4] Fix crash in sqlite3_vtab_collation() when called for an IS NOT NULL constraint. (check-in: [ad38d2c4] user: dan branch: trunk, size: 9033)
17:42
[4ffbecb3] part of check-in [51068dba] Experimentally add the SQLite expert functionality to the shell tool. (check-in: [51068dba] user: dan branch: expert-in-shell, size: 9148)
2017-04-18
20:10
[1033e430] 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: 8889)
2017-04-17
17:03
[6a50a153] part of check-in [159e8022] Add support for analyzing trigger programs to the sqlite3_expert code. (check-in: [159e8022] user: dan branch: schemalint, size: 6537)
2017-04-15
16:52
[c08c95fd] 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: 6194)
2017-04-14
19:41
[cd630eda] 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: 5667)
2017-04-11
17:43
[cc33f939] 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: 5415)
2017-04-10
20:00
[d4451ccd] part of check-in [9318f1b9] Add ext/expert/README.md. (check-in: [9318f1b9] user: dan branch: schemalint, size: 5343)
16:13
Renamed test/expert1.test → ext/expert/expert1.test. [c1b1405f] 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: 5279)