Many hyperlinks are disabled.
Use anonymous login
to enable hyperlinks.
History of tool/mkpragmatab.tcl
|
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 | |