/ File History
Login

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

History of src/pragma.h

2019-11-14
23:08
Backport support for the sqlite3_hard_heap_limit64() interface and the hard_heap_limit pragma to the 3.30 branch. file: [885f2f5d] check-in: [ba27012d] user: drh branch: branch-3.30, size: 24007
15:21
Merge recent enhancements from trunk. file: [ec3b31ea] check-in: [b8a631fd] user: drh branch: hard-heap-limit, size: 23810
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: [b45328f0] check-in: [4d424f30] user: drh branch: trunk, size: 23594
2019-09-16
12:35
Merge all recent trunk enhancements into the reuse-schema branch. file: [583d641c] check-in: [27eb2236] user: drh branch: reuse-schema, size: 24339
12:17
Merge recent trunk enhancements into the begin-concurrent-pnu branch. file: [9f897143] check-in: [54930b7e] user: drh branch: begin-concurrent-pnu, size: 24070
2019-08-20
17:14
Bring the hard-heap-limit branch up-to-date with trunk. file: [ef66a7db] check-in: [9b14eb77] user: drh branch: hard-heap-limit, size: 24007
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: [40962d65] check-in: [9c4bca64] user: drh branch: trunk, size: 23791
2019-07-08
21:12
Merge enhancements from trunk into the begin-concurrent-pnu branch. file: [45a9bd20] check-in: [05aa93af] user: drh branch: begin-concurrent-pnu, size: 24052
2019-05-24
13:04
Merge recent enhancements from trunk. file: [089d20e0] check-in: [ff9f3e09] user: drh branch: reuse-schema, size: 24321
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: [4a9fabff] check-in: [b3692c40] user: drh branch: trunk, size: 23773
2019-05-14
22:25
Merge all the latest trunk enhancements into the reuse-schema branch. file: [85a1a57c] check-in: [018f3199] user: drh branch: reuse-schema, size: 24376
21:51
Merge the latest trunk enhancements into begin-concurrent-pnu. file: [dfa60e58] check-in: [e70878b3] user: drh branch: begin-concurrent-pnu, size: 24107
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: [482c26f3] check-in: [eabe7f2d] user: drh branch: trunk, size: 23828
2019-04-25
18:15
Add the sqlite3_hard_heap_limit64() interface and the corresponding "PRAGMA hard_heap_limit=N" command. file: [9af5ddde] check-in: [b0ccef61] user: drh branch: hard-heap-limit, size: 23984
2019-03-08
15:30
Merge all the latest enhancements from trunk. file: [fabf163f] check-in: [667cce3d] user: drh branch: begin-concurrent-pnu, size: 24047
2019-02-25
17:54
Where possible, avoid loading all schemas into memory for PRAGMA statements. file: [9d7658a7] check-in: [64f97530] user: dan branch: reuse-schema, size: 24316
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: [a776bb9c] check-in: [9dbf512d] user: drh branch: trunk, size: 23768
2019-02-05
12:16
Keep the temp_store_directory and data_store_directory pragmas even when compiling with SQLITE_OMIT_DEPRECATED. file: [66f3e237] check-in: [93386a7c] user: drh branch: trunk, size: 23998
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: [b774c8fd] check-in: [507c4353] user: drh branch: trunk, size: 24133
2019-01-24
16:07
Omit deprecated PRAGMAs when compiling with the -DSQLITE_OMIT_DEPRECATED option. file: [14eed106] check-in: [008112bc] user: drh branch: trunk, size: 24132
2018-11-26
07:34
Merge latest begin-concurrent changes into this branch. file: [7003ea8e] check-in: [76608f75] user: dan branch: begin-concurrent-pnu, size: 24046
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: [fdd03d78] check-in: [4f987810] user: drh branch: trunk, size: 23767
2018-10-11
18:41
Add the textkey and textrekey pragmas. file: [e50df793] check-in: [f03164d4] user: drh branch: trunk, size: 23746
18:28
Add the textkey and textrekey pragmas. file: [e6bd0946] check-in: [f829099d] user: drh branch: apple-osx, size: 23691
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: [0ea63940] check-in: [2fdd0689] user: drh branch: pragma-table-vinfo, size: 23492
18:28
Add the extra "hidden" column to the end of the PRAGMA table_vinfo output. file: [32e7736d] check-in: [cf1b7613] user: drh branch: pragma-table-vinfo, size: 23708
17:15
Bring the PRAGMA table_vinfo statement up to date with trunk. file: [6eefd8c5] check-in: [6f606f99] user: drh branch: pragma-table-vinfo, size: 23503
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: [32f09ef7] check-in: [8bcd1a59] user: drh branch: pragma-table-vinfo, size: 23308
2018-09-28
21:11
Merge latest begin-concurrent changes into this branch. file: [2a1aa93f] check-in: [6f3dd980] user: dan branch: begin-concurrent-pnu, size: 23575
2018-09-20
08:28
Add a PRAGMA that restores the legacy ALTER TABLE RENAME TO behaviour. file: [fb46b1e6] check-in: [5acad2e9] user: dan branch: legacy-alter-table, size: 23296
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: [f1e9f51d] check-in: [02e1a13c] user: drh branch: reset-database, size: 23313
2017-11-28
02:47
Add the "PRAGMA table_ipk(TABLE)" command for evaluation purposes. file: [4ce81be7] check-in: [2494132a] user: drh branch: pragma-table-ipk, size: 23332
2017-11-01
18:48
The "PRAGMA noop_update" command now requires SQLITE_ENABLE_NOOP_UPDATE and no longer requires SQLITE_DEBUG. file: [ce41efb7] check-in: [81baf67c] user: drh branch: begin-concurrent-pnu, size: 23380
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: [aaf12079] check-in: [8d2a1cca] user: drh branch: est_count_pragma, size: 23521
2017-09-12
18:49
Add the highly-experimental "PRAGMA noop_update=TRUE" command. file: [70cb22e6] check-in: [de2e3717] user: drh branch: pragma-noop-update, size: 23367
2017-07-19
18:54
Merge latest trunk changes with this branch. file: [a59d572c] check-in: [be0df0a6] user: dan branch: server-process-edition, size: 23435
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: [10b1af34] check-in: [dcc40797] user: dan branch: server-process-edition, size: 22366
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: [bb837289] check-in: [2f3c3781] user: drh branch: list-pragmas, size: 23101
15:43
Add new pragmas: "function_list" and "module_list" file: [0d5573ec] check-in: [e5f01d7f] user: drh branch: list-pragmas, size: 22733
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: [99d3df4a] check-in: [7076e828] user: drh branch: enable-QPSG, size: 22032
2017-06-21
01:36
Enable pragma virtual tables for the integrity_check, quick_check, and foreign_key_check pragmas. file: [a8a94900] check-in: [118f7bb3] user: drh branch: trunk, size: 22055
2017-04-03
13:33
Force a schema load prior to "PRAGMA optimize". file: [37a1311d] check-in: [86897c24] user: drh branch: trunk, size: 21975
2017-03-02
14:17
Add an optional bitmask of allowed optimizations on the "PRAGMA optimize" command. The 0x01 bit is Debug Mode. file: [c9c76395] check-in: [a35388ee] user: drh branch: auto-analyze, size: 21956
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: [d97dd835] check-in: [9fced545] user: drh branch: auto-analyze, size: 21958
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: [1ec44ee8] check-in: [9626b41e] user: drh branch: vdbe_cycle_limit, size: 21954
2017-02-17
16:26
Add the "PRAGMA analyze_as_needed" command. file: [065e1844] check-in: [e93db237] user: drh branch: auto-analyze, size: 21929
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: [9e65a903] check-in: [fb2b8ae8] user: drh branch: auto-analyze, size: 21707
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: [cea24a63] check-in: [85026c8e] user: drh branch: auto-analyze, size: 21707
2017-01-27
16:24
Merge all recent enhancements from trunk. file: [5d3266fb] check-in: [fe86ff54] user: drh branch: est_count_pragma, size: 22075
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: [61aa5389] check-in: [6696cd18] user: dan branch: trunk, size: 21655
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: [27fd6a8a] check-in: [5c05d8ec] user: dan branch: pragma-columncount-fix, size: 21623
2016-12-16
16:49
Experimental merge of the est_count_pragma and the pragma-as-vtab branches. file: [e2636093] check-in: [4b73ee33] user: drh branch: est-count-pragma-vtab, size: 21682
2016-12-15
20:59
Code to automatically create eponymous virtual tables for read-only pragmas. Compiles, but does not yet work. file: [f9b221b2] check-in: [988a61e8] user: drh branch: pragma-as-vtab, size: 21262
16:01
Do more pragma processing from tables rather than in-line code. file: [7dff1007] check-in: [a88ca352] user: drh branch: table-driven-pragma, size: 21234
2016-10-21
17:25
Add the btree_sample(INDEX,LOCATION,LIMIT) pragma. file: [74d46e32] check-in: [affc2ef5] user: drh branch: est_count_pragma, size: 16268
2016-10-20
22:02
Experimental est_count pragma. file: [30d65596] check-in: [340822af] user: drh branch: est_count_pragma, size: 16071
2016-02-27
17:16
Experimental "PRAGMA onconflict=FAIL" statement to change the default ON CONFLICT algorithm to something other than ABORT. file: [0639ea99] check-in: [3a0c347c] user: drh branch: pragma-onconflict, size: 16102
2015-12-15
13:50
Add the SQLITE_OMIT_PARSER_TRACE compile-time option. file: [64c78a64] check-in: [2fda43e6] user: drh branch: trunk, size: 15880
2015-11-12
22:15
Always parse the schema *before* running "PRAGMA cache_size", not after. file: [3d94aebb] check-in: [12e7d9ec] user: drh branch: trunk, size: 15842
14:57
First attempt at enhancing the "PRAGMA cache_spill" statement to accept a cache threashold size. file: [31b110aa] check-in: [549d42be] user: drh branch: cache_spill=N, size: 15824
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: [631a91c8] check-in: [b79a4aff] user: drh branch: trunk, size: 15784
2015-05-27
03:46
Add the "PRAGMA cell_size_check=ON" command. file: [b8632d7c] check-in: [2ead43f0] user: drh branch: cell-size-check-pragma, size: 15802
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: [d2f776d7] check-in: [21e95d28] user: drh branch: ota-update, size: 15882
23:13
Merge all recent trunk changes, including the movement of the pragma table into the separate pragma.h header file. file: [09c89bca] check-in: [3af19f84] user: drh branch: index_xinfo, size: 15661
2015-02-02
22:19
Add an experimental pragma "PRAGMA preload;" that preloads the pcache with the entire database file. file: [32eb95f8] check-in: [6dca23e6] user: drh branch: preload-pragma, size: 15685
21:34
Break out the (script-generated) pragma parsing tables into a separate file, pragma.h, to make editing easier. file: [28804eae] check-in: [32c0325b] user: drh branch: trunk, size: 15516 Added