/ File History
Login
SQLite training in Houston TX on 2019-11-05 (details)
Part of the 2019 Tcl Conference

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

History of src/global.c

2019-09-23
12:38
Omit the sqlite3IntTokens array constant for a code simplification. file: [a1a8d698] check-in: [f907395e] user: drh branch: trunk, size: 13795
2019-08-12
14:17
Add a TESTCTRL that disables the verification of type, name, and tbl_name in the sqlite_master table. file: [d7a7a45a] check-in: [48d9b48a] user: drh branch: trunk, size: 13908
2019-08-02
20:45
Add the SQLITE_TESTCTRL_PRNG_SEED test control. file: [0c9c4584] check-in: [3ac57231] user: drh branch: prng-seed-test-control, size: 13853
2019-06-14
17:37
Deprecate the SQLITE_ALLOW_COVERING_INDEX_SCAN compile-time option when it is turned off. This probably will impact no-one. If it does, they will get an error message instructing them to contact developers, so that we can get feedback that somebody is actually using this feature. Start-time disabling of covering index scan is not affected. file: [1e942b1e] check-in: [23e49f99] user: drh branch: trunk, size: 13807
2019-01-31
15:38
Add the SQLITE_CONFIG_MEMDB_MAXSIZE configuration option for configuring the default maximum size of an in-memory database created using sqlite3_deserialize(). This is necessary to make the interface reasonably testable. file: [0dea3065] check-in: [cb72ee04] user: drh branch: trunk, size: 13500
2018-11-26
18:09
Do not allow direct access to internal-use SQL functions such as sqlite_rename_column() and sqlite3_rename_table() except when the new SQLITE_TESTCTRL_INTERNAL_FUNCTIONS flag is set. file: [8291eee0] check-in: [6e133054] user: drh branch: trunk, size: 13217
2018-06-19
19:01
OFD locks are now mostly working, but need additional tests. file: [58ab3df8] check-in: [4f1fb5c9] user: drh branch: ofd-locks, size: 13208
2018-04-16
21:12
Add SQLITE_CONFIG_SORTERREF_SIZE configuration option. file: [9bf034fd] check-in: [b25a7bb7] user: dan branch: sorter-reference, size: 13162
2018-02-12
20:27
When compiling with VDBE_PROFILE, add the sqlite3NProfileCnt global variable which can be used to measure per-opcode values other than elapse time, if non-zero. file: [01506976] check-in: [d44d5936] user: drh branch: trunk, size: 13109
2017-08-28
15:51
Remove the rarely-used scratch memory allocator. This makes the code smaller, faster, and easier to maintain. In place of the scratch allocator, add the SQLITE_CONFIG_SMALL_MALLOC configuration option that provides a hint to SQLite that large memory allocations should be avoided. file: [ac3094f1] check-in: [54b00024] user: drh branch: trunk, size: 12905
2017-05-03
15:54
Always enable URI filenames when compiling with SQLITE_HAS_CODEC. Also allow plaintext keys using the key= query parameter. file: [8a6ab6b4] check-in: [31a51b4d] user: drh branch: trunk, size: 12992
2017-01-02
19:02
Provide the SQLITE_DEFAULT_LOOKASIDE compile-time option and make it's default value be 1200,100 (raised from 512,125 in the latest release). file: [4a34512d] check-in: [584da48f] user: drh branch: trunk, size: 12847
2016-12-21
21:26
Change the default lookaside configuration from 500 slots of 128 bytes each to 125 slots of 512 bytes each. This uses the same amount of memory (64,000 bytes) but seems to perform much better in test applications. file: [dcdb89f3] check-in: [52a12e47] user: drh branch: trunk, size: 12396
2016-12-07
15:49
Rename the SQLITE_OMIT_BUILTIN_TEST compile-time option to SQLITE_UNTESTABLE. file: [235021a2] check-in: [f3608187] user: drh branch: trunk, size: 12396
2016-09-29
15:53
Clarification and typo-fixes in comments. No changes to code. file: [9da4ca5d] check-in: [e2cd79aa] user: drh branch: trunk, size: 12403
2016-09-18
16:08
Revise the implementation of OP_Once so that it is smaller, faster, and uses less memory. This also fixes an obscure bug introduced 3 days ago by check-in [5990a1bdb4a073]. file: [2917bbc4] check-in: [6bf5ba10] user: drh branch: trunk, size: 12541
2016-04-11
19:01
Performance optimization to sqlite3Dequote() and its callers. file: [c45ea22a] check-in: [9efe2265] user: drh branch: trunk, size: 12485
2016-03-07
17:37
Add the SQLITE_CONFIG_STMTJRNL_SPILL option for sqlite3_config(). file: [884d4c7e] check-in: [b6c42024] user: drh branch: trunk, size: 12442
2016-02-15
00:34
Improvements to the application-defined function mechanism so that it is more compact and runs faster, especially when the application defines thousands of new SQL functions. file: [ded7b97e] check-in: [3201fbcc] user: drh branch: many-app-functions, size: 11861
2015-12-30
16:51
Changes to the way that the default BINARY collating sequence is recorded result in a slightly smaller and slightly faster executable. More work could be done to make this cleaner. file: [bd5a0af3] check-in: [2081d757] user: drh branch: trunk, size: 11871
2015-09-11
05:06
Enhance mutex initialization to prevent possible race conditions between sqlite3_initialize() and sqlite3_config(). Also, re-check sqlite3GlobalConfig.isInit after the mutex subsystem has been initialized. file: [d8241636] check-in: [f6a8f577] user: mistachkin branch: mutexInitCmpSwap, size: 11823
2015-07-07
21:14
Add a compile-time constant for configuring the default pagecache setup. file: [508e4087] check-in: [ad5fdfba] user: drh branch: pcache-bulk-local, size: 11780
2015-07-06
18:54
Enhance separate pcache1 to allocate a block of pages from heap on startup, if possible, for a 5.2% performance improvement. file: [32c0ebfd] check-in: [aa7341c8] user: drh branch: pcache-bulk-local, size: 11777
2015-06-01
17:32
Break out the query flattener into a separate source-code file. file: [5aee11be] check-in: [e3fa8b93] user: drh branch: flattener-in-new-file, size: 11905
2015-02-19
17:16
Fix errors in the EBCDIC upper-case to lower-case translation table. file: [4f77cadb] check-in: [905009f6] user: drh branch: trunk, size: 11777
2015-01-02
15:55
Add the SQLITE_CONFIG_PMASZ start-time option. file: [12561d70] check-in: [acb0d1e8] user: drh branch: trunk, size: 11777
2014-11-07
13:24
Fix harmless typos in comments. file: [6ded36dd] check-in: [94c564da] user: drh branch: trunk, size: 11568
2014-11-04
17:23
Add various requirements evidence marks for sqlite3_config() options. file: [a50ad0b9] check-in: [d423349d] user: drh branch: trunk, size: 11566
2014-10-04
11:59
Updates to documentation and requirements marks. No code changes. file: [01c1f36e] check-in: [0f8102d7] user: drh branch: trunk, size: 11209
2014-09-06
16:39
Fix typos in comments. No code changes. file: [5110fa12] check-in: [e62aab5e] user: peter.d.reid branch: trunk, size: 10897
2014-05-16
14:27
Merge all recent changes from trunk, and especially the new sqlite3FaultSim() interface. file: [77ec119d] check-in: [43fcbd91] user: drh branch: threads, size: 10945
14:17
Repurpose the SQLITE_TESTCTRL_FAULT_INSTALL test-control to register a callback to be invoked by sqlite3FaultSim(). That test-control has been unused since 2008-06-20 and was never used in any official release. file: [1e4bd956] check-in: [0d43a7ad] user: drh branch: trunk, size: 10896
2014-05-03
11:22
Add the SQLITE_DEFAULT_WORKER_THREADS compile-time option. Fix a NULL-pointer dereference that can occur following OOM. file: [b7943ff4] check-in: [e0dea89b] user: drh branch: threads, size: 10722
2014-04-01
15:38
Even if compile time option SQLITE_MAX_WORKER_THREADS is set to one or greater, set the default number of worker threads to zero. Distribute data more evenly between threads in sqlite3VdbeSorterWrite() to improve performance when sorting large amounts of data. Add new test file sort2.test. file: [deadd872] check-in: [643c86a0] user: dan branch: threads, size: 10717
2014-03-31
19:57
Add the SQLITE_MAX_WORKER_THREADS compile time option. And the SQLITE_CONFIG_WORKER_THREADS sqlite3_config() switch. file: [57d9dd92] check-in: [2774710d] user: dan branch: threads, size: 10717
2013-11-29
15:06
Add a new sqlite3_test_control() that indicates that database files are always well-formed. Use this during testing to enable assert() statements that prove conditions that are always true for well-formed databases. file: [1d7bb7ea] check-in: [15e4f63d] user: drh branch: trunk, size: 10673
2013-04-15
17:03
Refactoring the mmap interface. The controlling pragma is now "mmap_size" instead of "mmap_limit". Also change SQLITE_CONFIG_MMAP_LIMIT and SQLITE_FCNTL_MMAP_LIMIT to SQLITE_CONFIG_MMAP_SIZE and SQLITE_FCNTL_MMAP_SIZE, respecctively. The default mmap_size is now always 0, meaning that memory mapped I/O is off by default. There is a new compile-time option SQLITE_MAX_MMAP_SIZE that determines a hard upper bound on the mmap_size. Setting SQLITE_MAX_MMAP_SIZE to zero disables the memory-mapped I/O logic and causes it to be omitted from the build. An extra argument is added to SQLITE_CONFIG_MMAP_SIZE that can optionally lower the SQLITE_MAX_MMAP_SIZE at start-time. The SQLITE_MAX_MMAP_SIZE is zero for platforms where we know that it does not work, meaning that it cannot be turned on by mistake on those platforms. file: [5caf4dea] check-in: [ea1404a1] user: drh branch: trunk, size: 10625
2013-04-01
22:38
Add the SQLITE_CONFIG_MMAP_LIMIT configuration option for overriding the SQLITE_DEFAULT_MMAP_LIMIT compile-time setting. Enhance "PRAGMA mmap_limit" so that without a specific database name, it sets the limit on all database files and changes the default for any future databases that might be added using ATTACH. file: [d2494a1c] check-in: [78141d0a] user: drh branch: experimental-mmap, size: 10605
2012-12-08
06:46
Merge updates from trunk. file: [36c6d660] check-in: [e65db42c] user: mistachkin branch: configReadOnly, size: 10585
2012-11-26
19:50
Add an option to register global hooks used for logging all SQL executed by an application. file: [e59ecd2c] check-in: [cd501bbc] user: dan branch: sqllog, size: 10539
2012-09-25
12:45
Merge updates from trunk. file: [617cf51a] check-in: [4a470741] user: mistachkin branch: configReadOnly, size: 10459
2012-09-17
20:44
Add the ability to disable the covering-index-scan optimization at compile-time, start-time, or at run-time. Add test cases to check this configurability. file: [fb44b11e] check-in: [ccb8ecc3] user: drh branch: fullscan-covering-index, size: 10413
2012-09-10
10:29
Initial prototype of SQLITE_CONFIG_READONLY. file: [2f3b6eb7] check-in: [7c340165] user: mistachkin branch: configReadOnly, size: 10313
2011-12-11
02:29
Fix harmless compiler warnings. file: [4cfdca5c] check-in: [1e6a698a] user: drh branch: trunk, size: 10267
2011-11-08
20:08
Experimental change to the pcache interface to allow page buffers to be allocated separately from their associated container structures. file: [107ccaac] check-in: [c275c9d3] user: dan branch: experimental-pcache, size: 10266
2011-09-19
13:01
Increase the default lookaside cache line size from 100 to 128 bytes. file: [e230227d] check-in: [db019465] user: drh branch: trunk, size: 10265
2011-06-21
15:27
Add a missing initializer for sqlite3GlobalConfig.bLocaltimeFault. file: [c70a46f2] check-in: [7fe8ba2e] user: dan branch: trunk, size: 10265
2011-04-22
19:37
Add the start of the "uri-filenames" feature. file: [29bfb856] check-in: [b8a8132e] user: dan branch: uri, size: 10213
2010-07-14
18:24
Make the result of an IN or NOT IN expression with an empty set on the right-hand side always either false or true, respectively, even if the left-hand side is NULL. Ticket [80e031a00f45dc] file: [02335177] check-in: [c288ac64] user: drh branch: trunk, size: 10112
2010-06-03
12:09
Remove global variables when compiled with SQLITE_OMIT_WSD file: [3fedfe02] check-in: [dd10a547] user: drh branch: trunk, size: 9998
2010-02-18
18:45
Add a new, experimental logging interface designed to aid in debugging of deeply embedded projects that use SQLite. file: [5a9c1e3c] check-in: [103321e3] user: drh branch: trunk, size: 9967
2009-11-16
15:11
Use the sqlite3CtypeMap to improve the speed and reduce the size of the logic in the tokenizer that recognizes identifiers. file: [75946a4a] check-in: [1c9243b0] user: drh branch: trunk, size: 9882
2009-11-14
23:22
Optimizations to the main loop inside sqlite3VdbeExec() to help VDBE byte code run a few percent faster. file: [9481e307] check-in: [d622ac6a] user: drh branch: trunk, size: 9577
2009-08-17
15:16
Add tests to check that sqlite recovers from an error in sqlite3_initialize() correctly. file: [271952d1] check-in: [904a371c] user: dan branch: trunk, size: 9274
13:42
Enhanced documentation and minor code tweaks in preparation for hardening the sqlite3_initialize/shutdown interfaces against initialization failures. file: [263dea92] check-in: [98c49e61] user: drh branch: trunk, size: 9234
2009-02-05
16:31
Make the pending byte adjustable via sqlite3_test_control() on all builds, not just on test builds. (CVS 6263) file: [448419c4] check-in: [e8f192e2] user: drh branch: trunk, size: 9220
2009-01-24
11:30
Fix some minor compiler warnings. Added sqlite3Isalpha() for use in the soundex() function. (CVS 6203) file: [ab003581] check-in: [bfc71edc] user: drh branch: trunk, size: 8305
2009-01-20
16:53
When not compiling for an EBCDIC system, use built-in alternatives to the tolowe r(), toupper() and other ctype.h library functions. Ticket #3597. (CVS 6196) file: [9dd8b611] check-in: [1041abd6] user: danielk1977 branch: trunk, size: 8280
2008-12-08
18:19
The amalgamation now compiles cleanly on GCC with options -pedantic-errors -Wno-long-long. (CVS 5991) file: [91723e45] check-in: [73c7302c] user: drh branch: trunk, size: 4802
2008-09-04
17:17
Add support for the SQLITE_THREADSAFE=2 and SQLITE_DEFAULT_MEMSTATUS compilation options. (CVS 5676) file: [20a3fe46] check-in: [85c2a589] user: danielk1977 branch: trunk, size: 3945
2008-09-01
18:34
Begin adding support for the SQLITE_OMIT_WSD macro. Some (many) WSD variables still need wrappers added to them. (CVS 5652) file: [9ced7c26] check-in: [573d92ab] user: danielk1977 branch: trunk, size: 3891
2008-08-21
20:21
Move date+time functions to start-time initialization. Additional start-time function cleanup. (CVS 5585) file: [239d03b6] check-in: [80d6a31c] user: drh branch: trunk, size: 3861
18:49
Initialize the global built-in function table at start-time instead of at compile-time. This is less prone to malfunction when compile-time parameters very. (CVS 5583) file: [39350827] check-in: [ef6936e5] user: drh branch: trunk, size: 3858
2008-07-28
19:34
Implement the "lookaside" memory allocation cache. Use of this cache makes the speed1.test script run about 15% faster. Added new interfaces to control the cache. (CVS 5488) file: [b9c96ee2] check-in: [e48f9697] user: drh branch: trunk, size: 3680
2008-07-08
14:52
Improved enforcement of the SQLITE_LIMIT_LENGTH limit. (CVS 5368) file: [f12dc84d] check-in: [ee931508] user: drh branch: trunk, size: 3433
2008-06-14
16:56
Continuing progress on the new memory allocation subsystem. Added the sqlite3_mem_methods structure for defining new memory allocators at run-time. (CVS 5219) file: [2304cfa3] check-in: [f00305f4] user: drh branch: trunk, size: 3422
2008-06-13
18:24
Progress toward implementation of sqlite3_config() and a rework of the mutex and memory allocation subsystems. This is an incremental check-in. (CVS 5218) file: [8a5c66b6] check-in: [a03c5af1] user: drh branch: trunk, size: 3407 Added