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
dan
a550f2decd In shared-cache mode, do not allow one connection to checkpoint a database while a second connection is reading or writing the same shared-cache. 
FossilOrigin-Name: e75b52d156905ce16bedb94f65c01a4640bdfa75
 2010-08-02 10:47:05 +00:00
dan
e04dc88be5 Use the read and write version fields of the database header to mark a database as operating in wal-mode. 
FossilOrigin-Name: 96bef18c1411c3e0348295886f105e1646c46320
 2010-04-20 18:53:15 +00:00
drh
b1299158c7 Continuing refinements to the filesize-in-header enhancement. 
FossilOrigin-Name: 79e22b95038c50b9b7f35e09262805ff6338b59b
 2010-03-30 22:58:33 +00:00
drh
5b47efa662 All the secure-delete setting to be changed at run-time using a pragma. 
The SQLITE_SECURE_DELETE compile-time option determines the default setting.

FossilOrigin-Name: f72f8a870a0fc98a9f2b564ffafe7946bbce506e
 2010-02-12 18:18:39 +00:00
drh
f25a5071a6 Performance improvement by avoiding unnecessary calls to memset(). 
FossilOrigin-Name: 85940468e6f93f7c493fbc129f13cf6233c5d0c0
 2009-11-18 23:01:25 +00:00
drh
c81c11f62c Remove the obsolete "$Id:$" RCS identifier strings from the source code. 
FossilOrigin-Name: f6c045f649036958078cb15cd9d5453680c82b0c
 2009-11-10 01:30:52 +00:00
drh
ea8ffdfec7 Further simplifications to btree.c, especially the sqlite3BtreeKey() and 
sqlite3BtreeData() functions.  New assert() statements added to verify
that these routines are called correctly. (CVS 6917)

FossilOrigin-Name: 96cfd079528501f6f1e658ce8a5a4e3bdea729be
 2009-07-22 00:35:23 +00:00
danielk1977
3054866c7c Restore (btree_set_cache_size) to test3.c. This is used on unix for the tcl "crash tests". Make some functions no longer used outside of btree.c static. (CVS 6869) 
FossilOrigin-Name: 1d96ce8c76e007ca29e7971a6c72b6387fe0fb93
 2009-07-09 05:07:37 +00:00
danielk1977
3509a65827 Make the sqlite3BtreeMoveto function static, since it is only used from within btree.c. Remove unused function lockBtreeWithRetry from btree.c. (CVS 6850) 
FossilOrigin-Name: 30d5ec62ab6a85ee60ee4128e20959842f8c7ad1
 2009-07-06 18:56:13 +00:00
danielk1977
602b466e99 Cause opening a transaction on a sharable b-tree module automatically obtain a read-lock on page 1. This means there is no way for sqlite3BtreeGetMeta() to fail. (CVS 6836) 
FossilOrigin-Name: e3c055f167f895ae45858de9d9d8a264df2f36b6
 2009-07-02 07:47:33 +00:00
danielk1977
0d19f7ac57 Define a set of constants to use as the "index" argument to sqlite3BtreeGetMeta and UpdateMeta. This makes some parts of the code easier to follow. (CVS 6709) 
FossilOrigin-Name: 6dbf4eca00f845baa7200aba421d0bc158ba96aa
 2009-06-03 11:25:07 +00:00
danielk1977
4b0aa4cf3e Workaround the need for internal API sqlite3BtreeCursorDb(). It was only being used for an assert() statement, which can be done differently. (CVS 6683) 
FossilOrigin-Name: 5904af6e6df3effdaaa30e7cf96ee316fc09b28d
 2009-05-28 11:05:57 +00:00
danielk1977
de630353d8 Speed up INSERT operations that add data to UNIQUE or PRIMARY KEY indexes by rationalizing duplicate seek operations. (CVS 6599) 
FossilOrigin-Name: cac4f3d812f0a02ca5c1fa78d366f694403929a8
 2009-05-04 11:42:29 +00:00
danielk1977
f7590db099 Changes to ensure that when running in shared-cache mode with a non-threadsafe build, the correct busy-handler callback is always invoked. (CVS 6481) 
FossilOrigin-Name: 683e4bd74783e6e3f6cf75f9582008c7b7e02a01
 2009-04-10 12:55:16 +00:00
drh
ce4869f893 Make sure the VACUUM statement locks down the page_size and auto_vacuum 
modes after it runs.  Otherwise, pragmas might change these settings on
a populated database, resulting in problems. (CVS 6442)

FossilOrigin-Name: 85e6a4740d6db731c8c35a331031c346e9189c27
 2009-04-02 20:16:58 +00:00
danielk1977
bd43455c38 Fix some cases where executing SQL from within a user-function callback could cause problems related to statement-transactions. (CVS 6355) 
FossilOrigin-Name: a60f4191791dd7bb49d5c95b350a9924845b59a8
 2009-03-18 10:33:00 +00:00
