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

2168 Commits

Author SHA1 Message Date
drh
748a52cdcb Add an assert() with an evidence mark to show that automatically 
generated rowids are positive.

FossilOrigin-Name: 740adca34e7fd309f0f761b8cc8581a9b7890793
 2010-09-01 11:50:08 +00:00
shaneh
c4d340a096 Ensure randomly generated rowids never go negative. 
FossilOrigin-Name: 631423677bd7043e99987edc633005443125181c
 2010-09-01 02:37:56 +00:00
dan
c311feec55 Do not clear the internal "schema has changed" flag when performing a savepoint rollback. The schema changes may not have taken place within the savepoint being rolled back. 
FossilOrigin-Name: c2a84430d3b6bb53b19af9294973575178290f93
 2010-08-31 16:25:19 +00:00
drh
d4187c716c Provide hints to the btree layer during the creation of transient tables 
when it is possible for those tables to use a hash rather than a binary tree.
No use is current made of those hints, though assert() statement verify
their accuracy.

FossilOrigin-Name: 4fead8e714c7e50a9d246467e62bc846ef6180a0
 2010-08-30 22:15:45 +00:00
drh
75c014c321 Remove the sqlite3BtreeFactor() wrapper routine. All modules now call 
sqlite3BtreeOpen() directly.

FossilOrigin-Name: 0900e35348f4b9bf327d6ae2884c4ddbb6345d8d
 2010-08-30 15:02:28 +00:00
drh
710c4841b0 Updates to comments on the VDBE opcodes. 
FossilOrigin-Name: 49c05b4e08920797f3a5dd14c292e2275db61acb
 2010-08-30 01:17:20 +00:00
dan
a235d0ca63 Fixes to allow fts3 tables to be renamed mid-transaction. 
FossilOrigin-Name: d1c875320a045c3938c765ceb543dfba1a0ecf0b
 2010-08-24 16:59:47 +00:00
drh
3bb9b93f1f Change two automatic array variables into static constant arrays. 
Update and reformat some comments for cleaner presentation.

FossilOrigin-Name: a7a15547cccb4aeb719aba19641f31390c316d8c
 2010-08-06 02:10:00 +00:00
drh
b975598ea0 Make sure all memory from sqlite3DbMalloc() is freed by sqlite3DbFree() and 
all memory from sqlite3_malloc() is freed by sqlite3_free().

FossilOrigin-Name: ac1f37a647e9ed1c00a901d26d9956a86c40117a
 2010-07-24 16:34:37 +00:00
drh
6e1f482824 Tweaks to the new shared-memory interface design - mostly comment changes. 
FossilOrigin-Name: 6336de7aa96a6e1e68cc123e5d5f485d790d95a2
 2010-07-13 23:41:40 +00:00
drh
c6b2a0ff99 Change the journal_mode pragma to remove the "default journal mode" concept. 
The journal_mode pragma only effects currently attached databases and does 
not change the behavior of future attachments.

FossilOrigin-Name: e396184cd3bdb96e29ac33af5d1f631cac553341
 2010-07-08 17:40:37 +00:00
dan
2411dea3ca Change code in OP_Rewind to avoid a valgrind warning following an error in the btree layer. This change does not fix any bug, just a warning. 
FossilOrigin-Name: 4f62dbcfc96855f69e71d163bfc051d9db08cca9
 2010-07-03 05:56:09 +00:00
drh
cac29a67e9 Omit the OP_JournalMode opcode from the VDBE when SQLITE_OMIT_PRAGMA is 
defined.

FossilOrigin-Name: 565ff65c61c85c9b2122b31bd9792692aa1e9cda
 2010-07-02 19:36:52 +00:00
drh
242c4f7702 When trying to transition from journal_mode MEMORY to WAL, use OFF as an 
intermediate journal mode.

FossilOrigin-Name: 4775b8f9a9d9b66fcd5abf3af111fcad249e662e
 2010-06-22 14:49:39 +00:00
dan
d956efebea Rearrange some code in OP_JournalMode to avoid incorrect returns from subsequent invocations of "PRAGMA journal_mode" following an IO error. 
FossilOrigin-Name: ce0a4a9b5f981d066822a9ae63740c91b35bfc60
 2010-06-18 16:13:45 +00:00
dan
731bf5bcf8 A different fix to [fc62af4523]. When changing from journal_mode=PERSIST or TRINCATE to some other rollback mode, delete the journal file only if a RESERVED lock can be obtained on the database file first. 
FossilOrigin-Name: b9b11855e8a9522309dd30e5256bb67d67e1353a
 2010-06-17 16:44:21 +00:00
