database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-25 09:59:22 +03:00
Code Activity
16,806 Commits 1,785 Branches 392 Tags
branch-3.15
Commit Graph

11727 Commits

Author SHA1 Message Date
drh
b3c4a1f04e Code constant vector components outside of any loops in CASE and BETWEEN 
expressions. Fix for [1a684656].

FossilOrigin-Name: 4c6efe600debf783e1cbb3db5df3b4097a707d33
 2016-11-23 21:13:41 +00:00
drh
fd630b2135 Prevent a possible use-after-free bug in the query optimizer. 
FossilOrigin-Name: 661b45068fc8bb885899d6d8ef403f987f5f1a08
 2016-11-23 21:08:01 +00:00
drh
018d5d7642 Disable the query flattener optimization for SELECT statements that are on 
the RHS of vector IN operators.  This is a hack that fixes the bug
described in ticket [da7841375186386c]. A better solution that does not
disable the query flattener is needed, but this will server for the time
being.

FossilOrigin-Name: 27438fb43db4eae90fa005e7872debbb1db22c88
 2016-11-23 21:01:38 +00:00
drh
02e84703e8 Fix a potential use-after-free error during parsing of malformed 
CREATE TABLE statement.

FossilOrigin-Name: 0f956597995ca0007c51a32c71cf5fb723ed4134
 2016-11-23 20:44:04 +00:00
drh
2451c8fd38 Avoid a crash that can occur after an obscure OOM in the built-in INSTR() 
function.

FossilOrigin-Name: 8a55b8e179f3fd14ae656680ed4ebd462800e2f6
 2016-11-23 20:19:00 +00:00
drh
33d2795554 Handle some obscure "row value misused" cases that could cause segfaults or 
assertion failures.

FossilOrigin-Name: 794763fd6c04cabb16300421ade169131b7d308d
 2016-11-23 19:43:48 +00:00
drh
c657d8c2a9 Take care not to try to generate code for the ATTACH and DETACH commands 
if there were syntax errors during parsing.
Fix for ticket [2f1b168ab4d4844]

FossilOrigin-Name: f8cf7ff1560dbd0dde5e6d4c9c22cd8ff43cce09
 2016-11-23 19:40:23 +00:00
drh
ac0e8a198d Add the SQLITE_FCNTL_WIN32_GET_HANDLE file control. 
FossilOrigin-Name: 5221e3cc6f81d078766a607408d4e8aa3be0a90e
 2016-11-03 18:49:15 +00:00
drh
e876607623 Fix an issue that was causing the new database image to be assembled entirely 
in heap memory when VACUUMing a database, even if it should use a temp file.
This could cause SQLITE_NOMEM errors when vacuuming very large databases on
32-bit systems.

FossilOrigin-Name: 3fae483faea3370785ac44ac65dbd03c21b9f6f2
 2016-11-03 18:36:26 +00:00
drh
15f3a25ffb Make sure left-join markings are transferred to the virtual scalar 
subexpressions when decomposing a vector comparison in the ON clause of
a LEFT JOIN.
Fix for ticket [fef4bb4bd9185ec8f].

FossilOrigin-Name: aba1e22bbae1cd21f6e1d10773ccbfc4682db52c
 2016-11-03 18:35:19 +00:00
drh
5e12e946f3 If all branches of an OR optimize scan that is the rhs of a LEFT JOIN use the 
same index, set the index cursor to return NULL values if there are no matches
for a row on the lhs.  Fix for ticket [34a579141b2c5ac]

FossilOrigin-Name: 54eeddeceb7545c9843d4ddf4ff73a894214c43b
 2016-11-03 18:33:52 +00:00
drh
32dbb674ba In the sessions module, avoid recording a change if an UPDATE statement 
overwrites a column with REAL affinity containing an integer value with 
the same value.

FossilOrigin-Name: 0fc4f0f4c270d29ec9c03d2954ef57f98461ede8
 2016-11-03 18:31:40 +00:00
drh
fcb704549f Avoid using the "direct overflow read" optimization to read large blobs if the 
pager layer has a wal file open - even if the database header indicates that
the db is not a wal database.

FossilOrigin-Name: 63cfe19724b5856bd246c6fb98d3d79f8e022f71
 2016-11-03 18:30:26 +00:00
