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
13,071 Commits 1,785 Branches 392 Tags
threadtest3
Commit Graph

887 Commits

Author SHA1 Message Date
drh
425e27db12 Add the sqlite3_cancel_auto_extension(X) interface which will undo a prior 
call to sqlite3_auto_extension(X).

FossilOrigin-Name: cdce87eb889a43dafcc560d5f97ab517d0266860
 2013-07-15 17:02:28 +00:00
drh
a95882ff39 Change the description of how sqlite3_progress_handler() works so that 
the N parameter is "approximate".  This aligns with the current implementation.
This is a documentation change only.  No changes to code.

FossilOrigin-Name: 7d829bdea3adcda50fbe930acb4e1ce73fd874e6
 2013-07-11 19:04:23 +00:00
drh
648e264342 Add the "defer_foreign_keys" pragma and the SQLITE_DBSTATUS_DEFERRED_FKS 
value for sqlite3_db_status().  This is a cherry-pick of a sequence of five
checkins in the sessions branch between [1d44e5d3c2] and [d39e65fe70].

FossilOrigin-Name: 527121ac3cdc96ac33ad975c227a6685a2f7e999
 2013-07-11 15:03:32 +00:00
drh
8d56e2059c Issue the new SQLITE_WARNING_AUTOINDEX warning on the SQLite log whenever 
an automatic index is created.

FossilOrigin-Name: 338826ef3f8a209b14f8d42370855cab9ac9ed45
 2013-06-28 23:55:45 +00:00
dan
f73819af05 Add extended error code SQLITE_BUSY_SNAPSHOT - returned in WAL mode when a read-transaction cannot be upgraded to a write-transaction because it is reading from a snapshot other than the most recently committed. 
FossilOrigin-Name: 361c22969aa75340ed696e00e3dc5d17d5493bee
 2013-06-27 11:46:27 +00:00
drh
bf159fa21b Add a new (experimental) sqlite3_stmt_status() verb that returns the number 
of VM steps.

FossilOrigin-Name: f1366bab737a3ac2ea20a0ec014cc306d7ded8a5
 2013-06-25 22:01:22 +00:00
drh
ee0231ef52 Updates to the Codec interface to support codecs on attached databases and 
to allow rekeying in the middle of a transaction.  These changes are only 
applicable if SQLite is compiled with SQLITE_HAS_CODEC.

FossilOrigin-Name: d5b084e9d8cfe9c0c339aca076d472bb50aa764c
 2013-05-29 17:48:28 +00:00
drh
9a1eccb621 Update the documentation to explain that when the 3rd parameter to 
sqlite3_bind_text() and friends is NULL the result is to bind a NULL
SQL value.  Ticket [19b44e35753ba]

FossilOrigin-Name: bd92de0e8d922b96513c5d431493800dda7e7562
 2013-04-30 14:25:32 +00:00
drh
a13090fee9 Fix a formatting typo in a comment. No changes to code. 
FossilOrigin-Name: 7a97226ffe174349e7113340f5354c4e44bd9738
 2013-04-26 19:33:34 +00:00
drh
9ea88b2b48 Update documentation with new hyperlinks. No changes to code. 
FossilOrigin-Name: 640eb54ad6aac9bc7109cba167389a9bcec3f21e
 2013-04-26 15:55:57 +00:00
drh
b9830a1454 Enhanced documentation for the SQLITE_CONFIG_SQLLOG mechanism and the 
test_sqllog.c demonstration file.  No changes to code.

FossilOrigin-Name: 206caf21f6f6963aa38a9aa0f6ea11c7230bb726
 2013-04-22 13:51:09 +00:00
drh
c288e442e3 Experiments in making loadable extensions easier to program. The 
shared library filename tries various operating-system specific extensions
if the bare library name does not work.  And the entry point is derived
from the filename is the legacy entry point name "sqlite3_extension_init"
is not found.

FossilOrigin-Name: 6cfa1d73d79b9f0be8157f0a37c264dd95b031c8
 2013-04-18 22:56:42 +00:00