drh
0b9b4301b8 Refactor and simplify the logic used to change journalmode. 
FossilOrigin-Name: 95cc3f6fdec5494560c3cd4439d06870d1c62506
 2010-06-11 17:01:24 +00:00
drh
4222441dee Remove the tests that enable tracing based on the existance of the "vdbe_*" 
files when in SQLITE_DEBUG mode.

FossilOrigin-Name: cdbb4e7ca7ec27e7e80dd66529d9d565f547887a
 2010-05-31 14:28:25 +00:00
drh
89c3f2ff43 Silently ignore errors trying to set the default journal_mode while doing 
an ATTACH.

FossilOrigin-Name: b9af4ad2efadfb2fb9e338dc081a6231f1536700
 2010-05-15 01:09:38 +00:00
drh
d9e5c4f6ed Refactoring the VFS-SHM methods used by WAL. This version compiles and 
runs non-WAL test cases but crashes and burns on wal.test.

FossilOrigin-Name: 2b00152c1ac0b3735aa6cfab61259ff04d81c701
 2010-05-12 18:01:39 +00:00
drh
eaf52d883a Remove the OP_Variable optimization of check-in [48b77b04935d894] since it 
can lead to malfunctions as described in ticket [26ff0c82d1e90].

FossilOrigin-Name: 7838163d087780a6fb403a17641b96f71baec088
 2010-05-12 13:50:23 +00:00
drh
be5481578a When an attempt to change journal_mode fails due to locks, be sure to 
leave internal structures in a consistent state.

FossilOrigin-Name: cf3d1e0b8a739302cf2848ac3e6eaaae04e6a44c
 2010-05-11 14:00:39 +00:00
drh
ab9b74443c Enhance the OP_JournalMode opcode with an ignore-errors option and use that 
option the ATTACH command.

FossilOrigin-Name: 0bdea4cfbd7832f2a00c01b93c92ba13d20139ef
 2010-05-10 11:20:05 +00:00
drh
3ebaee9633 The PRAGMA journal_mode=WAL; command now makes WAL the default journal mode 
for new databases added with ATTACH, so the behavior is consistent with the
other journal modes.

FossilOrigin-Name: c3520460a4a39fc5e981c3033068ffbb422a4af2
 2010-05-06 21:37:22 +00:00
drh
6e5b37faef After throwing an error to say that one cannot change into WAL mode within 
a tranactions, do not then go and change into WAL mode.

FossilOrigin-Name: 56a17dae91600a3863903f8d654ed52a0f720caf
 2010-05-06 16:06:38 +00:00
dan
586b9c8a94 Add the sqlite3_wal_checkpoint() and sqlite3_wal_autocheckpoint() APIs. 
FossilOrigin-Name: 9803196dec85e3aa4105cc477e9cfe98d370e486
 2010-05-03 08:04:49 +00:00
dan
5cf53537a8 Support compile-time option SQLITE_OMIT_WAL, for building without WAL support. 
FossilOrigin-Name: 9b230c43dfa112e3e1589f9775926807bd36b36e
 2010-05-01 16:40:20 +00:00
drh
d80b233850 Do not allow journal_mode=WAL if the underlying VFS does not support xShmOpen. 
FossilOrigin-Name: d1fcccecdc8e9ac5d0d022914e51c545f4e1b04f
 2010-05-01 00:59:37 +00:00
drh
7ed91f2344 Refactor wal.c to use the VFS. This check-in compiles and links and works 
ok as long as you leave WAL turned off, but WAL does not work.

FossilOrigin-Name: 62db5fa3b61be885b2d94e9b9ce3877b2c588350
 2010-04-29 22:34:07 +00:00
dan
e180c296ea Do not attempt to set journal_mode=wal on :memory: or temp file databases. 
FossilOrigin-Name: 30d0134454734fd9335896372c30a903e9adcc64
 2010-04-26 17:42:56 +00:00
dan
ede6eb8d1d Further tests and changes related to switching between WAL and rollback modes. 
FossilOrigin-Name: 1236318477787a612f02cc98caf2931bd2e99d94
 2010-04-22 06:27:04 +00:00
dan
b978002743 Tests for (and changes to) the code to switch between WAL and rollback modes. 
FossilOrigin-Name: 9f4f933f2c6596064fcfc7fb5add87e8c5b57448
 2010-04-21 18:37:57 +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
