Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History for src/dbstat.c
2024-08-22
| ||
16:22 | [73362c0df0] part of check-in [6c00e88ebd] Add the SQLITE_INDEX_SCAN_HEX bit to the sqlite3_index_info.idxFlags bitmask. When set, this bit causes the EXPLAIN QUERY PLAN output to show the idxNum value in hex rather than in decimal. This is purely a debugging aid. (check-in: [6c00e88ebd] user: drh branch: trunk, size: 29423) | |
2023-10-06
| ||
12:51 | [3b677254d5] part of check-in [f3b3d712d6] Ensure that all fields of static sqlite3_module objects are explicitly initialized, in order to hush-up nuisance compiler warnings. (check-in: [f3b3d712d6] user: drh branch: trunk, size: 29376) | |
2022-12-23
| ||
14:49 | [ec92074baa] part of check-in [c14bbe1606] Fix lots of harmless, nuisance compiler warnings, mostly unused parameter warnings in extensions. (check-in: [c14bbe1606] user: drh branch: trunk, size: 29325) | |
2022-12-02
| ||
15:31 | [a56a7ad116] part of check-in [5652154a8c] Use sqlite3_result_int64() instead of sqlite3_result_int() when returning potentially large values from the DBSTAT virtual table, to avoid integer overflows in the result. Forum post ada2ab044f. (check-in: [5652154a8c] user: drh branch: trunk, size: 29268) | |
2022-07-22
| ||
20:24 | [6a78b43639] part of check-in [57beb700c0] Add experimental 'xShadowName2' method for virtual table modules. (check-in: [57beb700c0] user: mistachkin branch: xShadowName2, size: 29311) | |
2021-09-29
| ||
19:15 | [861e08690f] part of check-in [c4c705abc6] Have the dbstat module arrange things internally so that there are 256 addressable bytes following each page buffer. This way, small buffer overreads caused by corrupt database pages do not lead to undefined behaviour. (check-in: [c4c705abc6] user: dan branch: trunk, size: 29258) | |
2021-09-27
| ||
17:11 | [bea044cfe9] part of check-in [6ab25f8bd5] Have the dbstat virtual table take a copy of each page buffer that it traverses instead of just a reference to the page-cache object. This avoids problems if an error causes transaction rollback while a dbstat cursor is open. dbsqlfuzz crash-417224040fee04f0f0e62b70265c518893b08769. (check-in: [6ab25f8bd5] user: dan branch: trunk, size: 28768) | |
2021-09-25
| ||
18:21 | [14d9098266] part of check-in [e03554a6a8] Fix a bad interaction between the pager cache and the dbstat module that could lead to a malfunction following an OOM. dbsqlfuzz 9ed3e4e3816219d3509d711636c38542bf3f40b1. (check-in: [e03554a6a8] user: dan branch: trunk, size: 27876) | |
2020-06-19
| ||
13:33 | [3aa79fc3ae] part of check-in [9536fa0ae0] Further refactoring of the schema table name. (check-in: [9536fa0ae0] user: drh branch: trunk, size: 27580) | |
2020-03-20
| ||
20:54 | [793deaf88a] 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: 27580) | |
2020-03-19
| ||
17:27 | [33fc9838b5] part of check-in [1d64f4a8af] Fix an integer overflow problem with the dbstat virtual table that comes up when trying to analyze a corrupt database. (check-in: [1d64f4a8af] user: drh branch: trunk, size: 27530) | |
2020-01-07
| ||
19:45 | [0f55297469] part of check-in [4c21373c21] Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set the risk rank for many virtual tables. (check-in: [4c21373c21] user: drh branch: new-security-options, size: 27482) | |
2020-01-04
| ||
19:14 | [5125f559b3] part of check-in [5b246b47ae] Fix DBSTAT so that it returns no rows, rather than an error when the WHERE clause is "schema=NULL". (check-in: [5b246b47ae] user: drh branch: trunk, size: 27431) | |
18:38 | [bf7fbea4ed] part of check-in [cfff5cb227] Omit the omit flat from eq constraints on column "name" of dbstat virtual tables. Fix for [74a4c386]. (check-in: [cfff5cb227] user: dan branch: trunk, size: 27560) | |
14:00 | [427b13c258] part of check-in [74ef6f2b6d] Omit the omit flag from eq constraints on column "aggregate" of dbstat virtual tables. Fix for [727074e2]. (check-in: [74ef6f2b6d] user: dan branch: trunk, size: 27778) | |
2019-11-19
| ||
18:48 | [6c407e5494] part of check-in [16fef3db06] Get the aggregate=TRUE feature working on the DBSTAT virtual table. (check-in: [16fef3db06] user: drh branch: dbstat-enhancements, size: 27705) | |
14:01 | [191351e68a] part of check-in [9b5722f0fe] Begin an enhancement effort for the built-in DBSTAT virtual table. (check-in: [9b5722f0fe] user: drh branch: dbstat-enhancements, size: 26391) | |
2019-01-09
| ||
11:19 | [c12833de69] part of check-in [fc5ecc88f8] Improved database corruption detection in the dbstat virtual table. (check-in: [fc5ecc88f8] user: drh branch: trunk, size: 23460) | |
11:06 | [71f0bb9c38] part of check-in [9d4c156fa2] Small simplification to the dbstat virtual table. (check-in: [9d4c156fa2] user: drh branch: trunk, size: 23347) | |
2018-11-16
| ||
20:18 | [3c8bd4e77f] part of check-in [5cd24e552b] Add SQLITE_CONSTRAINT support to the xBestIndex methods on dbstat, sqlite_dbpage, and zipfile. (check-in: [5cd24e552b] user: drh branch: trunk, size: 23429) | |
2018-11-13
| ||
20:21 | [d54c2449d0] part of check-in [a62e6b593b] Fix a potential buffer overread in the dbstat virtual table when processing a corrupt database file. (check-in: [a62e6b593b] user: drh branch: trunk, size: 23478) | |
2018-11-05
| ||
23:01 | [9ad3f2d9d1] part of check-in [31942b3dd3] 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: [31942b3dd3] user: drh branch: read-only-shadow, size: 23418) | |
2018-10-29
| ||
18:33 | [e042b0e783] part of check-in [cb874fd873] Fix minor memory leak in the dbstat extension that can occur following an attempt to analyze a corrupt database file. (check-in: [cb874fd873] user: drh branch: trunk, size: 23366) | |
16:07 | [5f96184b8a] part of check-in [a0d47f25ae] Harden the dbstat extension against corrupt database files. (check-in: [a0d47f25ae] user: drh branch: trunk, size: 23264) | |
2018-03-29
| ||
13:47 | [edabb82611] part of check-in [1fc72b707d] Modify the sqlite3OsFileControl() interface to detect unopened sqlite3_file objects and return SQLITE_NOTFOUND. (check-in: [1fc72b707d] user: drh branch: trunk, size: 22840) | |
2017-07-12
| ||
18:05 | [7a4ba8518b] part of check-in [604c11d1a3] Fix harmless compiler warnings about incomplete structure initializers. (check-in: [604c11d1a3] user: drh branch: trunk, size: 22859) | |
2016-08-18
| ||
14:33 | [19ee7a4e89] part of check-in [92a22f0134] Rename the Db.zName field to Db.zDbSName to make it more descriptive and to distinguish it from all of the other "zName" variables scattered throughout the code. (check-in: [92a22f0134] user: drh branch: zDbSName, size: 22707) | |
2016-06-13
| ||
15:59 | [4f6f7f52b4] part of check-in [a1e1cdc51d] Fix the declaration of the table implemented by DBSTAT so that it uses correct datatypes. (check-in: [a1e1cdc51d] user: drh branch: trunk, size: 22701) | |
2016-02-13
| ||
23:43 | [c845548d43] part of check-in [6a9c4a3ebf] Enhance ability to debug out-of-memory errors. (check-in: [6a9c4a3ebf] user: mistachkin branch: noMemBkpt, size: 22701) | |
2016-01-22
| ||
17:48 | [b2ec6793ee] part of check-in [7323175337] Add the sqlite3TokenInit() utility function. (check-in: [7323175337] user: drh branch: trunk, size: 22651) | |
15:44 | [d33af6b426] part of check-in [e60461e984] Have the dbstat module dequote any argument passed to the CREATE VIRTUAL TABLE statement before attempting to match it against the names of attached databases. (check-in: [e60461e984] user: dan branch: trunk, size: 22735) | |
2015-11-04
| ||
20:22 | [ffd63fc8ba] part of check-in [708253be34] Rename the sqlite3PagerAcquire() function to sqlite3PagerGet(). The former macro called sqlite3PagerGet() has been removed. (check-in: [708253be34] user: drh branch: trunk, size: 22602) | |
2015-09-08
| ||
21:12 | [e637e7a7ff] part of check-in [6beb512c7a] Enhance the DBSTAT virtual table with a new hidden table "schema" that if set will cause the table to report on the specified schema rather than on "main". Also: Fix a faulty assert in sqlite3_context_db_handle(). (check-in: [6beb512c7a] user: drh branch: trunk, size: 22593) | |
2015-05-12
| ||
19:10 | [f402e77e25] part of check-in [c3cbe3b06e] Attempt to get DBSTAT to compile without warnings across all build configurations. (check-in: [c3cbe3b06e] user: drh branch: trunk, size: 20717) | |
14:22 | [d0b0757e49] part of check-in [aad3ff257a] Fix a compiler warning when building with tclsqlite3.c and without SQLITE_ENABLE_DBSTAT_VTAB. (check-in: [aad3ff257a] user: drh branch: trunk, size: 20717) | |
12:24 | [7fd79cb56f] part of check-in [07c7d3925c] Try to get recent sqlite3_analyzer and sqldiff tests working for all tested combinations of compile-time options, especially SQLITE_OMIT_VIRTUALTABLE and SQLITE_OMIT_LOAD_EXTENSION. (check-in: [07c7d3925c] user: drh branch: trunk, size: 20750) | |
2015-05-11
| ||
11:59 | [fa5b981f37] part of check-in [4e6520159e] Revamp the way the DBSTAT virtual table is registered. (check-in: [4e6520159e] user: drh branch: trunk, size: 20616) | |
2015-05-07
| ||
18:29 | [db36fbd268] part of check-in [d51ce53932] Testing improvements and corner-case bug fixes for the dbstat virtual table. (check-in: [d51ce53932] user: drh branch: trunk, size: 20618) | |
14:41 | [a9c0550fe9] part of check-in [25ec09400b] Enhance the dbstat virtual table with the ability to analyze ATTACHed databases. (check-in: [25ec09400b] user: drh branch: trunk, size: 20438) | |
2015-05-05
| ||
10:46 | [1eacd31021] part of check-in [d2cb1becc0] Spell SQLITE_OMIT_VIRTUALTABLE correctly in a #if in dbstat.c. (check-in: [d2cb1becc0] user: drh branch: trunk, size: 19929) | |
2015-05-04
| ||
18:31 | Renamed and modified src/test_stat.c → src/dbstat.c. [ae435cf8c8] part of check-in [a24480a474] Rename the test_stat.c source file to dbstat.c and rework the makefiles to make dbstat.c a first-class source module. (check-in: [a24480a474] user: drh branch: dbstat-in-amalgamation, size: 19930) | |