database/sqlite
1
0
Fork 0
mirror of https://github.com/sqlite/sqlite.git synced 2025-08-07 02:42:48 +03:00
Code Activity
29,798 Commits 1,570 Branches 184 Tags
tclsqlite-db-copy-fix
Commit Graph

5077 Commits

Author SHA1 Message Date
drh
fba5765b57 Fix two test cases (due to changes in the formatting of constraint errors) 
so that all tests now pass.

FossilOrigin-Name: 129e2b69178147d04ee27fce66c17b39f8654da3
 2013-11-11 23:02:10 +00:00
drh
cbf1b8ef7d Merge in the WITHOUT ROWID changes. A few tests are failing now. They will 
be fixed in a follow-on check-in.

FossilOrigin-Name: 5addd1234ded59ce60fb633b76ac87d483377edd
 2013-11-11 22:55:26 +00:00
dan
14ec33f73b Fix typos in compile and run-time tests of the sqlite library version number in rtree.c. 
FossilOrigin-Name: f58d57017199421167dae8ebc67db2f19be45082
 2013-11-11 19:56:35 +00:00
dan
a9f5815b67 Add a way for virtual tables to return the expected number of rows for a scan (not just the overall cost) to SQLite. Have the rtree module make use of this. 
FossilOrigin-Name: 5a3cfd747a85480d215784817c3821d87ecfa2f7
 2013-11-11 19:01:33 +00:00
dan
d6dd5def4d Fix a bug preventing FTS from correctly processing bracket tokens that are immediately preceded by characters that are neither whitespace or token characters. 
FossilOrigin-Name: 49be646cd981f8ff0434cf90d2748afa30260017
 2013-11-04 08:56:22 +00:00
drh
d63d4b7bd7 Merge all trunk changes since 3.8.1 into the sessions branch. 
FossilOrigin-Name: aa72ea8a004de7fe744fc13baef19d05aea607d5
 2013-10-28 22:47:24 +00:00
drh
05684271c6 Improved header comment with better instructions on the vfslog.c 
extension.

FossilOrigin-Name: 4bd592c8f0e011e203443a6e88008a61d6926df5
 2013-10-19 16:51:39 +00:00
drh
8f8b231239 Add the SQLITE_FCNTL_TRACE file control and generate it for OP_Trace 
when compiled with SQLITE_USE_FCNTL_TRACE.  Update vfslog.c to make
use of the new file control.  Also update vfslog.c to log UNLOCK events
before the fact, rather than afterwards.

FossilOrigin-Name: e801f35a96d861a1e5f223655af4c8a6a7e356bc
 2013-10-18 20:03:43 +00:00
drh
06d6efb661 Further enhance the vfslog extension to record the number of freelist pages 
and the first freelist page in CHNGCTR-READ and CHNGCTR-WRITE records.

FossilOrigin-Name: 08157524ca816a81f3c341097e23982727eaa125
 2013-10-18 17:42:35 +00:00
drh
2eebbf699e In the vfslog extension for FILECONTROL records, show the pragma name for 
SQLITE_FCNTL_PRAGMAs and the requested size for SQLITE_FCNTL_SIZE_HINT.

FossilOrigin-Name: f062969548da26850ceeb48d4283f6567f828887
 2013-10-18 14:37:26 +00:00
drh
d82d4750a8 Merge the latest trunk changes. 
FossilOrigin-Name: 5806546822b717d712dc7cd9de88a86f5bf2f715
 2013-10-16 14:32:47 +00:00
dan
a4bbc8b119 Add the "languageid" hidden column to fts4aux. 
FossilOrigin-Name: 891df358e51075fb937f34952ce43bf51130b0d0
 2013-10-15 19:06:17 +00:00
drh
9327c70f68 Merge the latest trunk changes into the sessions branch. This merge 
should fix the build for WinRT.

FossilOrigin-Name: e111e4edf9d7b2d4d6d6673a7576801839e9537d
 2013-10-15 14:10:44 +00:00
mistachkin
bc863b50ba Fix harmless macro redefinition warnings in the totype extension. 
FossilOrigin-Name: a38adeb7ffd77474754b66877d60717cdb3cb865
 2013-10-15 10:43:04 +00:00
mistachkin
0593516fcc Fix harmless compiler warning in the totype extension. Include all standard whitespace characters in totypeIsspace. Minor adjustments to style and comments. 
FossilOrigin-Name: 73238f655a58c810876f46cc04eab1ac2d5b8ef7
 2013-10-14 22:35:40 +00:00
drh
5f8cdac620 Move the tointeger() and toreal() functions out of core and make them into 
a run-time loadable extension.