dan
f05c86dd73 Remove old code to interpret an argument (no longer used) to "PRAGMA checkpoint". 
FossilOrigin-Name: 27dc5977c19e717afd65d3805557e38dec7bedcb
 2010-04-13 11:56:03 +00:00
dan
7c24610e64 Import experimental write-ahead-logging code. 
FossilOrigin-Name: 409d61baeb0a19d1700c973f16c8acef7b8506cd
 2010-04-12 19:00:29 +00:00
drh
ab5cd70ae5 Fix the trace output of the OP_Function opcode to show the correct 
register numbers.

FossilOrigin-Name: 064c283eee82c5053e84058a0e1908e468da6ce3
 2010-04-07 14:32:11 +00:00
drh
a21a64dd0c Veryquick.test is now working. The SQLITE_STMTSTATUS_AUTOINDEX counter 
added.

FossilOrigin-Name: abbf16e5e7895971710fb3a8fd9c782fc1218a77
 2010-04-06 22:33:55 +00:00
drh
25d3adbb6a Minor comment changes to the OP_OpenEphemeral header. No changes to code. 
FossilOrigin-Name: 8e1d7ef47f643503aa823d9986a931a83c63648b
 2010-04-05 15:11:08 +00:00
drh
afc266a76a Clarification of the implementation of SQLITE_STMTSTATUS_FULLSCAN_STEP. 
No logical code changes - just commenting and layout changes to improve
readability.

FossilOrigin-Name: 06b9ca32255572a699dc51f46f848d0bf01255e1
 2010-03-31 17:47:44 +00:00
drh
b1299158c7 Continuing refinements to the filesize-in-header enhancement. 
FossilOrigin-Name: 79e22b95038c50b9b7f35e09262805ff6338b59b
 2010-03-30 22:58:33 +00:00
dan
b7dca7d733 Modify the vdbe so that the comparison operator opcodes do not modify the data type of operands. Fix for [aa92c76cd4]. 
FossilOrigin-Name: 8858042fa1449516a2c7dbb991dca3eb6c5794cb
 2010-03-05 16:32:12 +00:00
drh
a64fa9123e Increase the maximum length of an sqlite3_log() result string. Provide more 
details on the statement abort log message.

FossilOrigin-Name: 5322d1df5ba981001d248b7fb2ee02281e4f9723
 2010-03-04 00:53:32 +00:00
shaneh
84f4b2f237 Minor changes to silence some compiler warnings with MSVC. 
FossilOrigin-Name: 4927c62d6214d93e582bf1266215ed3519630c15
 2010-02-26 01:46:54 +00:00
drh
af46dc12f7 Add testcase() macros beside each sqlite3_log() call to make sure it is 
tested with both logging enable and disabled.

FossilOrigin-Name: 1168763d2cd96acfa0488198e8bc82f0c4fa35a3
 2010-02-24 21:44:07 +00:00
drh
cda455b7ff Add a sqlite3_log() call on anonymous constraint failures. 
Fix the output of test cases having to do with improved reprepare reporting.
Fix the VACUUM command to report more helpful error messages when things go
wrong.

FossilOrigin-Name: 69a493182fd77bec91598516ee42c11a6db1d039
 2010-02-24 19:23:56 +00:00
drh
413c3d36a2 Continuing improvements to error reporting and the sqlite3_log() routine. 
FossilOrigin-Name: edea3bb740ddd096a46e00678b59d465bb1e2903
 2010-02-23 20:11:56 +00:00
drh
9978c97ec5 Remove the obsolete sqlite3SafetyOn() mechanism. Add additional logging 
output for CORRUPT, and CANTOPEN errors.

FossilOrigin-Name: 7c4cca6d1a23a6d1591b62f58c3716a944969947
 2010-02-23 17:36:32 +00:00
drh
2d8d7cebe1 Fix a typo in the documentation for the OP_OpenPseudo opcode. 
FossilOrigin-Name: 9acfb0694059c80b2efc08a60232d4be91575c32
 2010-02-15 15:17:05 +00:00
drh
6658cd9a74 Remove the use of 64-bit math in the offset computations of 
the OP_Column opcode for a small performance improvement.

FossilOrigin-Name: 61a2c8d4d64c28119e9f06eb42f9c0437ba7a7bd
 2010-02-05 14:12:53 +00:00
drh
c5a7b51c69 When SQLITE_OMIT_FLOATING_POINT is defined, make sure the result of a 
mathematical operation is always tagged as an integer.

FossilOrigin-Name: e12da0d316fcc34a75554d59fe6d11d9f0e059e2
 2010-01-13 16:25:42 +00:00