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
e4a8b8769e Remove a redundant assignment statement. 
FossilOrigin-Name: a5fa09657bd6c4ea5fe6712b0f8af2170cbe0381
 2017-01-09 19:55:19 +00:00
drh
7441df72be Performance optimization and size reduction in the OP_Variable opcode. 
FossilOrigin-Name: 237aa97452e20c312f256a8fd62531e3d447f84b
 2017-01-09 19:27:04 +00:00
mistachkin
ab61cf7d93 Fix typo in a comment. No changes to code. 
FossilOrigin-Name: d38fd22935b1572f4481b39c2f9274329b18ea99
 2017-01-09 18:22:54 +00:00
drh
e7b554d615 Modify the OP_RowData opcode so that when P3!=0 it is allowed to hold an 
ephemeral copy of the content.  This avoids unnecessary memcpy() operations
in the xfer-optimization and VACUUM.

FossilOrigin-Name: 6e106acd74da3baa5c308a76443d2f0a7c904e5e
 2017-01-09 15:44:25 +00:00
drh
fb4e3a3bbb Encode a 64-bit integer literal in date.c as a constant expression so that 
it works on older compilers.  Also fix a harmless compiler warning in vdbe.c.

FossilOrigin-Name: f57952bac652901e1bd48b68301941efbcf29dc4
 2016-12-30 00:09:14 +00:00
drh
218c66e0e3 Disable new test modules nockpt.test and interrupt2.test for incompatible 
permutations.  Add a CORRUPT_DB term to an assert() in vdbe.c.

FossilOrigin-Name: a54e619e6f0266932c8873f9ac826fd042a0602f
 2016-12-27 12:35:36 +00:00
drh
6bd4dc6dc4 Fill in missing opcode documentation entries for OP_SorterNext and 
OP_SorterSort.

FossilOrigin-Name: 2940661b8c014b94973e05c44f1b1f4f443dbdd3
 2016-12-23 16:05:22 +00:00
drh
9bf755cc44 Use the VList object to replace Parse.azVar for tracking the mapping between 
SQL parameter names and parameter numbers.  There is a performance
improvement, though there are still a few hiccups in the current code.

FossilOrigin-Name: 68ecafa1425a41358c88f41efea3262f1b4490f2
 2016-12-23 03:59:31 +00:00
drh
a582b01698 Simplifications to the way UnpackedRecord objects are allocated. Smaller 
and faster code that also fixes a subtle (currently unreachable) bug.

FossilOrigin-Name: f7ab01f254cd9d7006b8dec29adb234a671b8e6f
 2016-12-21 19:45:54 +00:00
drh
f99dd359d0 Change the OP_IfNotZero opcode so that it decrements register P1 by 1 rather 
than the value in P3, and so that it only decrements if originally positive.
This avoids decrementing the smallest 64-bit signed integer.

FossilOrigin-Name: 165c044686212fbf7182dd560ad1e57eb4cc9838
 2016-12-18 17:42:00 +00:00
drh
e0a04a36a6 All temp.sqlite_master to be used as an alias for sqlite_temp_master. 
FossilOrigin-Name: 8d646905b830d5bb29092e103ac5cb499b3c7e5a
 2016-12-16 01:00:21 +00:00
drh
fbd8cbdcf5 Reorder the fields in the VdbeCursor object so that those that need to be 
bulk zeroed on allocation are grouped at the beginning, and the memset()
only runs over those fields that really need it.

FossilOrigin-Name: 8165f88bb1d40693d67005a8d5dc499085f64b91
 2016-12-10 12:58:15 +00:00
drh
719da30d53 Avoid signed integer overflow when dealing with a LIMIT and OFFSET whose 
sum exceeds the maximum integer value.

FossilOrigin-Name: c9bdf7adb4745cfaf23d9afd496e71fa37793108
 2016-12-10 04:06:49 +00:00
drh
d12602a9c5 Rename the SQLITE_OMIT_BUILTIN_TEST compile-time option to SQLITE_UNTESTABLE. 
FossilOrigin-Name: f360818737e73ee4f944685a547abc8f14f47819
 2016-12-07 15:49:02 +00:00
