aboutsummaryrefslogtreecommitdiff
path: root/ext/expert/sqlite3expert.c
Commit message (Collapse)AuthorAge
* Fix handling of columns with names that are SQL keywords in the ".expert" ↵dan2022-08-10
| | | | | command. FossilOrigin-Name: 5e1b8221c385deb04a3ff5aafb2e9fc55aecc6ffc68328674e3afe56c4273e29
* Improved robustness against OOM in the expert extension.drh2021-12-16
| | | FossilOrigin-Name: e732c429bafeffaf7e0f458213089c073c262a39eabb41b291e5006078ca7f98
* Add the "static" qualifier to some internal functions in code for various ↵dan2021-12-01
| | | | | SQLite extensions. FossilOrigin-Name: 8c986782547211098eb0e4e722eda0097421223af279381373d0055211b5e9d2
* Fix harmless static analyzer warnings in sessions, rtree, fts3 and fts5.drh2021-10-04
| | | | | | Add the -DSQLITE_OMIT_AUXILIARY_SAFETY_CHECKS compile-time option to cause ALWAYS() and NEVER() macros to be omitted from the build. FossilOrigin-Name: 1c67f957fc77e37ce8f0d447c41ca975e8e79a35d332739c24a633649b5b0387
* Fix harmless compiler warnings.drh2021-09-22
| | | FossilOrigin-Name: d678ecca02698753d1b33e072566112e94ea36d0d3a8f4a24d2b09d131968d88
* Fix harmless compiler warnings in shell.c.in, and a compiler warning indrh2021-09-22
| | | | | sqlite3expert.c which is a real error, though also harmless. FossilOrigin-Name: 56da0e9c0321d1fd3c360722cd6284296f9ba459f6b37ab35c81ecabd18f12e3
* Fix .expert name collision bug reported at ↵larrybr2021-09-21
| | | | | https://sqlite.org/forum/forumpost/05e6f32984561f57?t=h FossilOrigin-Name: 4a3f98ad0dd2a8c0370042611a041bed2bd8d9ca82d6706e2db349eb97aaf1f0
* Fix an issue with the SQLite Expert extension when a column has nodrh2021-07-08
| | | | | | collating sequence. [forum:/forumpost/78165fa250|Forum post 78165fa250]. FossilOrigin-Name: b1e0c22ec981cf5f8a6597abc6711b1a25019dd51de31129fbc504d3dc743bb4
* Fix the expert extension so that it handles generated columns correctly.dan2020-12-11
| | | FossilOrigin-Name: c2ae7ba6f8f4b10bd734051a0cfa8ed9675bd58c82ede4e9eadfd7cbcc03b82d
* Prevent potential segfault in the sqlite-expert idxPopulateStat1 context ↵mistachkin2020-12-02
| | | | | cleanup code. FossilOrigin-Name: c24f13448b5a55f45b4d4786a878fa73fe3395b5724f3bc2eea22e5e2b074353
* Fix a problem in sqlite-expert causing it to ignore equality constraints on ↵dan2020-09-17
| | | | | the second or subsequent columns of a multi-column PRIMARY KEY. FossilOrigin-Name: c666c85a433fbc83edef4dbfb0399672e570f5d7979ab61cb39ff5488595d822
* Extend the refactoring into extensions. Clean up stray newlines.drh2020-06-19
| | | FossilOrigin-Name: 7a876209a678a34c198b54ceef9e3c041f128a14dc73357f6a57cadadaa6cf7b
* Avoid another potential OOB read in sqlite3expert.c.dan2020-05-21
| | | FossilOrigin-Name: 0ccea80092f16e7f17f4c4de4f8be3fdef217199fcc08ace37e179c1b22c1294
* Update code in sqlite3expert.c to account for the fact that "-- TRIGGER xyz" ↵dan2020-05-15
| | | | | VM comments are now omitted for some builds. FossilOrigin-Name: 7cf93dc55c48c68731a1fe3ae3517fcfeb5c252bfa87e715a333c6194bcc0ace
* Fix another build problem for SQLITE_OMIT_VIRTUALTABLE builds.dan2020-05-15
| | | FossilOrigin-Name: 5e1eb0fa3afd74251bc8f484e3edfa81b15610479431af205bd952c91eecd21f
* Initial code to make shadow tables read-only to ordinary SQL. The nowdrh2018-11-05
| | | | | | | | 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. FossilOrigin-Name: 31942b3dd3f66eb0d9977bf1cadc2f2d7be7967cce2b55784be0b939dfef1985
* More minor changes to test scripts.dan2018-05-29
| | | FossilOrigin-Name: ce9b756f09df4feb485bbf9695f8c6774906eb1b2fb45a340b74ffd21c9adfd8
* More test case updates. Tests are all running now.drh2018-05-02
| | | FossilOrigin-Name: dab5e5294813891469660cceb211ac1a1e526715bb57dcdbb1ab90321e6a4dad
* Fix harmless compiler warnings, mostly unused parameters for UDFs in the CLI.drh2018-01-17
| | | FossilOrigin-Name: bfbeffab7735461acb3773242ba31dae15af9f8b0291c54a6734747bb1b36e66
* Fix a potential crash in sqlite3expert.c caused by a missing sqlite3_reset()dan2018-01-09
| | | | | call. FossilOrigin-Name: f6355970f04a3c4d85801c806366788139d8d5ad29383ec7faa81e2176ffe987
* Do not attempt to build the code in ext/expert/sqlite3expert.c ifdan2018-01-09
| | | | | SQLITE_OMIT_VIRTUALTABLE is defined. FossilOrigin-Name: ba967ad2e38590fe2a51e814a087140089be5e6a06a795a958e70a8a47f6350f
* Fix problems in the sqlite3expert.c code revealed by -fsanitize.dan2018-01-08
| | | FossilOrigin-Name: 7a93dd784bfdbf01927979a61643796e0901d9ac285fe4214677838def93a9a4
* Modify the new sqlite3_vtab_collation() interface so that it takes adrh2017-12-22
| | | | | | | 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. FossilOrigin-Name: 5c1fe6666019147a26480b5db1bf2f474a5d072c234c736f16ed5d2a9a040b3f
* Change the name of SQLITE_DBCONFIG_FULL_EQP to be SQLITE_DBCONFIG_TRIGGER_EQPdrh2017-12-21
| | | | | | (which we can do without breaking compatibility because the former name has not yet appeared in an official release) and streamline its implementation. FossilOrigin-Name: fffc7685d19f78ec322a4e834ad727af20a17e2e1c35680e4b1c4162c4786f60
* Get sqlite3_expert building on Windows.drh2017-05-03
| | | FossilOrigin-Name: d8254047b30f7c1be486bf39d4420678604573b951b5cc83c19ebf74aba0864c
* In sqlite3expert.c, do not copy the schema for virtual tables. Updates todrh2017-05-03
| | | | | makefiles to make building easier. FossilOrigin-Name: da15752dccf6090e40ec825db89048eca2b30185882225bf81f1891e914c2e7f
* Merge latest trunk changes into this branch.dan2017-04-20
| | | FossilOrigin-Name: b1533bc455f52f570c0f4b8aaa0da802757dc89b0e45b9a9b31aa591a44bf7bd
* Speed this branch up a bit by filtering before the virtual table layer whendan2017-04-20
| | | | | sampling user data. FossilOrigin-Name: 8e57c31340dd9ffc457da63c5996fb1b573f8154f864ec2b52c15f399906ac8b
* Avoid creating a temp table in the user database in the sqlite3_expert code.dan2017-04-20
| | | | | Trouble is, this makes sampling for stat1 data much slower. FossilOrigin-Name: c62e358243d96cb38a7ce2aa679fc640b62bf46080eab4bd5fc2acf5997d6cd5
* Add an option to generate stat1 data based on a subset of the user databasedan2017-04-20
| | | | | table contents to sqlite3_expert. FossilOrigin-Name: c69c3e21db6e141f7e24226c6432f2ed31fe5f177bd23781915871f8600ee56a
* Have sqlite3_expert_analyze() populate the sqlite_stat1 table before runningdan2017-04-18
| | | | | queries through the planner for the second time. FossilOrigin-Name: a157fcfde5afc27ae38e7cf4669fcc8e60e23d9d301ffe2e541dd69f895b493b
* Fix sqlite3_expert handling of triggers on views.dan2017-04-18
| | | FossilOrigin-Name: ff4976da667872614331d88e68fb67d347874f164a1c7950dd738c7c2320b954
* Add support for analyzing trigger programs to the sqlite3_expert code.dan2017-04-17
| | | FossilOrigin-Name: 159e8022a9d6701532b8b60e0c41154bc434c1bbdb107c8c97a78fb1140fa745
* Fix problems with handling constraints on the rowid column in sqlite3expert.c.dan2017-04-15
| | | FossilOrigin-Name: 2e6308798ae2db30564deb35ba3896597448edabbcac6efc4ff084552e42de30
* Fix memory leaks in the code on this branch. Make use of thedan2017-04-15
| | | | | | 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. FossilOrigin-Name: 0cd75a872c89958a7f418720a0e8c6f638f8284c488f666015c19136feae6be8
* Modify the code in ext/expert/ to use the vtab interface instead ofdan2017-04-14
| | | | | sqlite3_whereinfo_hook(). Remove sqlite3_whereinfo_hook(). FossilOrigin-Name: 3bb6585004090dbf92dd5e9abdf0fd2c921e64b5b3121c4fb7446db764ab59e5
* Add header comments to the API functions in sqlite3expert.h. Include a list ofdan2017-04-11
| | | | | all candidate indexes in the report output by the sqlite3_expert program. FossilOrigin-Name: 0c45c5eb9f0f171b8d7c5f0d2973f9f59915467506cdff1450f3e4b2134a01ca
* Add ext/expert/README.md.dan2017-04-10
| | | FossilOrigin-Name: 9318f1b9ed2d8da3a82ea69179e2d56a99d326c7721642665f87f6a4534e7bf0
* Changes to allow the code in sqlite3expert.c to be tested directly (via thedan2017-04-10
| | | | | | API in sqlite3expert.h) instead of by invoking the sqlite3_expert application. Fix memory leaks and other problems. FossilOrigin-Name: 5dd9831721b70a89a26728adcd49c7f6103ef8266891a79c2db34d913702709e
* Rename shell6.test to expert1.test. Have it invoke the sqlite3_expert binarydan2017-04-08
| | | | | if it is present. FossilOrigin-Name: be0deff940bea4f653d644113f42529a32ff7039d1d168119233aaf000a22f40
* Use hash tables instead of in-memory database tables for a few purposes indan2017-04-08
| | | | | sqlite3expert.c. FossilOrigin-Name: bf10e68d9e4d5eae7ae6148a7ad64c9596f2ed8ccd36065adb09a1f9e7dae50b
* Refactor code to suggest indexes from the shell tool into an extension indan2017-04-07
ext/expert. Unfinished. FossilOrigin-Name: 305e19f976ca064638a294e0817bf547ea745e1eb74746c5855514e6ced9c5fa
generated by cgit v1.2.3 (git 2.25.1) at 2025-07-22 15:07:55 +0000