database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-05 15:55:57 +03:00
Code Activity
30,100 Commits 1,570 Branches 183 Tags
optimize-null-values
Commit Graph

226 Commits

Author SHA1 Message Date
drh
c2e400af04 New assert() statements to validate OP_OpenEphemeral logic. 
FossilOrigin-Name: 6d55c3e238e06c6727f3e816a9268b6222ebfc90ec745bbbd48430bf7b16664c
 2024-10-18 01:14:14 +00:00
dan
d90ecb5d6e Have "PRAGMA quick_check" compare the number of entries in tables and indexes. 
FossilOrigin-Name: cc294c041b4c7a044ff344989f872415ced5263a0b654112371b2da7c852a688
 2024-02-02 16:51:24 +00:00
drh
594f5e24c4 The OP_Column opcode caches large column values coming from overflow pages. 
FossilOrigin-Name: ab1edcc7fedcf27922d5db4bc1bc673b1495ca9c66eb6debdda7b7776c068888
 2023-07-27 19:39:53 +00:00
drh
5dd74bf384 Improved progress-handler and interrupt detection during PRAGMA integrity_check. 
FossilOrigin-Name: 6db42780a9e530bcc94490cc6080536309666dc13523272d1799d6661137e908
 2023-01-11 16:17:31 +00:00
dan
1b3d13e65e Add the SQLITE_FCNTL_RESET_CACHE verb. Use it to ensure that the page cache is purged before and after a the recovery extension is run. 
FossilOrigin-Name: 6db0bc4bc0d272b610bef2aeeae43f539ed6e7cc0a9cc767d5af85ecb0019d5f
 2022-11-28 18:41:41 +00:00
