database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-07 02:42:48 +03:00
Code Activity
30,215 Commits 1,570 Branches 184 Tags
tcl-init
Commit Graph

2168 Commits

Author SHA1 Message Date
drh
bc8a6b31b6 Ensure that comparison operators do not mess up the MEM_Dyn flag on registers 
when reverting affinity changes.

FossilOrigin-Name: 02e3c88fbf6abdcf3975fb0fb71972b0ab30da30
 2015-03-31 11:42:23 +00:00
drh
edea911945 Merge all recent trunk enhancements into the sessions branch. 
FossilOrigin-Name: 54aaa6f29ad1bf84148c2403eed77e8311f68d66
 2015-03-24 19:02:13 +00:00
drh
f496a7dc81 More defenses against virtual table being deleted out from under a running 
statement.

FossilOrigin-Name: 116c99823022c017946b6088878a2d46759deb6e
 2015-03-24 14:05:50 +00:00
drh
a68d628291 Prevent a virtual table from being destroyed while it is in use. 
FossilOrigin-Name: fba674c083286dabb37fed9357b67593b56ed3a5
 2015-03-24 13:32:53 +00:00
drh
086723a4a8 Replace the Vdbe.inVtabMethod field with the sqlite3.nVDestroy counter. 
FossilOrigin-Name: 9faefb96272967e731e83ef516a8c1e1b876391b
 2015-03-24 12:51:52 +00:00
drh
474640638d Remove an unreachable branch from the OP_VCreate opcode. 
FossilOrigin-Name: 5fca41a3811766b48f5f23d5d49cc4e6e79fa867
 2015-03-21 12:22:16 +00:00
drh
1fa509afa1 Fix to get SQLITE_SMALL_STACK working correctly again after the previous change. 
FossilOrigin-Name: 78df0ce13d4f35226f2571bd7de78484ccbee4bb
 2015-03-20 16:34:49 +00:00
drh
e0997b341b Provide the BTREE_SEEK_EQ hint to the b-tree layer. 
FossilOrigin-Name: e750830f1e61160c0c67e35b13e50b35a95b50e1
 2015-03-20 14:57:50 +00:00
dan
8b3c0ae47c Fix a crash that can occur following an OOM condition within a CREATE VIRTUAL TABLE statement on a utf-16 database. 
FossilOrigin-Name: 9453e7da046c55715631f10f018e97a336197969
 2015-03-19 19:59:30 +00:00
dan
7377945a7b Fix a problem with creating virtual table with names specified using malformed utf-8 within utf-16 databases. 
FossilOrigin-Name: 9969cff2d0553c9bfa88a437e1bb0cc4200d49d7
 2015-03-19 18:56:17 +00:00
drh
099006de44 Merge all recent trunk enhancements into the sessions branch. 
FossilOrigin-Name: 1d1c57c3566d86cd44f146688b620131b3b57e52
 2015-03-17 18:54:10 +00:00
drh
0a0d0560ab Improve the text on one of the opcode documentation comments in vdbe.c. 
FossilOrigin-Name: 08958f57970d2346f3e98e62225e2b5d351d12d8
 2015-03-12 05:08:34 +00:00
drh
c11a172d5f Merge recent trunk enhancements into the sessions branch. 
FossilOrigin-Name: 68c8937e83b770d5ec6b1855c1bde81057c11b5f
 2015-03-09 13:07:45 +00:00
drh
16897072b5 Refactor some jump opcodes in the VDBE. Add JumpZeroIncr and DecrJumpZero. 
Fix the LIKE optimization to work with DESC sort order.

FossilOrigin-Name: 26cb5145bf52f8c3fffa8c69b6c24aee4d974883
 2015-03-07 00:57:37 +00:00
drh
a9c18a9067 Test cases added. Comments fixed. Proposed solution for 
ticket [05f43be8fdda9fbd9].

FossilOrigin-Name: 6b993bd54035b67f4d84941e3f444ca79b7feee1
 2015-03-06 20:49:52 +00:00
drh
f07cf6e2a5 The LIKE optimization must be applied twice, once for strings and a second 
time for BLOBs.  Ticket [05f43be8fdda9f].  This check-in is a proof-of-concept
of how that might be done.

FossilOrigin-Name: 5757e803cb5759b476bbc6453c58340089611420
 2015-03-06 16:45:16 +00:00
drh
51a74d4cbd More test cases and requirements marks for pragmas. 
FossilOrigin-Name: fc51037cd97063069620213a62efdeff5d898706
 2015-02-28 01:04:27 +00:00
drh
7a20f698df Merge trunk 3.8.8 beta changes into the sessions branch 
FossilOrigin-Name: 0ba124540b5b2a9ceda0f4f4a46e6be54edad813
 2015-01-14 17:16:23 +00:00
