/ All files named "tool/mkpragmatab.tcl"
Login

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

History for tool/mkpragmatab.tcl

2020-08-11
14:55
[37381569] part of check-in [b1a77b7e] Merge all changes since the 3.32.0 release into the reuse-schema branch. (check-in: [b1a77b7e] user: drh branch: reuse-schema, size: 16597)
2020-07-30
19:37
[d189900f] part of check-in [2b3241cf] Merge latest trunk change into this branch. (check-in: [2b3241cf] user: dan branch: begin-concurrent-pnu, size: 16235)
2020-07-03
12:32
[ae5585ae] part of check-in [07f849de] Fix the pragma_foreign_key_check virtual table so that it accepts arguments. (check-in: [07f849de] user: drh branch: trunk, size: 16089)
2020-05-18
16:19
[b4074a10] part of check-in [c69f030b] Merge recent changes from trunk. (check-in: [c69f030b] user: drh branch: begin-concurrent-pnu, size: 16217)
2020-05-16
19:00
[44bcfb4a] part of check-in [5af4abe9] Merge trunk enhancements in the reuse-schema branch. (Actual date of this check-in is 2020-05-18.) (check-in: [5af4abe9] user: drh branch: reuse-schema, size: 16589)
2020-04-09
18:44
[e7cec3e2] part of check-in [cedd138c] Merge recent trunk enhancements into the begin-concurrent-pnu branch. (check-in: [cedd138c] user: drh branch: begin-concurrent-pnu, size: 16177)
2020-03-31
20:57
[d348a4bf] part of check-in [a279b151] Add "PRAGMA analysis_limit=N;" to limit the number of rows visited by ANALYZE when N is positive. Positive N also disables collecting stat4. (check-in: [a279b151] user: drh branch: approximate-analyze, size: 16071)
2020-02-27
15:20
[b5136888] part of check-in [3f5650aa] Merge latest trunk changes into this branch. (check-in: [3f5650aa] user: dan branch: reuse-schema, size: 16549)
2020-02-07
01:12
[62663c65] part of check-in [5a877221] Simplify the code by removing the unsupported and undocumented SQLITE_HAS_CODEC compile-time option (check-in: [5a877221] user: drh branch: trunk, size: 16031)
2020-01-15
14:26
[85493320] part of check-in [f7839178] Merge all recent enhancements and fixes from trunk. (check-in: [f7839178] user: drh branch: reuse-schema, size: 17038)
13:48
[99bbcc6e] part of check-in [110a081f] Merge all recent enhancements and fixes from trunk. (check-in: [110a081f] user: drh branch: begin-concurrent-pnu, size: 16666)
2020-01-07
19:45
[ca12b1c7] part of check-in [4c21373c] Create the "trusted_schema" pragma. Add sqlite3_vtab_config() calls to set the risk rank for many virtual tables. (check-in: [4c21373c] user: drh branch: new-security-options, size: 16520)
2020-01-04
01:43
[ebff6eec] part of check-in [9ca906d2] Enhance PRAGMA function_list so that it shows all instances of each FuncDef, the number of arguments, the encoding, the type, and the flags. Use this capability to locate and fix incorrect function flags in the standard build. (check-in: [9ca906d2] user: drh branch: new-security-options, size: 16411)
2019-11-14
15:21
[70269c70] part of check-in [b8a631fd] Merge recent enhancements from trunk. (check-in: [b8a631fd] user: drh branch: hard-heap-limit, size: 16391)
2019-10-29
16:18
[faf48e29] part of check-in [4d424f30] Remove the legacy_file_format PRAGMA. In its place, provide the SQLITE_DBCONFIG_LEGACY_FILE_FORMAT option to sqlite3_db_config(). Fix for ticket [6484e6ce678fffab] (check-in: [4d424f30] user: drh branch: trunk, size: 16350)
2019-09-16
12:35
[ee69ec15] part of check-in [27eb2236] Merge all recent trunk enhancements into the reuse-schema branch. (check-in: [27eb2236] user: drh branch: reuse-schema, size: 16981)
12:17
[44471ca0] part of check-in [54930b7e] Merge recent trunk enhancements into the begin-concurrent-pnu branch. (check-in: [54930b7e] user: drh branch: begin-concurrent-pnu, size: 16609)
2019-08-20
17:14
[3ee0d8cf] part of check-in [9b14eb77] Bring the hard-heap-limit branch up-to-date with trunk. (check-in: [9b14eb77] user: drh branch: hard-heap-limit, size: 16504)
2019-08-17
15:27
[f115d63a] part of check-in [9c4bca64] Activatate introspection pragmas by default. The new option SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out. (check-in: [9c4bca64] user: drh branch: trunk, size: 16463)
2019-07-08
21:12
[742b0c05] part of check-in [05aa93af] Merge enhancements from trunk into the begin-concurrent-pnu branch. (check-in: [05aa93af] user: drh branch: begin-concurrent-pnu, size: 16591)
2019-05-24
13:04
[15241b90] part of check-in [ff9f3e09] Merge recent enhancements from trunk. (check-in: [ff9f3e09] user: drh branch: reuse-schema, size: 16963)
2019-05-21
17:04
[8250ef3d] part of check-in [b3692c40] Combine the implementations of the key and hexkey pragmas into a single case. Have both pragmas return "ok" if they are implemented. (check-in: [b3692c40] user: drh branch: trunk, size: 16445)
2019-05-14
22:25
[34f68553] part of check-in [018f3199] Merge all the latest trunk enhancements into the reuse-schema branch. (check-in: [018f3199] user: drh branch: reuse-schema, size: 16969)
21:51
[ecfd5c8e] part of check-in [e70878b3] Merge the latest trunk enhancements into begin-concurrent-pnu. (check-in: [e70878b3] user: drh branch: begin-concurrent-pnu, size: 16597)
2019-05-08
17:27
[d8887dfb] part of check-in [eabe7f2d] Provide the SQLITE_OMIT_CASE_SENSITIVE_LIKE_PRAGMA compile-time option to omit the case_sensitive_like pragma. This change, in combination with documentation changes, is the current solution to ticket [a340eef47b0cad5]. (check-in: [eabe7f2d] user: drh branch: trunk, size: 16451)
2019-04-25
18:15
[0b0d2500] part of check-in [b0ccef61] Add the sqlite3_hard_heap_limit64() interface and the corresponding "PRAGMA hard_heap_limit=N" command. (check-in: [b0ccef61] user: drh branch: hard-heap-limit, size: 16435)
2019-03-08
15:30
[b8c26632] part of check-in [667cce3d] Merge all the latest enhancements from trunk. (check-in: [667cce3d] user: drh branch: begin-concurrent-pnu, size: 16540)
2019-02-25
17:54
[a3ca473c] part of check-in [64f97530] Where possible, avoid loading all schemas into memory for PRAGMA statements. (check-in: [64f97530] user: dan branch: reuse-schema, size: 16912)
2019-02-06
00:11
[49039ade] part of check-in [9dbf512d] Back out check-in [008112bcef561a8], reenabling deprecated PRAGMAs when the SQLITE_OMIT_DEPRECATED compile-time option is used, because way too many TH3 tests depend on those deprecated PRAGMAs. (check-in: [9dbf512d] user: drh branch: trunk, size: 16394)
2019-02-05
12:16
[ecaabfae] part of check-in [93386a7c] Keep the temp_store_directory and data_store_directory pragmas even when compiling with SQLITE_OMIT_DEPRECATED. (check-in: [93386a7c] user: drh branch: trunk, size: 16564)
2019-01-31
01:39
[18d3d04b] part of check-in [507c4353] Improvements to "PRAGMA parser_trace=ON": Make it a flag pragma, and then use the flag to show the complete SQL text at the beginning of the parse. (check-in: [507c4353] user: drh branch: trunk, size: 16646)
2019-01-24
16:07
[f69c3acb] part of check-in [008112bc] Omit deprecated PRAGMAs when compiling with the -DSQLITE_OMIT_DEPRECATED option. (check-in: [008112bc] user: drh branch: trunk, size: 16601)
2018-11-26
07:34
[d5112b04] part of check-in [76608f75] Merge latest begin-concurrent changes into this branch. (check-in: [76608f75] user: dan branch: begin-concurrent-pnu, size: 16495)
2018-10-30
16:25
[a1334e70] part of check-in [4f987810] Split the SQLITE_WriteSchema flag in two flags, WriteSchema and SQLITE_NoSchemaError. Set only WriteSchema on a VACUUM to avoid problems when trying to vacuum a corrupt database. With this change, the size of the flags field on sqlite3 must grow from 32 to 64 bytes. (check-in: [4f987810] user: drh branch: trunk, size: 16349)
2018-10-11
18:41
[656e64fc] part of check-in [f03164d4] Add the textkey and textrekey pragmas. (check-in: [f03164d4] user: drh branch: trunk, size: 16328)
18:28
[4d727a83] part of check-in [f829099d] Add the textkey and textrekey pragmas. (check-in: [f829099d] user: drh branch: apple-osx, size: 16322)
2018-10-01
21:26
[fc895d5a] part of check-in [2fdd0689] Change the name of the pragma to PRAGMA table_xinfo. Improve the mkpragmatab.tcl script to reuse column names where appropriate. (check-in: [2fdd0689] user: drh branch: pragma-table-vinfo, size: 16101)
18:28
[03d3373f] part of check-in [cf1b7613] Add the extra "hidden" column to the end of the PRAGMA table_vinfo output. (check-in: [cf1b7613] user: drh branch: pragma-table-vinfo, size: 15583)
17:15
[75de913f] part of check-in [6f606f99] Bring the PRAGMA table_vinfo statement up to date with trunk. (check-in: [6f606f99] user: drh branch: pragma-table-vinfo, size: 15576)
2018-09-29
19:38
[22817232] part of check-in [8bcd1a59] Add the PRAGMA table_vinfo command (with an extra "v" before "info") that works like PRAGMA table_info (without the "v") except that it also shows hidden columns on virtual tables. (check-in: [8bcd1a59] user: drh branch: pragma-table-vinfo, size: 15465)
2018-09-28
21:11
[c9c20b94] part of check-in [6f3dd980] Merge latest begin-concurrent changes into this branch. (check-in: [6f3dd980] user: dan branch: begin-concurrent-pnu, size: 15536)
2018-09-20
08:28
[8b9b448b] part of check-in [5acad2e9] Add a PRAGMA that restores the legacy ALTER TABLE RENAME TO behaviour. (check-in: [5acad2e9] user: dan branch: legacy-alter-table, size: 15390)
2018-04-28
01:27
[c2efde2e] part of check-in [02e1a13c] Add the "PRAGMA reset_database=ON|OFF" command. When on, it causes the database to appear to be empty, causing the next transaction to reset it to an empty database. (check-in: [02e1a13c] user: drh branch: reset-database, size: 15407)
2017-11-28
02:47
[f49ae6e8] part of check-in [2494132a] Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. (check-in: [2494132a] user: drh branch: pragma-table-ipk, size: 15383)
2017-11-01
18:48
[0d67312a] part of check-in [81baf67c] The "PRAGMA noop_update" command now requires SQLITE_ENABLE_NOOP_UPDATE and no longer requires SQLITE_DEBUG. (check-in: [81baf67c] user: drh branch: begin-concurrent-pnu, size: 15425)
2017-09-22
20:18
[0ee82c05] part of check-in [8d2a1cca] Merge in all the trunk enhancements of the previous 7 months. The LIKE optimization has stopped working when there is an ESCAPE - that problem will be addressed in a subsequent check-in. (check-in: [8d2a1cca] user: drh branch: est_count_pragma, size: 15358)
2017-09-12
18:49
[e9a72539] part of check-in [de2e3717] Add the highly-experimental "PRAGMA noop_update=TRUE" command. (check-in: [de2e3717] user: drh branch: pragma-noop-update, size: 15412)
2017-07-19
18:54
[c249dee5] part of check-in [be0df0a6] Merge latest trunk changes with this branch. (check-in: [be0df0a6] user: dan branch: server-process-edition, size: 15419)
2017-07-13
21:06
[983057a1] part of check-in [dcc40797] Make the freelist format a separate feature from the page-level locking. Freelist format is now configure using "PRAGMA freelist_format". (check-in: [dcc40797] user: dan branch: server-process-edition, size: 14988)
2017-07-07
17:33
[2144bc85] part of check-in [2f3c3781] Add the "Pragma_list" pragma. Put all three pragmas created on this branch inside of #ifdef SQLITE_INTROSPECTION_PRAGMAS. (check-in: [2f3c3781] user: drh branch: list-pragmas, size: 15279)
15:43
[3707a958] part of check-in [e5f01d7f] Add new pragmas: "function_list" and "module_list" (check-in: [e5f01d7f] user: drh branch: list-pragmas, size: 15091)
2017-06-26
13:57
[aa94395a] part of check-in [7076e828] Add the SQLITE_DBCONFIG_ENABLE_QPSG option to activate the query planner stability guarantee. This involves refactoring the sqlite3.flags bitvector to carve out a free bit to use. (check-in: [7076e828] user: drh branch: enable-QPSG, size: 14848)
2017-06-21
01:36
[bdd4c764] part of check-in [118f7bb3] Enable pragma virtual tables for the integrity_check, quick_check, and foreign_key_check pragmas. (check-in: [118f7bb3] user: drh branch: trunk, size: 14871)
2017-04-03
13:33
[32bb4074] part of check-in [86897c24] Force a schema load prior to "PRAGMA optimize". (check-in: [86897c24] user: drh branch: trunk, size: 14831)
2017-03-02
14:17
[2ffe6d5f] part of check-in [a35388ee] Add an optional bitmask of allowed optimizations on the "PRAGMA optimize" command. The 0x01 bit is Debug Mode. (check-in: [a35388ee] user: drh branch: auto-analyze, size: 14820)
2017-02-22
20:24
[9b499f73] part of check-in [9fced545] Change the name of the analyze_as_needed pragma to "optimize". Enhance the comment (which will become documentation, assuming these changes land on trunk) to explain that the optimize pragma is likely to be enhanced in various ways in future releases and that applications should not depend upon the current behavior. (check-in: [9fced545] user: drh branch: auto-analyze, size: 14822)
2017-02-21
13:29
[b6ef1997] part of check-in [9626b41e] Proof of concept for a "PRAGMA vdbe_cycle_limit=N" command. When N>0, invoke sqlite3_interrupt() whenever any byte code program uses more than N virtual machine cycles. (check-in: [9626b41e] user: drh branch: vdbe_cycle_limit, size: 14807)
2017-02-17
16:26
[6fd5ecb4] part of check-in [e93db237] Add the "PRAGMA analyze_as_needed" command. (check-in: [e93db237] user: drh branch: auto-analyze, size: 14831)
15:26
[c955db93] part of check-in [fb2b8ae8] Set the TF_StatsUsed flag on tables when the query planner outcome is affected by the sqlite_stat1 data. Also, change the column names of the "PRAGMA stats" command so that they are not keywords. (check-in: [fb2b8ae8] user: drh branch: auto-analyze, size: 14786)
13:38
[9c0a855e] part of check-in [85026c8e] Enhance the Index and Table objects so that they remember if their stats come from the sqlite_stat1 table. Make the "PRAGMA stats" an SQLITE_DEBUG only pragma. Add the flags column to "PRAGMA stats". These are all preliminary steps toward a "PRAGMA analyze_ifneeded;" feature. (check-in: [85026c8e] user: drh branch: auto-analyze, size: 14794)
2017-01-27
16:24
[72cd1298] part of check-in [fe86ff54] Merge all recent enhancements from trunk. (check-in: [fe86ff54] user: drh branch: est_count_pragma, size: 14842)
2017-01-06
13:49
[ebb4bfcd] part of check-in [6696cd18] Ensure that "PRAGMA case_sensitive_like" and "PRAGMA shrink_memory" set the number of output columns to 0 (as they are statements that return no data). (check-in: [6696cd18] user: dan branch: trunk, size: 14763)
2017-01-05
19:32
[1b2c06e1] part of check-in [5c05d8ec] Ensure that sqlite3_column_count() returns 0 for the "set" mode of "get/set" PRAGMA statements that do not return a value in that case (e.g. page_size, cache_size, auto_vacuum). (check-in: [5c05d8ec] user: dan branch: pragma-columncount-fix, size: 14727)
2016-12-16
16:49
[c4e9c6b7] part of check-in [4b73ee33] Experimental merge of the est_count_pragma and the pragma-as-vtab branches. (check-in: [4b73ee33] user: drh branch: est-count-pragma-vtab, size: 14560)
2016-12-15
20:59
[a30ee935] part of check-in [988a61e8] Code to automatically create eponymous virtual tables for read-only pragmas. Compiles, but does not yet work. (check-in: [988a61e8] user: drh branch: pragma-as-vtab, size: 14481)
16:01
[999d7da2] part of check-in [a88ca352] Do more pragma processing from tables rather than in-line code. (check-in: [a88ca352] user: drh branch: table-driven-pragma, size: 14442)
2016-10-21
17:25
[c5ce5c56] part of check-in [affc2ef5] Add the btree_sample(INDEX,LOCATION,LIMIT) pragma. (check-in: [affc2ef5] user: drh branch: est_count_pragma, size: 11496)
2016-10-20
22:02
[bf6417cc] part of check-in [340822af] Experimental est_count pragma. (check-in: [340822af] user: drh branch: est_count_pragma, size: 11455)
2016-02-27
17:16
[bf99a053] part of check-in [3a0c347c] Experimental "PRAGMA onconflict=FAIL" statement to change the default ON CONFLICT algorithm to something other than ABORT. (check-in: [3a0c347c] user: drh branch: pragma-onconflict, size: 11437)
2015-12-15
13:50
[f0d5bb26] part of check-in [2fda43e6] Add the SQLITE_OMIT_PARSER_TRACE compile-time option. (check-in: [2fda43e6] user: drh branch: trunk, size: 11417)
2015-11-12
22:15
[e94e55d2] part of check-in [12e7d9ec] Always parse the schema *before* running "PRAGMA cache_size", not after. (check-in: [12e7d9ec] user: drh branch: trunk, size: 11379)
14:57
[473b6a15] part of check-in [549d42be] First attempt at enhancing the "PRAGMA cache_spill" statement to accept a cache threashold size. (check-in: [549d42be] user: drh branch: cache_spill=N, size: 11360)
2015-07-16
18:18
[84af2b18] part of check-in [b79a4aff] Defer the bulk pcache1 memory allocation until the first page allocation request. Limit the size of the pcache1 bulk allocation to the cache_size setting. Deallocate the bulk allocation on a sqlite3_db_release_memory() request, if the bulk allocation is completely unused. (check-in: [b79a4aff] user: drh branch: trunk, size: 11399)
2015-05-27
03:46
[40c287d3] part of check-in [2ead43f0] Add the "PRAGMA cell_size_check=ON" command. (check-in: [2ead43f0] user: drh branch: cell-size-check-pragma, size: 11418)
2015-02-04
23:51
[a5cb9b20] part of check-in [21e95d28] Merge all changes from index_xinfo, including the move of the pragma table into the separate pragma.h file. (check-in: [21e95d28] user: drh branch: ota-update, size: 11413)
23:13
[94f196c9] part of check-in [3af19f84] Merge all recent trunk changes, including the movement of the pragma table into the separate pragma.h header file. (check-in: [3af19f84] user: drh branch: index_xinfo, size: 11354)
2015-02-03
15:56
[aea392b6] part of check-in [1c111447] Remove "PRAGMA ota_mode". (check-in: [1c111447] user: dan branch: ota-update, size: 10959)
2015-02-02
22:19
[848a7444] part of check-in [6dca23e6] Add an experimental pragma "PRAGMA preload;" that preloads the pcache with the entire database file. (check-in: [6dca23e6] user: drh branch: preload-pragma, size: 11228)
21:34
[4b4e91f6] part of check-in [32c0325b] Break out the (script-generated) pragma parsing tables into a separate file, pragma.h, to make editing easier. (check-in: [32c0325b] user: drh branch: trunk, size: 11211)
2015-01-31
02:34
[5a401a3f] part of check-in [f9b6dc77] Merge in support for the index_xinfo pragma. (check-in: [f9b6dc77] user: drh branch: ota-update, size: 11048)
02:00
[4a3b465f] part of check-in [30f51d7b] Add the "index_xinfo" pragma. Add new columns to the "index_info" and "index_list" pragmas. (check-in: [30f51d7b] user: drh branch: index_xinfo, size: 10900)
2015-01-28
12:00
[b80cb9d1] part of check-in [17c69be8] Merge in all changes from trunk. (check-in: [17c69be8] user: drh branch: ota-update, size: 10905)
2014-12-19
19:28
[07a5124c] part of check-in [43db1f44] Experimental "PRAGMA data_version" command for detecting when another process has changed the database file. (check-in: [43db1f44] user: drh branch: data_version_pragma, size: 10757)
18:49
[f7facbe8] part of check-in [da27a09d] Simplify the implementation of the "header-value" pragmas (schema_version, user_version, freelist_count, and application_id) by making them more table-driven. (check-in: [da27a09d] user: drh branch: trunk, size: 10617)
2014-11-22
09:09
[7c9f48bf] part of check-in [600cefdd] Add SQLITE_ENABLE_OTA pre-processor directives so that this branch may be compiled with or without OTA. (check-in: [600cefdd] user: dan branch: ota-update, size: 10633)
2014-09-03
19:30
[22c85e67] part of check-in [209f672e] Split part of "PRAGMA ota_mode" off into "PRAGMA pager_ota_mode". This allows some specialized custom VFS implementations to intercept and implement the expected pager-related effects of this pragma. (check-in: [209f672e] user: dan branch: ota-update, size: 10563)
2014-08-25
15:13
[cce51d8f] part of check-in [29c5e8a7] Query or change the maximum number of worker threads allowed on each database connection separately using the "PRAGMA threads" command. (check-in: [29c5e8a7] user: drh branch: threads, size: 10485)
2014-05-05
22:49
[6c523433] part of check-in [f1a4bf01] Add the "omit_check_constraints" pragma that causes the check constraint expressions to be omitted from the parse tree. (check-in: [f1a4bf01] user: drh branch: reduce-schema-size, size: 10618)
2013-11-13
17:58
[78a77b2c] part of check-in [8ce33f4c] Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify some of the other debugging logic. (check-in: [8ce33f4c] user: drh branch: trunk, size: 10468)
2013-10-21
23:17
[17d40faa] part of check-in [f1d8c3b0] Improve support for the SQLITE_OMIT_FLAG_PRAGMAS compile-time option. (check-in: [f1d8c3b0] user: mistachkin branch: trunk, size: 10341)
2013-10-12
20:22
[3fc52e00] part of check-in [f0cf8c85] Restore the index_list pragma back to its former operation. Create a new PRAGMA stats used to access the table and index widths and heights. (check-in: [f0cf8c85] user: drh branch: trunk, size: 9202)
2013-10-07
00:36
[ceaaeebc] part of check-in [0aca31e1] Restore the hexrekey pragma which was accidently deleted during the pragma refactoring. Make sure the hexkey and hexrekey pragmas do not overflow buffers with a over-length key. (check-in: [0aca31e1] user: drh branch: trunk, size: 9123)
2013-10-03
14:08
[33fa7a6e] part of check-in [8338232a] Rework the PRAGMA implementation to only call sqlite3ReadSchema() from a single place, based on a flag in the pragma table, rather than separately from each case which needs the schema. (check-in: [8338232a] user: drh branch: trunk, size: 9056)
2013-09-13
21:03
[e24da149] part of check-in [b74e6be8] Fix the "const" qualifiers on the pragma name table. (check-in: [b74e6be8] user: drh branch: trunk, size: 8239)
21:01
[8f50568b] part of check-in [c326356f] Add the soft_heap_limit pragma. (check-in: [c326356f] user: drh branch: trunk, size: 8239)
19:00
[bf0979c5] part of check-in [c82e05c4] Tweak the new PRAGMA name parser to achieve full branch test coverage. (check-in: [c82e05c4] user: drh branch: trunk, size: 8214)
16:56
[a254fd56] part of check-in [ca052050] Enhance the pragma lookup table generator script to output a comment that gives the number of pragmas. (check-in: [ca052050] user: drh branch: trunk, size: 8214)
16:36
Added: [b45b0770] part of check-in [870c030b] Change the PRAGMA parser to use a binary search for the pragma name. Also: Minor performance enhancement to sqlite3DbFree() and to the token dequoter. (check-in: [870c030b] user: drh branch: trunk, size: 7893)