drh
7f75122149 Move the rowid cache out of VdbeCursor and into BtCursor. When multiple 
BtCursors are open on the same table, set their rowid cache all at the
same time.  Ticket #3731. (CVS 6354)

FossilOrigin-Name: 189785832a7dc9f4a0a2113d850b92b987e0f9bf
 2009-03-17 22:33:00 +00:00
danielk1977
a55331620e Optimize queries of the form "SELECT count(*) FROM <tbl>" by adding a sqlite3BtreeCount() interface to the btree layer. (CVS 6316) 
FossilOrigin-Name: d4aa6593183224b6868a322511511c0bbf63b598
 2009-02-24 10:01:51 +00:00
danielk1977
0410302e58 Commit first version of the 'backup' feature. (CVS 6241) 
FossilOrigin-Name: 663479b417fc06ba1790a544f28694f8797cee57
 2009-02-03 16:51:24 +00:00
drh
dc86e2b2cd Fix some minor compiler warnings. Added sqlite3Isalpha() for use in 
the soundex() function. (CVS 6203)

FossilOrigin-Name: bfc71edca471221add6b32b867d0b15171974eaf
 2009-01-24 11:30:42 +00:00
danielk1977
fd7f045225 Add the savepoint feature. This feature is largely untested at this point. (CVS 6036) 
FossilOrigin-Name: 34b56600ec0c5cd7b5faab265750252bc9850e3e
 2008-12-17 17:30:26 +00:00
danielk1977
c7af484b4b Make sqlite3_count_changes() and total_changes() work with "DELETE FROM <table-name>". (CVS 5844) 
FossilOrigin-Name: e68e4282adb9003aa297d033aeb5d9cadee215cd
 2008-10-27 13:59:33 +00:00
danielk1977
be51a65dbc After an OP_NullRow is executed on a cursor, cause any subsequent OP_Next or OP_Prev to behave as if there were no more rows to traverse. Ticket #3424. (CVS 5782) 
FossilOrigin-Name: af679f6170b346fe61df7dae963b2a2853e62a62
 2008-10-08 17:58:48 +00:00
drh
e63d999189 Additional changes toward fixing ticket #3292. (CVS 5562) 
FossilOrigin-Name: 0b92cbf5255020d4fde382f81590ff0488936667
 2008-08-13 19:11:48 +00:00
drh
a34605859d Detect and handles the case where a row is modified or deleted while it 
is being read during SELECT processing. (CVS 5399)

FossilOrigin-Name: c80a5d09935c60a2a50bc262c172a94073355f0d
 2008-07-11 21:02:53 +00:00
drh
34004cebb6 Additional test coverage for the btree module. Remove the failsafe() macro 
and replace it with ALWAYS() and NEVER(). (CVS 5395)

FossilOrigin-Name: d7e2f0d2d45574d6191c1b191c0daf5260696f27
 2008-07-11 16:15:17 +00:00
drh
93a960a0a8 Remove unused code. Test coverage enhancements. Modify the algorithm used 
to select column names for VIEWs of joins so that the constructed column
names omits the underlying table names. (CVS 5386)

FossilOrigin-Name: 636cd723296a8b1709011fdd99b236ffddf3f1b0
 2008-07-10 00:32:42 +00:00
shane
a6f6d20568 Omit declaration for functions that are only used by asserts if asserts aren't being used (NDEBUG). (CVS 5173) 
FossilOrigin-Name: 5afc445a0e49def38f198455ffce9266fc8724ad
 2008-05-29 03:01:23 +00:00
drh
59020f32cd Use "(void)" function arguments in declarations instead of "()". Both are 
legal but some pedantic compilers complain about the latter.  Ticket #3086. (CVS 5050)

FossilOrigin-Name: a4149ca317c2fd7ce87b8f23029c3f87a7f4c2e8
 2008-04-26 13:39:46 +00:00
drh
e14006d0de Modify the {quote: IdxDelete} opcode so that it takes an array of registers rather 
than a record formed using {quote: MakeRecord.}  This avoids a needless packing
and unpacking of the record to be deleted. (CVS 4916)

FossilOrigin-Name: ee381b43563e1b0637ee74389d076dff77deddf9
 2008-03-25 17:23:32 +00:00
danielk1977
cd3e8f7ce9 Use a vdbe memory cell to allocate the space required for vdbe cursors. (CVS 4912) 
FossilOrigin-Name: 047153648155654b0cd70b811935209d2e21776c
 2008-03-25 09:47:35 +00:00
drh
1e968a0cbf Removed the direct btree tests - part of the ongoing effort to test by 
calling only public interfaces.  Modify the sqlite3VdbeRecordCompare
interface to used a pre-parsed second key - resulting in a 13%
performance improvement on speed1p.test. (CVS 4911)

FossilOrigin-Name: 0e1d84f2f456e7680bb667266745b629ddf3605f
 2008-03-25 00:22:21 +00:00