drh
4670f6d5f6 Improvements to some of the comments that are used to render documentation 
concerning loadable extensions.  No changes to code.

FossilOrigin-Name: 76f4e31245fd1676a4520a2f7488bca6eb981e4a
 2013-04-17 14:04:52 +00:00
drh
9b4c59fa1b Refactoring the mmap interface. The controlling pragma is now "mmap_size" 
instead of "mmap_limit".  Also change SQLITE_CONFIG_MMAP_LIMIT and
SQLITE_FCNTL_MMAP_LIMIT to SQLITE_CONFIG_MMAP_SIZE and
SQLITE_FCNTL_MMAP_SIZE, respecctively.  
The default mmap_size is now always 0, meaning that
memory mapped I/O is off by default.  There is a new compile-time option
SQLITE_MAX_MMAP_SIZE that determines a hard upper bound on the mmap_size.
Setting SQLITE_MAX_MMAP_SIZE to zero disables the memory-mapped I/O logic
and causes it to be omitted from the build.  An extra argument is added
to SQLITE_CONFIG_MMAP_SIZE that can optionally lower the SQLITE_MAX_MMAP_SIZE
at start-time. The SQLITE_MAX_MMAP_SIZE is zero for platforms where we 
know that it does not work, meaning that it cannot be turned on by mistake
on those platforms.

FossilOrigin-Name: ea1404a10abd7f68e1f8e0708c8a3199d1f79665
 2013-04-15 17:03:42 +00:00
drh
a1710cc2ea Fix a formatting typo in a comment. No changes to code. 
FossilOrigin-Name: 3412424990c93d2978e819e6099811f1cdde316d
 2013-04-15 13:10:30 +00:00
drh
d040e76442 Add new primary error codes SQLITE_NOTICE and SQLITE_WARNING for use with 
sqlite3_log().  Add new extended error codes SQLITE_NOTICE_RECOVER_WAL and
SQLITE_NOTICE_RECOVER_ROLLBACK to use with sqlite3_log() messages that occur
on each recovery.

FossilOrigin-Name: be7d2c5482c41baf000d7fb5dccc31b974e91064
 2013-04-10 23:48:37 +00:00
drh
56282a5bc7 Add the sqlite3_strglob() interface. 
FossilOrigin-Name: 41d6ff32a6dd1311dc3aabe5156335a64a886919
 2013-04-10 16:13:38 +00:00
drh
67f7c780f3 Updates to the file-control documentation. No changes to code. 
FossilOrigin-Name: 51fab480d0487107709e6c9e00bc0512b82ef1aa
 2013-04-04 01:54:10 +00:00
drh
34f7490311 Change the mmap_limit pragma to report the new limit, or to report the 
existing limit if called with no arguments.  Report the default mmap_limit
as part of PRAGMA compile_options.  Set the default mmmap_limit to 0 for
all systems other than linux, mac, windows, and solaris.

FossilOrigin-Name: 2d9f1327fe79e40435ce1e2594d7cd9a5aea0ef2
 2013-04-03 13:09:18 +00:00
drh
a1f42c7c32 Add the SQLITE_CONFIG_MMAP_LIMIT configuration option for overriding the 
SQLITE_DEFAULT_MMAP_LIMIT compile-time setting.  Enhance "PRAGMA mmap_limit"
so that without a specific database name, it sets the limit on all database
files and changes the default for any future databases that might be added
using ATTACH.

FossilOrigin-Name: 78141d0a16dd1d56b575fccd149de7fa789cb06c
 2013-04-01 22:38:06 +00:00
drh
0d0614bdc6 Memory-mapped I/O is now on by default. The "PRAGMA mmap_limit(N)" can be 
used to issue a hint to the VFS to limit mmap space to N bytes.  The VFS
is free to ignore that hint if desired.  However, if "PRAGMA mmap_limit(0)"
is used, xFetch is never called.

FossilOrigin-Name: 1b37c4effdd03aa2ea938a71b4f22ed27391689b
 2013-03-25 23:09:28 +00:00
