/ File History
Login

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

History of tool/mkpragmatab.tcl

2019-11-14
15:21
Merge recent enhancements from trunk. file: [70269c70] check-in: [b8a631fd] user: drh branch: hard-heap-limit, size: 16391
2019-10-29
16:18
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] file: [faf48e29] check-in: [4d424f30] user: drh branch: trunk, size: 16350
2019-09-16
12:35
Merge all recent trunk enhancements into the reuse-schema branch. file: [ee69ec15] check-in: [27eb2236] user: drh branch: reuse-schema, size: 16981
12:17
Merge recent trunk enhancements into the begin-concurrent-pnu branch. file: [44471ca0] check-in: [54930b7e] user: drh branch: begin-concurrent-pnu, size: 16609
2019-08-20
17:14
Bring the hard-heap-limit branch up-to-date with trunk. file: [3ee0d8cf] check-in: [9b14eb77] user: drh branch: hard-heap-limit, size: 16504
2019-08-17
15:27
Activatate introspection pragmas by default. The new option SQLITE_OMIT_INTROSPECTION_PRAGMAS must be provided to keep them out. file: [f115d63a] check-in: [9c4bca64] user: drh branch: trunk, size: 16463
2019-07-08
21:12
Merge enhancements from trunk into the begin-concurrent-pnu branch. file: [742b0c05] check-in: [05aa93af] user: drh branch: begin-concurrent-pnu, size: 16591
2019-05-24
13:04
Merge recent enhancements from trunk. file: [15241b90] check-in: [ff9f3e09] user: drh branch: reuse-schema, size: 16963
2019-05-21
17:04
Combine the implementations of the key and hexkey pragmas into a single case. Have both pragmas return "ok" if they are implemented. file: [8250ef3d] check-in: [b3692c40] user: drh branch: trunk, size: 16445
2019-05-14
22:25
Merge all the latest trunk enhancements into the reuse-schema branch. file: [34f68553] check-in: [018f3199] user: drh branch: reuse-schema, size: 16969
21:51
Merge the latest trunk enhancements into begin-concurrent-pnu. file: [ecfd5c8e] check-in: [e70878b3] user: drh branch: begin-concurrent-pnu, size: 16597
2019-05-08
17:27
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]. file: [d8887dfb] check-in: [eabe7f2d] user: drh branch: trunk, size: 16451
2019-04-25
18:15
Add the sqlite3_hard_heap_limit64() interface and the corresponding "PRAGMA hard_heap_limit=N" command. file: [0b0d2500] check-in: [b0ccef61] user: drh branch: hard-heap-limit, size: 16435
2019-03-08
15:30
Merge all the latest enhancements from trunk. file: [b8c26632] check-in: [667cce3d] user: drh branch: begin-concurrent-pnu, size: 16540
2019-02-25
17:54
Where possible, avoid loading all schemas into memory for PRAGMA statements. file: [a3ca473c] check-in: [64f97530] user: dan branch: reuse-schema, size: 16912
2019-02-06
00:11
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. file: [49039ade] check-in: [9dbf512d] user: drh branch: trunk, size: 16394
2019-02-05
12:16
Keep the temp_store_directory and data_store_directory pragmas even when compiling with SQLITE_OMIT_DEPRECATED. file: [ecaabfae] check-in: [93386a7c] user: drh branch: trunk, size: 16564
2019-01-31
01:39
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. file: [18d3d04b] check-in: [507c4353] user: drh branch: trunk, size: 16646
2019-01-24
16:07
Omit deprecated PRAGMAs when compiling with the -DSQLITE_OMIT_DEPRECATED option. file: [f69c3acb] check-in: [008112bc] user: drh branch: trunk, size: 16601
2018-11-26
07:34
Merge latest begin-concurrent changes into this branch. file: [d5112b04] check-in: [76608f75] user: dan branch: begin-concurrent-pnu, size: 16495
2018-10-30
16:25
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. file: [a1334e70] check-in: [4f987810] user: drh branch: trunk, size: 16349
2018-10-11
18:41
Add the textkey and textrekey pragmas. file: [656e64fc] check-in: [f03164d4] user: drh branch: trunk, size: 16328
18:28
Add the textkey and textrekey pragmas. file: [4d727a83] check-in: [f829099d] user: drh branch: apple-osx, size: 16322
2018-10-01
21:26
Change the name of the pragma to PRAGMA table_xinfo. Improve the mkpragmatab.tcl script to reuse column names where appropriate. file: [fc895d5a] check-in: [2fdd0689] user: drh branch: pragma-table-vinfo, size: 16101
18:28
Add the extra "hidden" column to the end of the PRAGMA table_vinfo output. file: [03d3373f] check-in: [cf1b7613] user: drh branch: pragma-table-vinfo, size: 15583
17:15
Bring the PRAGMA table_vinfo statement up to date with trunk. file: [75de913f] check-in: [6f606f99] user: drh branch: pragma-table-vinfo, size: 15576
2018-09-29
19:38
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. file: [22817232] check-in: [8bcd1a59] user: drh branch: pragma-table-vinfo, size: 15465
2018-09-28
21:11
Merge latest begin-concurrent changes into this branch. file: [c9c20b94] check-in: [6f3dd980] user: dan branch: begin-concurrent-pnu, size: 15536
2018-09-20
08:28
Add a PRAGMA that restores the legacy ALTER TABLE RENAME TO behaviour. file: [8b9b448b] check-in: [5acad2e9] user: dan branch: legacy-alter-table, size: 15390
2018-04-28
01:27
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. file: [c2efde2e] check-in: [02e1a13c] user: drh branch: reset-database, size: 15407
2017-11-28
02:47
Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. file: [f49ae6e8] check-in: [2494132a] user: drh branch: pragma-table-ipk, size: 15383
2017-11-01
18:48
The "PRAGMA noop_update" command now requires SQLITE_ENABLE_NOOP_UPDATE and no longer requires SQLITE_DEBUG. file: [0d67312a] check-in: [81baf67c] user: drh branch: begin-concurrent-pnu, size: 15425
2017-09-22
20:18
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. file: [0ee82c05] check-in: [8d2a1cca] user: drh branch: est_count_pragma, size: 15358
2017-09-12
18:49
Add the highly-experimental "PRAGMA noop_update=TRUE" command. file: [e9a72539] check-in: [de2e3717] user: drh branch: pragma-noop-update, size: 15412
2017-07-19
18:54
Merge latest trunk changes with this branch. file: [c249dee5] check-in: [be0df0a6] user: dan branch: server-process-edition, size: 15419
2017-07-13
21:06
Make the freelist format a separate feature from the page-level locking. Freelist format is now configure using "PRAGMA freelist_format". file: [983057a1] check-in: [dcc40797] user: dan branch: server-process-edition, size: 14988
2017-07-07
17:33
Add the "Pragma_list" pragma. Put all three pragmas created on this branch inside of #ifdef SQLITE_INTROSPECTION_PRAGMAS. file: [2144bc85] check-in: [2f3c3781] user: drh branch: list-pragmas, size: 15279
15:43
Add new pragmas: "function_list" and "module_list" file: [3707a958] check-in: [e5f01d7f] user: drh branch: list-pragmas, size: 15091
2017-06-26
13:57
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. file: [aa94395a] check-in: [7076e828] user: drh branch: enable-QPSG, size: 14848
2017-06-21
01:36
Enable pragma virtual tables for the integrity_check, quick_check, and foreign_key_check pragmas. file: [bdd4c764] check-in: [118f7bb3] user: drh branch: trunk, size: 14871
2017-04-03
13:33
Force a schema load prior to "PRAGMA optimize". file: [32bb4074] check-in: [86897c24] user: drh branch: trunk, size: 14831
2017-03-02
14:17
Add an optional bitmask of allowed optimizations on the "PRAGMA optimize" command. The 0x01 bit is Debug Mode. file: [2ffe6d5f] check-in: [a35388ee] user: drh branch: auto-analyze, size: 14820
2017-02-22
20:24
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. file: [9b499f73] check-in: [9fced545] user: drh branch: auto-analyze, size: 14822
2017-02-21
13:29
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. file: [b6ef1997] check-in: [9626b41e] user: drh branch: vdbe_cycle_limit, size: 14807
2017-02-17
16:26
Add the "PRAGMA analyze_as_needed" command. file: [6fd5ecb4] check-in: [e93db237] user: drh branch: auto-analyze, size: 14831
15:26
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. file: [c955db93] check-in: [fb2b8ae8] user: drh branch: auto-analyze, size: 14786
13:38
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. file: [9c0a855e] check-in: [85026c8e] user: drh branch: auto-analyze, size: 14794
2017-01-27
16:24
Merge all recent enhancements from trunk. file: [72cd1298] check-in: [fe86ff54] user: drh branch: est_count_pragma, size: 14842
2017-01-06
13:49
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). file: [ebb4bfcd] check-in: [6696cd18] user: dan branch: trunk, size: 14763
2017-01-05
19:32
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). file: [1b2c06e1] check-in: [5c05d8ec] user: dan branch: pragma-columncount-fix, size: 14727
2016-12-16
16:49
Experimental merge of the est_count_pragma and the pragma-as-vtab branches. file: [c4e9c6b7] check-in: [4b73ee33] user: drh branch: est-count-pragma-vtab, size: 14560
2016-12-15
20:59
Code to automatically create eponymous virtual tables for read-only pragmas. Compiles, but does not yet work. file: [a30ee935] check-in: [988a61e8] user: drh branch: pragma-as-vtab, size: 14481
16:01
Do more pragma processing from tables rather than in-line code. file: [999d7da2] check-in: [a88ca352] user: drh branch: table-driven-pragma, size: 14442
2016-10-21
17:25
Add the btree_sample(INDEX,LOCATION,LIMIT) pragma. file: [c5ce5c56] check-in: [affc2ef5] user: drh branch: est_count_pragma, size: 11496
2016-10-20
22:02
Experimental est_count pragma. file: [bf6417cc] check-in: [340822af] user: drh branch: est_count_pragma, size: 11455
2016-02-27
17:16
Experimental "PRAGMA onconflict=FAIL" statement to change the default ON CONFLICT algorithm to something other than ABORT. file: [bf99a053] check-in: [3a0c347c] user: drh branch: pragma-onconflict, size: 11437
2015-12-15
13:50
Add the SQLITE_OMIT_PARSER_TRACE compile-time option. file: [f0d5bb26] check-in: [2fda43e6] user: drh branch: trunk, size: 11417
2015-11-12
22:15
Always parse the schema *before* running "PRAGMA cache_size", not after. file: [e94e55d2] check-in: [12e7d9ec] user: drh branch: trunk, size: 11379
14:57
First attempt at enhancing the "PRAGMA cache_spill" statement to accept a cache threashold size. file: [473b6a15] check-in: [549d42be] user: drh branch: cache_spill=N, size: 11360
2015-07-16
18:18
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. file: [84af2b18] check-in: [b79a4aff] user: drh branch: trunk, size: 11399
2015-05-27
03:46
Add the "PRAGMA cell_size_check=ON" command. file: [40c287d3] check-in: [2ead43f0] user: drh branch: cell-size-check-pragma, size: 11418
2015-02-04
23:51
Merge all changes from index_xinfo, including the move of the pragma table into the separate pragma.h file. file: [a5cb9b20] check-in: [21e95d28] user: drh branch: ota-update, size: 11413
23:13
Merge all recent trunk changes, including the movement of the pragma table into the separate pragma.h header file. file: [94f196c9] check-in: [3af19f84] user: drh branch: index_xinfo, size: 11354
2015-02-03
15:56
Remove "PRAGMA ota_mode". file: [aea392b6] check-in: [1c111447] user: dan branch: ota-update, size: 10959
2015-02-02
22:19
Add an experimental pragma "PRAGMA preload;" that preloads the pcache with the entire database file. file: [848a7444] check-in: [6dca23e6] user: drh branch: preload-pragma, size: 11228
21:34
Break out the (script-generated) pragma parsing tables into a separate file, pragma.h, to make editing easier. file: [4b4e91f6] check-in: [32c0325b] user: drh branch: trunk, size: 11211
2015-01-31
02:34
Merge in support for the index_xinfo pragma. file: [5a401a3f] check-in: [f9b6dc77] user: drh branch: ota-update, size: 11048
02:00
Add the "index_xinfo" pragma. Add new columns to the "index_info" and "index_list" pragmas. file: [4a3b465f] check-in: [30f51d7b] user: drh branch: index_xinfo, size: 10900
2015-01-28
12:00
Merge in all changes from trunk. file: [b80cb9d1] check-in: [17c69be8] user: drh branch: ota-update, size: 10905
2014-12-19
19:28
Experimental "PRAGMA data_version" command for detecting when another process has changed the database file. file: [07a5124c] check-in: [43db1f44] user: drh branch: data_version_pragma, size: 10757
18:49
Simplify the implementation of the "header-value" pragmas (schema_version, user_version, freelist_count, and application_id) by making them more table-driven. file: [f7facbe8] check-in: [da27a09d] user: drh branch: trunk, size: 10617
2014-11-22
09:09
Add SQLITE_ENABLE_OTA pre-processor directives so that this branch may be compiled with or without OTA. file: [7c9f48bf] check-in: [600cefdd] user: dan branch: ota-update, size: 10633
2014-09-03
19:30
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. file: [22c85e67] check-in: [209f672e] user: dan branch: ota-update, size: 10563
2014-08-25
15:13
Query or change the maximum number of worker threads allowed on each database connection separately using the "PRAGMA threads" command. file: [cce51d8f] check-in: [29c5e8a7] user: drh branch: threads, size: 10485
2014-05-05
22:49
Add the "omit_check_constraints" pragma that causes the check constraint expressions to be omitted from the parse tree. file: [6c523433] check-in: [f1a4bf01] user: drh branch: reduce-schema-size, size: 10618
2013-11-13
17:58
Add the "PRAGMA vdbe_eqp" command, only available with SQLITE_DEBUG. Simplify some of the other debugging logic. file: [78a77b2c] check-in: [8ce33f4c] user: drh branch: trunk, size: 10468
2013-10-21
23:17
Improve support for the SQLITE_OMIT_FLAG_PRAGMAS compile-time option. file: [17d40faa] check-in: [f1d8c3b0] user: mistachkin branch: trunk, size: 10341
2013-10-12
20:22
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. file: [3fc52e00] check-in: [f0cf8c85] user: drh branch: trunk, size: 9202
2013-10-07
00:36
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. file: [ceaaeebc] check-in: [0aca31e1] user: drh branch: trunk, size: 9123
2013-10-03
14:08
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. file: [33fa7a6e] check-in: [8338232a] user: drh branch: trunk, size: 9056
2013-09-13
21:03
Fix the "const" qualifiers on the pragma name table. file: [e24da149] check-in: [b74e6be8] user: drh branch: trunk, size: 8239
21:01
Add the soft_heap_limit pragma. file: [8f50568b] check-in: [c326356f] user: drh branch: trunk, size: 8239
19:00
Tweak the new PRAGMA name parser to achieve full branch test coverage. file: [bf0979c5] check-in: [c82e05c4] user: drh branch: trunk, size: 8214
16:56
Enhance the pragma lookup table generator script to output a comment that gives the number of pragmas. file: [a254fd56] check-in: [ca052050] user: drh branch: trunk, size: 8214
16:36
Change the PRAGMA parser to use a binary search for the pragma name. Also: Minor performance enhancement to sqlite3DbFree() and to the token dequoter. file: [b45b0770] check-in: [870c030b] user: drh branch: trunk, size: 7893 Added