database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2026-10-23 21:49:02 +03:00
Code Activity
7,281 Commits 1,782 Branches 392 Tags
branch-3.6.21
Commit Graph

5368 Commits

Author SHA1 Message Date
drh
47d7fd5219 Fix for the "(x AND y) OR z" bug backported to version 3.6.21. 
FossilOrigin-Name: 867347323b0c095159411de36cbd87b09c1b2863
 2009-12-16 23:28:31 +00:00
drh
00ce39458d Enhanced detection of database corruption in btree.c:allocateSpace(). 
FossilOrigin-Name: 5a511f98877f0f7f12d336b7831f3da901856b02
 2009-12-06 03:35:51 +00:00
drh
dc9b5f8ee3 Fix to check-in [f221f31eff]: Make sure local variable rc is declared even 
when compiled without SQLITE_DEBUG.

FossilOrigin-Name: 7a9a35327c55452e858335933ce11669fc888aeb
 2009-12-05 18:34:08 +00:00
dan
89e060e462 Catch an obscure case of database corruption. 
FossilOrigin-Name: 0f9b17a6da42b4da667bbbc00f713effe92a66b5
 2009-12-05 18:03:50 +00:00
drh
8e14c59611 Add the SQLITE_4_BYTE_ALIGNED_MALLOC compile-time option which tells some 
assert() statements that the underlying system only requires 4-byte alignment
of 8-byte data objects like double or int64 and that system malloc() only
guarantees 4-byte alignment of returned pointers.

FossilOrigin-Name: 08faee686eb2fabe0dde51231ee55880e78541e8
 2009-12-04 23:10:12 +00:00
drh
44a1d92050 Remove an assert() in btree.c:releasePage() that is not necessarily true 
when the btree is recovering from an OOM that occurs in the middle of
a balance().

FossilOrigin-Name: 04fc9c7661dd24d080f965e7eae9010a2d346e6a
 2009-12-04 22:51:39 +00:00
drh
476bda7de4 In the OSTRACE debugging macros in os_unix.c, identify the VFS currently 
in use.

FossilOrigin-Name: 082b8da005128f47f63e95b6b702bf4517221b2a
 2009-12-04 14:25:18 +00:00
drh
c9b9b8aab7 Fix an assert() in btree.c that might have fired on a corrupt database file. 
FossilOrigin-Name: 5ab2b3e300b70bc04cdead69275f8f734ea2d885
 2009-12-03 21:26:52 +00:00
drh
313aa5735a Remove a NEVER() from btree.c that could occur in a very obscure tested 
evaluation with an I/O error on fstat().

FossilOrigin-Name: d5861d9ffecca499d79d722b5f742ffe3a5aff44
 2009-12-03 19:40:00 +00:00
shaneh
5e17e8b7dd Fix a couple of compiler warnings under MSVC. 
FossilOrigin-Name: e3aa0870fce0666bf8c67ad6ec23e135d03b604a
 2009-12-03 04:40:47 +00:00
drh
a94cc4206a Add links from C/C++ interfaces to their equivalent SQL functions. Comment 
changes only - no changes to code.

FossilOrigin-Name: acce10f77125b5ab05d10ec10aef68dffa4e826a
 2009-12-03 01:01:02 +00:00
drh
614d265038 Fix compiler warnings in test_hexio.c. 
FossilOrigin-Name: 6a2e0725c20520aa90abb2bc04037ee7acebb930
 2009-12-02 18:03:57 +00:00
dan
bc7c039ce2 Clear the Pager.dbModified flag when unlocking the database. Assert that it is clear when locking the database. 
FossilOrigin-Name: d17ec16b7c5051c904c09580a856593b2fb85edc
 2009-12-02 14:44:32 +00:00
drh
fd7c9912b4 Add testcase() macros to make sure boundary cases in BEFORE UPDATE triggers 
are well tested.

FossilOrigin-Name: 27175caa28919fe145d369f27f52346b8bbadb1e
 2009-12-01 22:09:25 +00:00
drh
d8267b8925 Fix a faulty function prototype in test_intarray.c. 
FossilOrigin-Name: 110956a6505a9f17d08142d47003cf3bc4e515d3
 2009-12-01 18:46:06 +00:00
drh
cfa35664a5 Reorder function declarations in mutex_os2.c. This is a blind change - we 
have no capability of testing on OS/2.  
Ticket [97214a34d814]

FossilOrigin-Name: c40e4ef094bb9d58f14354602785ccc228f8bc2a
 2009-12-01 14:31:18 +00:00