drh
dee6554811 Merge all recent trunk changes into the experimental-mmap branch. 
FossilOrigin-Name: a607d63f0b6a3d3785e9385187d3e6b92e14fc70
 2013-03-25 19:57:26 +00:00
dan
df737fe6f5 Change the signature of the xUnfetch method to "int (*xUnfetch)(sqlite3_file*, sqlite3_int64 iOfst, void *p)". 
FossilOrigin-Name: 115b830509e8f0aa9d5965c1e9cd4f2ed9d01938
 2013-03-25 17:00:24 +00:00
dan
aef49d7141 Remove unnecessary code to round the size of a memory mapping to 4KB from os_unix.c. Rename SQLITE_IOERR_MREMAP to SQLITE_IOERR_MMAP. Fix other small issues in os_unix.c. 
FossilOrigin-Name: dce35c01a5fe66d2970075b1e3f0376026485e4c
 2013-03-25 16:28:54 +00:00
dan
f23da96636 Replace the sqlite3_io_methods.xMremap interface with sqlite3_io_methods.xFetch and xUnfetch. 
FossilOrigin-Name: 1431be95579160fb70408d43e17fc23c7b69ab4a
 2013-03-23 21:00:41 +00:00
mistachkin
48864df97d Many spelling fixes in comments. No changes to code. 
FossilOrigin-Name: 6f6e2d50941e444ebc83604daddcc034137a05b7
 2013-03-21 21:20:32 +00:00
dan
eb97b29345 When possible, use memory mapping when appending new pages to a database file. 
FossilOrigin-Name: 14135da3cdbafd699563a29608f32347cda28338
 2013-03-20 14:26:59 +00:00
dan
5d8a137218 Add the sqlite3_io_methods.xMremap() method to the VFS interface. Also "PRAGMA mmap_size". 
FossilOrigin-Name: 6183f1bd86ceed76d22d9762f3d7eb33262c62d1
 2013-03-19 19:28:06 +00:00
drh
ce3ca25cbc Clarifications to the documentation for the sqlite3_aggregate_context() API. 
Also, shorten an over-length source line in sqlite.h.in.

FossilOrigin-Name: 4fe2db1d866c80fe51f7fddbf9ce6753fb55b5f6
 2013-03-18 17:18:18 +00:00
dan
b2d3de3bf4 Use mmap() to read from the database file in rollback mode. This branch is unix only for now. 
FossilOrigin-Name: 6f21d9cbf5d457e63a7282015a89ae785526cf6d
 2013-03-14 18:34:37 +00:00
mistachkin
f5840160b7 Fix typo in sqlite3_close() function documentation reported on the mailing list. 
FossilOrigin-Name: 7232093d6c6871a9f4ea155ab215e3b39c1c322d
 2013-03-12 20:58:21 +00:00
dan
e3664fb03c Add extended error code SQLITE_READONLY_ROLLBACK. Returned if a read-only connection cannot read the database because doing so would require it to roll back a hot-journal. 
FossilOrigin-Name: 39247b14a52b0c0222fe5a848bf0aef0854058c4
 2013-03-05 15:09:25 +00:00
drh
433dccfb52 Rename SQLITE_CONSTRAINT_RAISE to SQLITE_CONSTRAINT_TRIGGER. Put the 
extended constraint error codes in alphabetical order.  Add many test cases
for the extended constraint error codes.

FossilOrigin-Name: 3f67437536591a1b0742a25b983707933aaa16d5
 2013-02-09 15:37:11 +00:00
drh
d91c1a1768 Add extended error codes for constraint errors. 
FossilOrigin-Name: 5461104668a49529577f21df97f6a0e7d8f0c679
 2013-02-09 13:58:25 +00:00
drh
39ac5de6c5 Fix a typo in a comment that is used to generate 
documentation.  No changes to code.

FossilOrigin-Name: e38adb60a7952ca9e28e496b4e4658c724a368d2
 2012-12-11 19:10:37 +00:00
drh
696b33e622 Add the SQLITE_FCNTL_TEMPFILENAME file control that asks the underlying VFS 
to return a new temporary filename.  Per request from NSS team at Mozilla.