FossilOrigin-Name: 9f66dd7e3790c04f0ab724419f5381bd21f9ebad
 2013-10-14 21:14:42 +00:00
dan
362d21614e Fix a crash in FTS incremental phrase processing that can occur if the second or subsequent token is much more common in the dataset than the first. 
FossilOrigin-Name: 0bf438fc30582a08fddfc3cec49366ee17ae2abe
 2013-10-14 20:30:51 +00:00
mistachkin
b084582299 Fix harmless compiler warning. 
FossilOrigin-Name: 4b130f88fba216e088f61252bbcdde57ec7ee6a9
 2013-10-12 02:33:22 +00:00
drh
4f99189051 Fix various harmless compiler warnings. Change the "warnings.sh" script to 
work with STAT4 instead of STAT3.

FossilOrigin-Name: 7df06684ab36bfdad9e9aca6940b7a665c2a0cb5
 2013-10-11 15:05:05 +00:00
drh
a63b852992 Synchronize with the trunk. 
FossilOrigin-Name: 136445ba020c9475d3f5a7843d7d0add98477138
 2013-10-10 20:13:18 +00:00
drh
a0cbd3fd17 Enhancements to the vfslog.c module to show all change-counter changes and 
to show the hostname and pid of the process that creates each log file.

FossilOrigin-Name: af7abebeb1f70466833bc766d294d721eaef746f
 2013-10-10 15:04:52 +00:00
drh
919e3b3908 Another fix to the hash signature algorithm in vfslog.c. 
FossilOrigin-Name: 34212aa8c405c4ff3f8045ec0cf2a860af61540f
 2013-10-10 13:41:04 +00:00
drh
7cd84ffc60 Fix the hash signature algorithm in vfslog.c. Add a utility program to 
show the hash signatures for every page of a database file.

FossilOrigin-Name: eaf4de13a63b2294ae575432a022493308a4313a
 2013-10-10 13:38:51 +00:00
dan
30e2f0ae08 Add ext/misc/vfslog.c, a VFS shim for unix that keeps a log of method calls made by SQLite. 
FossilOrigin-Name: 24a827b87666670c56d68a18685f4f712852fa92
 2013-10-10 13:04:46 +00:00
mistachkin
86f72f0721 Fix compilation issue with MSVC. 
FossilOrigin-Name: 36d64dc36f18c166b2c93c43579fa3bbb5cd545f
 2013-10-07 21:49:16 +00:00
dan
9211f8a6ce Allow FTS4 multi-token phrases to use a combination of in-memory and incrementally loaded doclists. This allows phrases to (partially) benefit from incremental doclists without disabling the deferred token optimization. 
FossilOrigin-Name: f6819c5f3363d358e7ef65fe6978f13991bd44af
 2013-10-03 19:27:14 +00:00
dan
eb26672d0e Add a test to check that the new multi-token phrase optimization is actually helping. 
FossilOrigin-Name: bc3a2ed5fb2402805928b0002457eebf06f87c47
 2013-10-02 08:04:27 +00:00
dan
ff574f4c76 Allow multi-token phrases to load doclists from the database incrementally. This allows queries that feature such phrases to benefit from the "docid<?" optimization. 
FossilOrigin-Name: ea543f081d93ed1bf66c21ce2108ec94e349f4c5
 2013-10-01 20:02:32 +00:00
dan
73632e37c9 Merge trunk changes with this branch. 
FossilOrigin-Name: e294a9c7c525d1da698259c2fef089579bfd1c0b
 2013-09-30 18:16:07 +00:00
dan
1f03e609ff Fix a performance problem in the FTS4 auxiliary functions triggered by an OR clause in the full-text query. 
FossilOrigin-Name: fa0f2f0e3e79ae653118b901e1cca7725dfaf249
 2013-09-30 18:14:45 +00:00
drh
92054fefcd Fix memory leaks in the amatch extension. Add a few simple test cases. 
FossilOrigin-Name: 604134732e309a738e21bcb4240b9ff285d2bfe4
 2013-09-30 17:37:15 +00:00
dan
19384380f3 Have fts4 full-text queries consider "docid<?" and similar constraints. 
FossilOrigin-Name: 6622424a3a149edd35ba2ba0881aa41b4536417b
 2013-09-30 11:42:19 +00:00
mistachkin
915fe4d7e0 Fix typo in comment. No changes to code. 
FossilOrigin-Name: 0b7bd46825b09c9e46290baee3e239344ca5bf0e
 2013-09-29 04:56:43 +00:00
drh
f42747246a In the nextchar.c extension, allow the second argument to the next_char() 
function to be a subquery.