drh
ab5be2e651 Change the OP_DecrJumpZero opcode back to its old behavior of always 
decrementing, except top the decrementing when it reaches the largest negative
number.

FossilOrigin-Name: 9d0d8c2e7c529562889de02346733dcb532e9388
 2016-11-30 05:08:59 +00:00
drh
64777ba834 Prevent a warning about integer overflow when using a very large negative 
LIMIT.

FossilOrigin-Name: 96106d5620eae51474234f4eec1d2c5bd570d486
 2016-11-30 01:05:41 +00:00
drh
9057fc7c7f Remove the OP_RowKey opcode. Use OP_RowData in its place. 
FossilOrigin-Name: 6ac7b07a4aff2e1a9031289e3dafdb9ac0071c24
 2016-11-25 19:32:32 +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
06a09a828a Small performance increase and size reduction in the OP_Column opcode. 
FossilOrigin-Name: a9498407e646305e7b60115d63e85c642bbd1c3f
 2016-11-25 17:03:03 +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
eaf6ae2992 Comment changes that attempt to better explain the behavior of the "seekResult" 
field on VdbeCursor objects and the seekResult parameter to
sqlite3BtreeInsert() and the OPFLAG_USESEEKRESULT flag on insert opcodes.
No changes to code.

FossilOrigin-Name: 345b46be75bdf6f9fb7367a6164d89bae11995a6
 2016-11-09 20:14:34 +00:00
drh
fb8c56f21b Fix a typo on the OP_IdxInsert documentation. No code changes. 
FossilOrigin-Name: e4acd98207bf12b28f6c0f77896ba8f0b0a155d5
 2016-11-09 01:19:25 +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
dan
3b908d41a0 Avoid superfluous cursor seeks in "INSERT OR REPLACE" statements. 
FossilOrigin-Name: bec5b6d4d083556d111a89186b4f7b35b5e7cebf
 2016-11-08 19:22:32 +00:00
drh
e77caa191b Fix a requirement mark. No changes to code. 
FossilOrigin-Name: d18f61b78c8fafef742efbc890382537e8584180
 2016-11-02 13:18:46 +00:00
drh
c3191d236a Minor simplification of the comparison opcodes. 
FossilOrigin-Name: 56474ebca3fdddb8f3c5156f06dc42dc0a65256c
 2016-10-18 16:36:15 +00:00
dan
1480095ff5 Changes to support interrupting a checkpoint using sqlite3_interrupt(). 
FossilOrigin-Name: c88d36e251abec24aa7e37cf550e148904b9fd2d
 2016-10-17 15:28:39 +00:00
drh
f013e20c66 Add documentation for the OP_SorterInsert opcode, formerly omitted by mistake. 
No changes to code.

FossilOrigin-Name: 16d88a907730e3773a1320dbaf1f82c2bc71d71f
 2016-10-15 18:37:05 +00:00
drh
44728d7e01 Do not bother to initialize unused fields in the BtreePayload object. 
FossilOrigin-Name: b10d0f939c82c4de3faa90b86de9ec4a89992856
 2016-10-04 00:47:26 +00:00
drh
2a1df937ab Avoid unnecessary Mem initializations when generating a new sqlite3_stmt 
object.

FossilOrigin-Name: 47ae1cda8dc255d100aeb8cb90ea4c9e449509be
 2016-09-30 17:46:44 +00:00
drh
5e769a50ad Two more typo fixes in comments. 
FossilOrigin-Name: 40c0fb0af678797c39a99853f9f4102464c16f4b
 2016-09-28 16:05:53 +00:00
drh
ed204d1f44 Fix typos in comments. No code changes. 
FossilOrigin-Name: 5bbd071d57a8048e2ca17bf97761e4f27fc5a6bf
 2016-09-28 16:04:22 +00:00
drh
96fdcb40af Update requirements marks due to improvements in the wording of documentation. 
No changes to code.

FossilOrigin-Name: bf903b2ecac5d7b25c9cc899cae41f1d69aafe4e
 2016-09-27 00:09:33 +00:00