FossilOrigin-Name: 1a63b1d5fa5d79f96eddbda6d94bc10248863710
 2012-12-06 19:01:42 +00:00
dan
71ba10d3c9 Fix problems in test_sqllog.c. Clarify the experimental SQLITE_CONFIG_SQLLOG interface. Handle at least the more likely error conditions in test_sqllog.c. 
FossilOrigin-Name: 429c5b2056d7b7c644ca53bc97b8e0b9cb89ab04
 2012-11-27 10:56:39 +00:00
dan
ac45593931 Add an option to register global hooks used for logging all SQL executed by an application. 
FossilOrigin-Name: cd501bbccf3e62b002317592cc331770b32c129a
 2012-11-26 19:50:41 +00:00
dan
9fc5b4a539 Change os_unix.c to propagate ENOENT errors back to sqlite as SQLITE_IOERR_DELETE_NOENT. Have SQLite ignore these where they are benign and propagate them back to the caller where they may indicate a file-system malfunction of some description. 
FossilOrigin-Name: bed9c172ce624ab7b5b9de9ad42444891717ad9a
 2012-11-09 20:17:26 +00:00
dan
80bb6f8217 Add SQLITE_FCNTL_BUSYHANDLER. Invoked to provide access to the busy-handler callback to custom VFS implementations. 
FossilOrigin-Name: 1262d2f471214a3417dd02159a7aa2355b18f789
 2012-10-01 18:44:33 +00:00
drh
86ae51c991 Update documentation to describe the threadsafety of 
sqlite3_enable_shared_cache().

FossilOrigin-Name: e081890cd77ad8de4bf55a8f8cf9d63bfaaf8218
 2012-09-24 11:43:43 +00:00
drh
de9a7b8a94 Add the ability to disable the covering-index-scan optimization at compile-time, 
start-time, or at run-time.  Add test cases to check this configurability.

FossilOrigin-Name: ccb8ecc30c8e6c7760131250297c2e452bbac43b
 2012-09-17 20:44:46 +00:00
mistachkin
7ea11af2d6 Improved reporting of filename translation errors in the Windows VFS. 
FossilOrigin-Name: eb0f1c292e6fb00c4d9dbb2317fdc4717c5be96b
 2012-09-13 15:24:29 +00:00
mistachkin
5dac843233 Added sqlite3_errstr API to translate a result code to the corresponding error message. 
FossilOrigin-Name: bf8a9ca5b58404112a8af666f5840b462b7bbfe1
 2012-09-11 02:00:25 +00:00
mistachkin
60a7523bd3 Fix typo in documentation for sqlite3_open_v2. No changes to code. 
FossilOrigin-Name: b532120a4a567a3fa54b87dd8ab94cc2c0347c7c
 2012-09-10 06:02:57 +00:00
drh
7a5d80e929 Formatting changes to the C code example in the documentation for 
sqlite3_temp_directory().  No changes to code.

FossilOrigin-Name: 5b4b39788ed9ac5962a17315d5549fc5e3f38c5e
 2012-08-28 00:17:56 +00:00
mistachkin
40e6319b61 Update API docs to include notes about the WinRT temporary directory. No changes to code. 
FossilOrigin-Name: eaeeb0699297dde824788e2907a0cfd2acd8f642
 2012-08-28 00:09:58 +00:00
mistachkin
d5578433ff Fix all known instances of 'repeated the' style typos in comments. No changes to code. 
FossilOrigin-Name: 9b19b847533f944f289d93dcdba29c0d67bf251c
 2012-08-25 10:01:29 +00:00
drh
bcebd86f7c Clarify that the number-of-bytes parameter to sqlite3_bind_blob() must 
be non-negative.

FossilOrigin-Name: b1b01c4cd9798d69951665ed7d6d9f79f6b463a1
 2012-08-17 13:44:31 +00:00
mistachkin
dfbfbffd13 Fix typos of function names sqlite3_result_error_toobig and sqlite3_result_error_nomem in the documentation. No changes to code. 
FossilOrigin-Name: bec97c98130f057321f3db1436a24377c3c64f81
 2012-08-01 20:20:27 +00:00