drh
08efa45113 Fix harmless typo in comment, reported by Debian in Fossil 
[https://fossil-scm.org/forum/forumpost/15f7327318].

FossilOrigin-Name: 5689f0d9ad1be532b274508938b25ff0d63027b8cc31f796dfaa2cca71d53642
 2022-11-16 19:57:21 +00:00
dan
2c7188732d Add the sqlite3_changes64() and sqlite3_total_changes64() API functions. 
FossilOrigin-Name: 48fdec22c966003f5577e0bf52906ef90df11e4e395723a646304e67ed976f37
 2021-06-22 18:32:05 +00:00
drh
42a410dcad Split the sqlite3BtreeMovetoUnpacked() routine into two separate routines 
sqlite3BtreeTableMoveto() and sqlite3BtreeIndexMoveto(), since we usually
know the type of btree in advance.  This results in less branching and
better performance.

FossilOrigin-Name: 3b0d34e5e5f9a16c3397e4551f3b534729b1b375770f05f6ed5847818b1f4c0b
 2021-06-19 18:32:20 +00:00
dan
4049ede97d Update a comment in btree.h. 
FossilOrigin-Name: 9645fe1a050e8b61aea1fba2f142819c387ecb043741392c5719bf7ad303bf8b
 2021-03-09 21:20:12 +00:00
dan
7aae73588a Better integrate the changes on this branch with OP_Insert and OP_IdxInsert. 
FossilOrigin-Name: 101cef14910d6e865a94bc870aed599321b893188062a9a61d70a9434992cf23
 2020-12-10 18:06:24 +00:00
dan
cd1b2d0b54 Transfer large index or WITHOUT ROWID records between b-trees when vacuuming without loading them into memory. 
FossilOrigin-Name: dfd4ca6891a893d0e9551689954d3e79114d5565f8a5264f96ad1d64fe1d6280
 2020-12-09 20:33:51 +00:00
dan
036e0675e6 Experimental changes to vacuum to avoid loading large records entirely into memory. Currently only works in limited cases only - for rowid tables when the page-size does not change. 
FossilOrigin-Name: c90e063ca9ddcdd1e9f1a2e25a3f7d6e7ee798373ad8acf65b90536b0a124c0d
 2020-12-08 20:19:07 +00:00
shearer
1e6c58dee2 Better understanding of savepoint code 
FossilOrigin-Name: ce6d8d621505f25e4fd43e7cf27445e1a2ddd58d79108d63499c2ae30cc9f610
 2020-09-30 09:17:53 +00:00
drh
37ccfcfeb9 New test-control that returns the number of calls to 
sqlite3BtreeMovetoUnpacked() on the main database and then resets the
counter.  This only works for SQLITE_DEBUG builds.

FossilOrigin-Name: dca5b91926431768babac28a6faf7674a5014db95caba727995b470e92b3182a
 2020-08-31 18:49:04 +00:00
drh
99744fa4ab Add support for the sqlite3_txn_state() interface. 
FossilOrigin-Name: ad195e3dd89d0f33b50070c18fb8f43c4eb24162515dfdd7c04d9e7d96b902a2
 2020-08-25 19:09:07 +00:00
drh
584e8b7630 All TCL tests now passing. 
FossilOrigin-Name: 4c5f3c6cacf84a36d0347790d98d82d1f584cd1537a13a2736348405c4d20367
 2020-07-22 17:12:59 +00:00
drh
abc3815860 Continuing work toward supporting unsigned 32-bit page numbers. 
FossilOrigin-Name: 9ce1710aad43cebe5ad50859c7685fb83e40cdd4a60913bd2b7e659bc59942fd
 2020-07-22 13:38:04 +00:00
drh
e9261dbd53 Initial changes to allow database up to 281TB in size. 
FossilOrigin-Name: 9cb7da9bdb666ea40771513b89591dca275f1e92092b39190df747e3797178a3
 2020-07-20 12:47:32 +00:00
drh
067b92ba00 Extend the refactoring into extensions. Clean up stray newlines. 
FossilOrigin-Name: 7a876209a678a34c198b54ceef9e3c041f128a14dc73357f6a57cadadaa6cf7b
 2020-06-19 15:24:12 +00:00
drh
e754830eae Merge recent trunk enhancements. 
FossilOrigin-Name: 2100b2c8f339e9778723fa0c91e479bab8675cf6fbea1664b6af49f40db6d27b
 2020-05-01 15:04:13 +00:00
drh
45248de39a The SQLITE_TESTCTRL_RESERVE operator is removed. In its place is the 
more generate SQLITE_FCNTL_RESERVE_BYTES which is an API and which can
operator on more than just the main schema.

FossilOrigin-Name: abc1aad74f7b6a1e72fb09936239f2224aa942d16296c6a3de0b8daef4bc8471
 2020-04-20 15:18:43 +00:00
drh
e50478d727 Remove the SQLITE_OMIT_BTREECOUNT option. Btree count is required. 
FossilOrigin-Name: a9bfa47aeea27e91611ba913d33e6635d2016e2c2ab78f9b0657f1bd8933e1a8
 2020-03-17 13:41:51 +00:00
drh
7b14b65d20 Do not allow triggers that run as part of REPLACE conflict resolution 
during an UPDATE to modify the the table being updated.  Otherwise, those
triggers might delete content out from under the update operation, leading
to all kinds of problems.  Ticket [314cc133e5ada126]

FossilOrigin-Name: db4b7e1dc399c1f16b827ac087aa37c0815f4b2f41f1ffad59963eead2ab5562
 2019-12-29 22:08:20 +00:00
drh
21f6daa2cd Faster response to sqlite3_interrupt() in the OP_IntegrityCk and OP_Count 
opcodes.

FossilOrigin-Name: bf875dc59909f9c22f7c1fc843bc4d9e5d97af5cb4ef43c4fa1d566ddfdeaacb
 2019-10-11 14:21:48 +00:00
drh
038ebf6875 Remove the unused P5 flag from the OP_Rewind opcode. 
FossilOrigin-Name: c2edbf3b8c643edcd5823eb907fd7531cf5be8a8b6a014fa1b123eb0ea3231cf
 2019-03-29 15:21:22 +00:00
drh
53d30dd371 Early detection of implausibly sized records to avoid unnecessary 
large memory allocations.

FossilOrigin-Name: 2c8769c69f301307db6663adb8b7c0b89f5959516bf6110cb8ff4b21bd903f70
 2019-02-04 21:10:24 +00:00
dan
67a9b8eded Omit all window-function related code when building with SQLITE_OMIT_WINDOWFUNC. 
FossilOrigin-Name: 5f04b016467342b5a796bf702ed25b621eb86f2961c1e703d276c93f2cb6aa89
 2018-06-22 20:51:35 +00:00
dan
07509f8c1e Merge latest trunk changes with this branch. 
FossilOrigin-Name: 251022034219819a1dc356542770ff46e3147a080f072eb20af6106771dadd92
 2018-06-07 20:35:28 +00:00
drh
bb2d9b1bf1 Change sqlite3BtreeBeginTrans() to return the BTREE_SCHEMA_COOKIE, for a 
small speed improvement when starting new transactions.

FossilOrigin-Name: a10662aa915ae2b5a78b3e10920350d32255b2d6b1a8aac0aba1ad173b07ed2b
 2018-06-06 16:28:40 +00:00
dan
c3a20c19a8 Add support for "ROWS BETWEEN <expr> PRECEDING AND <expr> FOLLOWING" window 
frames.

FossilOrigin-Name: 3a203660f1e4da3b8d2d605c494f4843f6e00752f28042b49e11d7d6550dd406
 2018-05-23 20:55:37 +00:00
drh
89ee229810 Activate the cell-overwrite optimization for index b-trees. 
FossilOrigin-Name: a68697d10ef17d452c8279181186faad7bc54e3a35858a336552f717449065ea
 2018-05-07 18:41:19 +00:00
drh
092457b18c Change the function name to sqlite_unsupported_offset(X). Only enable the 
function if compiled with -DSQLITE_ENABLE_OFFSET_SQL_FUNC.  The makefiles add
that definition to shell builds.

FossilOrigin-Name: 7a7f826e324b1a2c332e2f1d0740fd0babffcaca6275a798572f02ad367b99ab
 2017-12-29 15:04:49 +00:00
drh
2fc865c115 Add an experimental location(X) SQL function that attempt to return the 
location of the payload within the database for the record that contains
column X.  location(X) returns NULL if X is not an ordinary table column or
if SQLite cannot figure out the location because it is using a covering index.

FossilOrigin-Name: 51be9558164301c5dd4df23ab8b3e67de0b522f8d36f79f3d84d45d3dc2a83a4
 2017-12-16 20:20:37 +00:00
drh
fe0cf7a18c Avoid a test for CURTYPE_BTREE in sqlite3VdbeCursorMoveto() in order to reduce 
the size and improve the performance of OP_Column.

FossilOrigin-Name: f078deb25149b7b1881b7f3374b343d0677e82336d8fdd7f1cdd06d926b5dd57
 2017-08-16 19:20:20 +00:00
drh
2ab792e4c0 Change sqlite3BtreeNext() and sqlite3BtreePrevious() so that they return 
SQLITE_DONE if they have already reached the end (or beginning) of the table.
This gives a performance increase and size reduction.

FossilOrigin-Name: e972a3860892022d57b26ec44ce0fbadc61c1ff54b7a10b7e82390db88d323a7
 2017-05-30 18:34:07 +00:00
drh
7a6ea93fd8 Do not expose the name of the internal Mem object in the public interface 
defined by sqlite3.h.

FossilOrigin-Name: 19dd753f9e50fee247b1ab141669817c7e88bc3f6d6065dba6c731db9f7a2409
 2017-04-09 19:23:55 +00:00
drh
5e98e838da The analyze_as_needed pragma now responds to table size growth and will 
automatically rerun the analysis after each 10x size increase.

FossilOrigin-Name: bfbdd07409688fac4ccddbab3639745f6152e23d
 2017-02-17 19:24:06 +00:00
dan
f91c1318f4 Changes to allow some multi-row UPDATE statements to avoid the two-pass 
approach.

FossilOrigin-Name: 46db23ccd116ce5b9d949f9293be8a2818411b46
 2017-01-10 20:04:38 +00:00
drh
cb3cabd01b Refactor the sqlite3BtreeKey() and sqlite3BtreeData() internal interfaces 
into sqlite3BtreePayload() and sqlite3BtreePayloadChecked(), respectively.
This is a continuation of the optimization started by check-in
[2d831074cf].  The result is a slightly smaller and faster binary.

FossilOrigin-Name: 49ebc219faea30eaa61def4a3fba2817b9c58a86
 2016-11-25 19:18:28 +00:00
drh
d6ef5afe3f Change the OP_Last opcode so that it is a no-op if the cursor is already 
pointing at the end of the b-tree.

FossilOrigin-Name: 663473850c4274270445b3771911fa773a8c405f
 2016-11-15 04:00:24 +00:00
drh
9b4eaebc68 Enhance the OP_IdxInsert opcode to optionally accept unpacked key material. 
FossilOrigin-Name: 89d958abbac45f2ca5954080cd9e74ec9a07ebb2
 2016-11-09 00:10:33 +00:00
drh
2eb22af03d Changes to give a warning-free build with SQLITE_OMIT_INCRBLOB and 
SQLITE_OMIT_SHARED_CACHE.

FossilOrigin-Name: 711c59171b22df04224183a713e6c36e0bb3bba8
 2016-09-10 19:51:40 +00:00
drh
43f58d6a17 Fix various internal #defines to conform to new C-language naming restrictions, 
specifically that private-use macros names must not begin with "_".

FossilOrigin-Name: 5471aca0158851d3fb0a2517306917536deb38bb
 2016-07-09 16:14:45 +00:00
dan
272989b44d Add the SQLITE_DBSTATUS_PROPORTIONAL_CACHE_USED sqlite3_db_status() parameter. 
FossilOrigin-Name: 118321c8b9d88b8f439c952436f42838c3fc80cb
 2016-07-06 10:12:02 +00:00
drh
a7c90c42ea Change the sqlite3BtreeKeySize() interface into sqlite3BtreeIntegerKey() and 
make it only work for table btrees.  Change sqlite3BtreeDataSize() into
sqlite3BtreePayloadSize() and make it work for all btrees.  Combine
sqlite3BtreeDataFetch() and sqlite3BtreeKeyFetch() into a single
sqlite3BtreePayloadFetch() routine.  These changes seem to make the
b-tree interface more rational and they reduce both binary size and
CPU usage.

FossilOrigin-Name: bef35e18dd19732f7859287b097feeb593e5900f
 2016-06-04 20:37:10 +00:00
drh
8eeb4463d9 Simplify the sqlite3BtreeInsert() interface by gathering the five arguments 
describing the content to be inserted into the new BtreePayload structure, and
thus reducing the number of parameters from eight to four.

FossilOrigin-Name: 55f348cdd24c7812ea4b63345514764b69f64dc8
 2016-05-21 20:03:42 +00:00
drh
b052958657 Remove code not needed now that synchronous=OFF database files no longer 
trigger the use of a master journal.

FossilOrigin-Name: aa9f4c622af191edbeb6a535942944f8c91f5c37
 2016-02-22 23:44:42 +00:00
drh
def19e3b48 Change the name of the BTREE_IDXDELETE flag to BTREE_AUXDELETE, to better 
reflect its purpose.

FossilOrigin-Name: 1d3bf6bebdda9f96734bc139601e9b05344ea0b4
 2016-01-27 16:26:25 +00:00
drh
e807bdba86 Add a new hint bit on the flags parameter of sqlite3BtreeDelete(). The new 
BTREE_IDXDELETE bit indicates that the call is to delete an index entry 
corresponding to a table row that has already been deleted.

FossilOrigin-Name: ac2cbadd8000947c097da5b00c00090fe58fdcff
 2016-01-21 17:06:33 +00:00
drh
9c0c57a4ca Improved comments on the FORDELETE hint. No logic changes. 
FossilOrigin-Name: a3cec529f0238e4ca1196fec420f2de80d28db78
 2016-01-21 15:55:37 +00:00