drh
e5fe690d75 In shared-cache mode, make sure the busy hander invoked is the 
busy handler associated with the database connection that caused
the lock contention in the first place. (CVS 4598)

FossilOrigin-Name: c9eb65912f61ce0a6b66fe253652a1827e46b12a
 2007-12-07 18:55:28 +00:00
drh
33f4e02af6 Honor the SQLITE_OPEN_ flags passed into sqlite3_open_v2(). Some 
test cases added but more are needed.  Ticket #2616. (CVS 4376)

FossilOrigin-Name: 020a2b10d408f51d4ef3211c5f701f5378fd4625
 2007-09-03 15:19:34 +00:00
drh
fb98264aab Fix for the sqlite3AbortOtherActiveVdbes() problem. (CVS 4328) 
FossilOrigin-Name: e40d40a5d41c491bef852a92e5846b273b206909
 2007-08-30 01:19:59 +00:00
drh
ff0587c632 Improvements to mutex asserts. The quick test runs to completion without 
assertion faults. (CVS 4324)

FossilOrigin-Name: 2732af0ec77dbc90c0439b6a61d893d9ea3b5697
 2007-08-29 17:43:19 +00:00
drh
1fee73e74a Better asserts(). But now some of the tests are busted again. (CVS 4320) 
FossilOrigin-Name: e8060f85e7871572e2a38dc96f03e6e1f34cc8fd
 2007-08-29 04:00:57 +00:00
drh
b1ab8ea7f3 More locking fixes. Now makes it all the way through quick.test. There 
are errors but no assertion faults.  Progress. (CVS 4319)

FossilOrigin-Name: 844d40b8379d3374130e2d94f6e32c2cda34e0ca
 2007-08-29 00:33:07 +00:00
drh
4cf7c7f7e7 The shared_err test runs with no errors. But a potential deadlock has been 
discovered and is still unfixed. (CVS 4317)

FossilOrigin-Name: f84550be0a0c9e5859b852863b9a8f8ed3fd6919
 2007-08-28 23:28:07 +00:00
drh
900b31ef49 Work toward correct btree locking in a multithreaded environment. (CVS 4307) 
FossilOrigin-Name: b8cc493b47e618648f645ab73eb0253739e03fcd
 2007-08-28 02:27:51 +00:00
drh
27641703cc A complete run of quick.test with mutex debugging enabled. (CVS 4266) 
FossilOrigin-Name: 783e07d561d1f5509de9475f3b9f38315f247002
 2007-08-22 02:56:42 +00:00
drh
b21c8cd4f6 The sqlite3_value object now carries an sqlite3* pointer to use for 
recording malloc failures.  This eliminates the need to pass sqlite3*
pointers into many internal interfaces.  Also added more mutexing. (CVS 4263)

FossilOrigin-Name: 9287276191a582c1cf7cf6b71d8399727d8e534d
 2007-08-21 19:33:56 +00:00
drh
d677b3d688 Work toward multithreading support. Currently crashes quickly on a test. (CVS 4253) 
FossilOrigin-Name: 1315bd8e125602275fb718780f9b2730bd37f6ab
 2007-08-20 22:48:41 +00:00
drh
e53831d644 Begin adding mutexes. Compiles without SQLITE_OMIT_SHARED_CACHE but we 
get an assertion fault on the shared cache testing. (CVS 4239)

FossilOrigin-Name: 4c1e9ffebe7c611a8b6a89153ae97ab9bca19ea3
 2007-08-17 01:14:38 +00:00
drh
87cc3b3180 Remove compiler warnings in the amalgamation. (CVS 3960) 
FossilOrigin-Name: c5754530c6b1a8151c558f33d27fed70c95a988b
 2007-05-08 21:45:27 +00:00
drh
f8e632b630 Add the max_page_count pragma used to limit the maximum size of a database 
file.  Untested. (CVS 3948)

FossilOrigin-Name: b1b74f06688fd90fcaf54cf95e2e7beeb5fc1040
 2007-05-08 14:51:36 +00:00
drh
db6f6a7737 Fix a header problem introduced in the previous check-in. (CVS 3929) 
FossilOrigin-Name: bece7a6bae3a52da03c25b577e15a648eb91805a
 2007-05-05 18:49:53 +00:00
danielk1977
dcbb5d3f47 Test interaction of incremental io and other database writes. (CVS 3922) 
FossilOrigin-Name: 4516416b4d38679ea7d259155f241e54c4c58d7d
 2007-05-04 18:36:44 +00:00
danielk1977
2dec97077b Cache the location of overflow pages in cursors used for incremental blob IO. (CVS 3899) 
FossilOrigin-Name: 349f1ea7895f06c40affc985a13aa6686dfdea07
 2007-05-02 16:48:37 +00:00
drh
b026e05eb2 Begin adding the zeroblob API to support incremental blob i/o. (CVS 3894) 
FossilOrigin-Name: 7a01836dde45098796693bc6cb6045c4059adf1a
 2007-05-02 01:34:31 +00:00