drh
989412a1cf Take care to avoid integer overflow when doing the initial page cache 
allocation with an excessively large cache_size setting.

FossilOrigin-Name: 4d66ac98deaa85218be7ff0eb254f78b96d8e8d4
 2016-10-13 12:56:18 +00:00
drh
c436a03d02 Avoid reading the -1-th element of an array in the query planner. Fix to a 
bug introduced by check-in [8e2b25f9b8a7] from earlier today.  Curiously,
the problem only appeared on 32-bit systems.

FossilOrigin-Name: 443913d582bcd953d85159047541592e2f68ade3
 2016-10-12 18:55:53 +00:00
drh
013ae68b25 New testcase() macros to ensure coverage of the ORDER BY LIMIT optimization 
code in where.c.

FossilOrigin-Name: 61f0526978af667781c57bcc87510e4524efd0d8
 2016-10-12 15:15:30 +00:00
dan
83465a662f Fix a problem affecting queries that match the pattern (... WHERE ipk IN (....) ORDER BY ? LIMIT ?). Fix for [96c1454c]. 
FossilOrigin-Name: 8e2b25f9b8a7ed087d3cece74239814bee19429e
 2016-10-12 14:48:00 +00:00
dan
90b2fe6b1e When handling ORDER BY expressions, do not assume all values of an indexed expressions are distinct. Fix for [4766f444]. 
FossilOrigin-Name: aebe429e52ffef026cb0803fb164339d61bd2e88
 2016-10-10 14:34:00 +00:00
drh
48590fcb37 Make sure indexes on expressions skip over initial NULL values in the 
index.  Fix for ticket [4baa464912129477f3c9]

FossilOrigin-Name: 71797ba431085f9ae381ed5ea6471967926f4043
 2016-10-10 13:29:15 +00:00
dan
320d4c304d Add missing "static" to internal function whereRangeVectorLen(). 
FossilOrigin-Name: cbed3d75cf9a24037263d126727db7dd048a4f97
 2016-10-08 11:55:12 +00:00
drh
e3c6b61cee Fix harmless compiler warnings. 
FossilOrigin-Name: 2dde3375124198560c8ff15f87aadde2afd722c5
 2016-10-05 20:10:32 +00:00
drh
da5c62400f Do not set MEM_Blob unless the appropriate fields of the Mem object have 
been correctly initialized.

FossilOrigin-Name: a596b7c6cc780525120604090493f3f7d962b9fa
 2016-10-05 15:02:00 +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
a71c743aae Allow deterministic functions in the WHERE clause of a partial index. 
FossilOrigin-Name: c6e9b9421805c904b20900b711fa0e51773aef3e
 2016-10-03 18:13:23 +00:00
drh
c9b39288ae Size and performance optimizations on the sqlite3ExprAssignVarNumber() routine. 
FossilOrigin-Name: 109852e51e2cc2674940ba3e5097a92e66f88bb8
 2016-10-03 16:33:14 +00:00
drh
de25a88c50 Avoid unnecessary strlen() calls in sqlite3ExprAssignVarNumber() by passing in 
the token length from the parser.

FossilOrigin-Name: d15ae2e530cffea60263f203ac5f89b6790f4bd5
 2016-10-03 15:28:24 +00:00
drh
87c05f0c58 Avoid unnecessary memset() calls in the query optimizer. 
FossilOrigin-Name: 5bb7cde0731d23411e9df02a957010f94203397b
 2016-10-03 14:44:47 +00:00
drh
cca8a4ad6f Fix an obsolete comment on a variable definition in expr.c. No code changes. 
FossilOrigin-Name: 012ff6dd306328f7ea71a6600471c871e7ffe37b
 2016-10-03 12:56:48 +00:00
drh
1dd518cfcd Make sure the sqlite_sequence table is updated when an optional xfer 
optimization is used.  Fix for ticket [7b3328086a5c1].

FossilOrigin-Name: 81e4d4f897553f6fee540a38c3e83ceac5ba9b78
 2016-10-03 02:59:33 +00:00
drh
cb43a937e5 Allocate Parse objects off of the stack where appropriate for a substantial 
performance increase and a size reduction.

FossilOrigin-Name: ea8affa9e453b201b479162f621b591e7a65a489
 2016-10-03 01:21:51 +00:00