drh
65e8c82e1a Changes to the TCL interface header to allow it to be compiled independently 
from the amalgamation.

FossilOrigin-Name: 58113932d93926b4aa037a7487105a55f883cd0a
 2009-12-01 13:57:48 +00:00
drh
1e6349900d Initialize a variable (unnecessarily) to avoid a compiler warning. 
FossilOrigin-Name: db65fd5913aae4d83d2c2bc243653175be3c3d35
 2009-11-28 13:46:51 +00:00
dan
bb5f168f2e Move [7d30880114] to the trunk. Add optimizations to reduce the number of opcodes used for BEFORE UPDATE triggers. 
FossilOrigin-Name: 1b7c5250ccb63182324bfc3f1ea28f17b6db357a
 2009-11-27 12:12:34 +00:00
drh
5f18a221a1 Simplifications to the sqlite3_trace() bound parameter substitution logic. 
FossilOrigin-Name: cb4b928648504ce29d751834e9ee3b5278dfca65
 2009-11-26 14:01:53 +00:00
drh
d65311b980 Support zeroblob in trace output. 
FossilOrigin-Name: 5086bf8e838c824accda531afeb56a51dd40d795
 2009-11-25 21:05:09 +00:00
drh
c1bd1b33a5 Get trace with parameter insertion working for UTF16 databases. 
FossilOrigin-Name: 01d5451af0bd2743eb74b98f2e77dd2c75f403b6
 2009-11-25 19:35:23 +00:00
drh
c7bc4fde3c Initial check-in of code that inserts tokenizations of the values 
for bound parameters into the output of sqlite3_trace().

FossilOrigin-Name: 545cfb3b63f482036ae152e6ebcce86d373585a8
 2009-11-25 18:03:42 +00:00
drh
8965b50edf Enhance the %q, %Q, and %w printf conversions so that the precisions 
specifies the length of the input.

FossilOrigin-Name: 3ba773132d3baeb87acaee538b8fb0b0f4293673
 2009-11-25 16:53:37 +00:00
drh
5ff44379b3 Fix a tracing macro in the VDBE in the VColumn opcode. 
FossilOrigin-Name: cb74b81bb0322efdd66146d7de466c14564b18fd
 2009-11-24 16:26:17 +00:00
drh
7ab641fb01 Fix SQLITE_SECURE_DELETE so that it overwrites content on the root pages 
of tables and indices that are dropped using the truncate optimization.

FossilOrigin-Name: 02ef972a56aab1e61786000283193165d3968842
 2009-11-24 02:37:02 +00:00
drh
a62bb8d4d7 Make sure registers computed for the VFilter opcode are marked invalid 
after the VFilter opcode finishes.  Ticket [16fbf14cb2].

FossilOrigin-Name: 83dc7d38c2695d1b2a7d4866a4df9be9e41d1abe
 2009-11-23 21:23:45 +00:00
drh
1ac399e8eb Rearrange the order of two branches in order to restore 100% branch coverage 
after recent changes to in-memory database processing.

FossilOrigin-Name: 6ce6ff4402241d5c76acd0c60c85097dfcd7fd7c
 2009-11-23 15:59:27 +00:00
dan
f6963f99dd Change so that deleting an Expr structure requires only one frame per level in the expression tree, not two. 
FossilOrigin-Name: a4380ab326e4b0de29271c824d041193e86b7139
 2009-11-23 14:39:14 +00:00
drh
bfcb4adaf8 Fix a bug in transaction rollback during backup when the CODEC is enabled 
that can result in a corrupt backup file.  This is only a problem when
SQLITE_HAS_CODEC is defined.

FossilOrigin-Name: f3398fc4db765e2c63d425d570c4469a84b3328c
 2009-11-21 01:33:50 +00:00
drh
8c30f72deb When moving pages as part of autovacuum on an in-memory database, make sure 
that the source location is journalled so that a ROLLBACK can occur.
Part of the fix for ticket [564d412f15a00]

FossilOrigin-Name: 2f42f91fe65b0b21671936013df08037091f0cc6
 2009-11-20 18:48:35 +00:00
drh
456e4e4fba Fix a bug in LIMIT 0 for compound SELECT statement. 
The problem was introduced by recent enhancements and has not appeared
in any release.

FossilOrigin-Name: c6ed7e2a73a7a65cfa914ffcad4f603b6b7a22a8
 2009-11-20 16:13:15 +00:00
drh
3278315768 If the root pages numbers of the internal schema are adjusted due to 
autovacuum on a DROP TABLE statement and that statement later aborts (for
example, due to an OOM error) then reset the internal schema at the
conclusion of the statement.
Partial fix for ticket [564d412f15a].

