SQLite

All files named ”test/scanstatus.test”
Login

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

History for test/scanstatus.test

2023-03-03
21:17
[b249328caf] part of check-in [5a09191186] Make the SQLITE_DBCONFIG_STMT_SCANSTATUS option on by default in the CLI. (check-in: [5a09191186] user: dan branch: trunk, size: 11640)
2023-02-28
20:04
[2adde2d8fb] part of check-in [a63e4a150b] Change the name of SQLITE_DBCONFIG_STMT_SCANSTATS to SQLITE_DBCONFIG_STMT_SCANSTATUS. (check-in: [a63e4a150b] user: dan branch: trunk, size: 11596)
19:39
[177fe0fea6] part of check-in [0f5579bef2] Add an sqlite3_db_config() option - SQLITE_DBCONFIG_STMT_SCANSTATS - for enabling and disabling the collection of sqlite3_stmt_scanstats() statistics in SQLITE_ENABLE_STMT_SCANSTATUS builds. Collection of statistics is disabled by default. (check-in: [0f5579bef2] user: dan branch: trunk, size: 11593)
2023-02-06
11:02
[74391c2c09] part of check-in [c0fbc89ed2] Fix problems with test scripts preventing them from running with SQLITE_DEFAULT_MEMSTATUS=0 builds. Or builds without SQLITE_ENABLE_STAT4. (check-in: [c0fbc89ed2] user: dan branch: trunk, size: 11363)
2022-12-02
20:32
[7dbcfd6adc] part of check-in [5580083364] Enhance the sqlite3_stmt_scanstatus() API and add sqlite3_stmt_scanstatus_v2(). For creation of easier to read query performance reports. (check-in: [5580083364] user: dan branch: scanstatus_v2, size: 11271)
2021-03-23
15:39
[9a0ed37ab6] part of check-in [2eb28afd01] Tweaks to test/scanstatus.test to account for the new EQP format. (check-in: [2eb28afd01] user: drh branch: trunk, size: 11282)
2021-03-20
15:11
[049b870491] 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: 11300)
2019-02-26
19:16
[874e350117] part of check-in [29d02bf2fa] Reformat the white-space in a few test cases so that the tests work with Tcl 8.6.9. (check-in: [29d02bf2fa] user: dan branch: trunk, size: 11558)
2018-05-02
18:00
[d14842d0a2] part of check-in [5f0e803e33] Fix test cases so that they work with the new EXPLAIN QUERY PLAN output format. Only some of the cases have been fixed. This is an incremental check-in. (check-in: [5f0e803e33] user: drh branch: rework-EQP, size: 11559)
2017-10-13
15:56
[1ba0e2ee25] part of check-in [bf86478d9c] When compiling with SQLITE_TEST, extra options are available on the "DB version" command for controlling the internal state of the SqliteDb object, for testing purposes. (check-in: [bf86478d9c] user: drh branch: tclsqlite-cleanup, size: 11562)
2016-07-27
19:20
[030acbbdce] part of check-in [50f8ea37fb] Add test cases and fix a comment. (check-in: [50f8ea37fb] user: drh branch: improved-index-scan, size: 11550)
2014-11-22
18:50
[5253c219e3] part of check-in [221659945c] Deploy heuristics (well-commented) to better estimate how much unindexed terms in the WHERE clause filter the number of output rows from a single table. (check-in: [221659945c] user: drh branch: trunk, size: 11550)
2014-11-06
03:55
[a6dd739bc4] part of check-in [f968400066] Change the SQLITE_SCANSTAT_EST parameter so that it returns a double for the estimated number of output rows per loop, rather than a 64-bit integer. Revise the output format for the ".scanstats on" in the shell to make use of this new capability. (check-in: [f968400066] user: drh branch: scanstatus, size: 11550)
2014-11-03
15:33
[01afb2220f] part of check-in [a2303c7192] Add further tests. Fixes so that compilation without ENABLE_STMT_SCANSTATUS works. (check-in: [a2303c7192] user: dan branch: scanstatus, size: 11474)
11:25
[0c0baa647e] part of check-in [f5313e0c68] Remove unused variable from struct WhereInfo. Add some explanatory comments to new code. (check-in: [f5313e0c68] user: dan branch: scanstatus, size: 7579)
2014-11-01
20:38
[40c7712c8b] part of check-in [9ea37422a8] If SQLITE_ENABLE_STMT_SCANSTATUS is defined, record the number of times each VDBE opcode is executed. Derive the values returned by sqlite3_stmt_scanstatus() from these records on demand. (check-in: [9ea37422a8] user: dan branch: scanstatus, size: 6438)
18:08
[b4b1780bad] part of check-in [8d8cc9608d] Minor fixes and documentation improvements for sqlite3_stmt_scanstatus(). (check-in: [8d8cc9608d] user: dan branch: scanstatus, size: 5279)
2014-10-31
20:11
Added: [a62dad3311] part of check-in [6a9bab34ae] Add the experimental sqlite3_stmt_scanstatus() API. (check-in: [6a9bab34ae] user: dan branch: scanstatus, size: 1708)