SQLite

All files named ”src/sqliteLimit.h”
Login

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

History for src/sqliteLimit.h

2025-02-21
20:35
[6d817c28a8] part of check-in [5822feec43] The number of declared columns in an index is limited to SQLITE_LIMIT_COLUMN. But the actual number of columns in the implementation might need to be twice as much to account for the primary key at the end. Ensure that the code is able to deal with this. This is a correction to check-in [d7729dbbf231d57c]. (check-in: [5822feec43] user: drh branch: trunk, size: 7334)
17:03
[b963c1e8c4] part of check-in [d7729dbbf2] Detect when a UNIQUE or PRIMARY KEY on a WITHOUT ROWID table would need to use more than SQLITE_LIMIT_COLUMN columns and raise an error. Also include some unrelated compiler warning fixes. (check-in: [d7729dbbf2] user: drh branch: trunk, size: 7014)
2024-12-12
20:39
[da2cffdffa] part of check-in [3c25c69c93] Increase the maximum number of arguments on an SQL function to 1000 with the capability to increase it further up to 32767 using a compile-time option. (check-in: [3c25c69c93] user: drh branch: cf8f1552-commit-instr, size: 6859)
15:11
[1bbdbf72bd] part of check-in [e8d7d68ba0] Increase the maximum number of arguments on an SQL function to 1000 with the capability to increase it further up to 32767 using a compile-time option. (check-in: [e8d7d68ba0] user: drh branch: trunk, size: 6931)
2024-11-08
20:57
[6993c9cfe3] part of check-in [6aa01707af] Increase the minimum SQLITE_LENGTH_LIMIT from 1 to 30 to avoid problems doing simple things like converting strings into integers. See also [8fd5b8ec4ab9b555]. (check-in: [6aa01707af] user: drh branch: trunk, size: 6770)
2024-01-03
15:49
[6878ab64bd] part of check-in [e3acb8a43a] Change a constant from decimal to hex to avoid a compiler warning on Mac. (check-in: [e3acb8a43a] user: drh branch: trunk, size: 6698)
2024-01-02
20:34
[0c4b40bfeb] part of check-in [ffb35f1784] Increase the default "max_page_count" to its theoretical maximum of 4294967294. (check-in: [ffb35f1784] user: drh branch: trunk, size: 6681)
2023-06-07
08:40
[33b1c9baba] part of check-in [26c1bb4bd9] Add a C-source spell-checking facility. make misspell (on Nix) (check-in: [26c1bb4bd9] user: larrybr branch: spell-check, size: 6681)
2020-08-20
16:25
[d7323ffea5] part of check-in [5f58dd3a19] Fix a crash that could occur in SQLITE_MAX_EXPR_DEPTH=0 builds when processing SQL containing syntax errors. (check-in: [5f58dd3a19] user: dan branch: trunk, size: 6690)
2020-07-29
16:18
[2e76fa8b00] part of check-in [a80ae2c98b] Dozens and dozens of typo fixes in comments. This change adds no value to the end product and is disruptive, so it is questionable whether or not it will ever land on trunk. (check-in: [a80ae2c98b] user: drh branch: typos, size: 6796)
2020-02-12
20:50
[95cb8479ca] part of check-in [2def75693a] Increase the default upper bound on the number of parameters in a single SQL statement to 32766 (from 999). (check-in: [2def75693a] user: drh branch: trunk, size: 6796)
2019-11-07
19:59
[b1f05b390d] part of check-in [4ab9dbb939] Experimental branch to provide SQLITE_LIMIT_HEAP_K to limit the amount of allocated memory used by each database connection, individually. (check-in: [4ab9dbb939] user: drh branch: limit_heap_k, size: 7009)
2017-03-17
22:50
[1513bfb7b2] part of check-in [ef59146170] Begin enforcing the SQLITE_LIMIT_VDBE_OP. The documentation warned that this day might come. (check-in: [ef59146170] user: drh branch: trunk, size: 6609)
2016-06-24
02:21
[c845c0868e] part of check-in [a2778ae494] Provide for a separate default page size for TEMP and transient database files and initialize that separate default page size to 1024 instead of 4096. (check-in: [a2778ae494] user: drh branch: temp-page-size, size: 6854)
2016-03-23
13:46
[c0373387c2] part of check-in [412984642a] Update a requirement mark. No changes to code. (check-in: [412984642a] user: drh branch: trunk, size: 6605)
2016-03-04
04:01
[7b28cf72cb] part of check-in [2682e8e413] Change the default cache_size to -2000 (which means 2000*1024 bytes independent of page_size). (check-in: [2682e8e413] user: drh branch: trunk, size: 6549)
03:43
[7c17293db6] part of check-in [2e8a9ca9d3] Change the default page size for new database files to 4096 (from 1024). Except, when building the testfixture, preserve the legacy page size. Also fix a comment on SQLITE_MAX_ATTACHED. (check-in: [2e8a9ca9d3] user: drh branch: trunk, size: 6543)
2015-05-02
18:25
[c647cd30d5] part of check-in [f8b159794c] Add the SQLITE_LIMIT_PRINTF_WIDTH setting for sqlite3_limit() and associated logic for preventing DOS attacks using printf() with oversized widths or precisions. (check-in: [f8b159794c] user: drh branch: limit-printf-width, size: 6619)
2015-02-27
21:53
[216557999c] part of check-in [766ad65025] Remove all references to SQLITE_DEFAULT_TEMP_CACHE_SIZE. Add requirements marks related to cache_size changing. (check-in: [766ad65025] user: drh branch: trunk, size: 6440)
20:28
[a3bf51a748] part of check-in [8c2b29d9ac] New requirements marks and a few new test cases to go with them. No changes to code. (check-in: [8c2b29d9ac] user: drh branch: trunk, size: 6511)
2013-04-08
20:47
[3ea5c07b37] part of check-in [8a4314a398] Disable the use of memory-mapped I/O if the SQLITE_DISABLE_MMAP macro is defined. Automatically define this macro for OpenBSD and QNX. Other systems are likely to be added to the disabled list over time. (check-in: [8a4314a398] user: drh branch: trunk, size: 6898)
2013-04-03
13:38
[1097d2c541] part of check-in [ac1432b3a8] Fix a bug in the detection of iOS when setting the default mmap_limit. (check-in: [ac1432b3a8] user: drh branch: experimental-mmap, size: 6793)
13:09
[299a15148f] part of check-in [2d9f1327fe] Change the mmap_limit pragma to report the new limit, or to report the existing limit if called with no arguments. Report the default mmap_limit as part of PRAGMA compile_options. Set the default mmmap_limit to 0 for all systems other than linux, mac, windows, and solaris. (check-in: [2d9f1327fe] user: drh branch: experimental-mmap, size: 6802)
2013-04-02
18:25
[edc1e61e6b] part of check-in [d36ce0bbad] Fix the build for Mac. (check-in: [d36ce0bbad] user: drh branch: experimental-mmap, size: 6930)
10:29
[4d8d04c43b] part of check-in [d96272f031] Proposed template preprocessor magic for activating mmap only on platforms where we know it works. (check-in: [d96272f031] user: drh branch: experimental-mmap, size: 6928)
2013-03-25
23:09
[83d0cd0ce3] part of check-in [1b37c4effd] Memory-mapped I/O is now on by default. The "PRAGMA mmap_limit(N)" can be used to issue a hint to the VFS to limit mmap space to N bytes. The VFS is free to ignore that hint if desired. However, if "PRAGMA mmap_limit(0)" is used, xFetch is never called. (check-in: [1b37c4effd] user: drh branch: experimental-mmap, size: 6477)
2011-04-06
12:38
[164b0e6749] part of check-in [b7296fd380] Update a comment in sqliteLimit.h. No changes to code or tests. (check-in: [b7296fd380] user: dan branch: trunk, size: 6317)
2010-08-18
15:25
[a17dcd3fb7] part of check-in [56cc883d3a] Disable the SQLITE_MAX_PAGE_SIZE compile time option (it is now always set to 65536). Fix some other problems in test files. (check-in: [56cc883d3a] user: dan branch: trunk, size: 6317)
2010-08-12
02:41
[4ae9b00514] part of check-in [45362437d4] Increase the maximum page size from 32k to 64k. (check-in: [45362437d4] user: drh branch: trunk, size: 6180)
2010-05-03
11:05
[196e2f83c3] part of check-in [714e594726] Add the "PRAGMA wal_autocheckpoint" command. Rename "PRAGMA checkpoint" to "PRAGMA wal_checkpoint". (check-in: [714e594726] user: dan branch: wal, size: 6257)
2009-11-10
01:30
[3afab22917] part of check-in [f6c045f649] Remove the obsolete "$Id:$" RCS identifier strings from the source code. (check-in: [f6c045f649] user: drh branch: trunk, size: 6040)
2009-11-05
17:27
[285dd71407] part of check-in [bd443f39a9] Do not limit the trigger recursion depth when SQLITE_SMALL_STACK is defined since trigger recursion uses the heap, not the stack. (check-in: [bd443f39a9] user: drh branch: shunning-error, size: 6115)
2009-10-07
18:41
[38b2fffcd0] part of check-in [8382867956] Add some tests of statements in foreignkeys.html. (check-in: [8382867956] user: dan branch: trunk, size: 6197)
2009-09-10
02:54
[504a316188] part of check-in [913fb70ea8] Reduce default SQLITE_MAX_TRIGGER_DEPTH when SQLITE_SMALL_STACK is defined. (check-in: [913fb70ea8] user: shane branch: trunk, size: 6028)
2009-09-07
18:14
[be44f7f46c] part of check-in [d7dc8b4336] Add the SQLITE_LIMIT_TRIGGER_DEPTH option to sqlite3_limit(). (check-in: [d7dc8b4336] user: drh branch: trunk, size: 5946)
2009-01-10
16:15
[ffe93f5a0c] part of check-in [855c4093cf] Improve coverage of pager.c. (CVS 6158) (check-in: [855c4093cf] user: danielk1977 branch: trunk, size: 5816)
2009-01-07
16:15
[651a2757ba] part of check-in [1fe79ffd77] Change SQLITE_MAX_FUNCTION_ARG from 100 to 127 to match invariant H16124. Ticket #3567. (CVS 6134) (check-in: [1fe79ffd77] user: danielk1977 branch: trunk, size: 5415)
2008-03-26
15:56
[f435e728c6] part of check-in [d016d07840] Change comment in sqliteLimit.h to correctly describe the SQLITE_MAX_ATTACHED #define. Ticket #3016. (CVS 4920) (check-in: [d016d07840] user: drh branch: trunk, size: 5407)
2008-03-20
14:03
[eecbc288b4] part of check-in [60c77882b2] Initial implementation of per-connection limits and the sqlite3_limit() API. The sqllimits1.test script crashes. SQLITE_LIMIT_PAGE_COUNT and SQLITE_LIMIT_VDBE_OP are currently ignored. (CVS 4897) (check-in: [60c77882b2] user: drh branch: trunk, size: 5525)
2007-12-17
16:20
[ee4430f88f] part of check-in [07aeca3b9c] When SQLITE_MAX_SQL_LENGTH is 0, disable the limit. Make the default 0. Once again build the sqlite3 CLI from individual source files so that it can be built on systems that lack tclsh. Tickets #2845 and #2846. (CVS 4636) (check-in: [07aeca3b9c] user: drh branch: trunk, size: 5341)
2007-12-13
21:54
[e9831389ad] part of check-in [4e91a267fe] Change all instances of "it's" in comments to either "its" or "it is", as appropriate, in case the comments are ever again read by a pedantic grammarian. Ticket #2840. (CVS 4629) (check-in: [4e91a267fe] user: drh branch: trunk, size: 5335)
2007-12-11
20:04
[3657c8eb75] part of check-in [9335c94050] Fix a comment on the SQLITE_SQL_MAX_LENGTH definition. (CVS 4610) (check-in: [9335c94050] user: drh branch: trunk, size: 5336)
2007-11-05
14:30
[15ffe21167] part of check-in [9c2731f143] Make sure the default page size never exceeds the maximum page size. (CVS 4525) (check-in: [9c2731f143] user: drh branch: trunk, size: 5361)
2007-08-24
11:52
[1bcbbdfa85] part of check-in [13dda2e8e8] Select the default page size for new databases based on the sector-size and IOCAP flags. (CVS 4286) (check-in: [13dda2e8e8] user: danielk1977 branch: trunk, size: 5065)
2007-06-19
15:23
Added: [f14609c276] part of check-in [64bcc41f12] Change the name of the "limits.h" source file to "sqliteLimit.h". Ticket #2428. (CVS 4091) (check-in: [64bcc41f12] user: drh branch: trunk, size: 4642)