FossilOrigin-Name: e493b093f8ca722c3160b32a16fb615023978dc9
 2009-11-20 15:02:34 +00:00
drh
98829a65cd Avoid unnecessary page cache allocations when move a page while autovacuuming 
an in-memory database, since the allocation might fail making it impossible to
rollback the transaction.

FossilOrigin-Name: 9a429349ccc2fa9acd28365a86578f602e87dafb
 2009-11-20 13:18:14 +00:00
drh
88376ca791 Remove an unreachable branch from the OP_Affinity suppression logic. 
FossilOrigin-Name: 598727e6dae87f133c658fa125684f6ad978be60
 2009-11-19 15:44:53 +00:00
dan
91b71c1ab2 Merge with [4bd4330709]. 
FossilOrigin-Name: 7a46d1ebe348ce9f1e8732617a8e280f152fe979
 2009-11-19 14:57:14 +00:00
drh
cd7f457e6d Fix a bug introduced with recent optimizations: The unary minus operator 
is TK_UMINUS, not TK_MINUS.

FossilOrigin-Name: 4bd43307090258f8652c995b056101c51b81274a
 2009-11-19 14:48:40 +00:00
dan
44e0d68c44 Merge the fts3-refactor branch with the trunk. 
FossilOrigin-Name: c8d2bd37a4c16154912a0831690584011dc230cb
 2009-11-19 02:52:57 +00:00
drh
f25a5071a6 Performance improvement by avoiding unnecessary calls to memset(). 
FossilOrigin-Name: 85940468e6f93f7c493fbc129f13cf6233c5d0c0
 2009-11-18 23:01:25 +00:00
drh
2f2855b638 Suppress more instances of unnecessary OP_IsNull and OP_Affinity opcodes. 
FossilOrigin-Name: bf6c0bd1c5568c6292ea0a64c8a5071e1bd3079a
 2009-11-18 01:25:26 +00:00
drh
3c65721a5b Enhancements to the VDBE opcode loop to reduce the number of machine-code 
instructions evaluated by about 10%.

FossilOrigin-Name: 9744ffb3f5bc6d8fd59fbb6577a0d549411cd967
 2009-11-17 23:59:58 +00:00
drh
039fc32e84 Code generator tries to avoid pointless OP_IsNull and OP_Affinity opcodes. 
FossilOrigin-Name: ebb0c8a3e977dc741704e733b5a5d931d9b27028
 2009-11-17 18:31:47 +00:00
drh
68ff78b1b0 Make sure the output of sqlite3OsFullPathname is initialized even if the 
fails due to I/O or OOM errors.

FossilOrigin-Name: e4943adb83819dee06e2e9da25ff6d967ca170de
 2009-11-16 23:36:33 +00:00
drh
f6a82030a8 Fix a reference to freed memory that can occur following an OOM error in 
where.c.

FossilOrigin-Name: 929b6047391411c6f539e47afe6b63d16e352ccb
 2009-11-16 22:54:50 +00:00
drh
372726336b Back out part of the change in [23ea2b700fd6d28d] since TH3 reveals some 
problems in OOM situations.

FossilOrigin-Name: 15d215d62df72c1bf1e605629692ee40d96546a6
 2009-11-16 21:28:45 +00:00
drh
af2b572028 Use the sqlite3CtypeMap[] to improve the speed and reduce the size of the 
logic in the tokenizer that recognizes identifiers.

FossilOrigin-Name: 1c9243b0760741f48b15efb0da661255177aed8b
 2009-11-16 15:11:51 +00:00
drh
d93a8b276d Additional optimizations in sqlite3VdbeRecordCompare(). 
FossilOrigin-Name: 23ea2b700fd6d28d3b13663d164faba3760c572e
 2009-11-16 03:13:40 +00:00
drh
8b249a886d Optimizations to the sqlite3VdbeRecordCompare() routine help it to run 12.5% 
faster for some traces.

FossilOrigin-Name: 74c76f0bf946d184275de478ec72220d76342493
 2009-11-16 02:14:00 +00:00
dan
4b4d4469f5 Fixes to fts3 integrity check code. 
FossilOrigin-Name: d3cae986ee1a176b1b015c3cebcd58ff0c3bdf92
 2009-11-14 23:50:11 +00:00
drh
a6c2ed91ca Optimizations to the main loop inside sqlite3VdbeExec() to help VDBE byte code 
run a few percent faster.

FossilOrigin-Name: d622ac6ac7a297754494d3a33dbaeea02836272e
 2009-11-14 23:22:23 +00:00