mistachkin
7bb6e8e169 Get things compiling cleanly with MSVC and W4. 
FossilOrigin-Name: c8725fa5fa361959b0f0a3fb36f204905d6f0ae9
 2015-01-12 18:52:41 +00:00
drh
34794c3d0c Incorporate the SQLITE_CHECKPOINT_TRUNCATE enhancement and a couple of 
obscure bug fixes from trunk.

FossilOrigin-Name: 34ffa3b3c002b0e87d8382ad76e87dbaec0b2bc6
 2014-12-04 23:35:08 +00:00
drh
a25165fa68 Add an implementation mark and fix a comment describing the OP_Checkpoint 
opcode.

FossilOrigin-Name: 7475b90c558157802b036162376fceacc1b9ab4a
 2014-12-04 04:50:59 +00:00
dan
f26a1549ac Add the SQLITE_CHECKPOINT_TRUNCATE option. 
FossilOrigin-Name: 8e20a43419e46b6b9d1f60ec7ea420bbfb3ef358
 2014-12-02 19:04:54 +00:00
drh
6e09b16852 Merge all recent fixes and enhancements from trunk into sessions. 
FossilOrigin-Name: 2617d93713d9f4cf907ab2e7baef6a0f74f7198e
 2014-12-02 16:31:01 +00:00
drh
654858d7f4 Add some requirements marks to the record formatting logic. Comment changes 
only - the code is unaltered.

FossilOrigin-Name: 9a9627e178a67bbfc85366aaea900e674d22fb53
 2014-11-20 02:18:14 +00:00
drh
42a7b4bac9 Completely remove an assert() that had previously been commented out. 
FossilOrigin-Name: 89b3c1c4555c98c633089b21cdd2a1a3a1e751eb
 2014-11-19 14:31:12 +00:00
drh
04e8a58669 Merge recent trunk enhancements, including the read-after-ROLLBACK change 
and the addition of sqlite3_stmt_scanstatus() support, as well as various
minor bug fixes.

FossilOrigin-Name: f09055f3c4348264c7336f90646375f0d98b061e
 2014-11-18 21:20:57 +00:00
drh
64b600ff13 Merge in all the other ROLLBACK fixes from the branch-3.8.7 branch. 
I don't know why I was doing them one-by-one.

FossilOrigin-Name: 296b0c7397790ceadbdb330959e962f6491abc3e
 2014-11-18 20:49:30 +00:00
dan
756d3b3e9d Avoid calling sqlite3BtreeKeysize() on a b-tree cursor in SKIPNEXT or SKIPPREV state. 
FossilOrigin-Name: 2f2ecb994889acb783616acb7307f8fed962d213
 2014-11-17 19:44:44 +00:00
dan
2b8669a9da Avoid calling sqlite3BtreeKeysize() on a b-tree cursor in SKIPNEXT or SKIPPREV state. 
FossilOrigin-Name: 54e7d3fcb1ab21c03ffef1af93ae029a2901098a
 2014-11-17 19:42:48 +00:00
drh
77b1deec40 When a SELECT statement is terminated by a ROLLBACK TO operation, make the 
error message be "abort due to ROLLBACK" rather than 
"callback requested query abort".

FossilOrigin-Name: 34fc4a082c192830e48f643549c04a4f91912b8b
 2014-11-17 17:13:06 +00:00
drh
6f9c5669e2 When a transaction or savepoint rollback occurs, save the positions of all open read-cursors so that they can be restored following the rollback operation. Cherry-pick of check-in [dd03a2802f3f27] 
FossilOrigin-Name: 402780a9c8df9e7ea898bdca49c1191042fe387a
 2014-11-13 13:42:39 +00:00
dan
8023104252 When a transaction or savepoint rollback occurs, save the positions of all open read-cursors so that they can be restored following the rollback operation. 
FossilOrigin-Name: dd03a2802f3f276525f3cef9a93f825dd8606626
 2014-11-12 14:56:02 +00:00
drh
51a205410c Make sure that NULL results from OP_Column are fully and completely NULL and do not have the MEM_Ephem bit set. Fix for ticket [094d39a4c95ee4]. 
FossilOrigin-Name: e1017745e183f5d7429ce787ec2feef946a24f0f
 2014-11-12 14:07:28 +00:00
drh
85fabf1444 This is a cherry-pick of version [b5df5ac052]. 
FossilOrigin-Name: d4b2d5d066891e06f2bf4337902b44b000fa9fd2
 2014-11-11 22:55:26 +00:00
drh
47b7fc7843 Experimental changes that permit read operations to continue after a 
ROLLBACK, as long as the schema is unchanged.

FossilOrigin-Name: fa6e6a9ae276cad60e9a4abc1bc23cf2809ea786
 2014-11-11 01:33:57 +00:00