FossilOrigin-Name: 59b9fa223681a7329533b350be7bf5a0a3609255
 2013-09-28 13:28:40 +00:00
dan
7531a5a378 Add the sqlite3session_table_filter API to the sessions extension. 
FossilOrigin-Name: b7e4dd889d37c8f57c2d3c7900e802f644aac3ea
 2013-08-23 17:43:32 +00:00
drh
32683532f0 Merge in minor bug fixes and performance tweaks from trunk leading up to 
the version 3.8.0 release.

FossilOrigin-Name: 831492dca8bcfb1a1f83a8bb15de9cc94f29f07e
 2013-08-22 15:07:08 +00:00
dan
2505a5fee2 Fix an FTS4 problem introduced by [361084e1eb]. 
FossilOrigin-Name: 5f35c8cb8f8b67121c70f98c02c4aa7c25327690
 2013-08-21 15:45:27 +00:00
drh
90bf3d7422 Merge performance enhancements and compiler warning fixes from trunk. 
FossilOrigin-Name: 3e4033285deb417bd72c008917729dbf3bf4e90d
 2013-08-20 13:02:16 +00:00
dan
2c18788ffa Initialize a variable in fts3_write.c on the grounds that the argument required to show that it does not require initialization with is complicated. Add an assert() to where.c to silence a clang scan-build warning. 
FossilOrigin-Name: d6c4d48a002a6d7057fccc30064ce0b049678f0c
 2013-08-19 19:29:50 +00:00
dan
290703091e Add some extra assert() statements to silence a few clang warnings. 
FossilOrigin-Name: 1c63e9515b5f5cb9169928b108d002dcd18ad4fd
 2013-08-19 18:17:03 +00:00
drh
700a7fdf83 Merge in the latest changes from trunk. 
FossilOrigin-Name: 69d5bed017bda3e184857febcc8b6f6bed6ad228
 2013-08-06 14:52:27 +00:00
mistachkin
f3d2aaeca2 For the vtshim module, always zero out the xChildDestroy function pointer after calling it. 
FossilOrigin-Name: 240f7252c66ad3ff5ae0ef06455c1ff9bd78bbb4
 2013-08-05 21:54:17 +00:00
drh
7fb30bd0dd Merge in the latest trunk changes, including partial indexes, the MAX_PATH 
fix in os_win.c, and the sqlite3_cancel_auto_extension() API.

FossilOrigin-Name: 7e1acb390770d1bd189fac7a3a7f96106f96e3a4
 2013-08-02 20:44:48 +00:00
drh
b8c068329d Documentation changes to warn that sqlite3_set_auxdata() might call the 
destructor even before it returns.  Also fix the regexp extension to deal
with that case.  Ticket [406d3b2ef91c].

FossilOrigin-Name: 7acc8cd32d593a473c9e9adaf323220a7a46480a
 2013-07-18 14:16:48 +00:00
drh
47af6e76d6 Fix copy/paste errors in comments in the transitive_closure virtual table. 
No changes to code.

FossilOrigin-Name: b1b0de29fdf7de83722bb85b748f058b9901e77a
 2013-07-17 21:08:49 +00:00
drh
6f855952d0 Merge recent trunk changes (such as the query_only PRAGMA, the 
defer_foreign_keys PRAGMA, and the SQLITE_DBSTATUS_DEFERRED_FKS parameter
to sqlite3_db_status()) into the sessions branch.

FossilOrigin-Name: 8dfc0b78c38e519b64a796243ff7c0aff688ff36
 2013-07-11 15:31:57 +00:00
drh
07001c45a1 Remove the undocumented sqlite3_foreign_key_check() API and replace it with 
sqlite3_db_status(db, SQLITE_DBSTATUS_DEFERRED_FKS, ...).  Add test cases
for the new functionality.

FossilOrigin-Name: d39e65fe702a2e11477f2d996f77404f45763368
 2013-07-11 13:49:59 +00:00
drh
580d7dc71d Adjust the costs in the xBestIndex function of the spellfix1 virtual table 
to force the use of the MATCH term if it is available.

FossilOrigin-Name: f003bea9fe1b79e2b4d18fbef86c1d8f0f60e4b6
 2013-07-09 15:56:44 +00:00
drh
888e16e7c5 Pull in all the latest changes from trunk. 
FossilOrigin-Name: af3ca4c6e557e6bc92584586b5a97d9be41b0b82
 2013-07-09 13:05:49 +00:00
drh
1f10c28618 Modify several extensions to use the new exported function naming. 
Fix some shared library compilation issues.

FossilOrigin-Name: 1e39f85077f1f2b96c3a656c5b6334bafb005908
 2013-07-09 12:36:30 +00:00