mistachkin
d8992cef36 Fix harmless compiler warning. 
FossilOrigin-Name: 72429063956614975d90cae2a829cfa4296694da
 2016-09-20 17:49:01 +00:00
drh
8aaf7bcc8d Avoid unnecessary calls to ExpandBlob() for smaller and faster code. 
FossilOrigin-Name: 5e196fd18169e84806cd45dd1a8190339323e772
 2016-09-20 01:19:18 +00:00
drh
fadd2b1972 Very small optimization in the bytecode engine. 
FossilOrigin-Name: 46002511e52518bae14f210157f231c814c77c9e
 2016-09-19 23:39:34 +00:00
drh
9e5eb9c8cc 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].

FossilOrigin-Name: 6bf5ba10d28f1b0a32aa9a560ae3143a1235eadb
 2016-09-18 16:08:10 +00:00
drh
fd7459e0aa Improved description of the ElseNotEq opcode in comments. No changes to code. 
FossilOrigin-Name: e011435e2f57ddfe315d5da48e93185d6789fc80
 2016-09-17 17:39:01 +00:00
drh
21e19b44f0 Remove no-op code (adding an assert() to prove that the code was no-op) 
in the text affinity logic of the bytecode engine comparison operators.

FossilOrigin-Name: b9f5bdbf40ac6382e48f09ebcd53cc908e065527
 2016-09-15 14:54:51 +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
64caee4086 Performance improvements to the comparison operators in the bytecode engine. 
FossilOrigin-Name: 37803b19d219f4107f29b240d5d314600e4bd236
 2016-09-09 19:33:00 +00:00
drh
3fffbf9327 Simplifications to the SQLITE_KEEPNULL flag on VDBE comparison operators. 
FossilOrigin-Name: 96269f0179a7d8fa44ee278cef362962368c59ef
 2016-09-05 15:02:41 +00:00
drh
4910a76d45 Performance optimizations. 
FossilOrigin-Name: f1d06c49ba0d814dc7ffb538aac3f4e6251fd8f0
 2016-09-03 01:46:15 +00:00
drh
88e665fd0b Fix the "Synopsis" on the OP_Lt, OP_Le, OP_Gt, and OP_Ge opcodes, which 
has been backwards for time out of mind.

FossilOrigin-Name: f51248dcfa22e989dacde41021e96a65f12c5ca8
 2016-08-27 01:41:53 +00:00
drh
72e26dec86 Improved extended comments of comparison operators when the SQLITE_STOREP2 
flags is set on P5.  No changes to non-debug code.

FossilOrigin-Name: bbc1b016164ed0793e07302614384d52119463e0
 2016-08-24 21:24:04 +00:00
drh
b684fd5c4a Merge recent enhancements from trunk. 
FossilOrigin-Name: b17872363b60edab05a5d382a44038aad91e4d9f
 2016-08-19 15:41:24 +00:00
drh
9ef5e7708a Add the capability to VACUUM an attached database by specifying the schema 
name as an argument to the VACUUM command.  Since version 2.0, VACUUM has
accepted an argument which was silently ignored.  Now it has meaning.

FossilOrigin-Name: 29d63059b4d2bb612523ac55ebfef040d054a64f
 2016-08-19 14:20:56 +00:00
drh
5ea494425f Merge recent enhancements from trunk. 
FossilOrigin-Name: 4768a1066cb9c7627064d7efec44188d6755cb03
 2016-08-18 15:21:16 +00:00
drh
69c338263a Rename the Db.zName field to Db.zDbSName to make it more descriptive and to 
distinguish it from all of the other "zName" variables scattered throughout
the code.

FossilOrigin-Name: 92a22f01343a898455fd61c3b8e7d7c954f5b569
 2016-08-18 14:33:11 +00:00
drh
0f825a7e26 Remove an unnecessary stack variable from sqlite3VdbeExec(). 
FossilOrigin-Name: c54bd9c82dd34951dc87848c0b19fcccaef928db
 2016-08-13 14:17:02 +00:00