dan
b391b94431 Add new test file e_blobopen.test, containing tests for sqlite3_blob_open(). 
FossilOrigin-Name: ecbccd0e594d22b3ae7fabc8037951dc49570bc3
 2014-11-07 14:41:11 +00:00
drh
6b5631e02f Make sure that NULL results from OP_Column are fully and completely NULL 
and do not have the MEM_Ephem bit set.  Fix for ticket [094d39a4c95ee4].

FossilOrigin-Name: 42705fd7d892c4fdfb95fbbb468c99569beece25
 2014-11-05 15:57:39 +00:00
dan
e2f771b047 Add further tests. Fixes so that compilation without ENABLE_STMT_SCANSTATUS works. 
FossilOrigin-Name: a2303c719222f1effb51acc6b37930561148c00c
 2014-11-03 15:33:17 +00:00
dan
43764a8efb Minor performance enhancements to SQLITE_ENABLE_STMT_SCANSTATUS code. 
FossilOrigin-Name: f13d6ba8a72d75838c4aaf85326c1129da027f8b
 2014-11-01 21:00:04 +00:00
dan
6f9702ed4d If SQLITE_ENABLE_STMT_SCANSTATUS is defined, record the number of times each VDBE opcode is executed. Derive the values returned by sqlite3_stmt_scanstatus() from these records on demand. 
FossilOrigin-Name: 9ea37422a8cc2fce51bb10508e5e90f40fd4b511
 2014-11-01 20:38:06 +00:00
dan
89e71646df Minor fixes and documentation improvements for sqlite3_stmt_scanstatus(). 
FossilOrigin-Name: 8d8cc9608d30bb65fffcfe488e904411cbbc7f41
 2014-11-01 18:08:04 +00:00
dan
04489b6dce Add the experimental sqlite3_stmt_scanstatus() API. 
FossilOrigin-Name: 6a9bab34aeb6a01b612211a28c140de60a3e883c
 2014-10-31 20:11:32 +00:00
drh
ca3e10ea37 Merge recent trunk enhancements, and in particular the improvements to 
the b-tree balancing logic, into the sessions branch.

FossilOrigin-Name: 28b044a51215a3f64dafb2cf3b6cb7d2029580ef
 2014-10-31 14:53:32 +00:00
drh
739383d25d In the OP_Column opcode, when extracting a field that is past the end of 
a short record (because the row was originally inserted prior to ALTER TABLE
ADD COLUMN) then make sure the output register is fully NULL and does not
contain leftover flags (such as MEM_Ephem) from its previous use.
Fix for ticket [43107840f1c02].  This is a cherrypick of
check-in [24780f8ddc1683fc].

FossilOrigin-Name: 304ea6ba6f4cf40a76d32d37af73a253f493ba47
 2014-10-29 01:13:58 +00:00
drh
22e8d833f0 In the OP_Column opcode, when extracting a field that is past the end of 
a short record (because the row was originally inserted prior to ALTER TABLE
ADD COLUMN) then make sure the output register is fully NULL and does not
contain leftover flags (such as MEM_Ephem) from its previous use.
Fix for ticket [43107840f1c02].

FossilOrigin-Name: 24780f8ddc1683fc62180e6961dc6bfe1168f4df
 2014-10-29 00:58:38 +00:00
dan
c3da667b25 Modify the documentation for sqlite3_changes() to make it more testable. Add tests and minor fixes for the same. 
FossilOrigin-Name: 41cdd0c422d61533a94870cb5ad094682956d472
 2014-10-28 18:24:16 +00:00
drh
92fe38ece5 Merge recent trunk micro-optimizations and the DESC index GROUP BY ORDER BY 
bug fix into the sessions branch.

FossilOrigin-Name: 83d4114f2aa404e670ced33511183baacd813a01
 2014-10-14 13:41:32 +00:00
drh
8dd8362d64 Optimize a database corruption test inside of the OP_Column opcode. 
FossilOrigin-Name: 005e5b388a8a97bca6d1f0e06c40d68d92aa1212
 2014-10-13 23:39:02 +00:00
drh
facf47a891 Use the padding word in the Mem object as temporary storage for 
serial_type value in OP_Record, and thus avoid a redundant computation of
the serial_type for each column.

FossilOrigin-Name: 4b3b65ee5ea61e9b9671ca027940bf02689cb890
 2014-10-13 20:12:47 +00:00
drh
c22284f4b3 Reduce the CPU load imposed by sqlit3VdbeCursorMoveto() by factoring out 
some of its functions and by avoiding unnecessary calls.

FossilOrigin-Name: c2799aece17d347c64217a0e407bb10e50c184a3
 2014-10-13 16:02:20 +00:00