drh
445f3d564c Rearrange fields in the Parse object to reduce the amount of initialization 
required.

FossilOrigin-Name: 361940b44dd17bf2b39fc0e0716c0de6b2b7f4f7
 2016-10-01 21:43:37 +00:00
drh
216b70ff82 Reduce the width of a memset() to avoid double-initializing some variables. 
FossilOrigin-Name: 34edbfd12d6cfa6bbfa30eef9276a4865eadc869
 2016-10-01 20:43:41 +00:00
drh
230368c30d Remove an unnecessary memset() call. 
FossilOrigin-Name: a76bff74ce47c9c98106566bde5d781992657e22
 2016-10-01 19:32:54 +00:00
drh
d8e4b13256 Use sqlite3DbMallocRawNN() where appropriate, instead of 
sqlite3DbMallocRaw().

FossilOrigin-Name: 54a449a41d8d32da2f8b73689227ced866974a18
 2016-10-01 19:21:56 +00:00
drh
8dfef1175e Make sure deleting an unused prepared statement does not reference 
uninitialized fields in the structure.

FossilOrigin-Name: 7983eef0422439bfc85950554b000d46a9767ee3
 2016-10-01 16:53:45 +00:00
drh
76336d5b9d Avoid accessing Vdbe.pc if it is uninitialized. Check Vdbe.magic first. 
FossilOrigin-Name: 6ac6e4462a08cb2f3d28e4a23218fc1b110a2148
 2016-10-01 11:39:53 +00:00
drh
ab3182f7c4 Avoid unnecessary zeroing of fields in the Vdbe object when it is allocated. 
FossilOrigin-Name: 1e21bbe836539e64d24857f4faa3d12cd607dc7e
 2016-10-01 00:37:50 +00:00
drh
cd9af608e1 Avoid initializing the column-cache section of the Parse object, since entries 
in the cache will be initialized as they are used, and avoiding the initial
memset() saves many CPU cycles.

FossilOrigin-Name: 63cf7eafae5c3c1379edf416c5157010c7c120b5
 2016-09-30 22:24:29 +00:00
drh
94881d732b Fix an always-true conditional left over from the previous commit. 
FossilOrigin-Name: ab12fce3318db447995e1465f34a1e43cd623d6a
 2016-09-30 21:20:37 +00:00
drh
9b40d13f43 Fix the Parse.aColCache column cache so that all of the valid entries are 
in the first Parse.nColCache slots.

FossilOrigin-Name: 6028502059ccbd3699637b7a70a6d8ce1b7c3dad
 2016-09-30 20:22:27 +00:00
drh
e05950d878 Another simplification to the Parse object. 
FossilOrigin-Name: c1419727f5e4cb3ef63b5853b6ef3b1e53af0651
 2016-09-30 19:14:32 +00:00
drh
1d96cc60d0 Remove unnecessary fields from the Parse object. 
FossilOrigin-Name: 814e41da3563eecf5514811bc8ab2df4f5cc0d4b
 2016-09-30 18:35:36 +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
dd3bfe8648 Small size and performance optimization to sqlite3VdbeChangeP5(). 
FossilOrigin-Name: 3c93c8f5bbf54ed2a331079b28fdd94eb0e59e69
 2016-09-29 20:28:34 +00:00
drh
2831c4d123 Remove the peep-hole optimization of removing OP_Close opcodes that come 
before OP_Halt, as the extra work of removing those opcodes uses more cycles
than just running them.

FossilOrigin-Name: 984a96d79656c1b095aba1f88aca4bb787ba0bd8
 2016-09-29 19:50:02 +00:00
drh
42735c7d30 Size and performance optimization to sqlite3ValueFromExpr() 
FossilOrigin-Name: 945f82bc44c5a431c0fef0d36cf016671d7ade1e
 2016-09-29 19:27:16 +00:00
drh
22fa36dc04 Clarification and typo-fixes in comments. No changes to code. 
FossilOrigin-Name: e2cd79aa3104c51035bf29c548c322564731b75f
 2016-09-29 15:53:28 +00:00
drh
5f33eaa6a4 Use Knuth multiplicative hashing for the symbol table. 
FossilOrigin-Name: cc29ddd6be60bdbf107f285c9eb57d5896ebca2d
 2016-09-28 20:42:31 +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